| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 05A: PeopleSoft HR & PR Foundation | ||||||||||
| 1 | F060116 | Employee Master Information | 181 | YA | DEPT | Department Code | String | Generic Edit | 12 | 0 |
| 2 | F0601161 | Point-In-Time Employee Master | 183 | PT | DEPT | Department Code | String | Generic Edit | 12 | 0 |
| 3 | F060116W | EE Master Request File | 181 | YA | DEPT | Department Code | String | Generic Edit | 12 | 0 |
| H95: Object and Environment Tech | ||||||||||
| 4 | F00927 | E1 Users PIM Information | 14 | SK | DEPT | Department Code | String | Generic Edit | 12 | 0 |