| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAustralia |
1 | T5QLA | Australian Leave Accrual Unpaid Absence Rules | 2 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
2 | T5QLG | Leave Type Grouping Australia | 2 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
3 | T5QLH | Leave Type Grouping text Australia | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
4 | T5QLP | Leave Provisions - Australia | 2 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
5 | T5QLR | Leave Accrual Rules Australia | 2 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
6 | T5QLT | Leave Accrual-Id description Australia | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
7 | T5QRR | Term. Rules for Long Serv. Leave & Leave Loading Australia | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
8 | T5QRT | Term. Rules for Long Serv-Leave & Leave Loading Australia | 4 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
9 | T5QTR | Term. Rules for Long Serv. Leave & Leave Loading Australia | 7 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
10 | T5QTT | Termination Taxation of Leave Australia | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
TOPConstruction Industry |
11 | T5DBF | Construction Industry Leave | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
TOPNew Zealand |
12 | T7NZLA | Leave Accrual Id Table - NZ | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
13 | T7NZLB | Leave Accrual Id Description - NZ | 4 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
14 | T7NZLE | Related Leave Type - NZ | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
15 | T7NZLF | Related Leave Types Description - NZ | 4 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
16 | T7NZLG | Leave Type Grouping - NZ | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
17 | T7NZLH | Leave Type Grouping Description - NZ | 4 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
18 | T7NZLP | Leave Payment Rule Table - NZ | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
19 | T7NZLR | Leave Rule Table - NZ | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
20 | T7NZLU | Leave Unpaid Absence Rules - NZ | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
21 | T7NZXL | Termination Wage Types for Leave NZ | 3 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
22 | T001P | Personnel Area/Subarea | 6 | MOURA | Personnel Subarea Grouping for Leave Types | nvarchar | 2 | 0 | | |