FCT_CI_INCIDENT_ASSESSMENTSOURCE_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_BAND_ID INTEGER 4
25 CLAIM_DURATION CHARACTER VARYING(17) 17
26 CLAIM_DURATION_BAND_NAME CHARACTER VARYING(14) 14
27 CLAIM_SEGMENT_ID BIGINT 8
28 CLAIM_SEGMENT_NAME CHARACTER VARYING(256) 256
29 CLAIM_STATE_ID BIGINT 8
30 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
31 REPORT_ONLY_FLAG_ID BIGINT 8
32 REPORT_ONLY_FLAG CHARACTER VARYING(3) 3
33 CLAIM_DECISION_ID BIGINT 8
34 CLAIM_DECISION_NAME CHARACTER VARYING(256) 256
35 POLICY_NUMBER CHARACTER VARYING(40) 40
36 POLICY_SOURCESYSTEM_ID BIGINT 8
37 POLICY_SOURCE_SYSTEM_NAME CHARACTER VARYING(256) 256
38 POLICY_TYPE_ID BIGINT 8
39 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
40 LINE_OF_BUSINESS_ID BIGINT 8
41 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
42 CLAIM_PRIMARY_ADJUSTER_ID BIGINT 8
43 CLAIM_ADJUSTER_LOOKUP_USER_ID BIGINT 8
44 CLAIM_ADJUSTER CHARACTER VARYING(181) 181
45 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
46 TEAM_ID BIGINT 8
47 TEAM_NAME CHARACTER VARYING(100) 100
48 GROUP_TYPE_ID BIGINT 8
49 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
50 L1_TEAM_ID BIGINT 8
51 L1_TEAM_NAME CHARACTER VARYING(100) 100
52 L2_TEAM_ID BIGINT 8
53 L2_TEAM_NAME CHARACTER VARYING(100) 100
54 L3_TEAM_ID BIGINT 8
55 L3_TEAM_NAME CHARACTER VARYING(100) 100
56 L4_TEAM_ID BIGINT 8
57 L4_TEAM_NAME CHARACTER VARYING(100) 100
58 L5_TEAM_ID BIGINT 8
59 L5_TEAM_NAME CHARACTER VARYING(100) 100
60 L6_TEAM_ID BIGINT 8
61 L6_TEAM_NAME CHARACTER VARYING(100) 100
62 L7_TEAM_ID BIGINT 8
63 L7_TEAM_NAME CHARACTER VARYING(100) 100
64 L8_TEAM_ID BIGINT 8
65 L8_TEAM_NAME CHARACTER VARYING(100) 100
66 L9_TEAM_ID BIGINT 8
67 L9_TEAM_NAME CHARACTER VARYING(100) 100
68 L10_TEAM_ID BIGINT 8
69 L10_TEAM_NAME CHARACTER VARYING(100) 100
70 L11_TEAM_ID BIGINT 8
71 L11_TEAM_NAME CHARACTER VARYING(100) 100
72 CLAIM_SIU_REFERRAL_ID BIGINT 8
73 CLAIM_SIU_REFERRAL_NAME CHARACTER VARYING(256) 256
74 CLAIM_SIU_STATUS_ID BIGINT 8
75 CLAIM_SIU_STATUS_NAME CHARACTER VARYING(256) 256
76 INCIDENT_ID BIGINT 8
77 INCIDENT_CLAIMANT_TYPE_ID BIGINT 8
78 INCIDENT_CLAIMANT_TYPE_NAME CHARACTER VARYING(256) 256
79 INCIDENT_CREATE_DATE TIMESTAMP 8
80 INCIDENT_CREATE_DATE_ID INTEGER 4
81 INCIDENT_CREATED_DATE_YEAR INTEGER 4
82 INCIDENT_CREATED_DATE_QUARTER INTEGER 4
83 INCIDENT_CREATED_DATE_MONTH INTEGER 4
84 INCIDENT_CREATED_DATE_DAY INTEGER 4
85 INCIDENT_CREATED_DATE_DAY_TYPE_ID INTEGER 4
86 INCIDENT_CREATED_DATE_WEEK_TYPE_ID INTEGER 4
87 INCIDENT_CREATED_DATE_MONTH_TYPE_ID INTEGER 4
88 INCIDENT_CREATED_DATE_QUARTER_TYPE_ID INTEGER 4
89 INCIDENT_CREATED_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
90 INCIDENT_CREATED_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
91 INCIDENT_CREATED_DATE_R12_MONTH_TYPE_ID INTEGER 4
92 INCIDENT_CREATED_DATE_R13_MONTH_TYPE_ID INTEGER 4
93 INCIDENT_CREATED_DATE_HALF_TYPE_ID INTEGER 4
94 INCIDENT_CREATE_USER_ID BIGINT 8
95 INCIDENT_CREATE_USER_NAME CHARACTER VARYING(181) 181
96 INCIDENT_DESCRIPTION CHARACTER VARYING(2000) 2000
97 INCIDENT_ESTIMATED_REPAIR_COST_AMT NUMERIC(18,2) 19
98 INCIDENT_ESTIMATED_REPAIR_TIME CHARACTER VARYING(60) 60
99 INCIDENT_LOSS_CAUSE_ID BIGINT 8
100 INCIDENT_LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
101 CLAIM_LOSS_DATE TIMESTAMP 8
102 CLAIM_LOSS_DATE_ID INTEGER 4
103 CLAIM_LOSS_DATE_CAL_YEAR INTEGER 4
104 CLAIM_LOSS_DATE_CAL_QUARTER INTEGER 4
105 CLAIM_LOSS_DATE_CAL_MONTH INTEGER 4
106 CLAIM_LOSS_DATE_CAL_DAY INTEGER 4
107 CLAIM_LOSS_DATE_DAY_TYPE_ID INTEGER 4
108 CLAIM_LOSS_DATE_WEEK_TYPE_ID INTEGER 4
109 CLAIM_LOSS_DATE_MONTH_TYPE_ID INTEGER 4
110 CLAIM_LOSS_DATE_QUARTER_TYPE_ID INTEGER 4
111 CLAIM_LOSS_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
112 CLAIM_LOSS_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
113 CLAIM_LOSS_DATE_R12_MONTH_TYPE_ID INTEGER 4
114 CLAIM_LOSS_DATE_R13_MONTH_TYPE_ID INTEGER 4
115 CLAIM_LOSS_DATE_HALF_TYPE_ID INTEGER 4
116 CLAIM_EVENT_ID BIGINT 8
117 CLAIM_EVENT_CODE CHARACTER VARYING(60) 60
118 CLAIM_EVENT_NAME CHARACTER VARYING(60) 60
119 POLICY_INTERMEDIARY_TYPE_ID BIGINT 8
120 POLICY_INTERMEDIARY_TYPE_NAME CHARACTER VARYING(256) 256
121 POLICY_INTERMEDIARY_ID BIGINT 8
122 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(181) 181
123 INCIDENT_INSPECTION_PLAN_DATE TIMESTAMP 8
124 INCIDENT_INSPECTION_PLAN_DATE_ID INTEGER 4
125 INCIDENT_INSPECTION_PLAN_DATE_YEAR INTEGER 4
126 INCIDENT_INSPECTION_PLAN_DATE_QUARTER INTEGER 4
127 INCIDENT_INSPECTION_PLAN_DATE_MONTH INTEGER 4
128 INCIDENT_INSPECTION_PLAN_DATE_DAY INTEGER 4
129 INCIDENT_INSPECTION_PLAN_DATE_DAY_TYPE_ID INTEGER 4
130 INCIDENT_INSPECTION_PLAN_DATE_WEEK_TYPE_ID INTEGER 4
131 INCIDENT_INSPECTION_PLAN_DATE_MONTH_TYPE_ID INTEGER 4
132 INCIDENT_INSPECTION_PLAN_DATE_QUARTER_TYPE_ID INTEGER 4
133 INCIDENT_INSPECTION_PLAN_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
134 INCIDENT_INSPECTION_PLAN_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
135 INCIDENT_INSPECTION_PLAN_DATE_R12_MONTH_TYPE_ID INTEGER 4
136 INCIDENT_INSPECTION_PLAN_DATE_R13_MONTH_TYPE_ID INTEGER 4
137 INCIDENT_INSPECTION_PLAN_DATE_HALF_TYPE_ID INTEGER 4
138 INCIDENT_DAMAGE_DESCRIPTION CHARACTER VARYING(289) 289
139 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS BIGINT 8
140 INCIDENT_REPAIR_ESTIMATE_RECEIVED_STATUS_NAME CHARACTER VARYING(256) 256
141 INCIDENT_REPAIR_DONE_FLAG CHARACTER VARYING(1) 1
142 INCIDENT_ASSESSMENT_DESCRIPTION CHARACTER VARYING(128) 128
143 INCIDENT_ASSESSMENT_STATUS_ID BIGINT 8
144 INCIDENT_ASSESSMENT_STATUS_NAME CHARACTER VARYING(256) 256
145 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE TIMESTAMP 8
146 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_ID INTEGER 4
147 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_YEAR INTEGER 4
148 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER INTEGER 4
149 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH INTEGER 4
150 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY INTEGER 4
151 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
152 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
153 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
154 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
155 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
156 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
157 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
158 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
159 INCIDENT_ASSESSMENT_TARGET_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
160 INCIDENT_ASSESSMENT_CLOSE_DATE TIMESTAMP 8
161 INCIDENT_ASSESSMENT_CLOSE_DATE_ID INTEGER 4
162 INCIDENT_ASSESSMENT_CLOSE_DATE_YEAR INTEGER 4
163 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER INTEGER 4
164 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH INTEGER 4
165 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY INTEGER 4
166 INCIDENT_ASSESSMENT_CLOSE_DATE_DAY_TYPE_ID INTEGER 4
167 INCIDENT_ASSESSMENT_CLOSE_DATE_WEEK_TYPE_ID INTEGER 4
168 INCIDENT_ASSESSMENT_CLOSE_DATE_MONTH_TYPE_ID INTEGER 4
169 INCIDENT_ASSESSMENT_CLOSE_DATE_QUARTER_TYPE_ID INTEGER 4
170 INCIDENT_ASSESSMENT_CLOSE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
171 INCIDENT_ASSESSMENT_CLOSE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
172 INCIDENT_ASSESSMENT_CLOSE_DATE_R12_MONTH_TYPE_ID INTEGER 4
173 INCIDENT_ASSESSMENT_CLOSE_DATE_R13_MONTH_TYPE_ID INTEGER 4
174 INCIDENT_ASSESSMENT_CLOSE_DATE_HALF_TYPE_ID INTEGER 4
175 INCIDENT_ASSESSMENT_COMMENT CHARACTER VARYING(255) 255
176 INCIDENT_ASSESSMENT_INTERNAL_USER_ID BIGINT 8
177 INCIDENT_ASSESSMENT_INTERNAL_USER_NAME CHARACTER VARYING(181) 181
178 INCIDENT_ASSESSMENT_CLAIMED_ITEM_CONTENT_FLAG INTEGER 4
179 ASSESSMENT_SOURCE_NAME CHARACTER VARYING(255) 255
180 ASSESSMENT_SOURCE_SERVICE_PROVIDER_ID BIGINT 8
181 ASSESSMENT_SOURCE_SERVICE_PROVIDER_NAME CHARACTER VARYING(181) 181
182 ASSESSMENT_SOURCE_SERVICE_PROVIDER_TYPE_ID BIGINT 8
183 ASSESSMENT_SOURCE_SERVICE_PROVIDER_TYPE_NAME CHARACTER VARYING(256) 256
184 ASSESSMENT_SOURCE_DESCRIPTION CHARACTER VARYING(255) 255
185 ASSESSMENT_SOURCE_UPDATE_DATE TIMESTAMP 8
186 ASSESSMENT_SOURCE_UPDATE_DATE_ID INTEGER 4
187 ASSESSMENT_SOURCE_UPDATE_DATE_YEAR INTEGER 4
188 ASSESSMENT_SOURCE_UPDATE_DATE_QUARTER INTEGER 4
189 ASSESSMENT_SOURCE_UPDATE_DATE_MONTH INTEGER 4
190 ASSESSMENT_SOURCE_UPDATE_DATE_DAY INTEGER 4
191 ASSESSMENT_SOURCE_UPDATE_DATE_DAY_TYPE_ID INTEGER 4
192 ASSESSMENT_SOURCE_UPDATE_DATE_WEEK_TYPE_ID INTEGER 4
193 ASSESSMENT_SOURCE_UPDATE_DATE_MONTH_TYPE_ID INTEGER 4
194 ASSESSMENT_SOURCE_UPDATE_DATE_QUARTER_TYPE_ID INTEGER 4
195 ASSESSMENT_SOURCE_UPDATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
196 ASSESSMENT_SOURCE_UPDATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
197 ASSESSMENT_SOURCE_UPDATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
198 ASSESSMENT_SOURCE_UPDATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
199 ASSESSMENT_SOURCE_UPDATE_DATE_HALF_TYPE_ID INTEGER 4
200 ASSESSMENT_SOURCE_CREATE_DATE TIMESTAMP 8
201 ASSESSMENT_SOURCE_CREATE_DATE_ID INTEGER 4
202 ASSESSMENT_SOURCE_CREATE_DATE_YEAR INTEGER 4
203 ASSESSMENT_SOURCE_CREATE_DATE_QUARTER INTEGER 4
204 ASSESSMENT_SOURCE_CREATE_DATE_MONTH INTEGER 4
205 ASSESSMENT_SOURCE_CREATE_DATE_DAY INTEGER 4
206 ASSESSMENT_SOURCE_CREATE_DATE_DAY_TYPE_ID INTEGER 4
207 ASSESSMENT_SOURCE_CREATE_DATE_WEEK_TYPE_ID INTEGER 4
208 ASSESSMENT_SOURCE_CREATE_DATE_MONTH_TYPE_ID INTEGER 4
209 ASSESSMENT_SOURCE_CREATE_DATE_QUARTER_TYPE_ID INTEGER 4
210 ASSESSMENT_SOURCE_CREATE_DATE_CALENDAR_YEAR_TYPE_ID INTEGER 4
211 ASSESSMENT_SOURCE_CREATE_DATE_FINANCIAL_YEAR_TYPE_ID INTEGER 4
212 ASSESSMENT_SOURCE_CREATE_DATE_R12_MONTH_TYPE_ID INTEGER 4
213 ASSESSMENT_SOURCE_CREATE_DATE_R13_MONTH_TYPE_ID INTEGER 4
214 ASSESSMENT_SOURCE_CREATE_DATE_HALF_TYPE_ID INTEGER 4
215 ASSESSMENT_SOURCE_CREATE_USER_ID BIGINT 8
216 ASSESSMENT_SOURCE_CREATE_USER_NAME CHARACTER VARYING(181) 181
217 ASSESSMENT_SOURCE_COUNT BIGINT 8
218 ASSESSMENT_SOURCE_INCIDENT_ID BIGINT 8