| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 92 | GL | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP05: Time Accounting and HRM Base |
| 2 | F050116W | Employee Master Integrations Work File | 3 | EM | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 3 | F051124 | Director Text Setup File | 2 | Y4 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 4 | F051402 | Search Constants | 2 | SC | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 5 | F054101 | Employee Personal Profile Information History Table | 9 | EH | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 6 | F054101W | Employee Personal Profile Information Work Table | 9 | EP | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 7 | F06106 | Employee Pay Instructions | 103 | YM | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 8 | F0618 | Employee Transaction History | 9 | YT | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP05A: PeopleSoft HR & PR Foundation |
| 9 | F05844 | Approval Hierarchy Table | 2 | AH | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 10 | F060116 | Employee Master Information | 23 | YA | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 11 | F0601161 | Point-In-Time Employee Master | 25 | PT | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 12 | F060116W | EE Master Request File | 23 | YA | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 13 | F060116Z | Unedited Quick Hire Transaction File | 23 | SZ | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 14 | F060119 | Employee Jobs History File | 2 | YE | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 15 | F06345 | Historical Payroll Register | 7 | JL | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP05T: Time Entry |
| 16 | F051123 | Self Service Time Entry Layout Setup File | 2 | Y3 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 17 | F06116 | Employee Transaction Detail File | 9 | YT | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 18 | F06116Z1 | Employee Transactions - Batch File | 26 | VL | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 19 | F06116Z2 | ESS Timecard History | 26 | VM | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 20 | F06278 | Retro Timecard Detail File | 12 | YT | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 21 | F063951 | Payroll Journal (Compressed) File | 29 | GL | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP06: Payroll (old) - Obsolete-do not reuse |
| 22 | F060118 | Employee Jobs | 2 | YE | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP07: Payroll |
| 23 | F05290 | WF - Payroll Journal (Detail) | 29 | JR | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 24 | F06156 | Pay Check History Summary | 28 | YU | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 25 | F06270 | Retro Processing Parameter | 37 | JP | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 26 | F063106 | Deduction/Benefit Work File | 5 | Y7 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 27 | F06350I | WF - Paycheck (Interims) | 37 | Y4 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 28 | F06490 | Payroll/Accounts Payable Ledger Detail | 8 | JR | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 29 | F0716701 | Employee Assignment T/E Template Information | 27 | EA | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 30 | F0716709 | Employee Assignment T/E Template Info History | 27 | EA | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 31 | F0717 | ROE Summary History | 37 | JF | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 32 | F07235 | Auto Deposit Bank Workfile | 5 | Y6 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 33 | F07236 | Auto Deposit Tape File Setup | 2 | Y6 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 34 | F07236T | Auto Deposit Tape File Setup (Additional) | 2 | Y6 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 35 | F07350 | Payment File | 12 | Y0 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 36 | F07355 | Pre-Payroll Error File | 25 | Y5 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 37 | F07490 | Payroll - Accounts Payable Detail (One World) | 8 | JR | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 38 | F07727 | Canadian Pension Information | 4 | J7 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 39 | F07822 | Company Federal Control Table | 11 | JI | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 40 | F07830 | Employee Federal Control Table | 61 | Y0 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 41 | F07831 | Employee State/Local Control Table | 37 | YB | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 42 | F07832 | Employee Special Handling Control Table | 23 | YH | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 43 | F07850 | Group Fund Setup | 4 | FG | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 44 | F07UI200 | Timecard History Work File | 12 | TH | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08: Human Resources |
| 45 | F081161 | ACA Employee Eligibility | 25 | AD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 46 | F0811619 | ACA Employee Eligibility Archive | 25 | AD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 47 | F082003 | Grade/Step Progression Detail File | 4 | YW | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 48 | F083305 | Mail Merge Header/Detail | 21 | MM | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08AD: ADP Integration |
| 49 | F05137 | ADP Employee Master Information | 11 | AD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 50 | F051371 | ADP Employee DBA Instructions | 108 | AD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 51 | F051372 | ADP Employee Job Master Information | 5 | AD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 52 | F051373 | ADP Employee Auto Deposit Instructions | 5 | AD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 53 | F051374 | ADP Employee Tax Withholding/Override Instructions | 5 | AD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08B: Benefits Administration |
| 54 | F0833WF | Benefit Statement Work file | 18 | WF | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08H: Health and Safety |
| 55 | F08601 | Injury/Illness Case Master | 10 | HL | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08P: Position Control |
| 56 | F08005 | Business Unit/ Job Id. X-Ref | 1 | JV | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 57 | F08101 | Position Master | 26 | HP | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 58 | F081012 | Position Accounts | 2 | HC | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 59 | F08101P | Purge - Position Master | 26 | HP | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 60 | F08111 | Position Budget Detail | 19 | HQ | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 61 | F08111P | Purge - Position Budget Detail | 19 | HQ | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08R: Recruitment Management - (Appl. Track. & Req.) |
| 62 | F08102 | Requisition Information | 37 | HN | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 63 | F08401 | Applicant Master | 43 | HA | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 64 | F08401WF | Applicant Work File | 44 | XN | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08U: PeopleSoft HR US |
| 65 | F08910 | COBRA Qualified Beneficiary File | 27 | J1 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 66 | F08990 | COBRA General Constants | 2 | HW | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 67 | F089901 | COBRA General Constants Additional Information | 2 | CC | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 68 | F089902 | COBRA General Constants - COBRA Notices Information | 2 | J2 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 69 | F08991 | COBRA Qualifying Event Constant | 5 | HD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 70 | F08992 | Qualifying Event Rules Header | 4 | QE | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP08W: Wage and Salary |
| 71 | F08201 | Salary Review Workfile | 7 | HR | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 72 | F08818 | Increase Type Rules | 3 | YM | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 73 | F08830WF | Compensation Root Work Table | 12 | YN | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP09: General Accounting |
| 74 | F0911P | Purge - Account Ledger | 92 | GL | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 75 | F0911Z1 | Journal Entry Transactions - Batch File | 109 | VN | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 76 | F0911Z4 | F0911 Interoperability Table | 114 | SZ | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 77 | F0917 | Bank Statement Detail | 42 | GD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 78 | F09UI015 | Indexed Computations Multi-Tiered Entries | 92 | GL | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP09E: Expense Reimbursment |
| 79 | F20111 | Expense Report Header | 35 | EH | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP17C: Call Management |
| 80 | F1755 | Case Master | 99 | ZA | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 81 | F1760 | Time Entry | 17 | ZB | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 82 | F1797 | S/WM Address Book Information | 20 | CS | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP18: Timecard Automation |
| 83 | F186602 | Labor Rules Tag File | 23 | TF | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP37: Quality Management |
| 84 | F3711 | Test Results | 19 | TR | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 85 | F3711Z1 | Test Results Unedited Transaction Table | 32 | SZ | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 86 | F37900 | Certificate of Analysis (COA) Extract | 19 | TR | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP42: Sales Management |
| 87 | F42800G | Sales Update G Batch Workfile | 23 | SG | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP48S: Service Billing |
| 88 | F48096 | Billing Rate / Mark up Table | 17 | WQ | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 89 | F4812 | Billing Detail Workfile | 44 | WD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 90 | F4812H | Billing Workfile History | 44 | WD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 91 | F4812HS | Billing Workfile History Purged Save | 44 | WD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 92 | F48S0618 | Payroll Reclassification Workfile | 9 | YT | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 93 | F48S910 | Billing Detail Journal Workfile | 50 | W2 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 94 | F48S911 | Summarized Journal Workfile | 41 | W3 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 95 | F48SUI01 | Billing Detail Print Workfile | 44 | WD | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP52: Contract Billing |
| 96 | F5212 | T and M, Unit Price and Lumpsum Cross Reference Accounts | 19 | G5 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 97 | F5280W | Contract Revenue Summary Work File | 26 | GY | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP52G: Proj & Gov Contract Accounting |
| 98 | F52G21 | Contract Specific Labor Category Cross Reference | 13 | LR | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP54HS: Health & Safety Incident Mgt |
| 99 | F54HS02 | Incident People | 19 | S2 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| 100 | F54HS02M | Incident People Change History | 22 | I2 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP75A: Australia |
| 101 | F75A0301 | Superannuation Payment | 4 | SA | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
| TOP77: Payroll (Canadian) |
| 102 | F77200 | Canadian Employee Year-End Form Header - F77200 | 12 | J5 | HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 |
