FCT_MOTOR_CLAIMS_REVIEW_PERFORMANCE_INSIGHT_BACKUP_20210417

Database

INSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 ENTRY_DATE DATE 4
3 CCR_CC_USER_ID BIGINT 8
4 CCR_CC_CONTACT_ID BIGINT 8
5 CCR_CC_CONTACT_CONTACT CHARACTER VARYING(181) 181
6 CCR_CC_GROUP_ID BIGINT 8
7 CCR_CC_GROUP_NAME CHARACTER VARYING(100) 100
8 CCR_CC_CLAIM_ID BIGINT 8
9 CCR_CC_CLAIM_CLAIMNUMBER CHARACTER VARYING(40) 40
10 CCR_CC_CLAIM_STATE BIGINT 8
11 VOLUME_OF_CLAIMS_TOUCHED INTEGER 4
12 ACTIVITIES_CREATED CHARACTER VARYING(25) 25
13 VOLUME_OF_ACTIVITIES_CREATED BIGINT 8
14 CCR_CC_ACTIVITY_ID BIGINT 8
15 CCR_CC_ACTIVITY_PATTERN_ID BIGINT 8
16 CCR_CC_ACTIVITY_SUBJECT CHARACTER VARYING(255) 255
17 CCR_CC_ACTIVITY_STATUS BIGINT 8
18 ACTIVITY_STATUS_TYPECODE CHARACTER VARYING(50) 50
19 ACTIVITY_STATUS_NAME CHARACTER VARYING(256) 256
20 CCR_CC_ACTIVITY_ASSIGNEDUSERID BIGINT 8
21 CCR_CC_ACTIVITY_ASSIGNEDGROUPID BIGINT 8
22 CCR_CC_ACTIVITY_CREATEDATE DATE 4
23 CCR_CC_ACTIVITY_CLOSEDATE DATE 4
24 CCR_CC_ACTIVITY_TARGETDATE DATE 4
25 CCR_CC_ACTIVITY_PRIORITY BIGINT 8
26 OVERDUE_FLAG CHARACTER VARYING(3) 3
27 ACTIVITY_AGE INTEGER 4
28 DAYS_OVERDUE INTEGER 4
29 CCR_CC_ACTIVITY_INCIDENT_ID BIGINT 8
30 ACTIVITY_IN_SCOPE INTEGER 4
31 ACTIVITY_TARGET_DAYS BIGINT 8
32 ACTIVITY_TARGET_HOURS BIGINT 8
33 ACTIVITY_COMPLETED_WITH_SYSTEM_TARGET_INDICATOR INTEGER 4
34 ACTIVITY_TARGET_TYPE CHARACTER VARYING(24) 24
35 ACTIVITY_WORKING_HOURS_ELAPSED NUMERIC(32,10) 19
36 ACTIVITY_WORKING_DAYS_ELAPSED NUMERIC(38,1) 19
37 ACTIVITY_CALENDAR_HOURS_ELAPSED NUMERIC(31,10) 19
38 ACTIVITY_CALENDAR_DAYS_ELAPSED INTEGER 4
39 VOLUME_OF_RESERVE BIGINT 8
40 NET_RESERVE_MOVEMENT NUMERIC(38,2) 19
41 CLAIM_CLOSED INTEGER 4
42 ENTRY_DATE_YEAR INTEGER 4
43 ENTRY_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
44 ENTRY_DATE_QUARTER INTEGER 4
45 ENTRY_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
46 ENTRY_DATE_MONTH INTEGER 4
47 ENTRY_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
48 ENTRY_DATE_DAY INTEGER 4
49 ENTRY_DATE_DAY_LABEL CHARACTER VARYING(13) 13
50 ENTRY_DATE_FIN_YEAR INTEGER 4
51 ENTRY_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
52 ENTRY_DATE_FIN_QUARTER INTEGER 4
53 ENTRY_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
54 ENTRY_DATE_FIN_MONTH INTEGER 4
55 ENTRY_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
56 ENTRY_DATE_FIN_DAY INTEGER 4
57 ENTRY_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
58 ENTRY_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
59 ENTRY_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
60 ENTRY_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
61 ENTRY_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18
62 ENTRY_DATE_DAY_OF_WEEK BIGINT 8
63 ENTRY_DATE_DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
64 ENTRY_DATE_HOLIDAY_FLAG CHARACTER VARYING(13) 13
65 ENTRY_DATE_WORKING_DAY_FLAG INTEGER 4
66 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
67 LEGACYCLAIM_FLAG CHARACTER VARYING(3) 3
68 LEGACYCLAIM_CATEGORY CHARACTER VARYING(256) 256