| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05A: OW HR & PR Foundation |
1 | F060116 | Employee Master Information | 152 | YA | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
2 | F0601161 | Point-In-Time Employee Master | 154 | PT | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
3 | F060116W | EE Master Request File | 152 | YA | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
4 | F060116Z | Unedited Quick Hire Transaction File | 62 | SZ | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
5 | F060119 | Employee Jobs History File | 19 | YE | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
6 | F060118 | Employee Jobs | 18 | YE | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
TOP08: Human Resources |
7 | F082003 | Grade/Step Progression Detail File | 12 | YW | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
TOP08AD: ADP Integration |
8 | F05137 | ADP Employee Master Information | 20 | AD | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
TOP08P: Position Control |
9 | F08001 | Job information | 74 | JM | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
TOP08R: Recruitment Management - (Appl. Track. & Req.) |
10 | F08102 | Requisition Information | 16 | HN | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
TOP08W: Wage and Salary |
11 | F082001 | Pay Grade/Salary Range Table | 2 | HS | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
12 | F08201 | Salary Review Workfile | 11 | HR | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |
13 | F08830WF | Compensation Root Work Table | 34 | YN | PGRS | Pay Grade Step | String | Generic Edit | 4 | 0 |