FCT_FLEET_REPORT_RECOVERIES

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CLAIM_ID BIGINT 8
2 CLAIMNUMBER CHARACTER VARYING(40) 40
3 DATE_KEY INTEGER 4
4 MONTH_LABEL CHARACTER VARYING(13) 13
5 CALENDAR_DATE DATE 4
6 FLAG INTEGER 4
7 CLIENT_NAME CHARACTER VARYING(180) 180
8 FLEET_DIVISION CHARACTER VARYING(60) 60
9 LOSS_CAUSE_ID BIGINT 8
10 LOSS_CAUSE CHARACTER VARYING(256) 256
11 BLAME_CODES_ID BIGINT 8
12 BLAME_CODES CHARACTER VARYING(256) 256
13 STATUS_ID INTEGER 4
14 NEW_COUNT INTEGER 4
15 ACTIVE_COUNT INTEGER 4
16 REOPEN_COUNT_TM INTEGER 4
17 REOPEN_COUNT_EVER INTEGER 4
18 FINALISED_COUNT INTEGER 4
19 NEW_RECOVERY_COUNT INTEGER 4
20 ACTIVE_RECOVERY_COUNT INTEGER 4
21 FINALISED_RECOVERY_COUNT INTEGER 4
22 LOSS_DATE DATE 4
23 REPORTED_DATE DATE 4
24 CLOSED_DATE DATE 4
25 BRAND_ID BIGINT 8
26 BRAND CHARACTER VARYING(256) 256
27 BROKER_NAME CHARACTER VARYING(120) 120
28 ASSIGNED_TEAM_NAME CHARACTER VARYING(100) 100
29 CLOSED_BY_USERID CHARACTER VARYING(255) 255
30 CLOSED_BY_USERNAME CHARACTER VARYING(181) 181
31 CREATED_BY_USERID CHARACTER VARYING(255) 255
32 CREATED_BY_USERNAME CHARACTER VARYING(181) 181
33 POLICY_NUMBER CHARACTER VARYING(40) 40
34 AGEING_DAYS INTEGER 4
35 RECOVERY_STATUS CHARACTER VARYING(256) 256
36 RECOVERYOWNER_FIRSTNAME CHARACTER VARYING(90) 90
37 RECOVERYOWNER_LASTNAME CHARACTER VARYING(90) 90
38 RECOVERY_START TIMESTAMP 8
39 RECOVERY_COMPLETE TIMESTAMP 8
40 TOTAL_RECOVERED NUMERIC(38,2) 19
41 TOTAL_RECOVERY_RESERVE_OS NUMERIC(38,2) 19
42 TOTAL_SETTLED NUMERIC(38,2) 19
43 CLAIM_COST NUMERIC(38,2) 19
44 UNDER_DEDUCTIBLE_FLAG CHARACTER VARYING(7) 7