| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2NZ_LVACC | Payroll Result: Leave Accruals LVACC - NZ | 12 | EFFDT | Effective Date for LVACC Record - NZ | nvarchar | 8 | 0 | | |
2 | P2RQ_QSPR | HR-AU-PS: Payroll structure for Superannuation | 23 | EFFDT | APS Superannuation date of effect | nvarchar | 8 | 0 | | |
3 | P2UN_QSPR | HR-UN: Payroll structure for Superannuation | 23 | EFFDT | APS Superannuation date of effect | nvarchar | 8 | 0 | | |
TOPCompensation Administration |
4 | T71ADM10 | Compensation Review Item Attributes | 10 | EFFDT | Default Effective Date | nvarchar | 8 | 0 | | |
TOPEnterprise Compensation Management |
5 | T71ADM_EE_HIST | Compensation Tracking for Employees | 6 | EFFDT | Default Effective Date | nvarchar | 8 | 0 | | |
TOPPublic Sector |
6 | PA0507 | HR-AU-PS: Master Data (Superannuation) | 25 | EFFDT | APS Superannuation date of effect | nvarchar | 8 | 0 | | |