INT_MOTOR_STOCK_CLAIM_ACTIVITY

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
2 CLAIM_ID BIGINT 8
3 CLAIM_NUMBER CHARACTER VARYING(40) 40
4 LODGEMENT_DATE TIMESTAMP 8
5 UPDATETIME TIMESTAMP 8
6 EXTRACT_TIMESTAMP TIMESTAMP 8
7 RISK_STATE_ID BIGINT 8
8 RISK_STATE_NAME CHARACTER VARYING(256) 256
9 RISK_REGION_NAME CHARACTER VARYING(15) 15
10 RISK_POSTCODE CHARACTER VARYING(60) 60
11 LOSS_STATE_ID BIGINT 8
12 LOSS_STATE_NAME CHARACTER VARYING(256) 256
13 LOSS_REGION_NAME CHARACTER VARYING(15) 15
14 LOSS_POSTCODE CHARACTER VARYING(60) 60
15 LINE_OF_BUSINESS_ID BIGINT 8
16 VEHICLE_STYLE_ID BIGINT 8
17 INCIDENT_ID BIGINT 8
18 BRAND_ID BIGINT 8
19 LOSS_TYPE_ID BIGINT 8
20 LOSS_TYPE_NAME CHARACTER VARYING(256) 256
21 CREATE_DATE TIMESTAMP 8
22 CREATE_DATE_TEXT CHARACTER VARYING(10) 10
23 REOPEN_DATE TIMESTAMP 8
24 FINALISED_DATE TIMESTAMP 8
25 REPORT_ONLY_FLAG CHARACTER VARYING(9) 9
26 CLAIM_STATE_ID INTEGER 4
27 REJECT_REASON_ID BIGINT 8
28 REOPEN_REASON_ID BIGINT 8
29 CLOSED_OUTCOME_ID BIGINT 8
30 LOSSCAUSE_ID BIGINT 8
31 LOSS_CAUSE_NAME CHARACTER VARYING(256) 256
32 LOSSCAUSESUBTYPE_ID BIGINT 8
33 LOSS_CAUSE_SUB_TYPE_NAME CHARACTER VARYING(256) 256
34 LOSSCAUSE_GROUP CHARACTER VARYING(14) 14
35 CATASTOPHE_ID BIGINT 8
36 PREMIUM_STATUS_ID BIGINT 8
37 POLICY_PAYMENT_MODE_ID BIGINT 8
38 POLICY_RENEWAL_MODE_ID BIGINT 8
39 POLICY_STATUS_ID BIGINT 8
40 POLICY_COVERAGE_TYPE_ID BIGINT 8
41 ADJUSTER_USER_ID BIGINT 8
42 CREATE_USER_ID BIGINT 8
43 UPDATE_USER_ID BIGINT 8
44 LODGEMENT_USER_ID BIGINT 8
45 ACTIVITY_ID BIGINT 8
46 ACTIVITY_STATUS_ID BIGINT 8
47 ACTIVITY_TYPE_ID BIGINT 8
48 ACTIVITY_ASSIGNED_TO_USER_ID BIGINT 8
49 ACTIVITY_ASSIGNED_TO_GROUP_ID BIGINT 8
50 ACTIVITY_ASSIGNED_BY_USER_ID BIGINT 8
51 ACTIVITY_COMPLETED_WITH_TARGET_INDICATOR INTEGER 4
52 ACTIVITY_PRIORITY_ID BIGINT 8
53 ACTIVITY_BANDING_LOSS_TYPE_ID BIGINT 8
54 ACTIVITY_BANDING_LOSS_TYPE_NAME CHARACTER VARYING(256) 256
55 ACTIVITY_BANDING_CATEGORY_ID BIGINT 8
56 ACTIVITY_BANDING_CATEGORY_NAME CHARACTER VARYING(256) 256
57 ACTIVITY_BANDING_SUBJECT CHARACTER VARYING(255) 255
58 ACTIVITY_OVERDUE_FLAG CHARACTER VARYING(3) 3
59 ACTIVITY_AGE INTEGER 4
60 ACTIVITY_CREATE_USER_ID BIGINT 8
61 ACTIVITY_CLOSED_BY_USER_ID BIGINT 8
62 DAYS_OVERDUE INTEGER 4
63 ACTIVITY_COUNT INTEGER 4
64 ACTIVITY_AGE_BAND_ID INTEGER 4
65 EVENT_NAME CHARACTER VARYING(256) 256
66 CLAIMEVENTQUESTIONS_DANGEROUSHAZARDOUSGOODS BIGINT 8
67 POLICY_INTERMEDIARY_CC_CONTACT_ID BIGINT 8
68 POLICY_INTERMEDIARY_NAME CHARACTER VARYING(120) 120
69 POLICY_INTERMEDIARY_REFERENCE_CODE CHARACTER VARYING(40) 40
70 CLAIM_PROCESS_TYPE_ID BIGINT 8
71 LOSSDATE TIMESTAMP 8
72 CCR_CC_POLICY_POLICYTYPE BIGINT 8
73 FLEET_IND CHARACTER VARYING(9) 9
74 CAS_IND CHARACTER VARYING(7) 7
75 LOSS_CCR_CC_ADDRESS_COUNTRY BIGINT 8
76 POLICY_NUMBER CHARACTER VARYING(40) 40
77 CCR_CC_CLAIM_SC_INCIDENTREPORT BIGINT 8
78 INT_MOTOR_LODGEMENT_DATE_ASIS_LODGEMENT_DATE TIMESTAMP 8
79 CCR_CC_CLAIM_CREATETIME TIMESTAMP 8
80 CCR_CC_CLAIM_REOPENDATE TIMESTAMP 8
81 CCR_CC_CLAIM_CLOSEDATE TIMESTAMP 8
82 CCR_CC_CLAIM_LOSSDATE TIMESTAMP 8
83 ACTIVITY_CREATE_DATE TIMESTAMP 8
84 ACTIVITY_CLOSED_DATE TIMESTAMP 8
85 ACTIVITY_TARGET_DATE TIMESTAMP 8
86 LINE_OF_BUSINESS_NAME CHARACTER VARYING(256) 256
87 CCR_CCTL_SC_YESNOONLY_TYPECODE CHARACTER VARYING(50) 50
88 ACTIVITY_COMPLETED_IN_SCOPE CHARACTER VARYING(12) 12
89 ACTIVITY_COMPLETED_IN_SCOPE_WITHIN_SLA CHARACTER VARYING(23) 23
90 ACTIVITY_CONVERSION_30_DAYS CHARACTER VARYING(3) 3
91 ACTIVITY_CONVERSION_DAYS INTEGER 4
92 ACTIVITY_CONVERSION_HOURS NUMERIC(9,2) 19
93 CCR_CCX_SC_ASSESSMENTBOOKING_CREATEDATE TIMESTAMP 8
94 ASSESSMENT_PROCESS_TYPE_ID BIGINT 8
95 ASSESSMENT_PROCESS_TYPE_NAME CHARACTER VARYING(256) 256
96 ACTIVITY_COMPLETED_WITH_SYSTEM_TARGET_INDICATOR INTEGER 4
97 CCR_CC_ACTIVITY_PATTERN_ID BIGINT 8
98 ACTIVITY_TARGET_DAYS BIGINT 8
99 ACTIVITY_TARGET_HOURS BIGINT 8
100 ACTIVITY_TARGET_TYPE CHARACTER VARYING(24) 24
101 ACTIVITY_WORKING_HOURS_ELAPSED NUMERIC(26,6) 19
102 ACTIVITY_WORKING_DAYS_ELAPSED NUMERIC(38,0) 19
103 ACTIVITY_CALENDAR_HOURS_ELAPSED NUMERIC(25,6) 19
104 ACTIVITY_CALENDAR_DAYS_ELAPSED INTEGER 4
105 ACTIVITY_SUBJECT CHARACTER VARYING(255) 255
106 SC_LEGACYCLAIMNO CHARACTER VARYING(255) 255
107 LEGACYCLAIM_FLAG CHARACTER VARYING(3) 3
108 LEGACYCLAIM_CATEGORY CHARACTER VARYING(256) 256