INT_WC_PMOV_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 COMPANY CHARACTER(10) 10
7 STATE CHARACTER(10) 10
8 BURNERIND CHARACTER VARYING(1) 1
9 CLASS CHARACTER(3) 3
10 SUBCLASS CHARACTER(3) 3
11 COVERAGENUMBER SMALLINT 2
12 SEQUENCENUMBER SMALLINT 2
13 ITMSTATUS CHARACTER(1) 1
14 SEQPOLICYNO INTEGER 4
15 REVERSED_TRAN CHARACTER VARYING(1) 1
16 REVERSALINDIC CHARACTER VARYING(1) 1
17 TRANSACTIONTYPE CHARACTER(2) 2
18 DATEAPPROVED DATE 4
19 TRANINFORCE INTEGER 4
20 REASONCDE CHARACTER(2) 2
21 COVERAGESTATUS CHARACTER VARYING(1) 1
22 NEWRENEW CHARACTER VARYING(1) 1
23 POLICYSTATUS CHARACTER(1) 1
24 PAIDSTATUS CHARACTER VARYING(1) 1
25 CANCLAPSEREVIND CHARACTER VARYING(1) 1
26 CANCLAPSEREVEFFDATE DATE 4
27 INDUSTRYCODE CHARACTER VARYING(1) 1
28 CURRENTWAGES NUMERIC(14,2) 19
29 CURRENTWAGES_ACTUAL NUMERIC(12,2) 19
30 CURRENTWAGES_ESTIMATE NUMERIC(14,2) 19
31 WAGESDECSTAT CHARACTER(2) 2
32 ACTWAGEDECST CHARACTER(2) 2
33 EXTENSION_CODE CHARACTER(4) 4
34 EXTENSION_DESCRIPTION CHARACTER(60) 60
35 INCWAGES NUMERIC(15,2) 19
36 CUMWAGES NUMERIC(12,2) 19
37 POLICYEFFECTIVEDATE DATE 4
38 COVERAGECHGEFFECTDATE DATE 4
39 COVERAGEEXPIRYDATE DATE 4
40 COVERAGECHGEXPIRYDATE DATE 4
41 COVERAGEENTRYDATE DATE 4
42 COVERAGERENEWEDDATE DATE 4
43 INFORCEINCDATE DATE 4
44 INFORCEEXPDATE DATE 4
45 ANNBASICRATEDPREM NUMERIC(12,2) 19
46 ANNCOMMISSION1 NUMERIC(12,2) 19
47 ANNGROSSPREM NUMERIC(12,2) 19
48 ANNGSTONCOMMISSION NUMERIC(12,2) 19
49 ANNNETTPREM NUMERIC(12,2) 19
50 INCBASICRATEDPREM NUMERIC(11,2) 19
51 INCCOMMISSION1 NUMERIC(11,2) 19
52 INCGROSSPREM NUMERIC(12,2) 19
53 INCGSTONCOMMISSION NUMERIC(11,2) 19
54 INCNETTPREM NUMERIC(12,2) 19
55 INCOTHERCHARGES NUMERIC(11,2) 19
56 COMMISSION_ADJ NUMERIC(4,2) 19
57 COMM_ADJ_RC CHARACTER(65) 65
58 ADMIN NUMERIC(12,2) 19
59 INTEREST NUMERIC(12,2) 19
60 BONUS NUMERIC(12,2) 19
61 COMMONLAW NUMERIC(11,2) 19
62 DUSTDISEASE NUMERIC(12,2) 19
63 GST NUMERIC(11,2) 19
64 ITC NUMERIC(12,2) 19
65 PREMDISCOUNT NUMERIC(12,2) 19
66 STAMPDUTY NUMERIC(11,2) 19
67 TOTTARIFFPREM NUMERIC(12,2) 19
68 XSDELPREM NUMERIC(12,2) 19
69 CUMCOMMISSION1 NUMERIC(12,2) 19
70 CUMGROSSPREM NUMERIC(12,2) 19
71 TRANEARNWAGEPERDAY NUMERIC(12,2) 19
72 TRANEARNPREMPERDAY NUMERIC(12,2) 19
73 TRANEARNCOMMPERDAY NUMERIC(12,2) 19
74 CUMEARNWAGEPERDAY NUMERIC(12,2) 19
75 CUMEARNCOMMPERDAY NUMERIC(12,2) 19
76 CLIENTCLASS CHARACTER VARYING(1) 1
77 COMPANYPREFIX CHARACTER VARYING(1) 1
78 COVERAGECODE CHARACTER VARYING(1) 1
79 EMPLOYERCATEGORY CHARACTER VARYING(1) 1
80 EXPADJFACTOR INTEGER 4
81 LINEOFBUSINESSCODE CHARACTER VARYING(1) 1
82 MFACTOR INTEGER 4
83 SFUND INTEGER 4
84 STATECODE CHARACTER VARYING(1) 1
85 GROSSAMT NUMERIC(12,2) 19
86 BCPREMIUM NUMERIC(12,2) 19
87 ADJUSTMENT NUMERIC(12,2) 19
88 BURNERADJAMT NUMERIC(12,2) 19
89 ANZSIC_2006 CHARACTER(8) 8
90 ANZSIC_1993 CHARACTER(8) 8
91 BRANCH SMALLINT 2
92 REGION CHARACTER VARYING(1) 1
93 ACCOUNT1 CHARACTER VARYING(10) 10
94 COY CHARACTER VARYING(1) 1
95 AGTACCTYP CHARACTER(1) 1
96 GLCHANNEL CHARACTER VARYING(1) 1
97 GLPRODUCT_ORA CHARACTER VARYING(1) 1
98 GLCLASS CHARACTER VARYING(1) 1
99 GLENTITY CHARACTER VARYING(1) 1
100 GLSTATE CHARACTER VARYING(1) 1
101 GLCATGORY CHARACTER VARYING(1) 1
102 GLCENTRE CHARACTER VARYING(1) 1
103 PSOFTDEPT CHARACTER VARYING(1) 1
104 PSOFTBUSU CHARACTER VARYING(1) 1
105 PSOFTPRODUCT CHARACTER VARYING(1) 1
106 TXN CHARACTER(30) 30
107 BROKERCLOSINGNO CHARACTER VARYING(1) 1
108 CUMEARNPREMPERDAY NUMERIC(12,2) 19
109 SOURCE_SYSTEM CHARACTER VARYING(7) 7
110 IMAGEFLAG CHARACTER(1) 1
111 POLICYTYPE INTEGER 4
112 CED NUMERIC(11,2) 19
113 OSHPP NUMERIC(11,2) 19
114 CEDREFPCT SMALLINT 2
115 CEDPRMPCT SMALLINT 2
116 MAXCEDREF SMALLINT 2
117 IBNRIBNER SMALLINT 2
118 CEDPREMTH INTEGER 4
119 CEDINCMTH SMALLINT 2
120 CEDTERMST DATE 4
121 CEDTERMEN DATE 4
122 CEDCALCDT DATE 4
123 RC_BASE_OVERRIDE CHARACTER(2) 2
124 CEDTRANSTYPE CHARACTER(4) 4
125 POLICY_TERM_OFFERING CHARACTER(4) 4
126 CLAIM_BASIS CHARACTER(1) 1
127 INTERIM_ADJ_FACTOR CHARACTER VARYING(19) 19
128 FINAL_ADJ_FACTOR CHARACTER VARYING(19) 19
129 NO_OF_YEARS SMALLINT 2
130 CALL_UP_FREQ CHARACTER(1) 1
131 MAX_PREMIUM NUMERIC(11,0) 19
132 MAX_RATE NUMERIC(5,2) 19
133 MIN_PREMIUM NUMERIC(11,0) 19
134 MIN_RATE NUMERIC(5,2) 19
135 RMTYPE CHARACTER(34) 34
136 RMINCOFF INTEGER 4
137 RMINCPAID INTEGER 4
138 RMINCEARN INTEGER 4
139 SCHEME CHARACTER(27) 27
140 AGENT_NAME CHARACTER VARYING(40) 40
141 AGENT_TYPE CHARACTER(1) 1
142 AGENT_TYPE_DESC CHARACTER(20) 20
143 AGENT_CLUSTER CHARACTER VARYING(37) 37
144 CHANNEL CHARACTER(10) 10
145 CAT_C CHARACTER(1) 1
146 RENLIKEIND CHARACTER(1) 1
147 RERATE_TRAN INTEGER 4
148 ITEM_TERMINCEP DATE 4
149 ITEM_VOID_AT_INCEPTION CHARACTER VARYING(1) 1
150 PREVIOUS_POLICY_NUMBER CHARACTER VARYING(14) 14
151 PREVIOUS_INS_COMPANY CHARACTER VARYING(4) 4
152 COMMIT_TIMESTAMP TIMESTAMP 8