PC30305 - PC Position Seats Detail History | Prospr - Dynamics GP Table Reference

PC30305 - PC Position Seats Detail History

Query Builder

Select * from PC30305

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
CHANGEDATE_I	Change Date	Date	4	View
SEQ_I	Seq	Long Integer	4	View
CHANGETIME_I	Change Time	Time	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
CHANGEBY_I	Change By	String	16	View
CHANGEREASON_I	Change Reason	String	32	View