INT_MOTOR_CLAIMANT

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_DATE DATE 4
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
3 CLAIM_ID BIGINT 8
4 CONTACT_TYPE CHARACTER VARYING(50) 50
5 CLAIM_NUMBER CHARACTER VARYING(40) 40
6 FLEET_IND CHARACTER VARYING(9) 9
7 CAS_IND CHARACTER VARYING(9) 9
8 ROLE_ID BIGINT 8
9 BUSINESS_NAME CHARACTER VARYING(181) 181
10 DEDUP BIGINT 8
11 PRODUCT_ID BIGINT 8
12 PRODUCT_NAME CHARACTER VARYING(256) 256
13 LOSSCAUSE_ID BIGINT 8
14 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
15 TOTAL_LOSS_FLAG CHARACTER VARYING(1) 1
16 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
17 LOSSCAUSESUBTYPE_ID BIGINT 8
18 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
19 CLAIMSTATE_ID BIGINT 8
20 CLAIMSTATE_NAME CHARACTER VARYING(256) 256
21 POLICYTYPE_ID BIGINT 8
22 POLICYTYPE_NAME CHARACTER VARYING(256) 256
23 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
24 LINE_OF_BUSINESS_ID BIGINT 8
25 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
26 BRAND_ID BIGINT 8
27 BRAND_NAME CHARACTER VARYING(256) 256
28 RISK_STATE_ID BIGINT 8
29 RISK_STATE_CODE CHARACTER VARYING(50) 50
30 RISK_STATE_NAME CHARACTER VARYING(256) 256
31 LODGEMENT_DATE DATE 4
32 LODGEMENT_TIME TIMESTAMP 8
33 CLOSED_DATE DATE 4
34 REOPENED_DATE DATE 4
35 REOPENED_FLAG INTEGER 4
36 CATASTOPHE_ID BIGINT 8
37 CATASTROPHE_CODE CHARACTER VARYING(120) 120
38 INSURED_CONTACT_ID BIGINT 8
39 INSURED_NAME CHARACTER VARYING(181) 181
40 INSURED_FIRST_NAME CHARACTER VARYING(90) 90
41 INSURED_LAST_NAME CHARACTER VARYING(90) 90
42 INSURED_TITLE CHARACTER VARYING(256) 256
43 INSURED_WORK_PHONE CHARACTER VARYING(24) 24
44 INSURED_HOME_PHONE CHARACTER VARYING(30) 30
45 INSURED_MOBILE_PHONE CHARACTER VARYING(30) 30
46 INSURED_EMAIL CHARACTER VARYING(60) 60
47 INSURED_ACCEPTS_SMS CHARACTER VARYING(3) 3
48 INSURED_CITY CHARACTER VARYING(60) 60
49 INSURED_POSTALCODE CHARACTER VARYING(60) 60
50 INSURED_STATE CHARACTER VARYING(256) 256
51 INSURED_STATE_ID CHARACTER VARYING(50) 50
52 INSURED_ADDRESSLINE1 CHARACTER VARYING(55) 55
53 INSURED_ADDRESSLINE2 CHARACTER VARYING(55) 55
54 INSURED_ADDRESSLINE3 CHARACTER VARYING(55) 55
55 MAIN_CONTACT_NAME CHARACTER VARYING(181) 181
56 MAIN_CONTACT_FIRST_NAME CHARACTER VARYING(90) 90
57 MAIN_CONTACT_LAST_NAME CHARACTER VARYING(90) 90
58 MAIN_CONTACT_TITLE CHARACTER VARYING(256) 256
59 MAIN_CONTACT_WORK_PHONE CHARACTER VARYING(24) 24
60 MAIN_CONTACT_HOME_PHONE CHARACTER VARYING(30) 30
61 MAIN_CONTACT_MOBILE_PHONE CHARACTER VARYING(30) 30
62 MAIN_CONTACT_EMAIL CHARACTER VARYING(60) 60
63 MAIN_CONTACT_ACCEPTS_SMS CHARACTER VARYING(3) 3
64 MAIN_CONTACT_CITY CHARACTER VARYING(60) 60
65 MAIN_CONTACT_POSTALCODE CHARACTER VARYING(60) 60
66 MAIN_CONTACT_STATE CHARACTER VARYING(256) 256
67 MAIN_CONTACT_STATE_ID CHARACTER VARYING(50) 50
68 MAIN_CONTACT_ADDRESSLINE1 CHARACTER VARYING(55) 55
69 MAIN_CONTACT_ADDRESSLINE2 CHARACTER VARYING(55) 55
70 MAIN_CONTACT_ADDRESSLINE3 CHARACTER VARYING(55) 55
71 REPAIR_ACTUAL_COMPLETION_DATE TIMESTAMP 8
72 REPAIR_ACTUAL_COMPLETION_DATE_14DAYS DATE 4
73 POLICY_COVERAGE_TYPE_ID BIGINT 8
74 POLICY_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
75 VEHICLE_STYLE_ID BIGINT 8
76 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
77 FINALISED_OUTCOME_ID BIGINT 8
78 FINALISED_OUTCOME_NAME CHARACTER VARYING(512) 512
79 CCR_CCTL_SC_CLAIMDECISION_ID BIGINT 8
80 CLAIM_DECISION_ID BIGINT 8
81 CLAIM_DECISION_NAME CHARACTER VARYING(512) 512
82 ASSESSMENTPROCESSTYPE_ID BIGINT 8
83 ASSESSMENTPROCESSTYPE_NAME CHARACTER VARYING(256) 256
84 ASSESSOR_ID BIGINT 8
85 ASSESSOR_NAME CHARACTER VARYING(181) 181
86 VEHICLE_RETURNED_DATE TIMESTAMP 8
87 CCR_CCTL_SIUSTATUS_ID BIGINT 8
88 CCR_CCTL_SIUSTATUS_NAME CHARACTER VARYING(256) 256
89 REFER_INVESTIGATION_FLAG CHARACTER VARYING(3) 3
90 SPECIALNEED_TYPE_NAME CHARACTER VARYING(50) 50
91 SPECIALNEED_TYPE_CODE BIGINT 8
92 REPAIRER_ID BIGINT 8
93 REPAIRER_NAME CHARACTER VARYING(120) 120
94 REPAIRER_STATE_ID BIGINT 8
95 REPAIRER_STATE_CODE CHARACTER VARYING(50) 50
96 REPAIRER_STATE_NAME CHARACTER VARYING(256) 256
97 REPAIRER_REGION_NAME CHARACTER VARYING(15) 15
98 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
99 ASSESSMENT_CENTER_NAME CHARACTER VARYING(120) 120
100 ASSESSMENT_STATE_CODE CHARACTER VARYING(50) 50
101 ASSESSMENT_CENTER_STATE_NAME CHARACTER VARYING(256) 256
102 ASSESSMENT_CENTER_REGION_NAME CHARACTER VARYING(15) 15
103 ABLOCATION_CCR_ABTL_STATE_ID BIGINT 8
104 ASSMNT_LOCATION_TYPE_ID BIGINT 8
105 ASSMNT_LOCATION_TYPE_NAME CHARACTER VARYING(256) 256
106 POLICY_INTERMEDIARY_ID BIGINT 8
107 INCIDENT_REPAIR_COST_NET_GST NUMERIC(31,2) 19
108 INVOICEDATE DATE 4
109 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE_14DAYS DATE 4
110 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(256) 256
111 INTERMEDIARY_CCR_CC_CLAIMCONTACT_CONTACTID BIGINT 8
112 VEHICLE_HIGHPERFORMANCEIND CHARACTER VARYING(3) 3
113 UNIQUEVEHICLE CHARACTER VARYING(3) 3
114 POLICY_NUMBER CHARACTER VARYING(40) 40
115 INTERMEDIARY_TYPE_CODE CHARACTER VARYING(50) 50
116 CURRENT_FLAG CHARACTER VARYING(3) 3
117 LODGMENT_DATE_BAND_ID INTEGER 4
118 LODGMENT_DATE_BAND_NAME CHARACTER VARYING(21) 21
119 CLAIM_REOPEN_FLAG CHARACTER VARYING(3) 3
120 INCIDENT_REPAIR_COST_GROSS_GST NUMERIC(31,2) 19
121 INCIDENT_REPAIR_COST_NET_GST_BAND INTEGER 4
122 INCIDENT_REPAIR_COST_NET_GST_BAND_NAME CHARACTER VARYING(18) 18
123 INCIDENT_REPAIR_COST_GROSS_GST_BAND INTEGER 4
124 INCIDENT_REPAIR_COST_GROSS_GST_BAND_NAME CHARACTER VARYING(18) 18
125 VEHICLE_COLLECTED_DATE TIMESTAMP 8
126 CCR_CC_INCIDENT_SC_EXTERNALASSESSORIND CHARACTER VARYING(1) 1
127 RECOMMENDED_REPAIRER_FLAG CHARACTER VARYING(3) 3
128 MAX_TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
129 ADJUSTER_FIRSTNAME CHARACTER VARYING(90) 90
130 ADJUSTER_LASTNAME CHARACTER VARYING(90) 90
131 ADJUSTER_MIDDLENAME CHARACTER VARYING(90) 90