| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0006 | Business Unit Master | 3 | MC | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
2 | F0006D | Business Unit Alternate Description Master | 7 | LJ | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
3 | F0006DZ1 | Business Unit Alternate Description Z file | 21 | SZ | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
4 | F0006S | Date Effective Business Unit Master | 5 | MC | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
5 | F0006Z1 | Cost Center Unedited Transaction Table | 16 | SZ | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
6 | F0006Z2 | Business Unit Master Z File | 16 | SZ | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP01: Address Book |
7 | F0101 | Address Book Master | 5 | AB | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
8 | F0101Z2 | Address Book - Interoperability | 18 | SZ | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
9 | F0111 | Address Book - Who's Who | 9 | WW | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
10 | F0111Z1 | Batch Who's Who Information | 22 | BW | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP05: Time Accounting and HRM Base |
11 | F069016 | Payroll Tax Area Profile | 2 | YP | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
12 | F069116 | Payroll Transaction Constants | 3 | YC | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP05A: PeopleSoft HR & PR Foundation |
13 | F08096 | HR Generic Table Headings | 3 | H$ | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
14 | F08396 | Key Employee Heading | 4 | HX | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
15 | F08591 | Accrued Benefit Formulas | 3 | H5 | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP07: Payroll |
16 | F069026 | Payroll Generic Tables | 11 | Y2 | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
17 | F069171 | Payroll Payment/ Reporting Terms | 4 | YP | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
18 | F0729 | Employee DBA Override Instructions | 62 | Y9 | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP08AD: ADP Integration |
19 | F051375 | ADP Payroll DBA Transaction Constants | 5 | AD | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP08B: Benefits Administration |
20 | F08320 | Benefits Plan Master | 3 | BA | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP08U: PeopleSoft HR US |
21 | F08365 | NDT - Criteria Heading | 5 | HX | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP17: Customer Service Management |
22 | F1720 | Contract Header | 13 | CH | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP47: Electronic Commerce |
23 | F4780 | Address Cross-Reference | 8 | AX | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP48S: Service Billing |
24 | F4812 | Billing Detail Workfile | 43 | WD | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
25 | F4812H | Billing Workfile History | 43 | WD | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
26 | F4812HS | Billing Workfile History Purged Save | 43 | WD | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
27 | F48SUI01 | Billing Detail Print Workfile | 43 | WD | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP52: Contract Billing |
28 | F5201 | Contract Master | 7 | G4 | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP52G: Proj & Gov Contract Accounting |
29 | F52G01M | Advanced Contracts Modifications | 12 | CM | DC | Description - Compressed | String | Generic Edit | 40 | 0 |
TOP89: Conversion Programs |
30 | F01111Z1 | Batch - Contact Information | 24 | CB | DC | Description - Compressed | String | Generic Edit | 40 | 0 |