INT_WC_ANZSIC_WCOTAIL

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICY INTEGER 4
2 COMPANY SMALLINT 2
3 PRODUCT CHARACTER(3) 3
4 TERMIDENT BIGINT 8
5 ITEMNO SMALLINT 2
6 TRANCNT SMALLINT 2
7 TERMSTART INTEGER 4
8 ITEM_CLASS CHARACTER(3) 3
9 WCOTAIL_ITEM_IMAGEFLAG CHARACTER(1) 1
10 WCOTAIL_ITEM_ITMSTATUS CHARACTER(1) 1
11 WCOTAIL_ITEM_EFFECTDTE INTEGER 4
12 WCOTAIL_ITEM_TERMINCEP INTEGER 4
13 WCOTAIL_ITEM_DUEDATE INTEGER 4
14 WCOTAIL_NOTWCE_GROSSPREM_ITEM NUMERIC(38,2) 19
15 ACTIVTO INTEGER 4
16 ANZSICCD CHARACTER(8) 8
17 ACTWAGES NUMERIC(11,0) 19
18 ESTWAGES NUMERIC(11,0) 19
19 NOTWCE_ACTWAGES NUMERIC(11,0) 19
20 NOTWCE_ESTWAGES NUMERIC(11,0) 19
21 NOTWCE_ANZSICCD CHARACTER(8) 8
22 COUNT_ANZSIC_1993 BIGINT 8
23 MDLRATE NUMERIC(5,2) 19
24 UWCATG CHARACTER(2) 2
25 ACTNOEMP INTEGER 4
26 ESTNOEMP INTEGER 4
27 UWRATE NUMERIC(5,2) 19
28 TECHRATE NUMERIC(5,2) 19
29 INDRATE NUMERIC(5,2) 19
30 GZTADJRATE NUMERIC(5,2) 19
31 OVRUWRATE NUMERIC(5,2) 19
32 OVRMDLRATE NUMERIC(5,2) 19
33 RATEOVRREAS CHARACTER(2) 2
34 VARUWMODEL NUMERIC(5,2) 19
35 VARTECHUW NUMERIC(5,2) 19
36 VARINDSTUW NUMERIC(5,2) 19
37 WAGESRATE NUMERIC(11,2) 19
38 WAGESDECSTAT CHARACTER(2) 2
39 ACTWAGEDECST CHARACTER(2) 2
40 ROW_ID BIGINT 8