| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2B2_URLAN | HCM Declustering B2 - Leave Accrual (Table URLAN) | 14 | URART | Leave type | nvarchar | 2 | 0 | | |
2 | P2NZ_LVACC | Payroll Result: Leave Accruals LVACC - NZ | 5 | URART | Leave type | nvarchar | 2 | 0 | | |
3 | P2NZ_LVTAK | Payroll Result: Leave Taken LVTAK - NZ | 5 | URART | Leave type | nvarchar | 2 | 0 | | |
4 | P2NZ_P5NZB | Payroll Result: Leave Balance P5NZB - NZ | 7 | URART | Leave type | nvarchar | 2 | 0 | | |
5 | P2RM_MVENT | HR Master Record: Infotype 0005 (Leave Entitlement) | 6 | URART | Leave type | nvarchar | 2 | 0 | | |
6 | P2RQ_LSLPR | Payroll Results: LSLPR Table | 11 | URART | Leave type | nvarchar | 2 | 0 | | |
7 | P2RQ_LVACC | Payroll Results: Leave Accrual (Australia) | 5 | URART | Leave type | nvarchar | 2 | 0 | | |
8 | P2RQ_LVEPR | Payroll Results: LVEPR Table | 11 | URART | Leave type | nvarchar | 2 | 0 | | |
9 | P2RQ_P5BAL | Payroll Results: P5BAL Table | 7 | URART | Leave type | nvarchar | 2 | 0 | | |
10 | P2RX_VCP | Payroll Results: Leave Deduction | 7 | URART | Leave type | nvarchar | 2 | 0 | | |
TOPAustralia |
11 | T5QLA | Australian Leave Accrual Unpaid Absence Rules | 3 | URART | Leave type | nvarchar | 2 | 0 | | |
12 | T5QLP | Leave Provisions - Australia | 3 | URART | Leave type | nvarchar | 2 | 0 | | |
13 | T5QLR | Leave Accrual Rules Australia | 3 | URART | Leave type | nvarchar | 2 | 0 | | |
14 | T5QLT | Leave Accrual-Id description Australia | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
15 | T5QRR | Term. Rules for Long Serv. Leave & Leave Loading Australia | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
16 | T5QTR | Term. Rules for Long Serv. Leave & Leave Loading Australia | 3 | URART | Leave type | nvarchar | 2 | 0 | | |
17 | T5QTT | Termination Taxation of Leave Australia | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
TOPDenmark |
18 | T5M6A | Assignment of Leave Types to Wage Types | 2 | URART | Leave type | nvarchar | 2 | 0 | | |
19 | T5M_SUMMER_PER | Extra Vacation Days due to Vacation in the Summer Period | 5 | URART | Leave type | nvarchar | 2 | 0 | | |
TOPNew Zealand |
20 | PA0311 | Leave Adjustments - NZ | 24 | URART | Leave type | nvarchar | 2 | 0 | | |
21 | PA0312 | Leave History Adjustments NZ | 24 | URART | Leave type | nvarchar | 2 | 0 | | |
22 | T7NZLA | Leave Accrual Id Table - NZ | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
23 | T7NZLB | Leave Accrual Id Description - NZ | 5 | URART | Leave type | nvarchar | 2 | 0 | | |
24 | T7NZLP | Leave Payment Rule Table - NZ | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
25 | T7NZLR | Leave Rule Table - NZ | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
26 | T7NZLU | Leave Unpaid Absence Rules - NZ | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
27 | T7NZXL | Termination Wage Types for Leave NZ | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
28 | PTMLEACONV | Assignment Table IT0005 - IT2006 (RPTLEACONV Report) | 10 | URART | Leave type | nvarchar | 2 | 0 | | |
29 | T533T | Leave Type Texts | 4 | URART | Leave type | nvarchar | 2 | 0 | | |
30 | T557K | Relation Table: Quota Types for Reporting | 5 | URART | Leave type | nvarchar | 2 | 0 | | |