PC Position Seats Detail History (PC30305)

Product: Human Resources (414)
Series:

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