| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F051124 | Director Text Setup File | 1 | Y4 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 2 | F0605 | D/B/A Period Control File | 7 | J@ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 3 | F0609 | Deduction/Benefit/Accrual Ledger File | 12 | Y$ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 4 | F06145 | Calendar Month DBA Summary History File | 7 | YH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 5 | F06149 | Fiscal and Anniversary Rollover Work File | 5 | Y7 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 6 | F0618 | Employee Transaction History | 8 | YT | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 7 | F0619 | Benefit/Accrual Detail File | 12 | Y$ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 8 | F0626 | Wage Attachment Control File | 13 | JG | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 9 | F0627 | Workers Compensation Summary History | 6 | JH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 10 | F069116 | Payroll Transaction Constants | 91 | YC | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 11 | F06915 | Holiday Table | 2 | JH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 12 | F06920 | Savings Bond General Constant | 1 | YQ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 13 | F06926 | Tax Area/ Vendor Cross Reference | 3 | Y# | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 14 | F0709 | Deduction/Benefit/Accrual Ledger File | 14 | Y$ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP05A: OW HR & PR Foundation |
| 15 | F05003 | Verification of Employment Data | 25 | EV | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 16 | F05844 | Approval Hierarchy Table | 1 | AH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 17 | F060116 | Employee Master Information | 21 | YA | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 18 | F0601161 | Point-In-Time Employee Master | 23 | PT | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 19 | F060116W | EE Master Request File | 21 | YA | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 20 | F060116Z | Unedited Quick Hire Transaction File | 22 | SZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 21 | F06345 | Historical Payroll Register | 6 | JL | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP05T: Time Entry |
| 22 | F051123 | Self Service Time Entry Layout Setup File | 1 | Y3 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 23 | F06116 | Employee Transaction Detail File | 8 | YT | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 24 | F06116Z1 | Employee Transactions - Batch File | 25 | VL | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 25 | F06116Z2 | ESS Timecard History | 25 | VM | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 26 | F0623 | Piecework History File | 10 | JL | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 27 | F06278 | Retro Timecard Detail File | 11 | YT | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 28 | F06290 | Payroll Accounting Journal Work File | 22 | YR | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 29 | F06146 | Employee Transaction History Summary | 7 | YN | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP07: Payroll |
| 30 | F06136 | Tax History | 6 | YZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 31 | F06136A | Tax Summary (Additional) | 7 | YZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 32 | F06136B | Tax Summary (PA ACT 32) | 7 | YZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 33 | F06147 | Fiscal and Anniversary Year History | 5 | YD | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 34 | F06148 | Tax Area Transaction History | 6 | Y@ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 35 | F06156 | Pay Check History Summary | 27 | YU | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 36 | F06166 | Pay Check History Tax Ledger | 17 | YV | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 37 | F06166A | Tax Ledger (Additional) | 19 | YV | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 38 | F06166B | Tax Ledger (PA ACT 32) | 12 | YV | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 39 | F06270 | Retro Processing Parameter | 38 | JP | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 40 | F063106 | Deduction/Benefit Work File | 4 | Y7 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 41 | F06350I | WF - Paycheck (Interims) | 36 | Y4 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 42 | F06490 | Payroll/Accounts Payable Ledger Detail | 7 | JR | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 43 | F065016 | Automatic Bank Deposit Master | 4 | YG | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 44 | F068500 | 941 - Federal Tax History | 11 | YZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 45 | F06900 | Payroll Fiscal Patterns | 1 | Y$ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 46 | F0701734 | Prior Head Tax from a Previous Employer | 8 | Y3 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 47 | F0701740 | Quantum Control Tax | 11 | YQ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 48 | F0701741 | Canadian Deduction | 11 | YD | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 49 | F0705 | DBA Period Control File | 8 | J@ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 50 | F07107 | Employee Wage Attachment Rules | 16 | JW | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 51 | F07149 | Accrual Fiscal/Anniversary History Work File | 5 | Y8 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 52 | F0716701 | Employee Assignment T/E Template Information | 26 | EA | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 53 | F0716709 | Employee Assignment T/E Template Info History | 26 | EA | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 54 | F0717 | ROE Summary History | 36 | JF | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 55 | F0719 | DBA Transaction Detail History | 14 | Y$ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 56 | F07235 | Auto Deposit Bank Workfile | 4 | Y6 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 57 | F07236 | Auto Deposit Tape File Setup | 1 | Y6 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 58 | F07236T | Auto Deposit Tape File Setup (Additional) | 1 | Y6 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 59 | F0729 | Employee DBA Override Instructions | 61 | Y9 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 60 | F07350 | Payment File | 10 | Y0 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 61 | F07353 | Tax Detail File | 22 | Y3 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 62 | F07355 | Pre-Payroll Error File | 24 | Y5 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 63 | F073911 | Leave Rollover Balance Report Work File | 3 | Y8 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 64 | F074001 | New Hire Reporting Workfile - OneWorld Only | 47 | NH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 65 | F07490 | Payroll - Accounts Payable Detail (One World) | 7 | JR | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 66 | F077011B | Tax Integrity (PA Act32) | 2 | Y3 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 67 | F07727 | Canadian Pension Information | 2 | J7 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 68 | F07822 | Company Federal Control Table | 3 | JI | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 69 | F07824 | Company State/Local Control Table | 3 | JD | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 70 | F07825 | Company Special Handling Control Table | 3 | JA | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 71 | F07830 | Employee Federal Control Table | 60 | Y0 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 72 | F07831 | Employee State/Local Control Table | 36 | YB | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 73 | F07832 | Employee Special Handling Control Table | 22 | YH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 74 | F078506 | ADP Company Code to JDE Company Code | 1 | YJ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 75 | F07880 | SUI Magnetic Media Workfile | 2 | YW | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 76 | F07885 | SUI Payments for Quarterly Reporting | 1 | YW | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 77 | F07UI200 | Timecard History Work File | 11 | TH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP08: Human Resources |
| 78 | F08771 | CBPA System Company Constants | 1 | XG | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 79 | F087711B | Performance Appraisal Header Template Keys | 4 | XK | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 80 | F08771A | CBPA System Company Constants Tag Table | 1 | XG | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 81 | F08773 | CBPA System Appraisal Type Overrides | 2 | XL | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 82 | F08773A | CBPA System Appraisal Type Overrides Tag Table | 2 | XL | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 83 | F08776 | CBPA Appraisal Templates | 2 | XO | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP08AD: ADP Integration |
| 84 | F05137 | ADP Employee Master Information | 36 | AD | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 85 | F051375 | ADP Payroll DBA Transaction Constants | 93 | AD | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP08H: Health and Safety |
| 86 | F08601 | Injury/Illness Case Master | 9 | HL | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP08U: OW HR US |
| 87 | F08360 | Nondiscrimination Groups | 4 | HE | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 88 | F08367 | NDT - Company Selection Criteria | 3 | HZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 89 | F083675 | NDT - Prior Year Testing Method Selection Criteria | 3 | PF | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 90 | F08368 | NDT - Nondiscrimination Totals | 3 | DB | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 91 | F08910 | COBRA Qualified Beneficiary File | 28 | J1 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 92 | F08992 | Qualifying Event Rules Header | 3 | QE | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP08W: Wage and Salary |
| 93 | F08201 | Salary Review Workfile | 6 | HR | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP18: Resource Scheduling |
| 94 | F186602 | Labor Rules Tag File | 22 | TF | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP48S: Service Billing |
| 95 | F48S0618 | Payroll Reclassification Workfile | 8 | YT | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP54HS: Health & Safety Incident Mgt |
| 96 | F54HS02 | Incident People | 17 | S2 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 97 | F54HS02M | Incident People Change History | 20 | I2 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP74U: United Kingdom Localizations |
| 98 | F74U4051 | Header - CIS Monthly Return - UK - 04 | 2 | HM | CO | Company | String | Generic Edit | 5 | 0 |
| 99 | F74UUI51 | Header - XML Work File CIS Monthly Return - UK - 04 | 2 | HM | CO | Company | String | Generic Edit | 5 | 0 |
| TOP75A: Australia - Reporting System Only |
| 100 | F75A0140 | Australian Payment Summary | 2 | ZG | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 101 | F75A0500 | AU Bonus and Back Pay Tax Workfile | 10 | BP | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 102 | F75A0501 | AU Bonus and Back Pay Tax History | 10 | TH | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| TOP77: Payroll (Canadian) |
| 103 | F06176 | Unemployment Insurance History File | 13 | YS | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 104 | F0713 | Tax History | 6 | YZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 105 | F0713SAV | Backup Copy of F0713 For Tax Ledger Repost | 6 | YZ | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 106 | F0716 | Pay Check History Tax Ledger - Canadian DB | 17 | YV | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 107 | F07183 | Commission History Detail File | 9 | ZB | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 108 | F77220 | Employee Special Handling Detail - F77220 | 6 | J3 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 109 | F77230 | Employee Pension Maintenance - F77230 | 2 | J8 | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
| 110 | F77703 | Payroll History Audit Report - Worktable | 2 | AR | HMCO | Company - Home | String | Generic Edit | 5 | 0 |
