Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
1 | T7UNPF_FI_ADDET | Additional Details | 3 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
2 | T7UNPF_FI_ADJUS | Adjustments | 3 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
3 | T7UNPF_FI_CONTR | Contributions | 3 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
4 | T7UNPF_FI_GREMSG | Response Message | 2 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
5 | T7UNPF_FI_GRESP | Get Response | 2 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
6 | T7UNPF_FI_MISCE | Financial Interface Misc. Transactions | 3 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
7 | T7UNPF_FI_REMSG | Response Message | 2 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
8 | T7UNPF_FI_RESP | Response | 2 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
9 | T7UNPF_FI_STFHD | Staff Member Header Table | 3 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
10 | T7UNPF_FI_TRANS | Additional Details | 3 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
11 | T7UNPF_HR_ADDR | Address | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
12 | T7UNPF_HR_CHILD | Child details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
13 | T7UNPF_HR_CNTRC | Contract details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
14 | T7UNPF_HR_DEPND | Dependent details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
15 | T7UNPF_HR_DS | Duty Station details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
16 | T7UNPF_HR_EMAIL | Email Information | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
17 | T7UNPF_HR_LANG | Language Allowance | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
18 | T7UNPF_HR_LWOP | Leave Without Pay | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
19 | T7UNPF_HR_PART | Parttime Details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
20 | T7UNPF_HR_PHONE | Phone Information | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
21 | T7UNPF_HR_SAL | Salary details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
22 | T7UNPF_HR_SECON | Staff Secondment details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
23 | T7UNPF_HR_SEP | Staff Member Separation details | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
24 | T7UNPF_HR_STAFF | Staff Member Table | 5 | OPRHD | Unique ID | nvarchar | 15 | 0 | ||
25 | T7UNPF_HR_STFHD | Staff Member Header Table | 4 | OPRHD | Unique ID | nvarchar | 15 | 0 |