PC40800 - PC Position Seat Inheritance | Prospr

PC40800 - PC Position Seat Inheritance

Query Builder

Select * from PC40800

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
ACTINDX	Account Index	Long Integer	4	View
ACRUSTIM	Accrue Sick Time	Boolean	2	View
ACRUVACN	Accrue Vacation	Boolean	2	View
Calc_Min_Wage_Bal	Calc Min Wage Bal	Boolean	2	View
CALCMINWAGEBALCB	Calc Min Wage Bal CB	Boolean	2	View
CONTENDDTE	Contract End Date	Date	4	View
CONTSTARTDTE	Contract Start Date	Date	4	View
DIVISIONCODE_I	Division Code	String	8	View
DIVISIONCODECB	Division Code CB	Boolean	2	View
EMPLCLAS	Employee Class	String	16	View
EMPLCLASCB	Employee Class CB	Boolean	2	View
WCACFPAY	Which Cash Account For Pay	Integer	2	View
WHICHCACHACCTCB	Which Cash Account For Pay CB	Boolean	2	View
LOCATNID	Location ID	String	16	View
LOCATNIDCB	Location ID CB	Boolean	2	View
STMACMTH	Sick Time Accrual Method 0 is by Hours Worked 1 is by Amount.	Integer	2	View
SKTMACAM	Sick Time Accrual Amount	Long Integer	4	View
SKTMHPYR	Sick Time Hours Per Year	Long Integer	4	View
SUPERVISOR	Supervisor	String	32	View
SUPERVISORCB	Supervisor CB	Boolean	2	View
EMPLOYMENTTYPE	Type of Employment 1. Full Time Regular 2. Full Time Temp 3. Part Time Regular 4. Part Time Temp 5. Intern In SBM, this field is not available. 6. Other	Integer	2	View
EMPLOYMENTTYPECB	Type of Employment CB	Boolean	2	View
UNIONDUESAMOUNT_I	Union Dues Amount	Currency	10	View
UNIONINFOCB	Union Information CB	Boolean	2	View
UNIONNAME_I	Union Name	String	32	View
VACCRMTH	Vacation Accrual Method	Integer	2	View
VACCRAMT	Vacation Accrual Amount	Long Integer	4	View
VACAPRYR	Vacation Hours Per Year	Long Integer	4	View
VACSICKCB	Vacation Sick Information CB	Boolean	2	View
WRNSTFLSBLWZR	Warn Sick Time Falls Below Zero	Boolean	2	View
WRNVCNFLSBLWZR	Warn Vacation Falls Below Zero	Boolean	2	View
WKHRPRYR	Work Hours Per Year	Integer	2	View
WKHRPRYRCB	Work Hours Per Year CB	Boolean	2	View
WRKRCOMP	Workers Comp	String	8	View
WRKRCOMPCB	Workers Comp CB	Boolean	2	View
CONTACTNUM_I	Union Contract Num	String	32	View

PC40800 - PC Position Seat Inheritance

Query Builder

Customer Service

Information

My Account

Contact Us