FCT_MOTOR_FINANCE_PROCESS_MOTOR_WALKS_INSIGHT_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
2 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
3 VEHICLE_ASSESSMENT_STATUS CHARACTER VARYING(256) 256
4 RISK_STATE_NAME CHARACTER VARYING(256) 256
5 CAS_IND CHARACTER VARYING(9) 9
6 FLEET_IND CHARACTER VARYING(9) 9
7 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
8 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
9 TRANSACTION_MONTH TIMESTAMP 8
10 BRAND_NAME CHARACTER VARYING(256) 256
11 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
12 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
13 DEVELOPMENT_LODGE_MONTH NUMERIC(17,9) 19
14 DEVELOPMENT_LOSS_MONTH NUMERIC(17,9) 19
15 EXPOSURE_LOSS_PARTY_TYPE CHARACTER VARYING(256) 256
16 PAYEE_CATEGORY_FINAL NATIONAL CHARACTER VARYING(250) 250
17 LEVEL_1 CHARACTER VARYING(8) 8
18 LEVEL_2 CHARACTER VARYING(17) 17
19 LEVEL_3 CHARACTER VARYING(39) 39
20 LEVEL_4 CHARACTER VARYING(256) 256
21 LEVEL_5 NATIONAL CHARACTER VARYING(256) 256
22 TRANSACTION_AMOUNT_INCL_GST NUMERIC(38,2) 19
23 TRANSACTION_AMOUNT_EXCL_GST NUMERIC(38,2) 19