| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2AA_PS_SA | Payroll Result: Pension Data for KSA | 10 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
2 | P2QA_PS_QA | Payroll Result: Pension Data for QA | 10 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
3 | P2TN_NHI | Payroll Structure NHI Taiwan | 17 | EXRSN | Reason for exemption | nvarchar | 2 | 0 | | |
4 | P2TN_NHIF | Payroll Structure NHIF Taiwan | 17 | EXRSN | Reason for exemption | nvarchar | 2 | 0 | | |
5 | PA3320 | HR Master Record: Infotype 3320 | 25 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
6 | PA3335 | HR Master Record: Infotype 3335 | 26 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
7 | PA3378 | HR Master Record: Infotype 3378 | 25 | EXRSN | PDPA Exception Reason | nvarchar | 5 | 0 | | |
8 | PB3378 | Applicant data infotype 3378 (model) | 25 | EXRSN | PDPA Exception Reason | nvarchar | 5 | 0 | | |
9 | T5RET | PDPA Exceptional Reason Text Table | 3 | EXRSN | PDPA Exception Reason | nvarchar | 5 | 0 | | |
10 | T5REX | PDPA Exception Reason Definination | 2 | EXRSN | PDPA Exception Reason | nvarchar | 5 | 0 | | |
11 | T7QAPBS24 | Exemption Reason | 2 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
12 | T7QAPBS24T | Exemption Reason Text | 3 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
13 | T7SAPBS24 | Exemption Reason | 2 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
14 | T7SAPBS24T | Exemption Reason Text | 3 | EXRSN | Exemption Reason | nvarchar | 4 | 0 | | |
TOPTaiwan |
15 | PA0352 | NHI for Family member (TW) | 32 | EXRSN | Reason for exemption | nvarchar | 2 | 0 | | |
16 | PA0355 | National Health Insurance Taiwan | 29 | EXRSN | Reason for exemption | nvarchar | 2 | 0 | | |
17 | T7TW1D | NHI Exempt Reason and amount | 2 | EXRSN | Reason for exemption | nvarchar | 2 | 0 | | |
18 | T7TW1Y | NHI Exempt Reason Text | 3 | EXRSN | Reason for exemption | nvarchar | 2 | 0 | | |
TOPTask Resource Management |
19 | LGTKA | Task actual execution data log | 7 | EXRSN | External Reason | nvarchar | 3 | 0 | | |
20 | LLGST | Resource status log | 6 | EXRSN | External Reason | nvarchar | 3 | 0 | | |
21 | LNODE | Node | 8 | EXRSN | Reason for Object Being Blocked | nvarchar | 3 | 0 | | |
22 | LRSNC | External vs Internal reason code | 4 | EXRSN | External Reason | nvarchar | 3 | 0 | | |
23 | LRSNCT | External vs Internal reason code - description | 5 | EXRSN | External Reason | nvarchar | 3 | 0 | | |