FCT_MOTOR_GIO_BLUE_RIBBON

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CCR_CC_CLAIM_ID BIGINT 8
2 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
3 CCR_CC_INCIDENT_ID BIGINT 8
4 CCR_CC_VEHICLE_YEAR CHARACTER VARYING(20) 20
5 CCR_CC_VEHICLE_MAKE CHARACTER VARYING(60) 60
6 CCR_CC_VEHICLE_MODEL CHARACTER VARYING(80) 80
7 CCR_CC_VEHICLE_SC_NVIC CHARACTER VARYING(15) 15
8 CCR_CCTL_SC_BRAND_ID BIGINT 8
9 CCR_CCTL_SC_BRAND_NAME CHARACTER VARYING(256) 256
10 CCR_CCTL_SC_LINEOFBUSINESS_ID BIGINT 8
11 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
12 CCR_CC_COVERAGE_TYPE BIGINT 8
13 CCR_CC_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
14 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
15 CCR_CCTL_LOSSCAUSE_ID BIGINT 8
16 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
17 CCR_CCTL_SC_LOSSCAUSESUBTYPE_ID BIGINT 8
18 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
19 ASSESSMENT_CENTER_STATE_NAME CHARACTER VARYING(256) 256
20 ASSESSMENT_CENTER_REGION_NAME CHARACTER VARYING(15) 15
21 ASSESSMENT_CENTER_NAME CHARACTER VARYING(120) 120
22 REPAIRER_CCR_AB_ABCONTACT_PUBLICID CHARACTER VARYING(64) 64
23 REPAIRER_NAME CHARACTER VARYING(120) 120
24 ALIGNED_REPAIRER_STATE CHARACTER VARYING(256) 256
25 ALIGNED_REPAIRER_REGION CHARACTER VARYING(15) 15
26 ALIGNED_REPAIRER_BOOKING_LOCATION_ID BIGINT 8
27 ALIGNED_REPAIRER_BOOKING_LOCATION_NAME CHARACTER VARYING(612) 612
28 ALIGNED_REPAIRER_NAME CHARACTER VARYING(120) 120
29 ALIGNED_REPAIRER_ID BIGINT 8
30 CCR_CCX_SC_PNETQUOTEREQUEST_STATUS BIGINT 8
31 CCR_CCX_SC_PNETQUOTEREQUEST_STATUS_NAME CHARACTER VARYING(256) 256
32 CCR_CCTL_SC_PNETQUOTE_NAME CHARACTER VARYING(256) 256
33 ORIGINAL_ECD TIMESTAMP 8
34 PNETQUOTELINE_REPAIR_COST_NET_AMOUNT NUMERIC(38,2) 19
35 REPAIR_AGE_OVER_7DAYS_INDICATOR CHARACTER VARYING(1) 1
36 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_GROUP CHARACTER VARYING(13) 13
37 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_ID BIGINT 8
38 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_NAME CHARACTER VARYING(256) 256
39 CCR_CCTL_SC_ASSESSMENTPROCESSTYPE_TYPECODE CHARACTER VARYING(50) 50
40 CCR_CCTL_VEHICLESTYLE_ID BIGINT 8
41 CCR_CCTL_VEHICLESTYLE_NAME CHARACTER VARYING(256) 256
42 CCR_CCTL_LOSSPARTYTYPE_ID BIGINT 8
43 CCR_CCTL_LOSSPARTYTYPE_NAME CHARACTER VARYING(256) 256
44 CCR_CCTL_SC_PNETASSESSOUTCOME_ID BIGINT 8
45 CCR_CCTL_SC_PNETASSESSOUTCOME_NAME CHARACTER VARYING(256) 256
46 AUTHORISED_QUOTE_FLAG CHARACTER VARYING(14) 14
47 HIRE_CAR_DATE TIMESTAMP 8
48 SERVICE_TYPE CHARACTER VARYING(9) 9
49 AUTH_AMOUNT NUMERIC(9,2) 19
50 SERVICE_DAYS_LENGTH INTEGER 4
51 SERVICE_CREATOR_TEAM_ID BIGINT 8
52 SERVICE_CREATOR_TEAM_NAME CHARACTER VARYING(100) 100
53 SERVICE_CREATE_USER_ID BIGINT 8
54 SERVICE_CREATOR_FULLNAME CHARACTER VARYING(181) 181
55 SERVICE_SUBTYPE_ID CHARACTER VARYING(37) 37
56 SERVICE_SUBTYPE CHARACTER VARYING(256) 256
57 CCR_CCX_SC_PNETQUOTEREQUEST_ASSESSCOMPLETEDTE DATE 4
58 VEHICLE_ARRIVAL_DATE DATE 4
59 VEHICLE_RETURNED_DATE DATE 4
60 REPAIR_ACTUAL_COMPLETION_DATE DATE 4
61 SERVICE_START_DATE DATE 4