INT_WCOM_POLICY_ITEM_TERM

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 POLICYKEY BIGINT 8
2 POLICY INTEGER 4
3 COMPANY SMALLINT 2
4 QTEPRDUCT CHARACTER(3) 3
5 PRODUCT CHARACTER(3) 3
6 POLICY_NUMBER CHARACTER VARYING(12) 12
7 POLICY_TERMSTART INTEGER 4
8 POLICY_DUE_DATE INTEGER 4
9 ITEMNO SMALLINT 2
10 AGREEMENT_TYPE_CDC CHARACTER VARYING(3) 3
11 LATEST_TERM_IND BIGINT 8
12 FIRST_ESTWAGES NUMERIC(11,0) 19
13 LAST_ESTWAGES NUMERIC(11,0) 19
14 FIRST_ACTWAGES NUMERIC(11,0) 19
15 LAST_ACTWAGES NUMERIC(11,0) 19
16 FIRST_ESTNOEMP INTEGER 4
17 LAST_ESTNOEMP INTEGER 4
18 FIRST_ACTNOEMP INTEGER 4
19 LAST_ACTNOEMP INTEGER 4
20 LAST_TECHRATE NUMERIC(5,2) 19
21 LAST_MDLRATE NUMERIC(5,2) 19
22 LAST_INDRATE NUMERIC(5,2) 19
23 INITIAL_ESTIMATED_WAGES NUMERIC(11,0) 19
24 CURRENT_WAGES NUMERIC(11,0) 19
25 INITIAL_ESTIMATED_NOEMP INTEGER 4
26 CURRENT_NOEMP INTEGER 4
27 LAST_CBASICPRM NUMERIC(11,2) 19
28 LAST_ITEM_REASONCDE CHARACTER(2) 2
29 LAST_ITEM_ITMSTATUS CHARACTER(1) 1
30 MIN_PREM_FLAG_ITEM CHARACTER VARYING(1) 1
31 MIN_PREM_FLAG_POL CHARACTER VARYING(1) 1
32 EXTENSION_LEVEL1_KEY_POL INTEGER 4
33 EXTENSION_LEVEL1_NAME_POL CHARACTER(1) 1
34 LAST_POLICY_REASON CHARACTER VARYING(2) 2
35 LAST_POLICY_POLSTATUS CHARACTER VARYING(1) 1
36 LAST_POLICY_AGENT INTEGER 4
37 LAST_MINPRMAMT NUMERIC(11,2) 19
38 LAST_MIN_PREM_ADJ NUMERIC(11,2) 19
39 LAST_MIN_PREM_ADJ_RC CHARACTER(2) 2
40 LAST_ITEM_AGENT INTEGER 4
41 LAST_ITEM_ITCE NUMERIC(6,2) 19
42 ITCE_POL NUMERIC(6,2) 19
43 END_CONSENT CHARACTER(1) 1
44 PRIORCLM CHARACTER(1) 1
45 LOCATNREF INTEGER 4
46 POLICY_EXPIRY_DATE INTEGER 4
47 MULTIANZSIC_FLAG CHARACTER VARYING(1) 1
48 SAQ CHARACTER VARYING(4) 4
49 NUMBER_OF_LOCATIONS BIGINT 8
50 VARUWMODEL NUMERIC(5,2) 19
51 VARTECHUW NUMERIC(5,2) 19
52 VARINDSTUW NUMERIC(5,2) 19
53 OVRMDLRATE NUMERIC(5,2) 19
54 OVRUWRATE NUMERIC(5,2) 19
55 UWRATE NUMERIC(5,2) 19
56 RATEOVRREAS CHARACTER(2) 2
57 PURE_MODEL_RATE NUMERIC(5,2) 19
58 TBASICPRM NUMERIC(11,2) 19
59 PREMREAST CHARACTER(2) 2
60 WA_GAZETTE_DISCOUNT CHARACTER VARYING(1) 1
61 TRANDATE INTEGER 4
62 ITEM_CLASS CHARACTER(3) 3
63 ANZSICCD_1993 CHARACTER VARYING(8) 8
64 ANZSICCD_2006 CHARACTER(8) 8
65 EXTENSION_TYPE CHARACTER(4) 4
66 ITEM_SUM_INSURED INTEGER 4
67 HAZARD_INDEX CHARACTER VARYING(10) 10
68 RISKSTATE_KEY CHARACTER(2) 2
69 POLICY_STAGE_LEVEL1 CHARACTER VARYING(25) 25
70 EFFECTDTE INTEGER 4
71 DUEDATE INTEGER 4
72 SCHEME_TYPE CHARACTER(4) 4
73 REGO_NO CHARACTER(12) 12
74 COMPLTIND CHARACTER(1) 1
75 INSTALFRQ CHARACTER(1) 1
76 CPSTAFF_CURRENT CHARACTER VARYING(10) 10
77 CPSTAFF_NUMBER CHARACTER VARYING(10) 10
78 WORKCOVER_NUMBER CHARACTER(15) 15
79 ACQUIRE_MEMBERSHIP_NUMBER CHARACTER(15) 15
80 PREV_INSURANCE_YEARS SMALLINT 2
81 AGTACCTYP_NB CHARACTER VARYING(10) 10
82 CPBUSSRC CHARACTER VARYING(10) 10
83 IDP CHARACTER VARYING(50) 50
84 UW_CODE CHARACTER(8) 8
85 WAGEDEC_ACT CHARACTER(2) 2
86 WAGEDEC_EST CHARACTER(2) 2
87 RNWALTERM SMALLINT 2
88 LAST_RBASICPRM NUMERIC(11,2) 19
89 CANCEL_ON_INCEPTION CHARACTER VARYING(1) 1
90 ISSUEDSTATE_KEY CHARACTER VARYING(8) 8