| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2NZ_LVPAY | Payroll Result: Leave Payment LVPAY - NZ | 11 | ABBEG | Start Date | nvarchar | 8 | 0 | | |
TOPNew Zealand |
2 | HNZLVPAY | Table for modified LVPAY cluster table records | 13 | ABBEG | Start Date | nvarchar | 8 | 0 | | |
TOPPublic Sector |
3 | PDPBSZVABS | Periods (Record Type 60), ZVE-PBS | 13 | ABBEG | Start of Period, ZVE-PBS | nvarchar | 8 | 0 | | |
4 | PDPBSZVDIF | Difference (Record Type 70), ZVE-PBS | 13 | ABBEG | Start of Period, ZVE-PBS | nvarchar | 8 | 0 | | |
TOPSocial Insurance |
5 | P01EE_STAT | Admin. Records for Data Exchange for Compensation Benefits | 4 | ABBEG | Start of Absence | nvarchar | 8 | 0 | | |
TOPStatements |
6 | P01W_DBAL | Data Module: Statement of Earnings - General | 7 | ABBEG | Unable to Work/Rehabilitation Since | nvarchar | 8 | 0 | | |
7 | P01W_DBKR | Data Module: Remuneration Statement for Sick Pay | 8 | ABBEG | Unable to Work/Rehabilitation Since | nvarchar | 8 | 0 | | |