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	Length
1	PLANCODE	Plan	STR15_LBAU	String	15
2	JOBTITLE	Job Title	STR6_Payroll_Code	String	6
3	TEMPSEAT	Temporary Seat	Boolean	Boolean	0
4	SEAT	Seat	INT6	Long Integer	6
5	CHANGEDATE_I	Change Date	DT	Date	8
6	SEQ_I	Seq	LINT_10	Long Integer	10
7	CHANGETIME_I	Change Time	TM	Time	6
8	SEQNUMBR	Sequence Number	LI_Sequence_Number	Long Integer	10
9	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
10	STRTDATE	Start Date	DT	Date	8
11	ENDDATE	End Date	DT	Date	8
12	ASSIGNMENTSTATUS	Assignment Status	DDL_AssignmentStatus	Integer	0
13	PRIMARYPOSSEAT	Primary Position/Seat	CB	Boolean	0
14	EXPIREDCB	Expired CB	Expired CB	Boolean	0
15	INHERITSTATUS	Inheritance Status	DDL_InheritanceStatus	Integer	0
16	Base_Step_Increased_On	Base Step Increases On	DDL_BaseStepIncreasesOn	Integer	0
17	PYSTPTBLID	Pay Step Table ID	STR15_LBU	String	15
18	Step	Step	INT3_RB0_U	Integer	3
19	Step_Effective_Date	Step Effective Date	DT	Date	8
20	PAYRATEBASEDON	Pay Rate Based On	GB	Integer	0
21	PAYRATE	Pay Rate	DLR11_$S2	Currency	14
22	CHANGEBY_I	Change By	STR15_User_ID	String	15
23	CHANGEREASON_I	Change Reason	STR30_I	String	30
24	DEX_ROW_ID		int	int	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.