FCT_MOTOR_CLAIMS_ASSIST_CLAIM_DETAILS

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 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 LOSS_TYPE_CODE CHARACTER VARYING(50) 50
5 POLICY_ID BIGINT 8
6 POLICY_NUMBER CHARACTER VARYING(40) 40
7 LODGEMENT_DATE TIMESTAMP 8
8 UPDATETIME TIMESTAMP 8
9 EXTRACT_TIMESTAMP TIMESTAMP 8
10 RISK_STATE_ID BIGINT 8
11 RISK_REGION_NAME CHARACTER VARYING(15) 15
12 RISK_POSTCODE CHARACTER VARYING(60) 60
13 LOSS_STATE_ID BIGINT 8
14 LOSS_REGION_NAME CHARACTER VARYING(15) 15
15 LOSS_POSTCODE CHARACTER VARYING(60) 60
16 LINE_OF_BUSINESS_ID BIGINT 8
17 VEHICLE_STYLE_ID BIGINT 8
18 VEHICLE_INCIDENT_ID BIGINT 8
19 BRAND_ID BIGINT 8
20 CLAIM_DECISION_ID BIGINT 8
21 LOSS_TYPE_ID BIGINT 8
22 CREATE_DATE TIMESTAMP 8
23 REOPEN_DATE TIMESTAMP 8
24 FINALISED_DATE TIMESTAMP 8
25 FIRST_REOPEN_DATE TIMESTAMP 8
26 LATEST_REOPEN_DATE TIMESTAMP 8
27 LATEST_FINALISED_DATE TIMESTAMP 8
28 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
29 CLAIM_STATE_ID INTEGER 4
30 REJECT_REASON_ID BIGINT 8
31 REOPEN_REASON_ID BIGINT 8
32 LOSS_CAUSE_ID BIGINT 8
33 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
34 LOSS_CAUSE_SUB_TYPE_ID BIGINT 8
35 LOSS_CAUSE_SUB_TYPE_NAME CHARACTER VARYING(256) 256
36 LOSS_CAUSE_GROUP CHARACTER VARYING(14) 14
37 CATASTOPHE_ID BIGINT 8
38 CATASTROPHE_NUMBER CHARACTER VARYING(60) 60
39 CATASTROPHE_NAME CHARACTER VARYING(60) 60
40 PREMIUM_STATUS_ID BIGINT 8
41 POLICY_STATUS_ID BIGINT 8
42 POLICY_COVERAGE_TYPE_ID BIGINT 8
43 INVESTIGATION_STATUS_ID BIGINT 8
44 ADJUSTER_USER_ID BIGINT 8
45 CLAIM_CREATE_USER_ID BIGINT 8
46 CLAIM_CREATE_USER_CA_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
47 CLAIM_CREATE_USER_CA_NAME CHARACTER VARYING(256) 256
48 CLAIM_CREATE_USER_CA_MANAGER CHARACTER VARYING(256) 256
49 CLAIM_CREATE_USER_CA_LEADER CHARACTER VARYING(256) 256
50 CLAIM_CREATE_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
51 CLAIM_UPDATE_USER_ID BIGINT 8
52 CLAIM_CREATE_USER_DATE_KEY CHARACTER VARYING(285) 285
53 LODGEMENT_USER_ID BIGINT 8
54 LODGEMENT_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
55 LODGEMENT_USER_DATE_KEY CHARACTER VARYING(455) 455
56 LODGEMENT_USER_CA_NAME CHARACTER VARYING(256) 256
57 LODGEMENT_USER_CA_MANAGER CHARACTER VARYING(256) 256
58 LODGEMENT_USER_CA_LEADER CHARACTER VARYING(256) 256
59 LODGEMENT_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
60 LIABILITY_ASSESSMENT_ID BIGINT 8
61 EXCESS_RECEIVED_FLAG CHARACTER VARYING(9) 9
62 FIRST_EXCESS_RECEIVED_DATE TIMESTAMP 8
63 LATEST_EXCESS_RECEIVED_DATE TIMESTAMP 8
64 EXCESS_AMOUNT NUMERIC(38,2) 19
65 INITIAL_EXCESS_COLLECTION_AGE INTEGER 4
66 INITIAL_EXCESS_COLLECTION_AGE_BAND_ID INTEGER 4
67 TRANSACTION_STATUS_ID BIGINT 8
68 TRANSACTION_STATUS_NAME CHARACTER VARYING(256) 256
69 PAYMENT_TYPE_ID BIGINT 8
70 PAYMENT_TYPE_NAME CHARACTER VARYING(256) 256
71 COST_CATEGORY_ID BIGINT 8
72 COST_CATEGORY_NAME CHARACTER VARYING(256) 256
73 COST_TYPE_ID BIGINT 8
74 COST_TYPE_NAME CHARACTER VARYING(256) 256
75 TRANSACTION_NET_AMOUNT NUMERIC(38,2) 19
76 DEDUCTION_TYPE_ID CHARACTER VARYING(4) 4
77 RECEIPT_ID CHARACTER VARYING(60) 60
78 RECEIPT_NUMBER CHARACTER VARYING(60) 60
79 RECEIPT_PAYMENT_CHANNEL_ID BIGINT 8
80 RECEIPT_PAYMENT_CHANNEL_NAME CHARACTER VARYING(256) 256
81 RECEIPT_PAYMENT_METHOD_ID BIGINT 8
82 RECEIPT_PAYMENT_METHOD_NAME CHARACTER VARYING(256) 256
83 RECEIPT_REFERENCE_NUMBER_1 CHARACTER VARYING(60) 60
84 TRANSACTION_SUB_TYPE_ID BIGINT 8
85 TRANSACTION_SUB_TYPE_NAME CHARACTER VARYING(256) 256
86 RECEIPT_REFERENCE_NUMBER_2 CHARACTER VARYING(60) 60
87 RECEIPT_DATE TIMESTAMP 8
88 RECEIPT_DESCRIPTION CHARACTER VARYING(256) 256
89 TRANSACTION_AMOUNT NUMERIC(38,2) 19
90 REPORTING_AMOUNT NUMERIC(38,2) 19
91 DAMAGE_INDICATOR_FLAG CHARACTER VARYING(9) 9
92 VEHICLE_TOWED_FLAG CHARACTER VARYING(9) 9
93 VEHICLE_OPERABLE_FLAG CHARACTER VARYING(9) 9
94 EXCESS_WAIVED_FLAG CHARACTER VARYING(9) 9
95 TOTAL_EXCESS_APPLICABLE NUMERIC(18,2) 19
96 ASSESSMENT_BOOKING_CREATE_DATE TIMESTAMP 8
97 ASSESSMENT_BOOKING_APPOINTMENT_DATE TIMESTAMP 8
98 ASSESSMENT_BOOKING_UDPATE_DATE TIMESTAMP 8
99 CONTACT_ID BIGINT 8
100 ASSESSMENT_PROCESS_TYPE_ID BIGINT 8
101 ASSESSMENT_BOOKING_LOCATION_ID CHARACTER VARYING(30) 30
102 ASSESSMENT_BOOKING_LOCATION_TYPE_ID BIGINT 8
103 ASSESSMENT_BOOKING_LOCATION_STATE_ID BIGINT 8
104 CHOICE_OF_REPAIRER_FLAG CHARACTER VARYING(9) 9
105 BOOKING_COMPLETED_FLAG CHARACTER VARYING(9) 9
106 BOOK_APPOINTMENT_FLAG CHARACTER VARYING(9) 9
107 ASSESSMENT_BOOKING_STATUS_ID BIGINT 8
108 ASSESSMENT_NON_BOOKING_REASON_ID BIGINT 8
109 ASSESSMENT_BOOKING_CREATE_USER_ID BIGINT 8
110 ASSESSMENT_BOOKING_CREATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
111 ASSESSMENT_BOOKING_CREATE_USER_CA_NAME CHARACTER VARYING(256) 256
112 ASSESSMENT_BOOKING_CREATE_USER_CA_MANAGER CHARACTER VARYING(256) 256
113 ASSESSMENT_BOOKING_CREATE_USER_CA_LEADER CHARACTER VARYING(256) 256
114 ASSESSMENT_BOOKING_CREATE_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
115 ASSESSMENT_BOOKING_UPDATE_USER_CA_EMPLOYEE_NUMBER CHARACTER VARYING(256) 256
116 ASSESSMENT_BOOKING_UPDATE_USER_CA_NAME CHARACTER VARYING(256) 256
117 ASSESSMENT_BOOKING_UPDATE_USER_CA_MANAGER CHARACTER VARYING(256) 256
118 ASSESSMENT_BOOKING_UPDATE_USER_CA_LEADER CHARACTER VARYING(256) 256
119 ASSESSMENT_BOOKING_UPDATE_USER_CA_DEPARTMENT CHARACTER VARYING(256) 256
120 ASSESSMENT_BOOKING_USER_DATE_KEY CHARACTER VARYING(285) 285
121 AGE_TO_ACTIVATE INTEGER 4
122 SMART_BOOKING_OPPORTUNITY_FLAG CHARACTER VARYING(9) 9
123 LOSS_PARTY_TYPE_ID BIGINT 8
124 BOOKING_CANCEL_REASON_ID BIGINT 8
125 ASSESSMENT_BOOKING_UPDATE_USER_ID BIGINT 8
126 ASSESSMENT_BOOKING_UPDATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
127 ASSESSMENT_BOOKING_UPDATE_USER_NAME CHARACTER VARYING(181) 181
128 LICENSE_PLATE CHARACTER VARYING(40) 40
129 REPAIRER_ID BIGINT 8
130 REPAIRER_NAME CHARACTER VARYING(181) 181
131 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
132 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
133 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
134 CLAIM_PROCESS_TYPE_ID BIGINT 8
135 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
136 FLEET_MANAGER_NAME CHARACTER VARYING(181) 181
137 LOSSDATE TIMESTAMP 8
138 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
139 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
140 CCR_CC_POLICY_POLICYTYPE BIGINT 8
141 FLEET_IND CHARACTER VARYING(9) 9
142 CAS_IND CHARACTER VARYING(7) 7
143 POLICYNUMBER CHARACTER VARYING(40) 40
144 INSURED_NAME CHARACTER VARYING(181) 181
145 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255