PC40305 - PC Position Seats Detail | Prospr - Dynamics GP Table Reference

PC40305 - PC Position Seats Detail

Query Builder

Select * from PC40305

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PLANCODE	Plan	String	16	View
JOBTITLE	Job Title	String	8	View
TEMPSEAT	Temporary Seat	Boolean	2	View
SEAT	Seat	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
EMPLOYID	Employee ID	String	16	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
ASSIGNMENTSTATUS	Assignment Status	Integer	2	View
PRIMARYPOSSEAT	Primary Position/Seat	Boolean	2	View
EXPIREDCB	Expired CB	Boolean	2	View
INHERITSTATUS	Inheritance Status	Integer	2	View
Base_Step_Increased_On	Base Step Increases On	Integer	2	View
PYSTPTBLID	Pay Step Table ID	String	16	View
Step	Step	Integer	2	View
Step_Effective_Date	Step Effective Date	Date	4	View
PAYRATEBASEDON	Pay Rate Based On	Integer	2	View
PAYRATE	Pay Rate	Currency	10	View