FCT_MOTOR_PROFIT_AND_LOSS_INSIGHT_HIST_20210701031511

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CLAIM_ID BIGINT 8
3 CLAIM_COUNT INTEGER 4
4 CLAIMNUMBER_GROUP INTEGER 4
5 CLAIMNUMBER_GROUP_LABEL CHARACTER VARYING(10) 10
6 CLAIMNUMBER CHARACTER VARYING(40) 40
7 CLAIM_UPDATETIME TIMESTAMP 8
8 STATE_ID BIGINT 8
9 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
10 LOSSCAUSE_ID BIGINT 8
11 LOSSTYPE_ID BIGINT 8
12 LOSSTYPE_NAME CHARACTER VARYING(256) 256
13 BRAND_ID BIGINT 8
14 BRAND_NAME CHARACTER VARYING(256) 256
15 POLICYTYPE_ID BIGINT 8
16 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
17 LINEOFBUSINESS_ID BIGINT 8
18 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
19 CLAIM_STOCK_STATUS_ID INTEGER 4
20 CLAIM_STOCK_STATUS_NAME CHARACTER VARYING(11) 11
21 REPORT_ONLY_FLAG CHARACTER VARYING(1) 1
22 CLAIM_ASSIGNED_GROUP_NAME CHARACTER VARYING(100) 100
23 CLAIM_ASSIGNED_GROUP_TYPE CHARACTER VARYING(256) 256
24 CLAIM_ASSIGNED_TEAM_NAME CHARACTER VARYING(100) 100
25 CLAIM_ASSIGNEDUSER_ID BIGINT 8
26 CLAIM_ASSIGNED_USER_NAME CHARACTER VARYING(181) 181
27 LOSS_STATE_ID BIGINT 8
28 LOSS_STATE_NAME CHARACTER VARYING(256) 256
29 LOSS_REGION CHARACTER VARYING(15) 15
30 RISK_STATE_ID BIGINT 8
31 RISK_STATE_NAME CHARACTER VARYING(256) 256
32 RISK_REGION CHARACTER VARYING(15) 15
33 REOPENED_FLAG CHARACTER VARYING(1) 1
34 CATASTROPHE_ID BIGINT 8
35 CATASTROPHE_NAME CHARACTER VARYING(60) 60
36 LOSSCAUSE_NAME CHARACTER VARYING(256) 256
37 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
38 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
39 VEHICLE_STYLE_ID BIGINT 8
40 VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
41 LODGEMENT_DATE INTEGER 4
42 INITIAL_FINALISED_DATE INTEGER 4
43 LATEST_FINALISED_DATE INTEGER 4
44 LATEST_CLOSE_DATE TIMESTAMP 8
45 LATEST_REOPENED_DATE INTEGER 4
46 MOTOR_AGE_OF_CLAIM_1 INTEGER 4
47 CLAIM_AGE_BAND CHARACTER VARYING(14) 14
48 PANDL_STATUS_REOPENED CHARACTER VARYING(12) 12
49 PANDL_STATUS_FINALISED CHARACTER VARYING(13) 13
50 PANDL_STATUS_NEWCLAIM CHARACTER VARYING(13) 13
51 PANDL_STATUS_PREEXISTINGACTIVE CHARACTER VARYING(23) 23
52 PANDL_STATUS_ACTIVE CHARACTER VARYING(10) 10
53 TRANSACTION_ID BIGINT 8
54 TRANSACTION_UPDATETIME TIMESTAMP 8
55 TRANSACTION_CREATEUSER_ID BIGINT 8
56 TRANSACTION_CREATEDATE INTEGER 4
57 TRANSACTION_CREATETIME TIMESTAMP 8
58 TRANSACTION_PAYMENTTYPE_ID BIGINT 8
59 PAYMENT_TYPE_NAME CHARACTER VARYING(256) 256
60 TRANSACTION_COSTCATEGORY_ID BIGINT 8
61 TRANSACTION_COST_CATEGORY_NAME CHARACTER VARYING(256) 256
62 TRANSACTION_GLSERVICEACKDATE INTEGER 4
63 TRANSACTION_GLSERVICEACKTIME TIMESTAMP 8
64 TRANSACTION_COSTTYPE_ID BIGINT 8
65 TRANSACTION_COST_TYPE_NAME CHARACTER VARYING(256) 256
66 TRANSACTION_STATUS_ID BIGINT 8
67 TRANSACTION_STATUS_NAME CHARACTER VARYING(256) 256
68 TRANSACTION_CHECKID BIGINT 8
69 TRANSACTION_SUBTYPE_ID BIGINT 8
70 TRANSACTION_SUBTYPE_NAME CHARACTER VARYING(256) 256
71 TRANSACTION_USER_NAME CHARACTER VARYING(181) 181
72 TRANSACTION_CREATE_USER_TEAM_NAME CHARACTER VARYING(100) 100
73 TRANSACTION_GROUP_TYPE CHARACTER VARYING(256) 256
74 FINANCIALS_GROUPING_1 CHARACTER VARYING(18) 18
75 FINANCIALS_GROUPING_2 CHARACTER VARYING(16) 16
76 FINANCIALS_GROUPING_3 CHARACTER VARYING(15) 15
77 TRANSACTIONLINEITEM_ID BIGINT 8
78 TRANSACTIONLINEITEM_UPDATETIME TIMESTAMP 8
79 TRANSACTIONLINEITEM_LINECATEGORY_ID BIGINT 8
80 LINECATEGORY_NAME CHARACTER VARYING(256) 256
81 TRANSACTIONLINEITEM_TRANSACTIONAMOUNT NUMERIC(18,2) 19
82 TRANSACTIONLINEITEM_TRANSACTIONAMOUNT_POSITIVE_ONLY NUMERIC(18,2) 19
83 TRANSACTIONLINEITEM_GSTAMOUNT NUMERIC(18,2) 19
84 TRANSACTIONLINEITEM_ITCAMOUNT NUMERIC(18,2) 19
85 TRANSACTIONLINEITEM_DAMAMOUNT NUMERIC(18,2) 19
86 NET_TRANSACTION_AMOUNT NUMERIC(20,2) 19
87 TRANSACTIONLINEITEM_GROSSCLAIMCOST_AMOUNT NUMERIC(18,2) 19
88 TRANSACTIONLINEITEM_NETCLAIMCOST_AMOUNT NUMERIC(20,2) 19
89 TRANSACTIONLINEITEM_EXCESS_AMOUNT NUMERIC(18,2) 19
90 TRANSACTIONLINEITEM_EXCESSGST_AMOUNT NUMERIC(18,2) 19
91 TRANSACTION_WEIGHT NUMERIC(38,4) 19
92 NUMBER_OF_PAYMENT_LINES INTEGER 4
93 RECOVERY_ESTIMATE_FLAG CHARACTER VARYING(1) 1
94 OUTSTANDING_ESTIMATE_FLAG CHARACTER VARYING(1) 1
95 LOSSDATE INTEGER 4
96 REPORTEDDATE INTEGER 4
97 REPORT_DATE_KEY INTEGER 4
98 REPORT_DATE DATE 4
99 CLAIM_RECOVERY NUMERIC(38,2) 19
100 CLAIM_RECOVERY_RESERVE NUMERIC(38,2) 19
101 CLAIM_PAYMENT NUMERIC(38,2) 19
102 MIN_ESTIMATE_DATE TIMESTAMP 8
103 MIN_ESTIMATE_BACKOUT_DATE TIMESTAMP 8
104 GROSS_RECOVERYRESERVE_AMOUNT NUMERIC(18,2) 19
105 GROSS_RESERVE_AMOUNT NUMERIC(18,2) 19
106 GROSS_RECOVERY_AMOUNT NUMERIC(18,2) 19
107 GROSS_PAYMENT_AMOUNT NUMERIC(18,2) 19
108 NET_PAYMENT_AMOUNT NUMERIC(20,2) 19
109 NET_RECOVERY_AMOUNT NUMERIC(20,2) 19
110 TIME_TO_INITIAL_CLOSE NUMERIC(18,2) 19
111 TRANSACTION_DELAY NUMERIC(18,2) 19
112 LIFE_OF_INITIAL_CASE_ESTIMATE NUMERIC(18,2) 19
113 EVENT_NAME CHARACTER VARYING(256) 256
114 POLICYNUMBER CHARACTER VARYING(40) 40
115 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
116 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
117 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
118 CLAIM_PROCESS_TYPE_ID BIGINT 8
119 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
120 FLEET_IND CHARACTER VARYING(9) 9
121 CAS_IND CHARACTER VARYING(9) 9
122 PROFIT_CENTRE CHARACTER VARYING(60) 60
123 COST_CENTRE CHARACTER VARYING(15) 15
124 COST_CENTRE_REFERENCE CHARACTER VARYING(15) 15
125 INSURED_NAME CHARACTER VARYING(181) 181
126 LOSS_CCR_CC_ADDRESS_COUNTRY CHARACTER VARYING(256) 256
127 CCR_CCTL_FAULTRATING_ID BIGINT 8
128 CCR_CCTL_FAULTRATING_NAME CHARACTER VARYING(256) 256
129 EXPOSUREID BIGINT 8
130 INCIDENTID BIGINT 8
131 CLAIMANTTYPE_ID BIGINT 8
132 CLAIMANTTYPE_NAME CHARACTER VARYING(256) 256
133 CLAIMORDER BIGINT 8
134 LOSSPARTY BIGINT 8
135 LOSSPARTY_NAME CHARACTER VARYING(256) 256
136 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
137 LEGACY_CLAIM CHARACTER VARYING(3) 3
138 LEGACY_TYPE CHARACTER VARYING(256) 256