FCT_CI_INCIDENT_ASSESSMENTBUILDINGITEM_DRILLTHRU

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BRAND BIGINT 8
2 BRAND_NAME CHARACTER VARYING(256) 256
3 CLAIM_CREATED_DATE TIMESTAMP 8
4 CLAIM_CREATED_DATE_LBL CHARACTER VARYING(30) 30
5 CLAIM_CREATED_DATE_ID INTEGER 4
6 CLAIM_CREATED_DATE_YEAR INTEGER 4
7 CLAIM_CREATED_DATE_QUARTER INTEGER 4
8 CLAIM_CREATED_DATE_MONTH INTEGER 4
9 CLAIM_CREATED_DATE_DAY INTEGER 4
10 CLAIM_CREATED_DATE_DAY_TYPE_ID INTEGER 4
11 CLAIM_CREATED_DATE_WEEK_TYPE_ID INTEGER 4
12 CLAIM_CREATED_DATE_MONTH_TYPE_ID INTEGER 4
13 CLAIM_CREATED_DATE_QUARTER_TYPE_ID INTEGER 4
14 CLAIM_CREATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
15 CLAIM_CREATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
16 CLAIM_CREATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
17 CLAIM_CREATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
18 CLAIM_CREATED_DATE_HALF_TYPE_ID INTEGER 4
19 CLAIM_NUMBER CHARACTER VARYING(40) 40
20 VERIFIED_POLICY CHARACTER VARYING(256) 256
21 VERIFIED_POLICY_FLAG INTEGER 4
22 VERIFIED_POLICY_STATUS_ID INTEGER 4
23 VERIFIED_POLICY_STATUS CHARACTER VARYING(17) 17
24 CLAIM_DURATION CHARACTER VARYING(17) 17
25 CLAIM_DURATION_BAND_ID INTEGER 4
26 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
27 CLAIM_LATEST_FINALISED_DATE TIMESTAMP 8
28 CLAIM_LATEST_FINALISED_DATE_ID INTEGER 4
29 CLAIM_LATEST_CLOSED_DATE_YEAR INTEGER 4
30 CLAIM_LATEST_CLOSED_DATE_QUARTER INTEGER 4
31 CLAIM_LATEST_CLOSED_DATE_MONTH INTEGER 4
32 CLAIM_LATEST_CLOSED_DATE_DAY INTEGER 4
33 CLAIM_LATEST_CLOSED_DATE_DAY_TYPE_ID INTEGER 4
34 CLAIM_LATEST_CLOSED_DATE_WEEK_TYPE_ID INTEGER 4
35 CLAIM_LATEST_CLOSED_DATE_MONTH_TYPE_ID INTEGER 4
36 CLAIM_LATEST_CLOSED_DATE_QUARTER_TYPE_ID INTEGER 4
37 CLAIM_LATEST_CLOSED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
38 CLAIM_LATEST_CLOSED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
39 CLAIM_LATEST_CLOSED_DATE_R12_MONTH_TYPE_ID INTEGER 4
40 CLAIM_LATEST_CLOSED_DATE_R13_MONTH_TYPE_ID INTEGER 4
41 CLAIM_LATEST_CLOSED_DATE_HALF_TYPE_ID INTEGER 4
42 CLAIM_LATEST_REOPENED_DATE TIMESTAMP 8
43 CLAIM_LATEST_REOPENED_DATE_ID INTEGER 4
44 CLAIM_LATEST_REOPENED_DATE_YEAR INTEGER 4
45 CLAIM_LATEST_REOPENED_DATE_QUARTER INTEGER 4
46 CLAIM_LATEST_REOPENED_DATE_MONTH INTEGER 4
47 CLAIM_LATEST_REOPENED_DATE_DAY INTEGER 4
48 CLAIM_LATEST_REOPENED_DATE_DAY_TYPE_ID INTEGER 4
49 CLAIM_LATEST_REOPENED_DATE_WEEK_TYPE_ID INTEGER 4
50 CLAIM_LATEST_REOPENED_DATE_MONTH_TYPE_ID INTEGER 4
51 CLAIM_LATEST_REOPENED_DATE_QUARTER_TYPE_ID INTEGER 4
52 CLAIM_LATEST_REOPENED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
53 CLAIM_LATEST_REOPENED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
54 CLAIM_LATEST_REOPENED_DATE_R12_MONTH_TYPE_ID INTEGER 4
55 CLAIM_LATEST_REOPENED_DATE_R13_MONTH_TYPE_ID INTEGER 4
56 CLAIM_LATEST_REOPENED_DATE_HALF_TYPE_ID INTEGER 4
57 CLAIM_SEGMENT_ID BIGINT 8
58 CLAIM_SEGMENT_NAME CHARACTER VARYING(256) 256
59 CLAIM_STATE_ID BIGINT 8
60 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
61 REPORT_ONLY_FLAG_ID BIGINT 8
62 REPORT_ONLY_FLAG CHARACTER VARYING(3) 3
63 CLAIM_DECISION_ID BIGINT 8
64 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
65 POLICY_NUMBER CHARACTER VARYING(40) 40
66 POLICY_SOURCESYSTEM_ID BIGINT 8
67 POLICY_SOURCE_SYSTEM_NAME CHARACTER VARYING(256) 256
68 POLICY_TYPE_ID BIGINT 8
69 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
70 LINE_OF_BUSINESS_ID BIGINT 8
71 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
72 CLAIM_PRIMARY_ADJUSTER_ID BIGINT 8
73 CLAIM_ADJUSTER_LOOKUP_USER_ID BIGINT 8
74 CLAIM_ADJUSTER CHARACTER VARYING(181) 181
75 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
76 TEAM_ID BIGINT 8
77 TEAM_NAME CHARACTER VARYING(100) 100
78 GROUP_TYPE_ID BIGINT 8
79 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
80 L1_TEAM_ID BIGINT 8
81 L1_TEAM_NAME CHARACTER VARYING(100) 100
82 L2_TEAM_ID BIGINT 8
83 L2_TEAM_NAME CHARACTER VARYING(100) 100
84 L3_TEAM_ID BIGINT 8
85 L3_TEAM_NAME CHARACTER VARYING(100) 100
86 L4_TEAM_ID BIGINT 8
87 L4_TEAM_NAME CHARACTER VARYING(100) 100
88 L5_TEAM_ID BIGINT 8
89 L5_TEAM_NAME CHARACTER VARYING(100) 100
90 L6_TEAM_ID BIGINT 8
91 L6_TEAM_NAME CHARACTER VARYING(100) 100
92 L7_TEAM_ID BIGINT 8
93 L7_TEAM_NAME CHARACTER VARYING(100) 100
94 L8_TEAM_ID BIGINT 8
95 L8_TEAM_NAME CHARACTER VARYING(100) 100
96 L9_TEAM_ID BIGINT 8
97 L9_TEAM_NAME CHARACTER VARYING(100) 100
98 L10_TEAM_ID BIGINT 8
99 L10_TEAM_NAME CHARACTER VARYING(100) 100
100 L11_TEAM_ID BIGINT 8
101 L11_TEAM_NAME CHARACTER VARYING(100) 100
102 CLAIM_SIU_REFERRAL_ID BIGINT 8
103 CLAIM_SIU_REFERRAL_NAME CHARACTER VARYING(256) 256
104 CLAIM_SIU_STATUS_ID BIGINT 8
105 CLAIM_SIU_STATUS_NAME CHARACTER VARYING(256) 256
106 INCIDENT_ID BIGINT 8
107 INCIDENT_CLAIMANT_TYPE_ID BIGINT 8
108 INCIDENT_CLAIMANT_TYPE_NAME CHARACTER VARYING(256) 256
109 INCIDENT_CREATE_DATE TIMESTAMP 8
110 INCIDENT_CREATE_DATE_ID INTEGER 4
111 INCIDENT_CREATED_DATE_YEAR INTEGER 4
112 INCIDENT_CREATED_DATE_QUARTER INTEGER 4
113 INCIDENT_CREATED_DATE_MONTH INTEGER 4
114 INCIDENT_CREATED_DATE_DAY INTEGER 4
115 INCIDENT_CREATED_DATE_DAY_TYPE_ID INTEGER 4
116 INCIDENT_CREATED_DATE_WEEK_TYPE_ID INTEGER 4
117 INCIDENT_CREATED_DATE_MONTH_TYPE_ID INTEGER 4
118 INCIDENT_CREATED_DATE_QUARTER_TYPE_ID INTEGER 4
119 INCIDENT_CREATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
120 INCIDENT_CREATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
121 INCIDENT_CREATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
122 INCIDENT_CREATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
123 INCIDENT_CREATED_DATE_HALF_TYPE_ID INTEGER 4
124 INCIDENT_CREATE_USER_ID BIGINT 8
125 INCIDENT_CREATE_USER_NAME CHARACTER VARYING(181) 181
126 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
127 INCIDENT_ESTIMATED_REPAIR_COST_AMT NUMERIC(18,2) 19
128 INCIDENT_ESTIMATED_REPAIR_TIME CHARACTER VARYING(60) 60
129 INCIDENT_LOSS_CAUSE_ID BIGINT 8
130 INCIDENT_LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
131 CLAIM_LOSS_DATE TIMESTAMP 8
132 CLAIM_LOSS_DATE_ID INTEGER 4
133 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
134 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
135 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
136 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
137 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
138 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
139 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
140 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
141 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
142 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
143 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
144 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
145 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
146 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
147 CLAIM_EVENT_ID BIGINT 8
148 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
149 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
150 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
151 POLICY_INTERMEDIARY_ID BIGINT 8
152 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
153 INCIDENT_INSPECTION_PLAN_DATE TIMESTAMP 8
154 INCIDENT_INSPECTION_PLAN_DATE_ID INTEGER 4
155 INCIDENT_INSPECTION_PLAN_DATE_YEAR INTEGER 4
156 INCIDENT_INSPECTION_PLAN_DATE_QUARTER INTEGER 4
157 INCIDENT_INSPECTION_PLAN_DATE_MONTH INTEGER 4
158 INCIDENT_INSPECTION_PLAN_DATE_DAY INTEGER 4
159 INCIDENT_INSPECTION_PLAN_DATE_DAY_TYPE_ID INTEGER 4
160 INCIDENT_INSPECTION_PLAN_DATE_WEEK_TYPE_ID INTEGER 4
161 INCIDENT_INSPECTION_PLAN_DATE_MONTH_TYPE_ID INTEGER 4
162 INCIDENT_INSPECTION_PLAN_DATE_QUARTER_TYPE_ID INTEGER 4
163 INCIDENT_INSPECTION_PLAN_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
164 INCIDENT_INSPECTION_PLAN_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
165 INCIDENT_INSPECTION_PLAN_DATE_R12_MONTH_TYPE_ID INTEGER 4
166 INCIDENT_INSPECTION_PLAN_DATE_R13_MONTH_TYPE_ID INTEGER 4
167 INCIDENT_INSPECTION_PLAN_DATE_HALF_TYPE_ID INTEGER 4
168 INCIDENT_DAMAGE_DESCRIPTION CHARACTER VARYING(289) 289
169 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS BIGINT 8
170 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS_NAME CHARACTER VARYING(256) 256
171 INCIDENT_REPAIR_DONE_FLAG CHARACTER VARYING(1) 1
172 INCIDENT_ASSESSMENT_DESCRIPTION CHARACTER VARYING(128) 128
173 INCIDENT_ASSESSMENT_STATUS_ID BIGINT 8
174 INCIDENT_ASSESSMENT_STATUS_NAME CHARACTER VARYING(256) 256
175 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE TIMESTAMP 8
176 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_ID INTEGER 4
177 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_YEAR INTEGER 4
178 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER INTEGER 4
179 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH INTEGER 4
180 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY INTEGER 4
181 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
182 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
183 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
184 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
185 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
186 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
187 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
188 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
189 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
190 INCIDENT_ASSESSMENT_CLOSE_DATE TIMESTAMP 8
191 INCIDENT_ASSESSMENT_CLOSE_DATE_ID INTEGER 4
192 INCIDENT_ASSESSMENT_CLOSE_DATE_YEAR INTEGER 4
193 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER INTEGER 4
194 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH INTEGER 4
195 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY INTEGER 4
196 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
197 INCIDENT_ASSESSMENT_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
198 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
199 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
200 INCIDENT_ASSESSMENT_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
201 INCIDENT_ASSESSMENT_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
202 INCIDENT_ASSESSMENT_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
203 INCIDENT_ASSESSMENT_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
204 INCIDENT_ASSESSMENT_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
205 INCIDENT_ASSESSMENT_COMMENT CHARACTER VARYING(255) 255
206 INCIDENT_ASSESSMENT_INTERNAL_USER_ID BIGINT 8
207 INCIDENT_ASSESSMENT_INTERNAL_USER_NAME CHARACTER VARYING(181) 181
208 INCIDENT_ASSESSMENT_CLAIMED_ITEM_BUILDING_FLAG INTEGER 4
209 INCIDENT_ASSESSMENT_CLAIMED_ITEM_BUILDING_FLAG_NAME CHARACTER VARYING(256) 256
210 ASSESSMENT_BUILDING_ITEM_CATEGORY_ID BIGINT 8
211 ASSESSMENT_BUILDING_ITEM_CATEGORY_NAME CHARACTER VARYING(256) 256
212 ASSESSMENT_BUILDING_ITEM_ID BIGINT 8
213 ASSESSMENT_BUILDING_ITEM_NAME CHARACTER VARYING(256) 256
214 ASSESSMENT_BUILDING_ITEM_DESCRIPTION CHARACTER VARYING(255) 255
215 ASSESSMENT_BUILDING_ITEM_ACTION_ID BIGINT 8
216 ASSESSMENT_BUILDING_ITEM_ACTION_NAME CHARACTER VARYING(256) 256
217 ASSESSMENT_BUILDING_ITEM_COUNT BIGINT 8
218 ASSESSMENT_BUILDING_ITEM_ESTIMATE_AMOUNT NUMERIC(18,2) 19
219 ASSESSMENT_BUILDING_ITEM_COMMENT CHARACTER VARYING(255) 255
220 ASSESSMENT_BUILDING_ITEM_SERVICE_PROVIDER_ID BIGINT 8
221 ASSESSMENT_BUILDING_ITEM_SERVICE_PROVIDER_NAME CHARACTER VARYING(181) 181
222 ASSESSMENT_BUILDING_ITEM_EXPOSURE_NUMBER CHARACTER VARYING(40) 40
223 ASSESSMENT_BUILDING_ITEM_EXPOSURE_COVERAGE_TYPE_ID BIGINT 8
224 ASSESSMENT_BUILDING_ITEM_EXPOSURE_COVERAGE_TYPE_NAME CHARACTER VARYING(256) 256
225 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE TIMESTAMP 8
226 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_ID INTEGER 4
227 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_YEAR INTEGER 4
228 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_QUARTER INTEGER 4
229 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_MONTH INTEGER 4
230 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_DAY INTEGER 4
231 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_DAY_TYPE_ID INTEGER 4
232 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_WEEK_TYPE_ID INTEGER 4
233 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_MONTH_TYPE_ID INTEGER 4
234 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_QUARTER_TYPE_ID INTEGER 4
235 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
236 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
237 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
238 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
239 ASSESSMENT_BUILDING_ITEM_UPDATE_DATE_HALF_TYPE_ID INTEGER 4
240 ASSESSMENT_BUILDING_ITEM_CREATE_DATE TIMESTAMP 8
241 ASSESSMENT_BUILDING_ITEMCREATE_DATE_ID INTEGER 4
242 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_YEAR INTEGER 4
243 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_QUARTER INTEGER 4
244 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_MONTH INTEGER 4
245 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_DAY INTEGER 4
246 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_DAY_TYPE_ID INTEGER 4
247 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
248 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
249 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
250 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
251 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
252 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
253 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
254 ASSESSMENT_BUILDING_ITEM_CREATE_DATE_HALF_TYPE_ID INTEGER 4
255 ASSESSMENT_BUILDING_ITEM_CREATE_USER_ID BIGINT 8
256 ASSESSMENT_BUILDING_ITEM_CREATE_USER_NAME CHARACTER VARYING(181) 181
257 ASSESSMENT_BUILDING_ITEM_EXPOSURE_ID BIGINT 8
258 ASSESSMENT_BUILDING_ITEM_ASSESSMENT_SOURCE_ID BIGINT 8
259 ASSESSMENT_BUILDING_ITEM_INCIDENT_ID BIGINT 8
260 ASSESSMENT_BUILDING_ITEM_SALVAGE_POSSIBILITY_FLAG_ID BIGINT 8
261 ASSESSMENT_BUILDING_ITEM_SALVAGE_POSSIBILITY_FLAG_NAME CHARACTER VARYING(256) 256