FCT_MOTOR_STOCK_CLAIM_DETAILS_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 LODGEMENT_DATE DATE 4
3 CLAIM_ID BIGINT 8
4 CLAIM_NUMBER CHARACTER VARYING(40) 40
5 POLICY_ID BIGINT 8
6 POLICY_NUMBER CHARACTER VARYING(40) 40
7 REPORT_ONLY_FLAG CHARACTER VARYING(9) 9
8 CLAIM_STATE_ID BIGINT 8
9 CLAIM_STATE_NAME CHARACTER VARYING(50) 50
10 BRAND_ID BIGINT 8
11 BRAND_NAME CHARACTER VARYING(256) 256
12 RISK_STATE_ID BIGINT 8
13 RISK_STATE_NAME CHARACTER VARYING(256) 256
14 RISK_REGION_NAME CHARACTER VARYING(15) 15
15 RISK_POSTCODE CHARACTER VARYING(60) 60
16 RISK_CITY CHARACTER VARYING(60) 60
17 RISK_LONGITUDE NUMERIC(8,5) 19
18 RISK_LATITUDE NUMERIC(7,5) 19
19 LINE_OF_BUSINESS_ID BIGINT 8
20 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
21 LOSS_TYPE_ID BIGINT 8
22 LOSS_TYPE_NAME CHARACTER VARYING(256) 256
23 LOSS_STATE_ID BIGINT 8
24 LOSS_STATE_NAME CHARACTER VARYING(256) 256
25 LOSS_REGION_NAME CHARACTER VARYING(15) 15
26 LOSS_POSTCODE CHARACTER VARYING(60) 60
27 LOSS_CITY CHARACTER VARYING(60) 60
28 LOSS_LONGITUDE NUMERIC(8,5) 19
29 LOSS_LATITUDE NUMERIC(7,5) 19
30 VEHICLE_STYLE_ID BIGINT 8
31 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
32 CLAIM_DECISION_ID BIGINT 8
33 CLAIM_DECISION_NAME CHARACTER VARYING(512) 512
34 CREATE_DATE DATE 4
35 REOPEN_DATE DATE 4
36 FINALISED_DATE DATE 4
37 FIRST_REOPEN_DATE TIMESTAMP 8
38 LATEST_REOPEN_DATE TIMESTAMP 8
39 LATEST_FINALISED_DATE TIMESTAMP 8
40 REJECT_REASON_ID BIGINT 8
41 REJECT_REASON_NAME CHARACTER VARYING(256) 256
42 REOPEN_REASON_ID BIGINT 8
43 REOPEN_REASON_NAME CHARACTER VARYING(256) 256
44 FINALISED_OUTCOME_ID BIGINT 8
45 FINALISED_OUTCOME_NAME CHARACTER VARYING(512) 512
46 LOSSCAUSE_ID BIGINT 8
47 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
48 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
49 LOSSCAUSESUBTYPE_ID BIGINT 8
50 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
51 CATASTOPHE_ID BIGINT 8
52 CATASTROPHE_CODE CHARACTER VARYING(120) 120
53 PREMIUM_STATUS_ID BIGINT 8
54 PREMIUM_STATUS_NAME CHARACTER VARYING(256) 256
55 PREMIUM_STATUS_GROUP CHARACTER VARYING(14) 14
56 POLICY_PAYMENT_MODE_ID BIGINT 8
57 POLICY_PAYMENT_MODE_NAME CHARACTER VARYING(256) 256
58 POLICY_RENEWAL_MODE_ID BIGINT 8
59 POLICY_RENEWAL_MODE_NAME CHARACTER VARYING(256) 256
60 POLICY_STATUS_ID BIGINT 8
61 POLICY_STATUS_DESC CHARACTER VARYING(512) 512
62 POLICY_COVERAGE_TYPE_ID BIGINT 8
63 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
64 ADJUSTER_USER_ID BIGINT 8
65 ADJUSTER_USER_NAME CHARACTER VARYING(181) 181
66 ADJUSTER_TEAM_ID BIGINT 8
67 ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
68 CREATE_USER_ID BIGINT 8
69 CREATE_USER_NAME CHARACTER VARYING(181) 181
70 CREATE_TEAM_ID BIGINT 8
71 CREATE_TEAM_NAME CHARACTER VARYING(100) 100
72 LODGEMENT_USER_ID BIGINT 8
73 LODGEMENT_USER_NAME CHARACTER VARYING(181) 181
74 LODGEMENT_TEAM_ID BIGINT 8
75 LODGEMENT_TEAM_NAME CHARACTER VARYING(100) 100
76 LARGE_LOSS_FLAG_ID INTEGER 4
77 LARGE_LOSS_FLAG_DESCRIPTION CHARACTER VARYING(23) 23
78 LIABILITY_ASSESSMENT_ID BIGINT 8
79 LIABILITY_ASSESSMENT_DESCRIPTION CHARACTER VARYING(256) 256
80 INSURED_NAME CHARACTER VARYING(181) 181
81 RISK_LOCATION_ADDRESS CHARACTER VARYING(167) 167
82 LOSS_LOCATION_ADDRESS CHARACTER VARYING(167) 167
83 TOTAL_GROSS_INCURRED NUMERIC(38,2) 19
84 PAID_AMOUNT NUMERIC(38,2) 19
85 REMAINING_RESERVES NUMERIC(38,2) 19
86 RECOVERIES_AMOUNT NUMERIC(38,2) 19
87 OPEN_RECOVERY_RESERVES NUMERIC(38,2) 19
88 TOTAL_NET_INCURRED NUMERIC(38,2) 19
89 TOTAL_GROSS_INCURRED_NET_TAX NUMERIC(38,2) 19
90 TOTAL_NET_INCURRED_NET_TAX NUMERIC(38,2) 19
91 TOTAL_INGOING_ESTIMATE NUMERIC(38,2) 19
92 TOTAL_EXCESS_APPLICABLE NUMERIC(18,2) 19
93 TOTAL_EXCESS_RECEIVED NUMERIC(38,2) 19
94 TOTAL_EXCESS_OUTSTANDING NUMERIC(38,2) 19
95 CLAIM_AGE_BAND_ID INTEGER 4
96 CLAIM_AGE_BAND_NAME CHARACTER VARYING(14) 14
97 CLAIM_SECONDARY_AGE_BAND_ID INTEGER 4
98 CLAIM_SECONDARY_AGE_BAND_NAME CHARACTER VARYING(14) 14
99 CLAIM_AGE INTEGER 4
100 INCIDENT_ID BIGINT 8
101 LISTED_DRIVER_FLAG CHARACTER VARYING(1) 1
102 AGE_OF_INSURED_DRIVER INTEGER 4
103 AGE_OF_INSURED_DRIVER_TEXT CHARACTER VARYING(10) 10
104 GENDER_OF_INSURED_DRIVER CHARACTER VARYING(256) 256
105 VEHICLE_YEAR BIGINT 8
106 VEHICLE_YEAR_TEXT CHARACTER VARYING(9) 9
107 VEHICLE_MAKE CHARACTER VARYING(60) 60
108 VEHICLE_MODEL CHARACTER VARYING(80) 80
109 SC_NVIC CHARACTER VARYING(15) 15
110 LOSS_DAY_ID BIGINT 8
111 LOSS_DAY CHARACTER VARYING(9) 9
112 INVESTIGATION_STATUS_ID BIGINT 8
113 INVESTIGATION_STATUS_NAME CHARACTER VARYING(256) 256
114 CLAIM_FINANCIAL_STATUS_FLAG CHARACTER VARYING(9) 9
115 LITIGATION_STATUS_ID BIGINT 8
116 LITIGATION_STATUS_NAME CHARACTER VARYING(256) 256
117 SUBROGATION_STATUS_ID BIGINT 8
118 SUBROGATION_STATUS_NAME CHARACTER VARYING(256) 256
119 THIRD_PARTY_SETTLEMENT_STATUS_ID BIGINT 8
120 THIRD_PARTY_SETTLEMENT_STATUS_NAME CHARACTER VARYING(256) 256
121 RATING_ID CHARACTER(2) 2
122 RATING_IMPACT_ID BIGINT 8
123 RATING_IMPACT_NAME CHARACTER VARYING(256) 256
124 WEATHER_CONDITION_ID BIGINT 8
125 WEATHER_CONDITION_NAME CHARACTER VARYING(256) 256
126 LIGHT_CONDITION_ID BIGINT 8
127 LIGHT_CONDITION_NAME CHARACTER VARYING(256) 256
128 ROAD_CONDITION_ID BIGINT 8
129 ROAD_CONDITION_NAME CHARACTER VARYING(256) 256
130 POLICE_ATTEND_INCIDENT_FLAG CHARACTER VARYING(3) 3
131 ROAD_TYPE_ID BIGINT 8
132 ROAD_TYPE_NAME CHARACTER VARYING(256) 256
133 SUM_INSURED NUMERIC(18,2) 19
134 NUMBER_OF_VEHICLES BIGINT 8
135 NUMBER_OF_VEHICLES_TEXT CHARACTER VARYING(10) 10
136 EVENT_NAME CHARACTER VARYING(256) 256
137 NO_REMAINING_RESERVE_FLAG CHARACTER VARYING(3) 3
138 OUTSTANDING_RECOVERY_FLAG CHARACTER VARYING(3) 3
139 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
140 DIM_DANGEROUSGOODS_IND_NAME CHARACTER VARYING(256) 256
141 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
142 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
143 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
144 CLAIM_PROCESS_TYPE_ID BIGINT 8
145 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
146 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
147 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
148 LOSS_DATE DATE 4
149 LOSS_CCR_CC_ADDRESS_COUNTRY BIGINT 8
150 COUNTRY_NAME CHARACTER VARYING(256) 256
151 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
152 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
153 CCR_CC_POLICY_POLICYTYPE BIGINT 8
154 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
155 PROFIT_CENTRE CHARACTER VARYING(60) 60
156 COST_CENTRE CHARACTER VARYING(15) 15
157 COST_CENTRE_REFERENCE CHARACTER VARYING(15) 15
158 CI_TOTAL_LOSS_LARGE_LOSS_FLAG CHARACTER VARYING(9) 9
159 CCR_CCTL_LICENCECLASS_EXT_ID BIGINT 8
160 CCR_CCTL_LICENCECLASS_EXT_NAME CHARACTER VARYING(256) 256
161 FLEET_IND CHARACTER VARYING(9) 9
162 CAS_IND CHARACTER VARYING(7) 7
163 ASSESSOR_BASE_PAV NUMERIC(18,2) 19
164 ASSESSOR_ESTIMATED_PAV NUMERIC(18,2) 19
165 ASSESSMENT_CENTER_NAME CHARACTER VARYING(120) 120
166 ASSESSMENT_STATE_CODE CHARACTER VARYING(50) 50
167 ASSESSMENT_CENTER_STATE_NAME CHARACTER VARYING(256) 256
168 ASSESSMENT_CENTER_REGION_NAME CHARACTER VARYING(15) 15
169 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
170 LEGACY_CLAIM CHARACTER VARYING(3) 3
171 LEGACY_TYPE CHARACTER VARYING(256) 256