FCT_MOTOR_HOME_ACTIVITY_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_ASSIGNEDUSERID BIGINT 8
5 CCR_CC_CLAIM_ASSIGNEDGROUPID BIGINT 8
6 LODGEMENT_DATE INTEGER 4
7 FINALISED_DATE INTEGER 4
8 LOSS_CCR_CC_ADDRESS_STATE BIGINT 8
9 XREF_TYPE_ID INTEGER 4
10 CCR_CC_CLAIM_SC_INCIDENTREPORT BIGINT 8
11 CCR_CC_CLAIM_STATE BIGINT 8
12 CCR_CC_CLAIM_LOSSCAUSE BIGINT 8
13 DIM_LOSSCAUSE_NAME CHARACTER VARYING(256) 256
14 LOSSCAUSESUBTYPE_ID BIGINT 8
15 DIM_LOSSCAUSESUBTYPE_NAME CHARACTER VARYING(256) 256
16 RISK_CCR_CC_ADDRESS_STATE BIGINT 8
17 CCR_CC_POLICY_SC_LINEOFBUSINESS BIGINT 8
18 CCR_CC_POLICY_SC_BRAND BIGINT 8
19 CCR_CC_CLAIM_LOSSTYPE BIGINT 8
20 CCR_CC_ACTIVITYPATTERN_CLAIMLOSSTYPE_NAME CHARACTER VARYING(256) 256
21 CCR_CC_ACTIVITY_ID BIGINT 8
22 CCR_CC_ACTIVITY_CREATEDATE INTEGER 4
23 CCR_CC_ACTIVITY_STATUS BIGINT 8
24 CCR_CCTL_ACTIVITYCATEGORY_NAME CHARACTER VARYING(256) 256
25 CCR_CC_ACTIVITY_SUBJECT CHARACTER VARYING(255) 255
26 CCR_CC_ACTIVITYPATTERN_SUBJECT CHARACTER VARYING(255) 255
27 CCR_CC_ACTIVITY_ASSIGNEDUSERID BIGINT 8
28 CCR_CC_ACTIVITY_ASSIGNEDGROUPID BIGINT 8
29 CCR_CC_ACTIVITY_TARGETDATE INTEGER 4
30 CCR_CCTL_LOSSTYPE_NAME CHARACTER VARYING(256) 256
31 CCR_CC_ACTIVITY_CLOSEDDATE INTEGER 4
32 CCR_CC_ACTIVITY_PRIORITY BIGINT 8
33 CCR_CC_ACTIVITYPATTERN_AUTOMATEDONLY CHARACTER VARYING(9) 9
34 OVERDUE_FLAG CHARACTER VARYING(9) 9
35 ACTIVITY_AGE INTEGER 4
36 AGE_OF_ACTIVITY_BAND_ID INTEGER 4
37 CCR_CC_ACTIVITY_CREATEUSERID BIGINT 8
38 CCR_CC_ACTIVITY_CLOSEUSERID BIGINT 8
39 CCR_CCTL_COVERAGETYPE_NAME CHARACTER VARYING(256) 256
40 DAYS_OVERDUE_BAND_ID INTEGER 4
41 DAYS_OVERDUE INTEGER 4
42 ACTIVITY_COUNT INTEGER 4
43 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
44 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
45 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
46 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
47 CLAIM_PROCESS_TYPE_ID BIGINT 8
48 POLICY_TYPE_ID BIGINT 8
49 CCR_CC_CLAIM_LOSSDATE INTEGER 4
50 FLEET_IND CHARACTER VARYING(9) 9
51 CAS_IND CHARACTER VARYING(9) 9
52 POLICYNUMBER CHARACTER VARYING(40) 40
53 CCR_CC_COVERAGE_TYPE BIGINT 8
54 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
55 LEGACY_CLAIM CHARACTER VARYING(3) 3
56 LEGACY_TYPE CHARACTER VARYING(256) 256
57 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
58 BRAND_NAME CHARACTER VARYING(256) 256
59 DIM_DANGEROUSGOODS_IND_NAME CHARACTER VARYING(256) 256
60 CLAIM_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
61 CCR_CC_POLICY_POLICYTYPE_NAME CHARACTER VARYING(256) 256
62 XREF_DESCRIPTION CHARACTER VARYING(9) 9
63 RISK_STATE_NAME CHARACTER VARYING(256) 256
64 RISK_REGION CHARACTER VARYING(15) 15
65 LOSS_STATE_NAME CHARACTER VARYING(256) 256
66 LOSS_REGION CHARACTER VARYING(15) 15
67 REPORT_ONLY_FLAG_NAME CHARACTER VARYING(256) 256
68 PRIORITY_NAME CHARACTER VARYING(256) 256
69 OVERDUE_AGEING_BAND_NAME CHARACTER VARYING(14) 14
70 CLAIM_STATE_NAME CHARACTER VARYING(256) 256
71 ACTIVITY_ASSIGNED_USER_ID BIGINT 8
72 ACTIVITY_ASSIGNED_USER_NAME CHARACTER VARYING(181) 181
73 ACTIVITY_ASSIGNED_USER_TEAM_ID BIGINT 8
74 ACTIVITY_ASSIGNED_USER_TEAM_NAME CHARACTER VARYING(100) 100
75 ACTIVITY_ASSIGNED_USER_TEAM_TYPE CHARACTER VARYING(256) 256
76 ASSIGNED_TEAM_ID BIGINT 8
77 ASSIGNED_TEAM_NAME CHARACTER VARYING(100) 100
78 ASSIGNED_TEAM_TYPE CHARACTER VARYING(256) 256
79 ADJUSTER_ID BIGINT 8
80 ADJUSTER_NAME CHARACTER VARYING(181) 181
81 ADJUSTER_CURRENT_TEAM_NAME CHARACTER VARYING(100) 100
82 ADJUSTER_CURRENT_TEAM_TYPE CHARACTER VARYING(256) 256
83 ADJUSTER_TEAM_ID BIGINT 8
84 ADJUSTER_TEAM_NAME CHARACTER VARYING(100) 100
85 ADJUSTER_TEAM_TYPE CHARACTER VARYING(256) 256
86 ACTIVITY_STATUS_NAME CHARACTER VARYING(256) 256
87 ACTIVITY_CREATE_USER_ID BIGINT 8
88 ACTIVITY_CREATE_USER_NAME CHARACTER VARYING(181) 181
89 ACTIVITY_CREATE_TEAM_ID BIGINT 8
90 ACTIVITY_CREATE_TEAM_NAME CHARACTER VARYING(100) 100
91 ACTIVITY_CREATE_TEAM_TYPE CHARACTER VARYING(256) 256
92 ACTIVITY_CLOSE_USER_ID BIGINT 8
93 ACTIVITY_CLOSE_USER_NAME CHARACTER VARYING(181) 181
94 ACTIVITY_CLOSE_TEAM_ID BIGINT 8
95 ACTIVITY_CLOSE_TEAM_NAME CHARACTER VARYING(100) 100
96 ACTIVITY_CLOSE_TEAM_TYPE CHARACTER VARYING(256) 256
97 ACTIVITY_AGEING_BAND_ID INTEGER 4
98 ACTIVITY_AGEING_BAND_NAME CHARACTER VARYING(14) 14