| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP05: Time Accounting and HRM Base |
| 1 | F06005 | Batch Processing Parameters | 15 | JE | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 2 | F0605 | D/B/A Period Control File | 2 | J@ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 3 | F0607 | Wage Attachment Ledger File | 14 | JI | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 4 | F0609 | Deduction/Benefit/Accrual Ledger File | 7 | Y$ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 5 | F06106 | Employee Pay Instructions | 3 | YM | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 6 | F06107 | Employee Wage Attachment Rules | 2 | J$ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 7 | F061071 | Employee Wage Attachment Fee File | 2 | J$ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 8 | F06145 | Calendar Month DBA Summary History File | 2 | YH | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 9 | F06149 | Fiscal and Anniversary Rollover Work File | 2 | Y7 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 10 | F0618 | Employee Transaction History | 60 | YT | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 11 | F0619 | Benefit/Accrual Detail File | 7 | Y$ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 12 | F0626 | Wage Attachment Control File | 2 | JG | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 13 | F069036 | Payroll Transaction Cross Reference | 1 | YX | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 14 | F069106 | Union Benefits Master | 5 | Y1 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 15 | F069116 | Payroll Transaction Constants | 13 | YC | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 16 | F069117 | Tax Authority Tax Exemption File | 1 | YB | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 17 | F06915 | Holiday Table | 14 | JH | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 18 | F06923 | Valid Job Type/ Step Constant | 36 | YH | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 19 | F06925 | Employee/Vendor Cross Reference | 5 | YG | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 20 | F06936 | Retro Pay Types Rate | 4 | JA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 21 | F0709 | Deduction/Benefit/Accrual Ledger File | 7 | Y$ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 22 | F073111 | Pay Type to Activity Type Association | 2 | AA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP05A: OW HR & PR Foundation |
| 23 | F05002 | Pay Type by Category | 2 | EV | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 24 | F06345 | Historical Payroll Register | 23 | JL | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP05T: Time Entry |
| 25 | F06116 | Employee Transaction Detail File | 60 | YT | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 26 | F06116Z1 | Employee Transactions - Batch File | 71 | VL | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 27 | F0624 | Burden Distribution File | 3 | J# | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 28 | F06241 | Burden Distribution File | 3 | J# | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 29 | F06278 | Retro Timecard Detail File | 57 | YT | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 30 | F06290 | Payroll Accounting Journal Work File | 21 | YR | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 31 | F06904 | Automatic Accounting Instructions | 5 | Y# | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 32 | F069136 | Tip Disbursement | 8 | JE | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 33 | F06146 | Employee Transaction History Summary | 2 | YN | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP07: Payroll |
| 34 | F05290 | WF - Payroll Journal (Detail) | 37 | JR | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 35 | F06147 | Fiscal and Anniversary Year History | 2 | YD | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 36 | F06148 | Tax Area Transaction History | 3 | Y@ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 37 | F06270 | Retro Processing Parameter | 9 | JP | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 38 | F063106 | Deduction/Benefit Work File | 3 | Y7 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 39 | F06350I | WF - Paycheck (Interims) | 15 | Y4 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 40 | F06490 | Payroll/Accounts Payable Ledger Detail | 11 | JR | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 41 | F0690361 | Employee Rollover Table Overrides | 2 | RO | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 42 | F0705 | DBA Period Control File | 2 | J@ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 43 | F07107 | Employee Wage Attachment Rules | 2 | JW | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 44 | F071073 | Employee Level Multi Wage Attachment Rules | 2 | J3 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 45 | F071074 | Wage Attachment Exemption Rules | 2 | WE | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 46 | F07149 | Accrual Fiscal/Anniversary History Work File | 3 | Y8 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 47 | F0716701 | Employee Assignment T/E Template Information | 2 | EA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 48 | F0716702 | Employee Assignment Rates | 3 | EA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 49 | F0716704 | Employee Assignment Default Pay Type | 2 | EA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 50 | F0716709 | Employee Assignment T/E Template Info History | 2 | EA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 51 | F07186 | Stub Information History Table | 3 | Y8 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 52 | F0719 | DBA Transaction Detail History | 7 | Y$ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 53 | F0724 | Burden Distribution File | 6 | YS | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 54 | F07241 | Burden Distribution File | 6 | YS | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 55 | F0728 | Employee Paid Workers Compensation Transactions | 5 | YW | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 56 | F0729 | Employee DBA Override Instructions | 4 | Y9 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 57 | F07352 | Stub Information File | 3 | Y2 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 58 | F07355 | Pre-Payroll Error File | 16 | Y5 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 59 | F07390 | Year-End Rollover Workfile | 1 | RO | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 60 | F073911 | Leave Rollover Balance Report Work File | 5 | Y8 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 61 | F07490 | Payroll - Accounts Payable Detail (One World) | 10 | JR | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 62 | F077021 | Transaction History Integrity(Temp) | 8 | Y$ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 63 | F07811 | Negative Amount Workfile | 8 | JE | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 64 | F07815 | Special Handling Codes Setup | 4 | YF | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 65 | F07825 | Company Special Handling Control Table | 12 | JA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 66 | F07832 | Employee Special Handling Control Table | 9 | YH | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 67 | F078505 | ADP PDBA Quarterly Table Setup | 2 | YA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 68 | F07991 | Deduction - Benefit - Accrual History Conversion Data | 4 | YX | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 69 | F07UI200 | Timecard History Work File | 63 | TH | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP08: Human Resources |
| 70 | F083303 | Benefit Statement Cross Reference Detail | 4 | CR | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP08AD: ADP Integration |
| 71 | F051371 | ADP Employee DBA Instructions | 8 | AD | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 72 | F051375 | ADP Payroll DBA Transaction Constants | 15 | AD | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP08B: Benefits Administration |
| 73 | F083203 | Plan Master Rates | 3 | BG | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 74 | F08345 | 401(k) Elections Setup | 2 | B3 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 75 | F08346 | 401(K) Elections | 4 | B4 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 76 | F08370 | Reimbursement Spending Acct - Balance File | 5 | B7 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 77 | F08371 | Reimbursement Spending Account Claims File | 15 | B6 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 78 | F08381WF | Recalculate Plan Option Costs | 7 | RC | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 79 | F08515 | Plan DBA/Enrollment DBA Cross Reference | 1 | QB | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 80 | F085573W | Entered Benefit Amount/Rate Edits | 2 | MM | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP08U: OW HR US |
| 81 | F08360 | Nondiscrimination Groups | 28 | HE | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP09E: Expense Reimbursment |
| 82 | F09E118 | Expense Category / Report Type to Pay Type Mapping | 5 | PM | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP17C: Call Management |
| 83 | F1760 | Time Entry | 35 | ZB | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP18: Resource Scheduling |
| 84 | F186301 | Timecard Templates | 5 | TT | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 85 | F186408 | Overtime Rule Pay Type Inclusions | 2 | PI | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 86 | F186702 | Retropay Rules Paytype Inclusions | 2 | PI | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP48S: Service Billing |
| 87 | F48096 | Billing Rate / Mark up Table | 12 | WQ | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 88 | F4812 | Billing Detail Workfile | 36 | WD | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 89 | F4812H | Billing Workfile - History | 36 | WD | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 90 | F4812HS | Billing Workfile History Purged Save | 36 | WD | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 91 | F48S0618 | Payroll Reclassification Workfile | 60 | YT | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 92 | F48SUI01 | Billing Detail Print Workfile | 36 | WD | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP52: Contract Billing |
| 93 | F5212 | T and M - Unit Price and Lumpsum Cross Reference Accounts | 15 | G5 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 94 | F5214 | Billing Line - Component Code Cross Reference Table | 8 | A4 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 95 | F5215 | Component Billing Line Cross Reference Details | 10 | A5 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP75A: Australia - Reporting System Only |
| 96 | F75A0009 | Employee DBA Instructions | 2 | A9 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 97 | F75A670 | Long Service Leave Dates | 5 | LL | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 98 | F75A671 | Long Service Leave Audit | 2 | LA | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP75Z: New Zealand - Reporting System Only |
| 99 | F75Z0001 | New Zealand Special Processing Parameters | 1 | Z1 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 100 | F75Z0006 | Leave Taken A.G.E. Work File | 3 | Z6 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| TOP77: Payroll (Canadian) |
| 101 | F07183 | Commission History Detail File | 7 | ZB | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 102 | F77190 | Special Handling Setup - F77190 | 6 | J2 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 103 | F77220 | Employee Special Handling Detail - F77220 | 11 | J3 | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
| 104 | F77703 | Payroll History Audit Report - Worktable | 10 | AR | PDBA | DBA Code | Numeric | Generic Edit | 5 | 0 |
