FCT_MOTOR_SALVAGE_INSIGHT_TWB

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 REPORT_GROUP CHARACTER VARYING(8) 8
2 REPORT_DATE DATE 4
3 REFRESH_DATE TIMESTAMP 8
4 CLAIM_ID BIGINT 8
5 CLAIM_NUMBER CHARACTER VARYING(40) 40
6 INCIDENT_ID BIGINT 8
7 GL_MONTH TIMESTAMP 8
8 GL_FINYEAR INTEGER 4
9 BRAND_NAME CHARACTER VARYING(256) 256
10 LOSS_GROUP CHARACTER VARYING(14) 14
11 POLICY_TYPE CHARACTER VARYING(256) 256
12 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
13 VEHICLE_TYPE CHARACTER VARYING(256) 256
14 STATE CHARACTER VARYING(256) 256
15 SALVAGE_PATHING CHARACTER VARYING(32) 32
16 WOVR_TYPE_NAME CHARACTER VARYING(256) 256
17 FLEET_IND CHARACTER VARYING(9) 9
18 EVENT_NAME CHARACTER VARYING(256) 256
19 SALVAGE_ACCURACY_PERC_BANDING CHARACTER VARYING(9) 9
20 AWAITING_SALVAGE_DAYS CHARACTER VARYING(10) 10
21 SALVAGE_COUNT INTEGER 4
22 GROSS_SALVAGE_AMOUNT NUMERIC(38,2) 19
23 NET_SALVAGE_AMOUNT NUMERIC(38,6) 19
24 SALVAGE_AV_MV NUMERIC(38,2) 19
25 AWAITING_SALVAGE_COUNT INTEGER 4
26 AWAITING_SALVAGE_ESTIMATE NUMERIC(18,2) 19
27 SALVAGE_ESTIMATE_VALUE NUMERIC(18,2) 19
28 NET_COMMISSION_AMOUNT NUMERIC(16,6) 19
29 TLF_TO_SALREL_DAYS INTEGER 4
30 TLF_TO_SALREL_FLAG INTEGER 4
31 SALREL_TO_SALREC_DAYS INTEGER 4
32 SALREL_TO_SALREC_FLAG INTEGER 4
33 PCP_SALVAGE_COUNT INTEGER 4
34 PCP_GROSS_SALVAGE_AMOUNT NUMERIC(38,2) 19
35 PCP_NET_SALVAGE_AMOUNT NUMERIC(38,6) 19
36 PCP_SALVAGE_AV_MV NUMERIC(38,2) 19
37 PCP_AWAITING_SALVAGE_COUNT INTEGER 4
38 PCP_AWAITING_SALVAGE_ESTIMATE INTEGER 4
39 PCP_SALVAGE_ESTIMATE_VALUE NUMERIC(18,2) 19
40 PCP_NET_COMMISSION_AMOUNT NUMERIC(16,6) 19
41 PCP_TLF_TO_SALREL_DAYS INTEGER 4
42 PCP_TLF_TO_SALREL_FLAG INTEGER 4
43 PCP_SALREL_TO_SALREC_DAYS INTEGER 4
44 PCP_SALREL_TO_SALREC_FLAG INTEGER 4
45 BUDGET_SALVAGE_AMOUNT NUMERIC(38,6) 19
46 VEHICLE_MAKE CHARACTER VARYING(60) 60
47 VEHICLE_MODEL CHARACTER VARYING(80) 80
48 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
49 REGISTRATION_NUMBER CHARACTER VARYING(40) 40
50 VEHICLE_PAV NUMERIC(18,2) 19
51 ESTIMATED_COST_OF_REPAIRS NUMERIC(18,2) 19
52 SALVAGE_ESTIMATE_SOURCE CHARACTER VARYING(256) 256
53 CLAIM_LOSSDATE TIMESTAMP 8
54 SALVAGE_RECOVERY NUMERIC(38,2) 19
55 REGISTRATION_RECOVERY NUMERIC(38,2) 19
56 ASSESSMENT_LOCATION CHARACTER VARYING(120) 120
57 SALVAGEOUTCOMEDATE TIMESTAMP 8
58 TOTAL_LOSS_SUBMITTED_DATE DATE 4
59 SALAVGE_RECOVERY_DATE TIMESTAMP 8
60 REGISTRATION_RECOVERY_DATE TIMESTAMP 8