INT_CI_CLAIM_DRILLTHRU

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 POLICY_NUMBER CHARACTER VARYING(40) 40
4 CLAIM_CREATED_DATE TIMESTAMP 8
5 CLAIM_CREATED_DATE_LBL CHARACTER VARYING(30) 30
6 CLAIM_CREATED_DATE_ID INTEGER 4
7 CLAIM_REJECT_REASON BIGINT 8
8 CLAIM_REJECT_REASON_NAME CHARACTER VARYING(256) 256
9 CLAIM_ID BIGINT 8
10 CLAIM_NUMBER CHARACTER VARYING(40) 40
11 VERIFIED_POLICY_FLAG INTEGER 4
12 VERIFIED_POLICY CHARACTER VARYING(256) 256
13 CLAIM_DURATION_ID INTEGER 4
14 CLAIM_DURATION_BAND_ID INTEGER 4
15 CLAIM_SIU_REFERRAL_FLAG_ID BIGINT 8
16 CLAIM_SIU_REFERRAL_FLAG CHARACTER VARYING(256) 256
17 CLAIM_SIU_STATUS_ID BIGINT 8
18 CLAIM_SIU_STATUS CHARACTER VARYING(256) 256
19 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
20 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
21 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
22 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
23 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
24 CLAIM_INITIAL_FINALISED_DATE TIMESTAMP 8
25 CLAIM_INITIAL_FINALISED_DATE_YEAR INTEGER 4
26 CLAIM_INITIAL_FINALISED_DATE_QUARTER INTEGER 4
27 CLAIM_INITIAL_FINALISED_DATE_MONTH INTEGER 4
28 CLAIM_INITIAL_FINALISED_DATE_DAY INTEGER 4
29 CLAIM_INITIAL_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
30 CLAIM_INITIAL_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
31 CLAIM_INITIAL_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
32 CLAIM_INITIAL_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
33 CLAIM_INITIAL_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
34 CLAIM_INITIAL_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
35 CLAIM_INITIAL_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
36 CLAIM_INITIAL_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
37 CLAIM_INITIAL_FINALISED_DATE_HALF_TYPE_ID INTEGER 4
38 CLAIM_REOPENED_REASON_ID BIGINT 8
39 CLAIM_REOPENED_REASON CHARACTER VARYING(256) 256
40 CLAIM_SEGMENT_ID BIGINT 8
41 CLAIM_SEGMENT CHARACTER VARYING(256) 256
42 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
43 LOSS_CAUSE_ID BIGINT 8
44 CLAIM_DURATION CHARACTER VARYING(17) 17
45 CLAIM_STATE_ID BIGINT 8
46 CLAIM_STATE CHARACTER VARYING(256) 256
47 REPORT_ONLY_FLAG_ID BIGINT 8
48 REPORT_ONLY_FLAG CHARACTER VARYING(3) 3
49 CLAIM_CREATE_DATE_DATE_KEY INTEGER 4
50 CLAIM_CREATE_DATE_CAL_YEAR INTEGER 4
51 CLAIM_CREATE_DATE_CAL_QUARTER INTEGER 4
52 CLAIM_CREATE_DATE_CAL_MONTH INTEGER 4
53 CLAIM_CREATE_DATE_CAL_DAY INTEGER 4
54 CLAIM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
55 CLAIM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
56 CLAIM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
57 CLAIM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
58 CLAIM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
59 CLAIM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
60 CLAIM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
61 CLAIM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
62 CLAIM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
63 CLAIM_LAST_REOPENED_DATE_ID INTEGER 4
64 CLAIM_LAST_REOPENED_DATE_KEY INTEGER 4
65 CLAIM_LAST_REOPENED_DATE_CAL_YEAR INTEGER 4
66 CLAIM_LAST_REOPENED_DATE_CAL_QUARTER INTEGER 4
67 CLAIM_LAST_REOPENED_DATE_CAL_MONTH INTEGER 4
68 CLAIM_LAST_REOPENED_DATE_CAL_DAY INTEGER 4
69 CLAIM_LAST_REOPENED_DATE_DAY_TYPE_ID INTEGER 4
70 CLAIM_LAST_REOPENED_DATE_WEEK_TYPE_ID INTEGER 4
71 CLAIM_LAST_REOPENED_DATE_MONTH_TYPE_ID INTEGER 4
72 CLAIM_LAST_REOPENED_DATE_QUARTER_TYPE_ID INTEGER 4
73 CLAIM_LAST_REOPENED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
74 CLAIM_LAST_REOPENED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
75 CLAIM_LAST_REOPENED_DATE_R12_MONTH_TYPE_ID INTEGER 4
76 CLAIM_LAST_REOPENED_DATE_R13_MONTH_TYPE_ID INTEGER 4
77 CLAIM_LAST_REOPENED_DATE_HALF_TYPE_ID INTEGER 4
78 CLAIM_FINALISED_DATE INTEGER 4
79 CLAIM_FINALISED_DATE_KEY INTEGER 4
80 CLAIM_FINALISED_DATE_CAL_YEAR INTEGER 4
81 CLAIM_FINALISED_DATE_CAL_QUARTER INTEGER 4
82 CLAIM_FINALISED_DATE_CAL_MONTH INTEGER 4
83 CLAIM_FINALISED_DATE_CAL_DAY INTEGER 4
84 CLAIM_FINALISED_DATE_DAY_TYPE_ID INTEGER 4
85 CLAIM_FINALISED_DATE_WEEK_TYPE_ID INTEGER 4
86 CLAIM_FINALISED_DATE_MONTH_TYPE_ID INTEGER 4
87 CLAIM_FINALISED_DATE_QUARTER_TYPE_ID INTEGER 4
88 CLAIM_FINALISED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
89 CLAIM_FINALISED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
90 CLAIM_FINALISED_DATE_R12_MONTH_TYPE_ID INTEGER 4
91 CLAIM_FINALISED_DATE_R13_MONTH_TYPE_ID INTEGER 4
92 CLAIM_FINALISED_DATE_HALF_TYPE_ID INTEGER 4
93 CLAIM_PRIMARY_ADJUSTER_ID BIGINT 8
94 CLAIM_ADJUSTER_LOOKUP_USER_ID BIGINT 8
95 CLAIM_ADJUSTER CHARACTER VARYING(181) 181
96 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
97 TEAM_ID BIGINT 8
98 TEAM_NAME CHARACTER VARYING(100) 100
99 GROUP_TYPE_ID BIGINT 8
100 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
101 L1_TEAM_ID BIGINT 8
102 L1_TEAM_NAME CHARACTER VARYING(100) 100
103 L2_TEAM_ID BIGINT 8
104 L2_TEAM_NAME CHARACTER VARYING(100) 100
105 L3_TEAM_ID BIGINT 8
106 L3_TEAM_NAME CHARACTER VARYING(100) 100
107 L4_TEAM_ID BIGINT 8
108 L4_TEAM_NAME CHARACTER VARYING(100) 100
109 L5_TEAM_ID BIGINT 8
110 L5_TEAM_NAME CHARACTER VARYING(100) 100
111 L6_TEAM_ID BIGINT 8
112 L6_TEAM_NAME CHARACTER VARYING(100) 100
113 L7_TEAM_ID BIGINT 8
114 L7_TEAM_NAME CHARACTER VARYING(100) 100
115 L8_TEAM_ID BIGINT 8
116 L8_TEAM_NAME CHARACTER VARYING(100) 100
117 L9_TEAM_ID BIGINT 8
118 L9_TEAM_NAME CHARACTER VARYING(100) 100
119 L10_TEAM_ID BIGINT 8
120 L10_TEAM_NAME CHARACTER VARYING(100) 100
121 L11_TEAM_ID BIGINT 8
122 L11_TEAM_NAME CHARACTER VARYING(100) 100
123 CLAIM_ASSIGNMENT_DATE TIMESTAMP 8
124 CLAIM_ASSIGNMENT_DATE_ID INTEGER 4
125 CLAIM_ASSIGNED_DATE_CAL_YEAR INTEGER 4
126 CLAIM_ASSIGNED_DATE_CAL_QUARTER INTEGER 4
127 CLAIM_ASSIGNED_DATE_CAL_MONTH INTEGER 4
128 CLAIM_ASSIGNED_DATE_CAL_DAY INTEGER 4
129 CLAIM_ASSIGNED_DATE_DAY_TYPE_ID INTEGER 4
130 CLAIM_ASSIGNED_DATE_WEEK_TYPE_ID INTEGER 4
131 CLAIM_ASSIGNED_DATE_MONTH_TYPE_ID INTEGER 4
132 CLAIM_ASSIGNED_DATE_QUARTER_TYPE_ID INTEGER 4
133 CLAIM_ASSIGNED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
134 CLAIM_ASSIGNED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
135 CLAIM_ASSIGNED_DATE_R12_MONTH_TYPE_ID INTEGER 4
136 CLAIM_ASSIGNED_DATE_R13_MONTH_TYPE_ID INTEGER 4
137 CLAIM_ASSIGNED_DATE_HALF_TYPE_ID INTEGER 4
138 CLAIM_LOSS_DATE TIMESTAMP 8
139 CLAIM_LOSS_DATE_ID INTEGER 4
140 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
141 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
142 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
143 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
144 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
145 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
146 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
147 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
148 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
149 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
150 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
151 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
152 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
153 CLAIM_RISK_INDICATORS_FLAG_ID INTEGER 4
154 CLAIM_RISK_INDICATORS_FLAG_NAME CHARACTER VARYING(256) 256
155 CLAIM_EVENT_ID BIGINT 8
156 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
157 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
158 CLAIM_DECISION_ID BIGINT 8
159 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
160 POLICY_GST_EXEMPT_FLAG INTEGER 4
161 POLICY_GST_EXEMPT_FLAG_NAME CHARACTER VARYING(256) 256
162 POLICY_GST_REGISTERED_FLAG INTEGER 4
163 POLICY_GST_REGISTERED_FLAG_NAME CHARACTER VARYING(256) 256
164 POLICY_ITC_PERCENTAGE NUMERIC(4,1) 19
165 POLICY_TYPE_ID BIGINT 8
166 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
167 LINE_OF_BUSINESS_ID BIGINT 8
168 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
169 CURRENT_POLICY_STATUS_ID BIGINT 8
170 CURRENT_POLICY_STATUS_NAME CHARACTER VARYING(256) 256
171 LOSS_LOCATION_ID BIGINT 8
172 POLICY_SOURCESYSTEM_ID BIGINT 8
173 POLICY_SOURCE_SYSTEM_NAME CHARACTER VARYING(256) 256
174 BRANDMARKER_LOB CHARACTER VARYING(10) 10
175 CLAIM_LITIGATION_FLAG_ID INTEGER 4
176 CLAIM_LITIGATION_FLAG_NAME CHARACTER VARYING(256) 256
177 POLICY_VERIFIED_ID CHARACTER VARYING(1) 1
178 CLAIM_POLICY_VERIFICATION_STATUS_ID BIGINT 8
179 VERIFIED_POLICY_STATUS_ID INTEGER 4
180 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
181 CLAIM_COMPLAINT_FLAG INTEGER 4
182 CLAIM_COMPLAINT_FLAG_NAME CHARACTER VARYING(256) 256
183 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
184 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
185 POLICY_INTERMEDIARY_ID BIGINT 8
186 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
187 CLAIM_EXTERNAL_REFERENCE_NUMBER CHARACTER VARYING(40) 40
188 CLAIM_DESCRIPTION CHARACTER VARYING(2000) 2000
189 CLAIM_PERMISSION_SECURITY_TYPE_ID BIGINT 8
190 CLAIM_PERMISSION_SECURITY_TYPE_NAME CHARACTER VARYING(256) 256
191 CLAIM_PERMISSION_SECURITY_TYPE_CODE CHARACTER VARYING(50) 50
192 GROSS_PAID_AMOUNT NUMERIC(38,2) 19
193 CLAIM_GROSS_PAID_AMOUNT_BAND_ID INTEGER 4
194 CLAIM_GROSS_PAID_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
195 GROSS_INCURRED_AMOUNT NUMERIC(38,2) 19
196 GROSS_INCURRED_AMOUNT_BAND_ID INTEGER 4
197 GROSS_INCURRED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
198 NET_INCURRED_AMOUNT NUMERIC(38,2) 19
199 NET_INCURRED_AMOUNT_BAND_ID INTEGER 4
200 NET_INCURRED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
201 GROSS_RECOVERED_AMOUNT NUMERIC(38,2) 19
202 GROSS_RECOVERED_AMOUNT_BAND_ID INTEGER 4
203 GROSS_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
204 NET_RECOVERED_AMOUNT NUMERIC(38,2) 19
205 NET_RECOVERED_AMOUNT_BAND_ID INTEGER 4
206 NET_RECOVERED_AMOUNT_BAND_NAME CHARACTER VARYING(15) 15
207 CLAIM_EXCESS_RECOVERY_STATUS CHARACTER VARYING(14) 14
208 CLAIM_EXCESS_RECOVERY_DURATION INTEGER 4
209 CLAIM_SALVAGE_RECOVERY_STATUS CHARACTER VARYING(14) 14
210 CLAIM_SALVAGE_RECOVERY_DURATION INTEGER 4
211 CLAIM_DEBT_RECOVERY_STATUS CHARACTER VARYING(14) 14
212 CLAIM_DEBT_RECOVERY_DURATION INTEGER 4
213 CLAIM_SIU_REFERRAL_REASON_COMMENT CHARACTER VARYING(2000) 2000