PC Position Seats Detail History (PC30305)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PC30305

Display Name: PC Position Seats Detail History
Physical Name: PC30305
Technical Name: pcPositionSeatsDetailHistory

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	PLANCODE	Plan	STR15_LBAU	String	16	15
2	JOBTITLE	Job Title	STR6_Payroll_Code	String	8	6
3	TEMPSEAT	Temporary Seat	Boolean	Boolean	2	0
4	SEAT	Seat	INT6	Long Integer	4	6
5	CHANGEDATE_I	Change Date	DT	Date	4	8
6	SEQ_I	Seq	LINT_10	Long Integer	4	10
7	CHANGETIME_I	Change Time	TM	Time	4	6
8	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	4	10
9	EMPLOYID	Employee ID	STR15_Employee_ID	String	16	15
10	STRTDATE	Start Date	DT	Date	4	8
11	ENDDATE	End Date	DT	Date	4	8
12	ASSIGNMENTSTATUS	Assignment Status	DDL_AssignmentStatus	Integer	2	0
13	PRIMARYPOSSEAT	Primary Position/Seat	CB	Boolean	2	0
14	EXPIREDCB	Expired CB	Expired CB	Boolean	2	0
15	INHERITSTATUS	Inheritance Status	DDL_InheritanceStatus	Integer	2	0
16	Base_Step_Increased_On	Base Step Increases On	DDL_BaseStepIncreasesOn	Integer	2	0
17	PYSTPTBLID	Pay Step Table ID	STR15_LBU	String	16	15
18	Step	Step	INT3_RB0_U	Integer	2	3
19	Step_Effective_Date	Step Effective Date	DT	Date	4	8
20	PAYRATEBASEDON	Pay Rate Based On	GB	Integer	2	0
21	PAYRATE	Pay Rate	DLR11_$S2	Currency	10	14
22	CHANGEBY_I	Change By	STR15_User_ID	String	16	15
23	CHANGEREASON_I	Change Reason	STR30_I	String	32	30
24	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.