FCT_MOTOR_STOCK_CLAIM_MVMNT_DRILLTHRU_INSIGHT_HIST

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CLAIM_ID BIGINT 8
3 REPORTING_MONTH CHARACTER VARYING(223) 223
4 REPORT_DATE DATE 4
5 LODGEMENT_DATE DATE 4
6 CLAIM_NUMBER CHARACTER VARYING(40) 40
7 RISK_STATE_ID BIGINT 8
8 RISK_STATE_NAME CHARACTER VARYING(256) 256
9 RISK_REGION_NAME CHARACTER VARYING(15) 15
10 RISK_POSTCODE CHARACTER VARYING(60) 60
11 LOSS_STATE_ID BIGINT 8
12 LOSS_STATE_NAME CHARACTER VARYING(256) 256
13 LOSS_REGION_NAME CHARACTER VARYING(15) 15
14 LOSS_POSTCODE CHARACTER VARYING(60) 60
15 LINE_OF_BUSINESS_ID BIGINT 8
16 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
17 VEHICLE_STYLE_ID BIGINT 8
18 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
19 BRAND_ID BIGINT 8
20 BRAND_NAME CHARACTER VARYING(256) 256
21 CLAIM_DECISION_ID BIGINT 8
22 CLAIM_DECISION_NAME CHARACTER VARYING(512) 512
23 PRODUCT_ID BIGINT 8
24 PRODUCT_NAME CHARACTER VARYING(256) 256
25 CREATE_DATE DATE 4
26 FIRST_REOPEN_DATE DATE 4
27 LATEST_REOPEN_DATE DATE 4
28 LATEST_FINALISED_DATE DATE 4
29 REJECT_REASON_ID BIGINT 8
30 REJECT_REASON_NAME CHARACTER VARYING(256) 256
31 REOPEN_REASON_ID BIGINT 8
32 REOPEN_REASON_NAME CHARACTER VARYING(256) 256
33 CLOSED_OUTCOME_ID BIGINT 8
34 CLOSED_OUTCOME_NAME CHARACTER VARYING(512) 512
35 POLICY_ID BIGINT 8
36 POLICY_NUMBER CHARACTER VARYING(40) 40
37 CLAIM_STATE_ID INTEGER 4
38 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
39 CLAIM_STATE_NAME CHARACTER VARYING(11) 11
40 REOPENED_DATE DATE 4
41 FINALISED_DATE DATE 4
42 LOSSCAUSE_ID BIGINT 8
43 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
44 LOSSCAUSESUBTYPE_ID BIGINT 8
45 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
46 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
47 CATASTOPHE_ID BIGINT 8
48 CATASTROPHE_CODE CHARACTER VARYING(120) 120
49 POLICY_STATUS_ID BIGINT 8
50 POLICY_STATUS_DESC CHARACTER VARYING(512) 512
51 PREMIUM_STATUS_ID BIGINT 8
52 PREMIUM_STATUS_NAME CHARACTER VARYING(256) 256
53 PREMIUM_STATUS_GROUP CHARACTER VARYING(14) 14
54 POLICY_PAYMENT_MODE_ID BIGINT 8
55 POLICY_PAYMENT_MODE_NAME CHARACTER VARYING(256) 256
56 POLICY_RENEWAL_MODE_ID BIGINT 8
57 POLICY_RENEWAL_MODE_NAME CHARACTER VARYING(256) 256
58 POLICY_COVERAGE_TYPE_ID BIGINT 8
59 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
60 ADJUSTER_USER_ID BIGINT 8
61 ADJUSTER_USER_NAME CHARACTER VARYING(181) 181
62 ADJUSTER_TEAM_ID BIGINT 8
63 ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
64 CREATE_USER_ID BIGINT 8
65 CREATE_USER_NAME CHARACTER VARYING(181) 181
66 CREATE_TEAM_ID BIGINT 8
67 CREATE_TEAM_NAME CHARACTER VARYING(100) 100
68 LODGEMENT_USER_ID BIGINT 8
69 LODGEMENT_USER_NAME CHARACTER VARYING(181) 181
70 LODGEMENT_TEAM_ID BIGINT 8
71 LODGEMENT_TEAM_NAME CHARACTER VARYING(100) 100
72 LARGE_LOSS_FLAG_ID INTEGER 4
73 LIABILITY_ASSESSMENT_ID BIGINT 8
74 LIABILITY_ASSESSMENT_DESCRIPTION CHARACTER VARYING(256) 256
75 ACTUAL_AGE_OF_ACTIVE NUMERIC(38,0) 19
76 ACTUAL_AGE_OF_FINALISED NUMERIC(38,0) 19
77 AGE_OF_ACTIVE INTEGER 4
78 COUNT_OF_ACTIVE INTEGER 4
79 COUNT_OF_REOPENED INTEGER 4
80 AGE_OF_FINALISED CHARACTER VARYING(10) 10
81 COUNT_OF_FINALISED INTEGER 4
82 AGE_TO_ACTIVATE INTEGER 4
83 CLAIM_FINALISED_AGE_BAND_ID INTEGER 4
84 CLAIM_REOPENED_AGE_BAND_ID INTEGER 4
85 AGE_OF_REOPENED CHARACTER VARYING(10) 10
86 CLAIM_STATUS_AT_START_ID BIGINT 8
87 CLAIM_STATUS_AT_START_NAME CHARACTER VARYING(11) 11
88 CLAIM_STATUS_AT_END_ID BIGINT 8
89 CLAIM_STATUS_AT_END_NAME CHARACTER VARYING(11) 11
90 CLAIM_MOVEMENT_STATUS CHARACTER VARYING(14) 14
91 CLAIM_MOVEMENT_STATUS_NAME CHARACTER VARYING(52) 52
92 CLAIM_MOVEMENT_STATUS_GROUP_NAME CHARACTER VARYING(16) 16
93 CLAIM_MOVEMENT_STAUS_GROUP_ID INTEGER 4
94 CLAIM_FINALISED_AGE_BAND_DESCRIPTION CHARACTER VARYING(14) 14
95 CLAIM_REOPENED_AGE_BAND_DESCRIPTION CHARACTER VARYING(14) 14
96 LARGE_LOSS_FLAG_DESCRIPTION CHARACTER VARYING(3) 3
97 INSURED_NAME CHARACTER VARYING(181) 181
98 RISK_LOCATION_ADDRESS CHARACTER VARYING(167) 167
99 LOSS_LOCATION_ADDRESS CHARACTER VARYING(167) 167
100 TOTAL_GROSS_INCURRED NUMERIC(38,2) 19
101 PAID_AMOUNT NUMERIC(38,2) 19
102 REMAINING_RESERVES NUMERIC(38,2) 19
103 RECOVERIES_AMOUNT NUMERIC(38,2) 19
104 OPEN_RECOVERY_RESERVES NUMERIC(38,2) 19
105 TOTAL_NET_INCURRED NUMERIC(38,2) 19
106 TOTAL_GROSS_INCURRED_NET_TAX NUMERIC(38,2) 19
107 TOTAL_NET_INCURRED_NET_TAX NUMERIC(38,2) 19
108 TOTAL_INGOING_ESTIMATE NUMERIC(38,2) 19
109 TOTAL_EXCESS_APPLICABLE NUMERIC(18,2) 19
110 TOTAL_EXCESS_RECEIVED NUMERIC(38,2) 19
111 TOTAL_EXCESS_OUTSTANDING NUMERIC(38,2) 19
112 NO_REMAINING_RESERVE_FLAG CHARACTER VARYING(3) 3
113 OUTSTANDING_RECOVERY_FLAG CHARACTER VARYING(3) 3
114 EVENT_NAME CHARACTER VARYING(256) 256
115 CLAIM_MOVEMENT_STATUS_ID CHARACTER VARYING(31) 31
116 POLICYTYPE BIGINT 8
117 POLICYTYPE_NAME CHARACTER VARYING(256) 256
118 CLAIM_AGE_BAND_ID INTEGER 4
119 CLAIM_AGE_BAND_NAME CHARACTER VARYING(14) 14
120 LEGACY_CLAIM_ID CHARACTER VARYING(255) 255
121 LEGACY_CLAIM_FLAG CHARACTER VARYING(3) 3
122 LEGACY_CLAIM_TYPE BIGINT 8
123 LEGACY_CLAIM_TYPE_NAME CHARACTER VARYING(256) 256