| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| PLANCODE | Plan |
String | 16 | View | |
| JOBTITLE | Job Title |
String | 8 | View | |
| DSCRIPTN | Description |
String | 32 | View | |
| ACTINDX | Account Index |
Long Integer | 4 | View | |
| ATACRSTM | Auto Accrue Sick Time |
Boolean | 2 | View | |
| ATACRVAC | Auto Accrue Vacation |
Boolean | 2 | View | |
| BUDGETPERMSEATAMT | Budget Pemanent Seats Amount |
Integer | 2 | View | |
| BUDGETTEMPSEATAMT | Budget Temp Seats Amount |
Integer | 2 | View | |
| BUGETBENPERCENT | Budget Benefit Percent |
Currency | 10 | View | |
| BUDGETTAXPERCENT | Budget Tax Percent |
Currency | 10 | View | |
| BUDGETBENAMOUNT | Budget Benefit Amount |
Currency | 10 | View | |
| BUDGETTAXAMOUNT | Budget Tax Amount |
Currency | 10 | View | |
| Calc_Min_Wage_Bal | Calc Min Wage Bal |
Boolean | 2 | View | |
| WCACFPAY | Which Cash Account For Pay |
Integer | 2 | View | |
| CHANGEBY_I | Change By |
String | 16 | View | |
| CHANGEDATE_I | Change Date |
Date | 4 | View | |
| CONTENDDTE | Contract End Date |
Date | 4 | View | |
| CONTSTARTDTE | Contract Start Date |
Date | 4 | View | |
| CREATDDT | Created Date |
Date | 4 | View | |
| CRUSRID | Created User ID |
String | 16 | View | |
| DEPRTMNT | Department |
String | 8 | View | |
| DIVISIONCODE_I | Division Code |
String | 8 | View | |
| EEOCLASS_I | EEO Class |
Integer | 2 | View | |
| EMPLCLAS | Employee Class |
String | 16 | View | |
| FLSASTATUS | FLSA Status |
Integer | 2 | View | |
| BUDGETEDFTE | Budgeted FTE |
Currency | 10 | View | |
| INHERITANCELOCK | Inheritance Lock |
Boolean | 2 | View | |
| LOCATNID | Location ID |
String | 16 | View | |
| NOTEINDX | Note Index |
Currency | 10 | View | |
| NOTEINDX2 | Note Index2 |
Currency | 10 | View | |
| GROSSPAYINDEX | Gross Pay Index |
Long Integer | 4 | View | |
| BENEFITEXPINDEX | Benefits Expense Index |
Long Integer | 4 | View | |
| WCOMPTAXEXPINDEX | W/Comp Tax Expense Index |
Long Integer | 4 | View | |
| TAXBENEXPENSEINDEX | Taxable Benefit Expense Index |
Long Integer | 4 | View | |
| EMPLYRFICAMEINDEX | Employer FICA/ME Index |
Long Integer | 4 | View | |
| EMPLYRFICASEINDEX | Employer FICA/SE Index |
Long Integer | 4 | View | |
| EMPLYRFUTAINDEX | Employer FUTA Index |
Long Integer | 4 | View | |
| EMPLYRSUTAINDEX | Employer SUTA Index |
Long Integer | 4 | View | |
| POSSTATUS | Position Status |
Integer | 2 | View | |
| REPORTSTOPOS | Reports To Position |
String | 8 | View | |
| REVIEWSETUPCODE_I | Review Setup Code |
String | 32 | 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 | |
| SKILLSETNUMBER_I | Skill Set Number |
Long Integer | 4 | View | |
| SUPERVISORCODE_I | Supervisor Code |
String | 8 | View | |
| EMPLOYMENTTYPE | Type of Employment 1. Full Time Regular |
Integer | 2 | View | |
| UNIONDUESAMOUNT_I | Union Dues Amount |
Currency | 10 | 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 | |
| WRNSTFLSBLWZR | Warn Sick Time Falls Below Zero |
Boolean | 2 | View | |
| WRNVCNFLSBLWZR | Warn Vacation Falls Below Zero |
Boolean | 2 | View | |
| WRKRCOMP | Workers Comp |
String | 8 | View | |
| CONTACTNUM_I | Union Contract Num |
String | 32 | View | |
| TXTFIELD | Text Field |
Text | 2 | View |