INT_PI_MOTOR_CLAIMANT_SATISFACTION

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CCR_CC_CLAIM_ID BIGINT 8
3 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
4 CCR_CCTL_LOSSTYPE_ID BIGINT 8
5 CCR_CCTL_LOSSCAUSE_ID BIGINT 8
6 CCR_CCTL_SC_LOSSCAUSESUBTYPE_ID BIGINT 8
7 CCR_CCTL_CLAIMSTATE_ID BIGINT 8
8 CCR_CCTL_POLICYTYPE_ID BIGINT 8
9 REPORT_ONLY_FLAG INTEGER 4
10 CCR_CCTL_SC_LINEOFBUSINESS_ID BIGINT 8
11 CCR_CCTL_SC_BRAND_ID BIGINT 8
12 RISK_CCR_CCTL_STATE_ID BIGINT 8
13 LODGEMENT_DATE DATE 4
14 LODGEMENT_TIME TIMESTAMP 8
15 CLOSED_DATE DATE 4
16 CCR_CC_CLAIM_CLOSEDATE TIMESTAMP 8
17 REOPENED_DATE DATE 4
18 CCR_CC_CLAIM_REOPENDATE TIMESTAMP 8
19 REOPENED_FLAG INTEGER 4
20 CCR_CC_CATASTROPHE_ID BIGINT 8
21 INSURED_CCR_CC_CONTACT_ID BIGINT 8
22 REPAIR_ACTUAL_COMPLETION_DATE TIMESTAMP 8
23 REPAIR_ACTUAL_COMPLETION_DATE_14DAYS TIMESTAMP 8
24 CCR_CCTL_COVERAGETYPE_ID BIGINT 8
25 CCR_CCTL_VEHICLESTYLE_ID BIGINT 8
26 CCR_CCTL_CLAIMCLOSEDOUTCOMETYPE_ID BIGINT 8
27 CCR_CCTL_SC_CLAIMDECISION_ID BIGINT 8
28 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_ID BIGINT 8
29 ASSESSOR_CCR_CC_CONTACT_ID BIGINT 8
30 VEHICLE_RETURNED_DATE TIMESTAMP 8
31 CCR_CCTL_SIUSTATUS_ID BIGINT 8
32 REFER_INVESTIGATION_FLAG INTEGER 4
33 SPECIALNEED_FLAG INTEGER 4
34 REPAIRER_CCR_AB_ABCONTACT_ID BIGINT 8
35 REPAIRER_CCR_ABTL_STATE_ID BIGINT 8
36 ABLOCATION_CCR_AB_ABCONTACT_ID BIGINT 8
37 ABLOCATION_CCR_ABTL_STATE_ID BIGINT 8
38 CCR_ABTL_SC_LOCATIONCONTACTTYPE_ID BIGINT 8
39 INSURED_INCIDENT_REPAIR_COST_NET_GST NUMERIC(31,2) 19
40 CCR_CCX_SC_PNETQUOTEINVOICE_INVOICEDATE TIMESTAMP 8
41 CCR_CC_POLICY_SC_INTERMEDTYPE BIGINT 8
42 INTERMEDIARY_CCR_CC_CLAIMCONTACT_CONTACTID BIGINT 8
43 VEHICLE_HIGHPERFORMANCEIND CHARACTER VARYING(3) 3
44 UNIQUEVEHICLE CHARACTER VARYING(3) 3
45 POLICYNUMBER CHARACTER VARYING(40) 40
46 CLAIM_COUNT INTEGER 4
47 REPORT_DATE DATE 4
48 EXCESS_AMT NUMERIC(18,2) 19
49 VEHICLE_MAKE CHARACTER VARYING(60) 60
50 VEHICLE_MODEL CHARACTER VARYING(80) 80
51 VEHICLE_YEAR BIGINT 8
52 QUALITYISSUE_FLAG CHARACTER VARYING(1) 1
53 CLAIM_SELF_SERVICE_FLAG CHARACTER VARYING(1) 1
54 REPAIRER_ID BIGINT 8
55 REPAIRER_NAME CHARACTER VARYING(120) 120
56 FULFILMENT_VALUE NUMERIC(38,2) 19
57 POLICY_PAYMENT_MODE BIGINT 8
58 ACTIVITY_OVERDUE_FLAG CHARACTER VARYING(1) 1
59 CLAIMANT_TOTAL_PAYMENTS NUMERIC(38,2) 19
60 TOTAL_PAYMENTS NUMERIC(18,2) 19
61 CCR_CC_INCIDENT_SC_EXTERNALASSESSORIND CHARACTER VARYING(1) 1
62 VEHICLE_SC_FINANCEIND CHARACTER VARYING(1) 1
63 VEHICLE_REG_NO CHARACTER VARYING(40) 40
64 INCIDENT_NO BIGINT 8
65 TOTAL_LOSS_CREATETIME TIMESTAMP 8
66 SURVEY_DATE TIMESTAMP 8
67 MAX_TOTAL_LOSS_FULFILLED_DATE TIMESTAMP 8
68 HOWREPORTED BIGINT 8
69 POLICYID BIGINT 8
70 HOWREPORTED_DESC CHARACTER VARYING(256) 256
71 POLICYTYPE_DESC CHARACTER VARYING(256) 256
72 RECOMMENDED_REPAIRER_FLAG CHARACTER VARYING(3) 3
73 REPLACEMENT_VEHICLE_FLAG CHARACTER VARYING(1) 1
74 VEHICLE_COLLECTED_DATE TIMESTAMP 8
75 VEHICLE_COLLECTED_DATE_DERV TIMESTAMP 8
76 VEHICLE_DRIVABLE_FLAG CHARACTER(1) 1