FCT_MOTOR_COMBINED_COST_INSIGHT_HIST_20210801021656

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 COMBINED_COST_DATE INTEGER 4
3 COMBINED_TYPE CHARACTER VARYING(10) 10
4 COMBINED_COST_SUBTYPE CHARACTER VARYING(512) 512
5 COMBINED_COST_VOLUME INTEGER 4
6 COMBINED_COST_AMOUNT NUMERIC(38,2) 19
7 COMBINED_COST_AMOUNT_BAND_ID INTEGER 4
8 CLAIM_NUMBER CHARACTER VARYING(40) 40
9 CLAIM_ID BIGINT 8
10 POLICYID BIGINT 8
11 POLICYNUMBER CHARACTER VARYING(40) 40
12 VEHICLE_DETAIL_HIERARCHY CHARACTER VARYING(162) 162
13 VEHICLE_YEAR CHARACTER VARYING(20) 20
14 VEHICLE_MAKE CHARACTER VARYING(60) 60
15 VEHICLE_MODEL CHARACTER VARYING(80) 80
16 SC_NVIC CHARACTER VARYING(15) 15
17 PNETQUOTEREQUEST_NUMBER CHARACTER VARYING(13) 13
18 ASSESSMENT_CENTRE_TYPE_ID BIGINT 8
19 ASSESSMENT_CENTRE_TYPE_NAME CHARACTER VARYING(256) 256
20 POLICY_COVERAGE_TYPE_ID BIGINT 8
21 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
22 LIABILITY_ASSESSMENT_ID BIGINT 8
23 LIABILITY_ASSESSMENT_DESCRIPTION CHARACTER VARYING(256) 256
24 CLAIM_DECISION_ID BIGINT 8
25 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
26 QUOTEREQUEST_STATUS BIGINT 8
27 QUOTEREQUEST_STATUS_NAME CHARACTER VARYING(256) 256
28 LINE_OF_BUSINESS_ID BIGINT 8
29 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
30 LOSS_CAUSE_GROUP_TEXT CHARACTER VARYING(14) 14
31 LOSS_CAUSE_ID BIGINT 8
32 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
33 LOSS_CAUSE_SUB_TYPE_ID BIGINT 8
34 LOSS_CAUSE_SUB_TYPE_NAME CHARACTER VARYING(256) 256
35 LOSS_CAUSE_KEY INTEGER 4
36 REPAIRER_NAME CHARACTER VARYING(120) 120
37 ASSESSOR_NAME CHARACTER VARYING(181) 181
38 ASSESSMENT_CENTRE_NAME CHARACTER VARYING(120) 120
39 ASSESSMENT_CENTRE_REGION_NAME CHARACTER VARYING(15) 15
40 ASSESSMENT_CENTRE_STATE_NAME CHARACTER VARYING(256) 256
41 REPORT_DATE DATE 4
42 REPORTING_MONTH_FLAG CHARACTER VARYING(9) 9
43 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
44 ASSESSMENT_PROCESS_GROUP_NAME CHARACTER VARYING(13) 13
45 VEHICLE_STYLE_ID BIGINT 8
46 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
47 ALIGNED_REPAIRER_PUBLICID CHARACTER VARYING(64) 64
48 ALIGNED_REPAIRER_NAME CHARACTER VARYING(120) 120
49 ALIGNED_ASSESSMENT_CENTRE_NAME CHARACTER VARYING(612) 612
50 ALIGNED_ASSESSMENT_CENTRE_REGION_NAME CHARACTER VARYING(15) 15
51 ALIGNED_ASSESSMENT_CENTRE_STATE_NAME CHARACTER VARYING(256) 256
52 RISK_LOCATION_ADDRESS CHARACTER VARYING(167) 167
53 RISK_CITY CHARACTER VARYING(60) 60
54 RISK_LONGITUDE NUMERIC(8,5) 19
55 RISK_LATITUDE NUMERIC(7,5) 19
56 RISK_POSTCODE CHARACTER VARYING(60) 60
57 RISK_REGION_NAME CHARACTER VARYING(15) 15
58 RISK_STATE_ID BIGINT 8
59 RISK_STATE_NAME CHARACTER VARYING(256) 256
60 RISK_POSTCODE_KEY CHARACTER VARYING(82) 82
61 LOSS_LOCATION_ADDRESS CHARACTER VARYING(167) 167
62 LOSS_CITY CHARACTER VARYING(60) 60
63 LOSS_LONGITUDE NUMERIC(8,5) 19
64 LOSS_LATITUDE NUMERIC(7,5) 19
65 LOSS_POSTCODE CHARACTER VARYING(60) 60
66 LOSS_REGION_NAME CHARACTER VARYING(15) 15
67 LOSS_STATE_ID BIGINT 8
68 LOSS_STATE_NAME CHARACTER VARYING(256) 256
69 LOSS_POSTCODE_KEY CHARACTER VARYING(82) 82
70 BRAND_ID BIGINT 8
71 BRAND_NAME CHARACTER VARYING(256) 256
72 LOSS_PARTY_TYPE_ID BIGINT 8
73 LOSS_PARTY_TYPE_NAME CHARACTER VARYING(256) 256
74 CATASTROPHE_ID BIGINT 8
75 CATASTROPHE_NAME CHARACTER VARYING(60) 60
76 SMART_UNINVITED_FLAG CHARACTER VARYING(3) 3
77 LODGEMENT_DATE INTEGER 4
78 DAYS_TO_AUTHORISATION INTEGER 4
79 LINE_ITEM_VOLUME INTEGER 4
80 EVENT_NAME CHARACTER VARYING(256) 256
81 ALIGNED_REPAIRER_KEY CHARACTER VARYING(86) 86
82 ALL_REPAIRER_KEY CHARACTER VARYING(240) 240
83 ASSESSOR_KEY CHARACTER VARYING(301) 301
84 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
85 DIM_DANGEROUSGOODS_IND_NAME CHARACTER VARYING(256) 256
86 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
87 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
88 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
89 CLAIM_PROCESS_TYPE_ID BIGINT 8
90 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
91 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
92 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
93 CCR_CC_CLAIM_LOSSDATE INTEGER 4
94 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
95 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
96 CCR_CC_POLICY_POLICYTYPE BIGINT 8
97 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
98 FLEET_IND CHARACTER VARYING(9) 9
99 CAS_IND CHARACTER VARYING(9) 9
100 INSURED_NAME CHARACTER VARYING(181) 181
101 TOTAL_LOSS_COMBINED_VOLUME INTEGER 4
102 CASH_SETTLE_TYPE BIGINT 8
103 CASH_SETTLEMENT_TYPE_NAME CHARACTER VARYING(256) 256
104 CASH_SETTLE_REASON BIGINT 8
105 CASH_SETTLEMENT_REASON_NAME CHARACTER VARYING(256) 256
106 CASH_SETTLE_USER_ID BIGINT 8
107 CASH_SETTLE_USER_NAME CHARACTER VARYING(181) 181
108 CASH_SETTLE_TEAM_NAME CHARACTER VARYING(100) 100
109 CASH_SETTLE_DATE TIMESTAMP 8
110 COMBINED_COST_AMOUNT_BAND_TYPECODE CHARACTER VARYING(19) 19
111 COMBINED_COST_AMOUNT_BAND_SUBNAME CHARACTER VARYING(19) 19
112 COMBINED_COST_AMOUNT_BAND_NAME CHARACTER VARYING(19) 19
113 COMBINED_COST_AMOUNT_BAND_NAME_ORDER INTEGER 4
114 OUTCOME CHARACTER VARYING(17) 17
115 BOOKING_CREATE_DATE DATE 4
116 VEHICLE_ARRIVE_DATE DATE 4
117 AGE_TO_ARRIVE INTEGER 4
118 AGE_TO_AUTHORISE_FROM_ARRIVE INTEGER 4
119 COMBINED_COST_COMPLETED_DATE DATE 4
120 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
121 LEGACYCLAIM_FLAG CHARACTER VARYING(3) 3
122 LEGACYCLAIM_CATEGORY CHARACTER VARYING(256) 256