FCT_CI_CLAIM_CONTRIBUTING_FACTORS_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 CLAIM_NUMBER CHARACTER VARYING(40) 40
3 BRAND_ID BIGINT 8
4 BRAND_NAME CHARACTER VARYING(256) 256
5 POLICY_NUMBER CHARACTER VARYING(40) 40
6 VERIFIED_POLICY_STATUS_ID INTEGER 4
7 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
8 VERIFIED_POLICY_FLAG INTEGER 4
9 VERIFIED_POLICY CHARACTER VARYING(256) 256
10 POLICY_TYPE_ID BIGINT 8
11 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
12 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
13 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
14 POLICY_INTERMEDIARY_ID BIGINT 8
15 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
16 CLAIM_SIU_STATUS_ID BIGINT 8
17 CLAIM_SIU_STATUS CHARACTER VARYING(256) 256
18 CLAIM_SEGMENT_ID BIGINT 8
19 CLAIM_SEGMENT CHARACTER VARYING(256) 256
20 CREATE_DATE TIMESTAMP 8
21 CLAIM_CREATE_DATE_CAL_YEAR INTEGER 4
22 CLAIM_CREATE_DATE_CAL_QUARTER INTEGER 4
23 CLAIM_CREATE_DATE_CAL_MONTH INTEGER 4
24 CLAIM_CREATE_DATE_CAL_DAY INTEGER 4
25 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
26 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
27 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
28 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
29 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
30 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
31 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
32 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
33 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
34 CLAIM_LOSS_DATE TIMESTAMP 8
35 CLAIM_LOSS_DATE_ID INTEGER 4
36 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
37 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
38 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
39 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
40 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
41 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
42 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
43 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
44 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
45 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
46 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
47 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
48 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
49 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
50 CLAIM_INITIAL_FINALISED_DATE_YEAR INTEGER 4
51 CLAIM_INITIAL_FINALISED_DATE_QUARTER INTEGER 4
52 CLAIM_INITIAL_FINALISED_DATE_MONTH INTEGER 4
53 CLAIM_INITIAL_FINALISED_DATE_DAY INTEGER 4
54 CLAIM_INITIAL_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
55 CLAIM_INITIAL_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
56 CLAIM_INITIAL_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
57 CLAIM_INITIAL_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
58 CLAIM_INITIAL_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
59 CLAIM_INITIAL_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
60 CLAIM_INITIAL_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
61 CLAIM_INITIAL_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
62 CLAIM_INITIAL_FINALISED_DATE_HALF_TYPE_ID INTEGER 4
63 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
64 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
65 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
66 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
67 CLAIM_LASTEST_REOPENED_DATE_KEY INTEGER 4
68 CLAIM_LASTEST_REOPENED_DATE_CAL_YEAR INTEGER 4
69 CLAIM_LASTEST_REOPENED_DATE_CAL_QUARTER INTEGER 4
70 CLAIM_LASTEST_REOPENED_DATE_CAL_MONTH INTEGER 4
71 CLAIM_LASTEST_REOPENED_DATE_CAL_DAY INTEGER 4
72 CLAIM_LASTEST_REOPENED_DATE_DAY_TYPE_ID INTEGER 4
73 CLAIM_LASTEST_REOPENED_DATE_WEEK_TYPE_ID INTEGER 4
74 CLAIM_LASTEST_REOPENED_DATE_MONTH_TYPE_ID INTEGER 4
75 CLAIM_LASTEST_REOPENED_DATE_QUARTER_TYPE_ID INTEGER 4
76 CLAIM_LASTEST_REOPENED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
77 CLAIM_LASTEST_REOPENED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
78 CLAIM_LASTEST_REOPENED_DATE_R12_MONTH_TYPE_ID INTEGER 4
79 CLAIM_LASTEST_REOPENED_DATE_R13_MONTH_TYPE_ID INTEGER 4
80 CLAIM_LASTEST_REOPENED_DATE_HALF_TYPE_ID INTEGER 4
81 CLAIM_ASSIGNMENT_DATE TIMESTAMP 8
82 CLAIM_ASSIGNMENT_DATE_ID INTEGER 4
83 CLAIM_ASSIGNED_DATE_CAL_YEAR INTEGER 4
84 CLAIM_ASSIGNED_DATE_CAL_QUARTER INTEGER 4
85 CLAIM_ASSIGNED_DATE_CAL_MONTH INTEGER 4
86 CLAIM_ASSIGNED_DATE_CAL_DAY INTEGER 4
87 CLAIM_ASSIGNED_DATE_DAY_TYPE_ID INTEGER 4
88 CLAIM_ASSIGNED_DATE_WEEK_TYPE_ID INTEGER 4
89 CLAIM_ASSIGNED_DATE_MONTH_TYPE_ID INTEGER 4
90 CLAIM_ASSIGNED_DATE_QUARTER_TYPE_ID INTEGER 4
91 CLAIM_ASSIGNED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
92 CLAIM_ASSIGNED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
93 CLAIM_ASSIGNED_DATE_R12_MONTH_TYPE_ID INTEGER 4
94 CLAIM_ASSIGNED_DATE_R13_MONTH_TYPE_ID INTEGER 4
95 CLAIM_ASSIGNED_DATE_HALF_TYPE_ID INTEGER 4
96 CLAIM_DURATION CHARACTER VARYING(17) 17
97 CLAIM_DURATION_BAND_ID INTEGER 4
98 CLAIM_DURATION_BAND CHARACTER VARYING(14) 14
99 CLAIM_REJECT_REASON_ID BIGINT 8
100 CLAIM_REJECT_REASON CHARACTER VARYING(256) 256
101 CLAIM_REOPENED_REASON_ID BIGINT 8
102 CLAIM_REOPENED_REASON CHARACTER VARYING(256) 256
103 CLAIM_EVENT_ID BIGINT 8
104 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
105 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
106 CLAIM_STATE_ID BIGINT 8
107 CLAIM_STATE CHARACTER VARYING(256) 256
108 GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
109 GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
110 GROSS_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
111 NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
112 NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
113 NET_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
114 CLAIM_CONTRIBUTING_FACTOR_ID BIGINT 8
115 CLAIM_CONTRIBUTING_FACTOR_CATEGORY CHARACTER VARYING(256) 256
116 CLAIM_CONTRIBUTING_FACTOR_SUBCATEGORY CHARACTER VARYING(256) 256
117 CLAIM_CONTRIBUTING_FACTOR_VALUE CHARACTER VARYING(256) 256
118 CLAIM_CONTRIBUTING_FACTOR_OTHERDET CHARACTER VARYING(60) 60
119 CLAIM_CONTRIBUTING_FACTOR_UPDATETIME TIMESTAMP 8
120 CLAIM_CONTRIBUTING_FACTOR_UPDATE_USER_ID BIGINT 8
121 CLAIM_CONTRIBUTING_FACTOR_UPDATE_USER CHARACTER VARYING(181) 181
122 CLAIM_CONTRIBUTING_FACTOR_CREATE_USER_ID BIGINT 8
123 CLAIM_CONTRIBUTING_FACTOR_CREATE_USER CHARACTER VARYING(181) 181
124 CLAIM_CONTRIBUTING_FACTOR_CREATE_DATE TIMESTAMP 8
125 CLAIM_CONTRIBUTING_FACTOR_CREATE_DATE_LBL CHARACTER VARYING(30) 30
126 CLAIM_CONTRIBUTING_FACTOR_CREATE_DATE_ID INTEGER 4
127 CLAIM_CONTRIBUTING_CREATE_DATE_DATE_KEY INTEGER 4
128 CLAIM_CONTRIBUTING_CREATE_DATE_CAL_YEAR INTEGER 4
129 CLAIM_CONTRIBUTING_CREATE_DATE_CAL_QUARTER INTEGER 4
130 CLAIM_CONTRIBUTING_CREATE_DATE_CAL_MONTH INTEGER 4
131 CLAIM_CONTRIBUTING_CREATE_DATE_CAL_DAY INTEGER 4
132 CLAIM_CONTRIBUTING_CREATE_DATE_DAY_TYPE_ID INTEGER 4
133 CLAIM_CONTRIBUTING_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
134 CLAIM_CONTRIBUTING_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
135 CLAIM_CONTRIBUTING_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
136 CLAIM_CONTRIBUTING_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
137 CLAIM_CONTRIBUTING_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
138 CLAIM_CONTRIBUTING_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
139 CLAIM_CONTRIBUTING_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
140 CLAIM_CONTRIBUTING_CREATE_DATE_HALF_TYPE_ID INTEGER 4