05A: OW HR & PR Foundation |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 812 | F05002 | EV | 9 | 1 | Pay Type by Category | Files | 05A: OW HR & PR Foundation | No |
2 | 812 | F05003 | EV | 58 | 1 | Verification of Employment Data | Files | 05A: OW HR & PR Foundation | No |
3 | 812 | F05004 | SC | 7 | 1 | Common Settings for HR Employee Self Service Programs | Files | 05A: OW HR & PR Foundation | No |
4 | 812 | F05840 | SR | 8 | 4 | Employee/Supervisor Relationship Level | Transaction Files | 05A: OW HR & PR Foundation | No |
5 | 812 | F05842 | AT | 13 | 3 | Employee/Supervisor Approval History | Transaction Files | 05A: OW HR & PR Foundation | No |
6 | 812 | F05844 | AH | 10 | 1 | Approval Hierarchy Table | Transaction Files | 05A: OW HR & PR Foundation | No |
7 | 812 | F060116 | YA | 209 | 14 | Employee Master Information | Master Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
8 | 812 | F0601161 | PT | 211 | 1 | Point-In-Time Employee Master | History Files | 05A: OW HR & PR Foundation | No |
9 | 812 | F0601162 | PH | 7 | 1 | Point-In-Time Employee Master Header | History Files | 05A: OW HR & PR Foundation | No |
10 | 812 | F060116W | YA | 229 | 1 | EE Master Request File | Secondary Master Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
11 | 812 | F060116Z | SZ | 208 | 2 | Unedited Quick Hire Transaction File | Transaction Files | 05A: OW HR & PR Foundation | No |
12 | 812 | F060117 | YA | 16 | 1 | Employee Master - International Data | Master Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
13 | 812 | F060117A | YA | 7 | 1 | Employee Master - International Data Tag | Files | 05A: OW HR & PR Foundation | |
14 | 812 | F060120 | YA | 29 | 1 | Employee Master Additional Information File | Master Files | 05A: OW HR & PR Foundation | No |
15 | 812 | F06041 | JK | 3 | 1 | Specify Future Data Fields | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
16 | 812 | F06045 | BB | 12 | 1 | Employee Master - Mass Changes | Batch Input Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
17 | 812 | F06345 | JL | 58 | 2 | Historical Payroll Register | Regular Work Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
18 | 812 | F069056 | YO | 20 | 1 | Establishment Constant File | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
19 | 812 | F08011 | JV | 15 | 1 | Job Evaluation - Compensable Factors Table | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
20 | 812 | F08040 | JT | 29 | 1 | HR History Constants | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
21 | 812 | F08041 | JU | 3 | 1 | Select Data Items for History Tracking | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
22 | 812 | F08042 | JW | 12 | 3 | HR History | History Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
23 | 812 | F08043 | AC | 11 | 1 | HR Additional Constants | Constants Files | 05A: OW HR & PR Foundation | No |
24 | 812 | F08046 | HZ | 5 | 2 | Turnover Column Consolidation | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
25 | 812 | F08094 | JW | 4 | 1 | Profile Database - Cross Reference | Extra Features Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
26 | 812 | F08095 | J9 | 17 | 1 | Payroll Resume/HR Conversion | Extra Features Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
27 | 812 | F08096 | H$ | 10 | 2 | HR Generic Table Headings | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
28 | 812 | F08097 | H# | 7 | 1 | HR Generic Table Ranges | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
29 | 812 | F08393 | BN | 7 | 1 | Pay Type Tables | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
30 | 812 | F083931 | BN | 7 | 1 | DBA Pay Type Tables | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
31 | 812 | F08396 | HX | 8 | 1 | Key Employee Heading | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
32 | 812 | F08397 | HY | 10 | 1 | Key Employee Detail | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
33 | 812 | F08591 | H5 | 10 | 2 | Accrued Benefit Formulas | Constants Files | 05A: OW HR & PR Foundation | AS400 Coexistence Tables |
34 | 812 | F980014D | MD | 10 | 6 | Mail Merge Runtime Web Data | Files | 05A: OW HR & PR Foundation | Business Data |