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 |
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 |
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 |