FCT_MOTOR_RECOVERY_INSIGHT

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CCR_CC_CLAIM_ID BIGINT 8
3 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
4 CCR_CC_CLAIM_LOSSTYPE BIGINT 8
5 LOSS_TYPE_CODE CHARACTER VARYING(50) 50
6 LOSS_TYPE_NAME CHARACTER VARYING(256) 256
7 CCR_CC_CLAIM_LOSSCAUSE BIGINT 8
8 LOSSCAUSESUBTYPE_ID BIGINT 8
9 CCR_CC_CLAIM_STATE BIGINT 8
10 CCR_CC_POLICY_SC_LINEOFBUSINESS BIGINT 8
11 CCR_CC_POLICY_SC_BRAND BIGINT 8
12 LODGEMENT_DATE DATE 4
13 FINALISED_DATE DATE 4
14 AGE_OF_CLAIM INTEGER 4
15 AGE_OF_CLAIM_TEXT CHARACTER VARYING(10) 10
16 AGE_OF_CLAIM_BAND_ID INTEGER 4
17 XREF_TYPE_ID INTEGER 4
18 CCR_CC_CLAIM_ASSIGNEDUSERID BIGINT 8
19 CCR_CC_CLAIM_ASSIGNEDGROUPID BIGINT 8
20 LOSS_CCR_CC_ADDRESS_STATE BIGINT 8
21 CCR_CC_CLAIM_SC_INCIDENTREPORT BIGINT 8
22 LEGAL_COSTS NUMERIC(38,2) 19
23 MERC_COMMISSION NUMERIC(38,2) 19
24 CLAIM_COUNT INTEGER 4
25 CLAIM_DEMAND_SENT_TPI_STATUS BIGINT 8
26 CLAIM_DEMAND_RECEIVED_TPI_STATUS CHARACTER VARYING(1) 1
27 EXPECTED_RECOVERY_AMOUNT NUMERIC(18,2) 19
28 UNDEMANDED_AMOUNT NUMERIC(38,2) 19
29 DEMAND_SENT_COUNT BIGINT 8
30 DEMAND_SENT_AMOUNT NUMERIC(18,2) 19
31 RECOVERY_COUNT NUMERIC(38,1) 19
32 RECOVERY_AMOUNT NUMERIC(38,2) 19
33 DEMAND_RECEIVED_COUNT BIGINT 8
34 DEMAND_RECEIVED_AMOUNT NUMERIC(38,2) 19
35 SETTLEMENT_COUNT BIGINT 8
36 SETTLEMENT_AMOUNT NUMERIC(38,2) 19
37 CCR_CC_MATTER_ID BIGINT 8
38 CCR_CC_MATTER_MATTERTYPE BIGINT 8
39 CCR_CC_MATTER_PRIMARYCAUSE BIGINT 8
40 CCR_CC_MATTER_LEGALSPECIALITY BIGINT 8
41 CCR_CC_MATTER_COURTTYPE BIGINT 8
42 CCR_CC_MATTER_RESOLUTION BIGINT 8
43 MATTER_COUNT BIGINT 8
44 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
45 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
46 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
47 CLAIM_PROCESS_TYPE_ID BIGINT 8
48 FLEET_MANAGER_IND CHARACTER VARYING(22) 22
49 POLICY_TYPE_ID BIGINT 8
50 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
51 OWNING_AGENCY_IND CHARACTER VARYING(16) 16
52 OWNING_AGENCY_NAME CHARACTER VARYING(120) 120
53 FLEET_IND CHARACTER VARYING(9) 9
54 CAS_IND CHARACTER VARYING(9) 9
55 INSURED_CCR_CC_VEHICLE_STYLE BIGINT 8
56 CCR_CC_NEGOTIATIONLINE_ID BIGINT 8
57 DEMAND_SENT_SOURCE_GROUP_1 CHARACTER VARYING(20) 20
58 DEMAND_SENT_SOURCE_GROUP_1_SORT_ORDER INTEGER 4
59 DEMAND_SENT_SOURCE_GROUP_2 CHARACTER VARYING(302) 302
60 DEMAND_SENT_SOURCE_NAME CHARACTER VARYING(302) 302
61 DEMAND_SENT_TPI_STATUS BIGINT 8
62 SUBROSTRATEGY_ID BIGINT 8
63 DEMAND_SENT_DATE TIMESTAMP 8
64 CCR_CC_TRANSACTION_SC_GLSERVICEACKTIME TIMESTAMP 8
65 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE DATE 4
66 UNRECOVERED_AMOUNT NUMERIC(38,2) 19
67 CC_SUBROADVERSEPARTY_SC_RECOVERYSTATUS BIGINT 8
68 CCR_CCX_SC_RECOVERIESCALDATA_SD_ADJUSTMENTREASON BIGINT 8
69 CCR_CCX_SC_RECOVERIESCALDATA_SN_ADJUSTMENTREASON BIGINT 8
70 CCR_CC_SUBROADVERSEPARTY_ADVERSEPARTYID BIGINT 8
71 AGE_OF_DEMAND BIGINT 8
72 AGE_OF_DEMAND_TEXT CHARACTER VARYING(10) 10
73 AGE_OF_DEMAND_BAND_ID INTEGER 4
74 CURRENT_RECOVERY_AGENT CHARACTER VARYING(120) 120
75 TIER CHARACTER VARYING(256) 256
76 FINAL_RECALLED_AGENT CHARACTER VARYING(120) 120
77 DATE_OUTSOURCED TIMESTAMP 8
78 DATE_RETURNED TIMESTAMP 8
79 DAYS_OUTSOURCED INTEGER 4
80 RECALL_OUTSOURCED_DAYS INTEGER 4
81 DEMAND_RECEIVED_SOURCE_GROUP_1 CHARACTER VARYING(20) 20
82 DEMAND_RECEIVED_SOURCE_GROUP_1_SORT_ORDER INTEGER 4
83 DEMAND_RECEIVED_SOURCE_GROUP_2 CHARACTER VARYING(302) 302
84 DEMAND_RECEIVED_SOURCE_NAME CHARACTER VARYING(302) 302
85 DEMAND_RECEIVED_TPI_STATUS BIGINT 8
86 DEMAND_RECEIVED_DATE TIMESTAMP 8
87 SETTLEMENT_DATE TIMESTAMP 8
88 CCR_CCX_SC_EVALUATIONCALDATA_RN_ADJUSTMENTREASON BIGINT 8
89 AGE_OF_SETTLEMENT BIGINT 8
90 AGE_OF_SETTLEMENT_TEXT CHARACTER VARYING(10) 10
91 AGE_OF_SETTLEMENT_BAND_ID INTEGER 4
92 CCR_CC_CLAIM_FAULTRATING BIGINT 8
93 CCR_CCX_SC_CLAIMAUTO_SC_RESPONSIBLEPARTYIDENTIFIED INTEGER 4
94 CCR_CC_CLAIM_SC_CLOSEDOUTCOME BIGINT 8
95 POLICYNUMBER CHARACTER VARYING(40) 40
96 RECOVERY_OWNER_ID BIGINT 8
97 SETTLEMENTASSIGNEDUSERID BIGINT 8
98 SOURCE_VIEW CHARACTER VARYING(25) 25
99 CCR_CC_POLICY_SC_LINEOFBUSINESS_NAME CHARACTER VARYING(256) 256
100 CCR_CC_POLICY_SC_BRAND_NAME CHARACTER VARYING(256) 256
101 LOSS_CCR_CC_ADDRESS_REGION_NAME CHARACTER VARYING(15) 15
102 LOSS_CCR_CC_ADDRESS_STATE_NAME CHARACTER VARYING(256) 256
103 CCR_CC_CLAIM_LOSSCAUSE_NAME CHARACTER VARYING(256) 256
104 LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
105 INSURED_CCR_CC_VEHICLE_STYLE_NAME CHARACTER VARYING(256) 256
106 CCR_CC_CLAIM_STATE_NAME CHARACTER VARYING(256) 256
107 CCR_CC_CLAIM_SC_INCIDENTREPORT_REPORT_ONLY_FLAG_NAME CHARACTER VARYING(256) 256
108 AGE_OF_CLAIM_BAND_NAME CHARACTER VARYING(14) 14
109 CCR_CC_CLAIM_ASSIGNEDGROUP_TEAM_NAME CHARACTER VARYING(100) 100
110 CCR_CC_CLAIM_ASSIGNEDGROUP_SUBRO_GROUP_NAME CHARACTER VARYING(256) 256
111 CCR_CC_CLAIM_ASSIGNEDGROUP_TEAM_TYPE CHARACTER VARYING(256) 256
112 CCR_CC_CLAIM_ASSIGNEDUSER_ADJUSTER_NAME CHARACTER VARYING(181) 181
113 CCR_CC_CLAIM_ASSIGNEDUSER_ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
114 CCR_CC_CLAIM_ASSIGNEDUSER_ADJUSTER_TEAM_TYPE_NAME CHARACTER VARYING(256) 256
115 CCR_CC_CLAIM_ASSIGNEDUSER_ADJUSTER_TEAM_SUBRO_GROUPING CHARACTER VARYING(256) 256
116 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS_NAME CHARACTER VARYING(256) 256
117 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(512) 512
118 POLICY_TYPE_NAME CHARACTER VARYING(256) 256
119 CC_SUBROADVERSEPARTY_SC_RECOVERYSTATUS_NAME CHARACTER VARYING(256) 256
120 SUBROSTRATEGY_NAME CHARACTER VARYING(256) 256
121 XREF_TYPE_DESCRIPTION CHARACTER VARYING(9) 9
122 AGE_OF_DEMAND_BAND_NAME CHARACTER VARYING(14) 14
123 CCR_CCX_SC_RECOVERIESCALDATA_SD_ADJUSTMENTREASON_NAME CHARACTER VARYING(256) 256
124 CCR_CCX_SC_RECOVERIESCALDATA_SN_ADJUSTMENTREASON_NAME CHARACTER VARYING(256) 256
125 DEMAND_SENT_TPI_STATUS_NAME CHARACTER VARYING(256) 256
126 AGE_OF_SETTLEMENT_BAND_NAME CHARACTER VARYING(14) 14
127 CCR_CCX_SC_EVALUATIONCALDATA_RN_ADJUSTMENTREASON_SAVEDREASONNAME CHARACTER VARYING(256) 256
128 DEMAND_RECEIVED_TPI_STATUS_NAME CHARACTER VARYING(9) 9
129 CCR_CC_MATTER_MATTERTYPE_NAME CHARACTER VARYING(256) 256
130 CCR_CC_MATTER_PRIMARYCAUSE_NAME CHARACTER VARYING(256) 256
131 CCR_CC_MATTER_LEGALSPECIALITY_NAME CHARACTER VARYING(256) 256
132 CCR_CC_MATTER_COURTTYPE_NAME CHARACTER VARYING(256) 256
133 CCR_CC_MATTER_RESOLUTION_NAME CHARACTER VARYING(256) 256
134 CCR_CC_SUBROADVERSEPARTY_ADVERSEPARTY_NAME CHARACTER VARYING(181) 181
135 RECOVERY_OWNER_NAME CHARACTER VARYING(181) 181
136 RECOVERY_TEAM_ID BIGINT 8
137 RECOVERY_TEAM_NAME CHARACTER VARYING(100) 100
138 RECOVERY_TEAM_TYPE_NAME CHARACTER VARYING(256) 256
139 RECOVERY_TEAM_SUBRO_GROUPING CHARACTER VARYING(256) 256
140 SETTLEMENT_ASSIGNED_USER_NAME CHARACTER VARYING(181) 181
141 SETTLEMENT_ASSIGNED_TEAM_ID BIGINT 8
142 SETTLEMENT_ASSIGNED_TEAM_NAME CHARACTER VARYING(100) 100
143 RECOVERY_CLOSED_DATE TIMESTAMP 8
144 FINALISED_DATE_YEAR INTEGER 4
145 FINALISED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
146 FINALISED_DATE_QUARTER INTEGER 4
147 FINALISED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
148 FINALISED_DATE_MONTH INTEGER 4
149 FINALISED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
150 FINALISED_DATE_DAY INTEGER 4
151 FINALISED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
152 FINALISED_DATE_FIN_YEAR INTEGER 4
153 FINALISED_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
154 FINALISED_DATE_FIN_QUARTER INTEGER 4
155 FINALISED_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
156 FINALISED_DATE_FIN_MONTH INTEGER 4
157 FINALISED_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
158 FINALISED_DATE_FIN_DAY INTEGER 4
159 FINALISED_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
160 FINALISED_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
161 FINALISED_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
162 FINALISED_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
163 FINALISED_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
164 LODGEMENT_DATE_YEAR INTEGER 4
165 LODGEMENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
166 LODGEMENT_DATE_QUARTER INTEGER 4
167 LODGEMENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
168 LODGEMENT_DATE_MONTH INTEGER 4
169 LODGEMENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
170 LODGEMENT_DATE_DAY INTEGER 4
171 LODGEMENT_DATE_DAY_LABEL CHARACTER VARYING(13) 13
172 LODGEMENT_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
173 LODGEMENT_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
174 LODGEMENT_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
175 LODGEMENT_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
176 CCR_CC_CLAIM_LOSSDATE_YEAR INTEGER 4
177 CCR_CC_CLAIM_LOSSDATE_YEAR_LABEL CHARACTER VARYING(13) 13
178 CCR_CC_CLAIM_LOSSDATE_QUARTER INTEGER 4
179 CCR_CC_CLAIM_LOSSDATE_QUARTER_LABEL CHARACTER VARYING(13) 13
180 CCR_CC_CLAIM_LOSSDATE_MONTH INTEGER 4
181 CCR_CC_CLAIM_LOSSDATE_MONTH_LABEL CHARACTER VARYING(13) 13
182 CCR_CC_CLAIM_LOSSDATE_DAY INTEGER 4
183 CCR_CC_CLAIM_LOSSDATE_DAY_LABEL CHARACTER VARYING(13) 13
184 CCR_CC_CLAIM_LOSSDATE_CURRENT_MONTH CHARACTER VARYING(8) 8
185 CCR_CC_CLAIM_LOSSDATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
186 CCR_CC_CLAIM_LOSSDATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
187 CCR_CC_CLAIM_LOSSDATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
188 DEMAND_SENT_DATE_YEAR INTEGER 4
189 DEMAND_SENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
190 DEMAND_SENT_DATE_QUARTER INTEGER 4
191 DEMAND_SENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
192 DEMAND_SENT_DATE_MONTH INTEGER 4
193 DEMAND_SENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
194 DEMAND_SENT_DATE_DAY INTEGER 4
195 DEMAND_SENT_DATE_DAY_LABEL CHARACTER VARYING(13) 13
196 DEMAND_SENT_DATE_FIN_YEAR INTEGER 4
197 DEMAND_SENT_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
198 DEMAND_SENT_DATE_FIN_QUARTER INTEGER 4
199 DEMAND_SENT_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
200 DEMAND_SENT_DATE_FIN_MONTH INTEGER 4
201 DEMAND_SENT_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
202 DEMAND_SENT_DATE_FIN_DAY INTEGER 4
203 DEMAND_SENT_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
204 DEMAND_SENT_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
205 DEMAND_SENT_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
206 DEMAND_SENT_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
207 DEMAND_SENT_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
208 DEMAND_RECEIVED_DATE_YEAR INTEGER 4
209 DEMAND_RECEIVED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
210 DEMAND_RECEIVED_DATE_QUARTER INTEGER 4
211 DEMAND_RECEIVED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
212 DEMAND_RECEIVED_DATE_MONTH INTEGER 4
213 DEMAND_RECEIVED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
214 DEMAND_RECEIVED_DATE_DAY INTEGER 4
215 DEMAND_RECEIVED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
216 DEMAND_RECEIVED_DATE_FIN_YEAR INTEGER 4
217 DEMAND_RECEIVED_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
218 DEMAND_RECEIVED_DATE_FIN_QUARTER INTEGER 4
219 DEMAND_RECEIVED_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
220 DEMAND_RECEIVED_DATE_FIN_MONTH INTEGER 4
221 DEMAND_RECEIVED_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
222 DEMAND_RECEIVED_DATE_FIN_DAY INTEGER 4
223 DEMAND_RECEIVED_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
224 DEMAND_RECEIVED_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
225 DEMAND_RECEIVED_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
226 DEMAND_RECEIVED_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
227 DEMAND_RECEIVED_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
228 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_YEAR INTEGER 4
229 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_YEAR_LABEL CHARACTER VARYING(13) 13
230 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_QUARTER INTEGER 4
231 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_QUARTER_LABEL CHARACTER VARYING(13) 13
232 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_MONTH INTEGER 4
233 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_MONTH_LABEL CHARACTER VARYING(13) 13
234 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_DAY INTEGER 4
235 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_DAY_LABEL CHARACTER VARYING(13) 13
236 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_CURRENT_MONTH CHARACTER VARYING(8) 8
237 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
238 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
239 CCR_CC_TRANSACTION_SC_GLSERVICEACKDATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
240 DATE_OUTSOURCED_YEAR INTEGER 4
241 DATE_OUTSOURCED_YEAR_LABEL CHARACTER VARYING(13) 13
242 DATE_OUTSOURCED_QUARTER INTEGER 4
243 DATE_OUTSOURCED_QUARTER_LABEL CHARACTER VARYING(13) 13
244 DATE_OUTSOURCED_MONTH INTEGER 4
245 DATE_OUTSOURCED_MONTH_LABEL CHARACTER VARYING(13) 13
246 DATE_OUTSOURCED_DAY INTEGER 4
247 DATE_OUTSOURCED_DAY_LABEL CHARACTER VARYING(13) 13
248 DATE_OUTSOURCED_CURRENT_MONTH CHARACTER VARYING(8) 8
249 DATE_OUTSOURCED_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
250 DATE_OUTSOURCED_PREVIOUS_MONTH CHARACTER VARYING(8) 8
251 DATE_OUTSOURCED_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
252 SETTLEMENT_DATE_YEAR INTEGER 4
253 SETTLEMENT_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
254 SETTLEMENT_DATE_QUARTER INTEGER 4
255 SETTLEMENT_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
256 SETTLEMENT_DATE_MONTH INTEGER 4
257 SETTLEMENT_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
258 SETTLEMENT_DATE_DAY INTEGER 4
259 SETTLEMENT_DATE_LABEL CHARACTER VARYING(13) 13
260 SETTLEMENT_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
261 SETTLEMENT_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
262 SETTLEMENT_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
263 SETTLEMENT_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
264 RECOVERY_CLOSED_DATE_YEAR INTEGER 4
265 RECOVERY_CLOSED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
266 RECOVERY_CLOSED_DATE_QUARTER INTEGER 4
267 RECOVERY_CLOSED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
268 RECOVERY_CLOSED_DATE_MONTH INTEGER 4
269 RECOVERY_CLOSED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
270 RECOVERY_CLOSED_DATE_DAY INTEGER 4
271 RECOVERY_CLOSED_DATE_LABEL CHARACTER VARYING(13) 13
272 RECOVERY_CLOSED_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
273 RECOVERY_CLOSED_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
274 RECOVERY_CLOSED_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
275 RECOVERY_CLOSED_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
276 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
277 LEGACY_CLAIM CHARACTER VARYING(3) 3
278 LEGACY_TYPE CHARACTER VARYING(256) 256