| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RK_WCB1 | Payroll results - Workers' compensation information | 10 | CLGRP | Classification group for WCB | nvarchar | 4 | 0 | | |
2 | T77WWW_ELIGIBLE | Employee Eligibility for Advanced Claims | 3 | CLGRP | Employee Eligibility Group | nvarchar | 2 | 0 | | |
TOPCalculation of Employment Period |
3 | T525T | Time Specification Type for Employment Period Calculation | 6 | CLGRP | Collision Group for Time Specification Type | nvarchar | 2 | 0 | | |
4 | T525TCL | Collision Group for Time Specification Type | 2 | CLGRP | Collision Group for Time Specification Type | nvarchar | 2 | 0 | | |
5 | T525TCLT | Collision Group for Time Specification Type | 3 | CLGRP | Collision Group for Time Specification Type | nvarchar | 2 | 0 | | |
TOPCanada |
6 | T5KWA | Workers' Compensation accounts table | 2 | CLGRP | Classification group for WCB | nvarchar | 4 | 0 | | |
7 | T5KWB | Classification groups assignment for WCB | 4 | CLGRP | Classification group for WCB | nvarchar | 4 | 0 | | |
8 | T5KWC | Classification groups for WCB | 2 | CLGRP | Classification group for WCB | nvarchar | 4 | 0 | | |
9 | T5KWT | Classification groups for WCB - Text table | 3 | CLGRP | Classification group for WCB | nvarchar | 4 | 0 | | |