FCT_MOTOR_STOCK_CLAIM_DRILLTHRU

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

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