INT_PI_MOTOR_MILESTONES_DAYS

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_INCIDENT_ID BIGINT 8
2 LIFE_CLAIM_DAYS INTEGER 4
3 LIFE_QUALITY_ISSUE_DAYS INTEGER 4
4 LIFE_COMPLAINT_DAYS INTEGER 4
5 LIFE_LODGE_TO_PRIMARY_BOOKING_DAYS INTEGER 4
6 LIFE_LODGE_TO_READY_ASSESSMENT_DAYS INTEGER 4
7 LIFE_READY_ASSESSMENT_DAYS INTEGER 4
8 LIFE_LODGE_TO_REP_AUTH_DAYS INTEGER 4
9 LIFE_ARRIVE_DAYS_TO_REP_AUTH_DAYS INTEGER 4
10 LIFE_REP_AUTH_TO_VEH_COLLECTED_DAYS INTEGER 4
11 LIFE_ARRIVE_DAYS_TO_VEH_COLLECTED_DAYS INTEGER 4
12 LIFE_REP_AUTH_TO_REPAIRS_COMPLETED_DAYS INTEGER 4
13 LIFE_LODGE_TO_FIRST_XS_PAY_DAYS INTEGER 4
14 LIFE_FIRST_XS_PAY_TO_XS_LAST_PAY_DAYS INTEGER 4
15 LIFE_LODGE_TO_TL_CREATE_DAYS INTEGER 4
16 LIFE_TL_CREATE_TO_TL_FULFILLED_DAYS INTEGER 4
17 LIFE_TL_DAYS INTEGER 4
18 LIFE_CUSTOMER_DAYS INTEGER 4
19 LIFE_CUSTOMER_BANDING_DAYS CHARACTER VARYING(14) 14
20 LIFE_REPAIR_DAYS INTEGER 4
21 LIFE_REPAIR_BANDING_DAYS CHARACTER VARYING(14) 14
22 LIFE_REP_AUTH_SPEED_DAYS INTEGER 4
23 LIFE_REP_AUTH_SPEED_BANDING_DAYS CHARACTER VARYING(14) 14
24 LIFE_REPAIR_SPEED_DAYS INTEGER 4
25 LIFE_REPAIR_SPEED_BANDING_DAYS CHARACTER VARYING(14) 14
26 LIFE_ASSESSMENT_SPEED_DAYS INTEGER 4
27 LIFE_ASSESSMENT_SPEED_BANDING_DAYS CHARACTER VARYING(14) 14
28 LIFE_BOOKING_SPEED_DAYS INTEGER 4
29 LIFE_BOOKING_SPEED_BANDING_DAYS CHARACTER VARYING(14) 14
30 LIFE_QUOTE_SPEED_DAYS INTEGER 4
31 LIFE_QUOTE_SPEED_BANDING_DAYS CHARACTER VARYING(14) 14
32 CLAIM_STATUS CHARACTER VARYING(17) 17
33 INVOICE_BANDING CHARACTER VARYING(14) 14
34 ARRIVED_VALIDITY_TEST CHARACTER VARYING(8) 8
35 COLLECTED_VALIDITY_TEST CHARACTER VARYING(8) 8
36 ISSUE_VALIDITY_TEST CHARACTER VARYING(8) 8
37 BOOKING_VALIDITY_TEST CHARACTER VARYING(8) 8
38 ASSESSMENT_VALIDITY_TEST CHARACTER VARYING(8) 8
39 SEQ_LODGE_TO_BOOK INTEGER 4
40 SEQ_BOOK_TO_APPOINTMENT INTEGER 4
41 SEQ_APPOINTMENT_TO_ARRIVE INTEGER 4
42 SEQ_ARRIVE_TO_QUOTE INTEGER 4
43 SEQ_QUOTE_TO_APPROVE INTEGER 4
44 SEQ_APPROVE_TO_COMPLETE INTEGER 4
45 SEQ_COMPLETE_TO_COLLECT INTEGER 4
46 SEQ_COLLECT_TO_INVOICE INTEGER 4
47 SEQ_ARRIVE_TO_TL_SUBMIT INTEGER 4
48 SEQ_TL_SUMBIT_TO_TL_APPROVE INTEGER 4
49 SEQ_TL_APPROVE_TO_TL_FULFILLED INTEGER 4
50 SEQ_QUOTE_TO_TL_SUBMIT INTEGER 4
51 SEQ_ARRIVE_TO_COMPLETE INTEGER 4
52 LIFE_TOTAL_LOSS_SUBMIT_TO_FULFIL_SPEED_BANDING_DAYS CHARACTER VARYING(14) 14
53 LIFE_TOTAL_LOSS_SUBMIT_SPEED_BANDING_DAYS CHARACTER VARYING(14) 14
54 ARRIVETOFULFIL INTEGER 4