PC Position Seats Detail (PC40305)

Product: Human Resources (414)
Series:

Display Name: PC Position Seats Detail
Physical Name: PC40305
Technical Name: pcPositionSeatsDetail

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	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
6	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
7	STRTDATE	Start Date	Date	DT	8
8	ENDDATE	End Date	Date	DT	8
9	ASSIGNMENTSTATUS	Assignment Status	Integer	DDL_AssignmentStatus	0
10	PRIMARYPOSSEAT	Primary Position/Seat	Boolean	CB	0
11	EXPIREDCB	Expired CB	Boolean	Expired CB	0
12	INHERITSTATUS	Inheritance Status	Integer	DDL_InheritanceStatus	0
13	Base_Step_Increased_On	Base Step Increases On	Integer	DDL_BaseStepIncreasesOn	0
14	PYSTPTBLID	Pay Step Table ID	String	STR15_LBU	15
15	Step	Step	Integer	INT3_RB0_U	3
16	Step_Effective_Date	Step Effective Date	Date	DT	8
17	PAYRATEBASEDON	Pay Rate Based On	Integer	GB	0
18	PAYRATE	Pay Rate	Currency	DLR11_$S2	14