| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F050116W | Employee Master Integrations Work File | 14 | EM | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
2 | F0618 | Employee Transaction History | 63 | YT | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
3 | F069116 | Payroll Transaction Constants | 79 | YC | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
4 | F06915 | Holiday Table | 15 | JH | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP05A: PeopleSoft HR & PR Foundation |
5 | F05003 | Verification of Employment Data | 28 | EV | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
6 | F060116 | Employee Master Information | 28 | YA | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
7 | F0601161 | Point-In-Time Employee Master | 30 | PT | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
8 | F060116W | EE Master Request File | 28 | YA | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
9 | F060116Z | Unedited Quick Hire Transaction File | 60 | SZ | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
10 | F060119 | Employee Jobs History File | 25 | YE | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP05T: Time Entry |
11 | F06116 | Employee Transaction Detail File | 63 | YT | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
12 | F06116Z1 | Employee Transactions - Batch File | 77 | VL | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
13 | F06116Z2 | ESS Timecard History | 77 | VM | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
14 | F06278 | Retro Timecard Detail File | 63 | YT | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
15 | F060118 | Employee Jobs | 24 | YE | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP07: Payroll |
16 | F06270 | Retro Processing Parameter | 47 | JP | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
17 | F0729 | Employee DBA Override Instructions | 14 | Y9 | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
18 | F07UI200 | Timecard History Work File | 66 | TH | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP08: Human Resources |
19 | F081161 | ACA Employee Eligibility | 20 | AD | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
20 | F0811619 | ACA Employee Eligibility Archive | 20 | AD | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP08AD: ADP Integration |
21 | F05137 | ADP Employee Master Information | 23 | AD | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
22 | F051375 | ADP Payroll DBA Transaction Constants | 81 | AD | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP08P: Position Control |
23 | F08001 | Job information | 5 | JM | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP08R: Recruitment Management - (Appl. Track. & Req.) |
24 | F08102 | Requisition Information | 18 | HN | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP08W: Wage and Salary |
25 | F082001 | Pay Grade/Salary Range Table | 9 | HS | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
26 | F08201 | Salary Review Workfile | 9 | HR | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
27 | F08290 | Pay/Salary Formula File | 1 | HG | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
28 | F08830WF | Compensation Root Work Table | 16 | YN | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP18: Timecard Automation |
29 | F186602 | Labor Rules Tag File | 73 | TF | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
TOP48S: Service Billing |
30 | F48S0618 | Payroll Reclassification Workfile | 63 | YT | SALY | Pay Class (H/S/P) | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.