| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | Y$AN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | Y$CKCN | Check Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | Y$HMO | Month - Update of History | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 4 | Y$DWK | Date - Worked | Date | Generic Edit | 6 | 0 | |
| 5 | Y$PPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 | |
| 6 | Y$CKDT | Date - Pay Check | Date | Generic Edit | 6 | 0 | |
| 7 | Y$PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 8 | Y$UKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 9 | Y$PRTR | Transaction No. - Payroll | Numeric | Generic Edit | 9 | 0 | Allow NULL? |
| 10 | Y$CPE | COBRA Plan | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | Y$DISO | DBA Type | Character | UDC (05 DI) | 1 | 0 | Allow NULL? |
| 12 | Y$RTAM | Amount or Rate | Numeric | Generic Edit | 9 | 4 | Allow NULL? |
| 13 | Y$DEDM | Method of Calculation | Character | UDC (06 DM) | 1 | 0 | Allow NULL? |
| 14 | Y$HMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 15 | Y$TAXX | Tax Identification Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 16 | Y$GPA | Amount - Gross Pay | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 17 | Y$ARRA | Amount - Arrearage | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 18 | Y$PHRW | Hours Worked | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 19 | Y$MCUG | Business Unit - DBA Allocation | String | Generic Edit | 12 | 0 | Allow NULL? |
| 20 | Y$CMHU | Calendar Month Method | Character | UDC (52 YN) | 1 | 0 | Allow NULL? |
| 21 | Y$CLBS | DBA Calculation Basis | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 22 | Y$UN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 23 | Y$JBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 24 | Y$JBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 25 | Y$WST | Work State | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 26 | Y$WCNT | Work County | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 27 | Y$WCTY | Work City | Numeric | Generic Edit | 4 | 0 | Allow NULL? |
| 28 | Y$ANN8 | Address Number-Provider/Trustee | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | Y$WCMP | Worker's Comp. Insurance Code | String | UDC (00 W) | 4 | 0 | Allow NULL? |
| 30 | Y$WET | Sub Class - Workers Comp | Character | UDC (07 WH) | 1 | 0 | Allow NULL? |
| 31 | Y$PGRP | Deduct/Benefit Override Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 32 | Y$MV | Effect on Disposable Wage | Character | UDC (05A MV) | 1 | 0 | Allow NULL? |
| 33 | Y$ICC | Interim Check Code | Character | UDC (07 IC) | 1 | 0 | Allow NULL? |
| 34 | Y$ICS | Interim Check Status | Character | UDC (07 IC) | 1 | 0 | Allow NULL? |
| 35 | Y$USR | Payroll Lockout Identification | String | Generic Edit | 18 | 0 | Allow NULL? |
| 36 | Y$DAAF | Deduction Factor | Character | UDC | 1 | 0 | Allow NULL? |
| 37 | Y$DTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 | Allow NULL? |
| 38 | Y$PCK | Method of Printing | Character | UDC (05A PT) | 1 | 0 | Allow NULL? |
| 39 | Y$YST | Processed Code | Character | UDC (07 YW) | 1 | 0 | Allow NULL? |
| 40 | Y$GICU | General Ledger Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 41 | Y$CMMT | Check Comment (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 42 | Y$PCNO | Payroll Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 43 | Y$PALF | Name - Alpha Sort | String | Generic Edit | 12 | 0 | Allow NULL? |
| 44 | Y$GVCH | A/P Voucher (Y N) | Character | UDC (05 YB) | 1 | 0 | Allow NULL? |
| 45 | Y$WANO | Wage Attach Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 46 | Y$CALC | Calculate If No Gross (Y N) | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 47 | Y$DPRI | Order To Adjust Ded | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 48 | Y$EPRI | When To Adjust Ded | Character | UDC (05A EP) | 1 | 0 | Allow NULL? |
| 49 | Y$ARRR | Arrearage Method | Character | UDC (05A AR) | 1 | 0 | Allow NULL? |
| 50 | Y$DLVL | DBA Calculation Level | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 51 | Y$TDBA | Code - Tax Area Deduction | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 52 | Y$UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 53 | Y$UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 54 | Y$PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 55 | Y$JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 56 | Y$USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
