INT_CI_ACTIVITY

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 ACTIVITY_CLAIM_ID BIGINT 8
3 ACTIVITY_CREATE_USER_ID BIGINT 8
4 ACTIVITY_STATUS_ID BIGINT 8
5 ACTIVITY_CLOSE_DATE TIMESTAMP 8
6 ACTIVITY_CLOSE_DATE_ID INTEGER 4
7 ACTIVITY_CREATE_DATE TIMESTAMP 8
8 ACTIVITY_CREATE_DATE_ID INTEGER 4
9 ACTIVITY_TARGET_DATE TIMESTAMP 8
10 ACTIVITY_TARGET_DATE_ID INTEGER 4
11 ACTIVITY_ESCALATION_DATE TIMESTAMP 8
12 ACTIVITY_ESCALATION_DATE_ID INTEGER 4
13 ACTIVITY_LAST_VIEWED_DATE TIMESTAMP 8
14 ACTIVITY_LAST_VIEWED_DATE_ID INTEGER 4
15 ACTIVITY_UPDATE_DATE TIMESTAMP 8
16 ACTIVITY_UPDATE_DATE_ID INTEGER 4
17 ACTIVITY_ID BIGINT 8
18 ACTIVITY_COUNT INTEGER 4
19 ACTIVITIES_NUMBER_OF_DAYS_OVERDUE NUMERIC(31,12) 19
20 ACTIVITIES_TOTAL_NUMBER_OVERDUE INTEGER 4
21 ACTIVITY_SLA_STATUS CHARACTER VARYING(15) 15
22 ACTIVITY_INSIDE_SLA_FLAG CHARACTER VARYING(3) 3
23 ACTIVITY_ASSIGNMENT_DATE TIMESTAMP 8
24 ACTIVITY_ASSIGNMENT_DATE_ID INTEGER 4
25 ACTIVITY_ASSIGNED_TO_GROUP_ID BIGINT 8
26 ACTIVITY_ASSIGNED_TO_USER_ID BIGINT 8
27 ACTIVITY_ASSIGNED_QUEUE_ID BIGINT 8
28 ACTIVITY_COMPLETED_BY_DEPARTMENT_USER_ID BIGINT 8
29 ACTIVITY_COMPLETED_BY_USER_ID BIGINT 8
30 ACTIVITY_UPDATE_BY_USER_ID BIGINT 8
31 ACTIVITY_APPROVED_FLAG_ID INTEGER 4
32 ACTIVITY_APPROVAL_STATUS CHARACTER VARYING(21) 21
33 ACTIVITY_ESCALATED_FLAG_ID INTEGER 4
34 ACTIVITY_TYPE_ID BIGINT 8
35 ACTIVITY_ASSIGNED_BY_DEPARTMENT_USER_ID BIGINT 8
36 ACTIVITY_ASSIGNED_BY_USER_ID BIGINT 8
37 ACTIVITY_PREVIOUS_ASSIGNED_USER_ID BIGINT 8
38 ACTIVITY_PREVIOUS_GROUP_ID BIGINT 8
39 ACTIVITY_PREVIOUS_QUEUE_ID BIGINT 8
40 ACTIVITY_PRIORITY_ID BIGINT 8
41 ACTIVITYPATTERNID BIGINT 8
42 COMPLETED_STATUS_DESC CHARACTER VARYING(19) 19
43 ACTIVITY_DESCRIPTION CHARACTER VARYING(2000) 2000
44 ACTIVITY_SUBJECT_NAME CHARACTER VARYING(255) 255
45 ACTIVITY_APPROVAL_ISSUE_DESC CHARACTER VARYING(255) 255
46 ACTIVITY_APPROVAL_RATIONALE_DESC CHARACTER VARYING(255) 255
47 PATTERN_ACTIVITY_CLASS_ID BIGINT 8
48 PATTERN_CATEGORY_ID BIGINT 8
49 PATTERN_TYPE_ID BIGINT 8
50 PATTERN_TARGET_NUMBER_OF_DAYS BIGINT 8
51 PATTERN_SUBJECT_NAME CHARACTER VARYING(255) 255
52 PATTERN_DESCRIPTION CHARACTER VARYING(2000) 2000
53 ACTIVITY_PATTERN_PRIORITY_ID BIGINT 8
54 ACTIVITY_TRANSACTIONSET_ID BIGINT 8
55 ACTIVITY_EXPOSURE_ID BIGINT 8
56 ACTIVITY_PATTERN_ID BIGINT 8
57 ACTIVITY_INCIDENT_ID BIGINT 8
58 ACTIVITY_COMPLAINT_ID BIGINT 8
59 ACTIVITIES_COMPLETED_WITHIN_SLA_INDICATOR INTEGER 4
60 ACTIVITIES_COMPLETED_OUTSIDE_SLA_INDICATOR INTEGER 4
61 ACTIVITIES_TOTAL_ACTUAL_TURNAROUND_COUNT INTEGER 4
62 ACTIVITIES_TOTAL_ACTUAL_TURNAROUND INTERVAL 12
63 ACTIVITIES_TOTAL_ACTUAL_TURNAROUND_DAYS NUMERIC(31,12) 19
64 ACTIVITIES_TOTAL_TARGET_TURNAROUND_COUNT INTEGER 4
65 ACTIVITIES_TOTAL_TARGET_TURNAROUND INTERVAL 12
66 ACTIVITIES_TOTAL_TARGET_TURNAROUND_DAYS NUMERIC(31,12) 19
67 ACTIVITIES_TOTAL_CREATE_TURNAROUND_COUNT INTEGER 4
68 ACTIVITIES_TOTAL_CREATE_ACTUAL_TURNAROUND INTERVAL 12
69 ACTIVITIES_TOTAL_CREATE_ACTUAL_TURNAROUND_DAYS NUMERIC(31,12) 19