| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | ADCHGF | Change Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 2 | ADPAYBN | Payroll Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | ADAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | ADNDEP | Dependents | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 5 | ADDOB | Date - Birth | Date | Generic Edit | 6 | 0 | |
| 6 | ADEEOM | Ethnic Code | String | UDC (06 M) | 2 | 0 | Allow NULL? |
| 7 | ADEST | Employment Status | Character | UDC (06 ES) | 1 | 0 | Allow NULL? |
| 8 | ADSEX | Gender (Male/Female) | Character | UDC (07 SG) | 1 | 0 | Allow NULL? |
| 9 | ADDST | Date Started | Date | Generic Edit | 6 | 0 | |
| 10 | ADPAST | Employee Pay Status | Character | UDC (06 PS) | 1 | 0 | Allow NULL? |
| 11 | ADHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 12 | ADSHFT | Shift Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 13 | ADSSN | Employee Tax ID | String | Generic Edit | 20 | 0 | Allow NULL? |
| 14 | ADUN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 15 | ADHM02 | EEO - Veteran | Character | UDC (05 HO) | 1 | 0 | Allow NULL? |
| 16 | ADEEOJ | Job Category (EEO) | String | UDC (06 J) | 3 | 0 | Allow NULL? |
| 17 | ADFLSA | FLSA Exempt Y/N | Character | UDC (05 FL) | 1 | 0 | Allow NULL? |
| 18 | ADPFRQ | Pay Frequency | Character | UDC (06 PF) | 1 | 0 | Allow NULL? |
| 19 | ADPGRD | Pay Grade | String | Generic Edit | 6 | 0 | Allow NULL? |
| 20 | ADPGRS | Pay Grade Step | String | Generic Edit | 4 | 0 | Allow NULL? |
| 21 | ADSAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 22 | ADPHRT | Rate - Hourly | Numeric | Generic Edit | 9 | 3 | Allow NULL? |
| 23 | ADSALY | Pay Class (H/S/P) | Character | UDC (05A PK) | 1 | 0 | Allow NULL? |
| 24 | ADIH | Hours per Standard Year | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 25 | ADSTDH | Hours - Standard per Payperiod | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 26 | ADSTDD | Hours - Standard per Day | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 27 | ADANPA | Supervisor | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | ADWCMP | Worker's Comp. Insurance Code | String | UDC (00 W) | 4 | 0 | Allow NULL? |
| 29 | ADEIC | Earned Income Credit Status | Character | UDC (05 EI) | 1 | 0 | Allow NULL? |
| 30 | ADMSTX | Marital Status - Tax | Character | UDC (06 MS) | 1 | 0 | Allow NULL? |
| 31 | ADTARR | Tax Area (Residence) | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | ADSCDC | School District Code | Numeric | UDC (07 SS) | 5 | 0 | Allow NULL? |
| 33 | ADMSTI | Marital Status - State Tax | Character | UDC (06 MS) | 1 | 0 | Allow NULL? |
| 34 | ADSUI | Source of SUI Reporting | Character | UDC (05 SR) | 1 | 0 | Allow NULL? |
| 35 | ADTARA | Tax Area (Work) | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | ADHMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 37 | ADNRVW | Date - Next Review | Date | Generic Edit | 6 | 0 | |
| 38 | ADPSDT | Date - Pay Starts | Date | Generic Edit | 6 | 0 | |
| 39 | ADDSI | Date - Original Employment | Date | Generic Edit | 6 | 0 | |
| 40 | ADLADT | Date - LOA Expiration Date | Date | Generic Edit | 6 | 0 | |
| 41 | ADLSDT | Date - LOA Beginning Date | Date | Generic Edit | 6 | 0 | |
| 42 | ADDT | Date - Terminated | Date | Generic Edit | 6 | 0 | |
| 43 | ADFICM | Tax Calc Method | Character | UDC (06 TM) | 1 | 0 | Allow NULL? |
| 44 | ADGNNM | Name - Given | String | Generic Edit | 25 | 0 | Allow NULL? |
| 45 | ADSRNM | Name - Surname | String | Generic Edit | 25 | 0 | Allow NULL? |
| 46 | ADMDNM | Name - Middle | String | Generic Edit | 25 | 0 | Allow NULL? |
| 47 | ADAR1 | Phone Prefix | String | Generic Edit | 6 | 0 | Allow NULL? |
| 48 | ADPH1 | Phone Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 49 | ADPHTP | Phone Number Type | String | UDC (01 PH) | 4 | 0 | Allow NULL? |
| 50 | ADAR2 | Phone Prefix 2 | String | Generic Edit | 6 | 0 | Allow NULL? |
| 51 | ADPH2 | Phone Number 2 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 52 | ADPHT2 | Phone Number Type 2 | String | UDC (01 PH) | 4 | 0 | Allow NULL? |
| 53 | ADADD1 | Address Line 1 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 54 | ADADD2 | Address Line 2 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 55 | ADADD3 | Address Line 3 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 56 | ADADD4 | Address Line 4 | String | Generic Edit | 40 | 0 | Allow NULL? |
| 57 | ADCTY1 | City | String | Generic Edit | 25 | 0 | Allow NULL? |
| 58 | ADADDS | State | String | UDC (00 S) | 3 | 0 | Allow NULL? |
| 59 | ADADDZ | Postal Code | String | Generic Edit | 12 | 0 | Allow NULL? |
| 60 | ADEMAL | Electronic Address | String | Generic Edit | 256 | 0 | Allow NULL? |
| 61 | ADETP | Electronic Address Type | String | UDC (01 ET) | 4 | 0 | Allow NULL? |
| 62 | ADMSA | Marital Status - Actual | Character | UDC (07 MS) | 1 | 0 | Allow NULL? |
| 63 | ADTINCL | Type of Increase Next Review | Character | UDC (06 RV) | 1 | 0 | Allow NULL? |
| 64 | ADJBCX | Job Title | String | Generic Edit | 30 | 0 | Allow NULL? |
| 65 | ADDATRVW | Date Last Reviewed | Date | Generic Edit | 6 | 0 | |
| 66 | ADLSRD | Last Compensation Review Date | Date | Generic Edit | 6 | 0 | |
| 67 | ADNSRD | Next Compensation Review Date | Date | Generic Edit | 6 | 0 | |
| 68 | ADRWTYP | Review Type | Character | UDC (05 RY) | 1 | 0 | Allow NULL? |
| 69 | ADPRNM | Preferred Name | String | Generic Edit | 20 | 0 | Allow NULL? |
| 70 | ADAPS | Status - Applicant | String | UDC (08 AS) | 2 | 0 | Allow NULL? |
| 71 | ADUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 72 | ADLVEL | Level In Relation To Employee | Integer | Generic Edit | 3 | 0 | Allow NULL? |
| 73 | ADAPPST | Approval Status | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 74 | ADAPPTY | Approval Type | String | UDC (05 AP) | 4 | 0 | Allow NULL? |
| 75 | ADADP01 | ADP User Defined Cat Code - 01 | Character | UDC (05 I1) | 1 | 0 | Allow NULL? |
| 76 | ADADP02 | ADP User Defined Cat Code - 02 | Character | UDC (05 I2) | 1 | 0 | Allow NULL? |
| 77 | ADADP03 | ADP User Defined Cat Code - 03 | Character | UDC (05 I3) | 1 | 0 | Allow NULL? |
| 78 | ADADP04 | ADP User Defined Cat Code - 04 | Character | UDC (05 I4) | 1 | 0 | Allow NULL? |
| 79 | ADADP05 | ADP User Defined Cat Code - 05 | Character | UDC (05 I5) | 1 | 0 | Allow NULL? |
| 80 | ADADP11 | ADP User Defined Date - 01 | Date | Generic Edit | 6 | 0 | |
| 81 | ADADP12 | ADP User Defined Date - 02 | Date | Generic Edit | 6 | 0 | |
| 82 | ADADP13 | ADP User Defined Date - 03 | Date | Generic Edit | 6 | 0 | |
| 83 | ADADP14 | ADP User Defined Date - 04 | Date | Generic Edit | 6 | 0 | |
| 84 | ADADP15 | ADP User Defined Date - 05 | Date | Generic Edit | 6 | 0 | |
| 85 | ADADP21 | ADP User Defined Data - 01 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 86 | ADADP22 | ADP User Defined Data - 02 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 87 | ADADP23 | ADP User Defined Data - 03 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 88 | ADADP24 | ADP User Defined Data - 04 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 89 | ADADP25 | ADP User Defined Data - 05 | String | Generic Edit | 20 | 0 | Allow NULL? |
| 90 | ADADP31 | ADP User Defined Numeric - 01 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 91 | ADADP32 | ADP User Defined Numeric - 02 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 92 | ADADP33 | ADP User Defined Numeric - 03 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 93 | ADADP34 | ADP User Defined Numeric - 04 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 94 | ADADP35 | ADP User Defined Numeric - 05 | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
