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 |