INT_WC_UNPROC_PHDR_NICHE_CHG0208107

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 GLPRODUCT CHARACTER VARYING(1) 1
2 POLICYNUMBER CHARACTER VARYING(15) 15
3 POLICYNO INTEGER 4
4 TERMIDENT BIGINT 8
5 FUND CHARACTER(10) 10
6 STATE CHARACTER(10) 10
7 COMPANY CHARACTER(10) 10
8 POLICYEFFECTIVEDATE DATE 4
9 TERMEFFECTIVEDATE DATE 4
10 TERMEXPIRYDATE DATE 4
11 ANZSIC_2006 CHARACTER(8) 8
12 ANZSIC_1993 CHARACTER(8) 8
13 WIC CHARACTER VARYING(1) 1
14 HAZARDINDEX NUMERIC(5,2) 19
15 SCHEME CHARACTER(27) 27
16 BRANCH SMALLINT 2
17 REGION CHARACTER VARYING(1) 1
18 AGENT_GROUP CHARACTER VARYING(60) 60
19 ACCOUNT1 CHARACTER VARYING(10) 10
20 ACCOUNT2 CHARACTER VARYING(1) 1
21 ACCOUNTTYPE1 CHARACTER VARYING(1) 1
22 ACCOUNTTYPE2 CHARACTER VARYING(1) 1
23 DISTN1 CHARACTER(20) 20
24 DISTN2 CHARACTER VARYING(1) 1
25 PROVISIONAL INTEGER 4
26 TOTALANZSICS BIGINT 8
27 MULTI_ANZSIC CHARACTER VARYING(1) 1
28 WAGES_ACTUAL NUMERIC(14,2) 19
29 WAGES_ESTIMATE NUMERIC(14,2) 19
30 WAGES NUMERIC(38,0) 19
31 STAFF INTEGER 4
32 STAFF_ESTIMATE INTEGER 4
33 BASICRATEDPREM NUMERIC(12,2) 19
34 GROSSPREM NUMERIC(38,2) 19
35 BONUS NUMERIC(12,2) 19
36 COMMONLAW NUMERIC(12,2) 19
37 XSDELPREM NUMERIC(12,2) 19
38 ADMIN NUMERIC(12,2) 19
39 ITC NUMERIC(12,2) 19
40 PREMDISCOUNT NUMERIC(12,2) 19
41 INTEREST NUMERIC(12,2) 19
42 OTHERCHARGES NUMERIC(12,2) 19
43 DUSTDISEASE NUMERIC(12,2) 19
44 SFUND NUMERIC(12,2) 19
45 STAMPDUTY NUMERIC(12,2) 19
46 GST NUMERIC(12,2) 19
47 COMMISSION NUMERIC(12,2) 19
48 GSTONCOMMISSION NUMERIC(12,2) 19
49 CED NUMERIC(12,2) 19
50 OSHPP NUMERIC(12,2) 19
51 POLICYSTATUS CHARACTER(1) 1
52 LINEOFBUSINESSCODE CHARACTER VARYING(1) 1
53 UNDERWRITERCODE CHARACTER(8) 8
54 CLIENTCLASS CHARACTER VARYING(1) 1
55 COMPANYPREFIX CHARACTER VARYING(1) 1
56 CLIENTPOLICY INTEGER 4
57 CLIENTAGENT INTEGER 4
58 CLIENTAGENT2 CHARACTER VARYING(1) 1
59 CANCELREVIVEEFFDATE CHARACTER VARYING(1) 1
60 POLICYSTATUS_TERM CHARACTER VARYING(1) 1
61 COY CHARACTER VARYING(1) 1
62 CANCELLAPSEREASON CHARACTER VARYING(2) 2
63 RENEWALSTATUS CHARACTER VARYING(1) 1
64 DECLRN CHARACTER VARYING(1) 1
65 NAMEREF INTEGER 4
66 NAME CHARACTER VARYING(80) 80
67 SOURCE_SYSTEM CHARACTER VARYING(7) 7
68 BURNERIND CHARACTER VARYING(1) 1
69 FRONT CHARACTER VARYING(1) 1
70 POLICYTYPE INTEGER 4
71 SEQPOLICYNO INTEGER 4
72 MULTI_LOC_FLAG CHARACTER VARYING(1) 1
73 NO_OF_LOC BIGINT 8
74 TECHRATE NUMERIC(38,6) 19
75 INDRATE NUMERIC(38,6) 19
76 OVRMDLRATE NUMERIC(5,2) 19
77 OVRUWRATE NUMERIC(5,2) 19
78 GZTADJRATE NUMERIC(38,6) 19
79 RATEOVRREAS CHARACTER(2) 2
80 VARUWMODEL NUMERIC(18,8) 19
81 VARTECHUW NUMERIC(38,6) 19
82 VARINDSTUW NUMERIC(38,6) 19
83 WAGESRATE NUMERIC(38,2) 19
84 MINPREREAS CHARACTER(2) 2
85 MINPREM_B NUMERIC(38,2) 19
86 MINPREM_E NUMERIC(38,2) 19
87 MINPREMADJ_B NUMERIC(38,6) 19
88 MINPREMADJ_E NUMERIC(38,6) 19
89 CEDREFPCT SMALLINT 2
90 CEDPRMPCT SMALLINT 2
91 MAXCEDREF SMALLINT 2
92 IBNRIBNER SMALLINT 2
93 CEDPREMTH INTEGER 4
94 CEDINCMTH SMALLINT 2
95 CEDTERMST DATE 4
96 CEDTERMEN DATE 4
97 CEDCALCDT DATE 4
98 POLICY_TERM_OFFERING CHARACTER(4) 4
99 CLAIM_BASIS CHARACTER(1) 1
100 INTERIM_ADJ_FACTOR CHARACTER VARYING(19) 19
101 FINAL_ADJ_FACTOR CHARACTER VARYING(19) 19
102 NO_OF_YEARS SMALLINT 2
103 CALL_UP_FREQ CHARACTER(1) 1
104 MAX_PREMIUM NUMERIC(11,0) 19
105 MAX_RATE NUMERIC(5,2) 19
106 MIN_PREMIUM NUMERIC(11,0) 19
107 MIN_RATE NUMERIC(5,2) 19
108 SAQ CHARACTER VARYING(4) 4
109 SAQANS1 CHARACTER VARYING(4) 4
110 SAQANS2 CHARACTER VARYING(4) 4
111 SAQANS3 CHARACTER VARYING(4) 4
112 SAQANS4 CHARACTER VARYING(4) 4
113 SAQANS5 CHARACTER VARYING(4) 4
114 RMTYPE CHARACTER(34) 34
115 RMINCOFF INTEGER 4
116 RMINCPAID INTEGER 4
117 RMINCEARN INTEGER 4
118 MULTI_YEAR CHARACTER(2) 2
119 CAT_C CHARACTER(1) 1
120 RENLIKEIND CHARACTER(1) 1
121 FREE_FORMAT_FLAG CHARACTER VARYING(1) 1
122 STD_CLAUSE_FLAG CHARACTER VARYING(1) 1
123 INSTAL_FREQ CHARACTER(1) 1
124 NO_OF_BUNDLES BIGINT 8
125 NAT_ACCOUNT CHARACTER(60) 60
126 NAT_OWNER CHARACTER(60) 60
127 KAM1 CHARACTER(60) 60
128 KAM2 CHARACTER(60) 60
129 AGENT_NAME CHARACTER VARYING(40) 40
130 AGENT_TYPE CHARACTER(1) 1
131 AGENT_TYPE_DESC CHARACTER(20) 20
132 AGENT_CLUSTER CHARACTER VARYING(37) 37
133 CHANNEL CHARACTER(10) 10
134 WAGESDECSTAT CHARACTER(2) 2
135 ACTWAGEDECST CHARACTER(2) 2
136 RERATE INTEGER 4
137 PREVIOUS_POLICY_NUMBER CHARACTER VARYING(14) 14
138 PREVIOUS_INS_COMPANY CHARACTER VARYING(4) 4
139 NTCETYPE CHARACTER(1) 1
140 COMMIT_TIMESTAMP TIMESTAMP 8