FCT_MOTOR_FLEET_CLAIMS_EXTRACT_CMC12_INT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CLAIM_ID BIGINT 8
3 INSURED_NAME CHARACTER VARYING(181) 181
4 POLICYNUMBER CHARACTER VARYING(40) 40
5 POLICY_EFFECTIVEDATE DATE 4
6 POLICY_EXPIRATIONDATE DATE 4
7 POLICY_INCEPTIONDATE DATE 4
8 CLAIMNUMBER CHARACTER VARYING(40) 40
9 CLIENT_REFERENCE CHARACTER VARYING(15) 15
10 CLAIM_LOSSDATE DATE 4
11 CLAIM_LOSSTIME TIME 8
12 CLAIM_REPORTEDDATE DATE 4
13 PROFIT_CENTRE CHARACTER VARYING(60) 60
14 COST_CENTRE CHARACTER VARYING(15) 15
15 LIABILITY CHARACTER VARYING(256) 256
16 LOSS_CAUSE CHARACTER VARYING(256) 256
17 LOSS_DESCRIPTION CHARACTER VARYING(256) 256
18 THIRD_PARTY_IDENTIFIED CHARACTER VARYING(14) 14
19 THIRD_PARTY_INSURED CHARACTER VARYING(11) 11
20 NEW_CLAIM_DESCRIPTION CHARACTER VARYING(2000) 2000
21 CATASTROPHE_EVENT CHARACTER VARYING(121) 121
22 BUSINESS_OF_INSURED CHARACTER(60) 60
23 FLEET_MIX_CATEGORY CHARACTER VARYING(100) 100
24 VEHICLE_REGISTRATION_NUMBER CHARACTER VARYING(40) 40
25 MANUFACTURE_YEAR BIGINT 8
26 VEHICLE_MAKE CHARACTER VARYING(60) 60
27 VEHICLE_MODEL CHARACTER VARYING(80) 80
28 OWN_DAMAGE_NET NUMERIC(38,2) 19
29 THIRD_PARTY_DAMAGE_NET NUMERIC(38,2) 19
30 ASSESSORS_FEES_NET NUMERIC(38,2) 19
31 OTHER_FEES_NET NUMERIC(38,2) 19
32 OTHER_FEES_GST_ITC NUMERIC(38,2) 19
33 SALVAGE_RECOVERIES_NET NUMERIC(38,2) 19
34 THIRD_PARTY_RECOVERIES_NET NUMERIC(38,2) 19
35 EXCESS_RECOVERIES_NET NUMERIC(38,2) 19
36 UNDER_DEDUCTIBLE_RECOVERIES_NET NUMERIC(38,2) 19
37 REFUND_EXCESS_NET NUMERIC(38,2) 19
38 REFUND_UD_NET NUMERIC(38,2) 19
39 OUTSTANDING_ESTIMATES_NET NUMERIC(38,2) 19
40 RECOVERY_ESTIMATES_NET NUMERIC(38,2) 19
41 EXCESS_RECOVERY_ESTIMATE_NET NUMERIC(38,2) 19
42 UNDER_DEDUCTIBLE_RECOVERY_ESTIMATE_NET NUMERIC(38,2) 19
43 OWN_DAMAGE_GROSS NUMERIC(38,2) 19
44 THIRD_PARTY_DAMAGE_GROSS NUMERIC(38,2) 19
45 ASSESSORS_FEES_GROSS NUMERIC(38,2) 19
46 OTHER_FEES_GROSS NUMERIC(38,2) 19
47 SALVAGE_RECOVERIES_GROSS NUMERIC(38,2) 19
48 THIRD_PARTY_RECOVERIES_GROSS NUMERIC(38,2) 19
49 EXCESS_RECOVERIES_GROSS NUMERIC(38,2) 19
50 UNDER_DEDUCTIBLE_RECOVERIES_GROSS NUMERIC(38,2) 19
51 REFUND_EXCESS_GROSS NUMERIC(38,2) 19
52 REFUND_UD_GROSS NUMERIC(38,2) 19
53 OUTSTANDING_ESTIMATES_GROSS NUMERIC(38,2) 19
54 RECOVERY_ESTIMATES_GROSS NUMERIC(38,2) 19
55 EXCESS_RECOVERY_ESTIMATE_GROSS NUMERIC(38,2) 19
56 UNDER_DEDUCTIBLE_RECOVERY_ESTIMATE_GROSS NUMERIC(38,2) 19
57 NET_INCURRED NUMERIC(38,2) 19
58 GROSS_INCURRED NUMERIC(38,2) 19
59 GROSS_PAID NUMERIC(38,2) 19
60 GST_ITC NUMERIC(38,2) 19
61 NET_PAID NUMERIC(38,2) 19
62 NET_INCURRED_EXCLUDES_UD_EXCESS_RECOVERIES_REFUNDS NUMERIC(38,2) 19
63 GROSS_INCURRED_EXCLUDES_UD_EXCESS_RECOVERIES_REFUNDS NUMERIC(38,2) 19
64 GROSS_PAID_EXCLUDES_UD_EXCESS_RECOVERIES_REFUNDS NUMERIC(38,2) 19
65 GST_ITC_EXCLUDES_UD_EXCESS_RECOVERIES_REFUNDS NUMERIC(38,2) 19
66 NET_PAID_EXCLUDES_UD_EXCESS_RECOVERIES_REFUNDS NUMERIC(38,2) 19
67 CLAIM_STATUS CHARACTER VARYING(256) 256
68 CLOSED_DATE TIMESTAMP 8
69 EXCESS NUMERIC(18,2) 19
70 TOTAL_INCURRED_EXCL_RECOV_INCL_GST NUMERIC(38,2) 19
71 UNDER_DEDUCTIBLE_INDICATOR CHARACTER VARYING(3) 3
72 UNDER_EXCESS_GST_APPLICABLE NUMERIC(38,2) 19
73 UNDER_EXCESS_GST NUMERIC(38,2) 19
74 UNDER_EXCESS_NON_GST_APPLICABLE NUMERIC(38,2) 19
75 PRIOR_MONTH_UNDER_EXCESS_GST_APPLICABLE NUMERIC(38,2) 19
76 PRIOR_MONTH_UNDER_EXCESS_GST NUMERIC(38,2) 19
77 PRIOR_MONTH_UNDER_EXCESS_NON_GST_APPLICABLE NUMERIC(38,2) 19
78 PRIOR_MONTH_EXCESS NUMERIC(18,2) 19
79 UNDER_EXCESS_TAX_INVOICE_GST_APPLICABLE NUMERIC(38,2) 19
80 UNDER_EXCESS_TAX_INVOICE_GST NUMERIC(38,2) 19
81 UNDER_EXCESS_TAX_INVOICE_GST_NON_APPLICABLE NUMERIC(38,2) 19
82 EXCESS_INVOICE NUMERIC(38,2) 19
83 UNDER_DEDUCTIBLE_FLAG CHARACTER VARYING(3) 3