INT_CI_ACTIVITY_USER

Database

SDSNZP01

Schema

X01PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ACTIVITY_ID BIGINT 8
2 ACTIVITY_CLAIM_ID BIGINT 8
3 ACTIVITY_CREATE_USER_ID BIGINT 8
4 ACTIVITY_CREATE_USER_NAME CHARACTER VARYING(181) 181
5 ACTIVITY_CREATE_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
6 ACTIVITY_CREATE_USER_TEAM_ID BIGINT 8
7 ACTIVITY_CREATE_USER_TEAM_NAME CHARACTER VARYING(100) 100
8 ACTIVITY_CREATE_USER_GROUP_TYPE_ID BIGINT 8
9 ACTIVITY_CREATE_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
10 ACTIVITY_CREATE_USER_L1_TEAM_ID BIGINT 8
11 ACTIVITY_CREATE_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
12 ACTIVITY_CREATE_USER_L2_TEAM_ID BIGINT 8
13 ACTIVITY_CREATE_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
14 ACTIVITY_CREATE_USER_L3_TEAM_ID BIGINT 8
15 ACTIVITY_CREATE_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
16 ACTIVITY_CREATE_USER_L4_TEAM_ID BIGINT 8
17 ACTIVITY_CREATE_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
18 ACTIVITY_CREATE_USER_L5_TEAM_ID BIGINT 8
19 ACTIVITY_CREATE_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
20 ACTIVITY_CREATE_USER_L6_TEAM_ID BIGINT 8
21 ACTIVITY_CREATE_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
22 ACTIVITY_CREATE_USER_L7_TEAM_ID BIGINT 8
23 ACTIVITY_CREATE_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
24 ACTIVITY_CREATE_USER_L8_TEAM_ID BIGINT 8
25 ACTIVITY_CREATE_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
26 ACTIVITY_CREATE_USER_L9_TEAM_ID BIGINT 8
27 ACTIVITY_CREATE_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
28 ACTIVITY_CREATE_USER_L10_TEAM_ID BIGINT 8
29 ACTIVITY_CREATE_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
30 ACTIVITY_CREATE_USER_L11_TEAM_ID BIGINT 8
31 ACTIVITY_CREATE_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
32 ACTIVITY_ASSIGNED_TO_GROUP_ID BIGINT 8
33 ACTIVITY_ASSIGNED_TO_GROUP_NAME CHARACTER VARYING(100) 100
34 ACTIVITY_ASSIGNED_TO_USER_ID BIGINT 8
35 ACTIVITY_ASSIGNED_TO_USER_NAME CHARACTER VARYING(181) 181
36 ACTIVITY_ASSIGNED_TO_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
37 ACTIVITY_ASSIGNED_TO_USER_TEAM_ID BIGINT 8
38 ACTIVITY_ASSIGNED_TO_USER_TEAM_NAME CHARACTER VARYING(100) 100
39 ACTIVITY_ASSIGNED_TO_USER_GROUP_TYPE_ID BIGINT 8
40 ACTIVITY_ASSIGNED_TO_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
41 ACTIVITY_ASSIGNED_TO_USER_L1_TEAM_ID BIGINT 8
42 ACTIVITY_ASSIGNED_TO_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
43 ACTIVITY_ASSIGNED_TO_USER_L2_TEAM_ID BIGINT 8
44 ACTIVITY_ASSIGNED_TO_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
45 ACTIVITY_ASSIGNED_TO_USER_L3_TEAM_ID BIGINT 8
46 ACTIVITY_ASSIGNED_TO_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
47 ACTIVITY_ASSIGNED_TO_USER_L4_TEAM_ID BIGINT 8
48 ACTIVITY_ASSIGNED_TO_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
49 ACTIVITY_ASSIGNED_TO_USER_L5_TEAM_ID BIGINT 8
50 ACTIVITY_ASSIGNED_TO_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
51 ACTIVITY_ASSIGNED_TO_USER_L6_TEAM_ID BIGINT 8
52 ACTIVITY_ASSIGNED_TO_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
53 ACTIVITY_ASSIGNED_TO_USER_L7_TEAM_ID BIGINT 8
54 ACTIVITY_ASSIGNED_TO_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
55 ACTIVITY_ASSIGNED_TO_USER_L8_TEAM_ID BIGINT 8
56 ACTIVITY_ASSIGNED_TO_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
57 ACTIVITY_ASSIGNED_TO_USER_L9_TEAM_ID BIGINT 8
58 ACTIVITY_ASSIGNED_TO_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
59 ACTIVITY_ASSIGNED_TO_USER_L10_TEAM_ID BIGINT 8
60 ACTIVITY_ASSIGNED_TO_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
61 ACTIVITY_ASSIGNED_TO_USER_L11_TEAM_ID BIGINT 8
62 ACTIVITY_ASSIGNED_TO_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
63 ACTIVITY_COMPLETED_BY_USER_ID BIGINT 8
64 ACTIVITY_COMPLETED_BY_USER_NAME CHARACTER VARYING(181) 181
65 ACTIVITY_COMPLETED_BY_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
66 ACTIVITY_COMPLETED_BY_USER_TEAM_ID BIGINT 8
67 ACTIVITY_COMPLETED_BY_USER_TEAM_NAME CHARACTER VARYING(100) 100
68 ACTIVITY_COMPLETED_BY_USER_GROUP_TYPE_ID BIGINT 8
69 ACTIVITY_COMPLETED_BY_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
70 ACTIVITY_COMPLETED_BY_USER_L1_TEAM_ID BIGINT 8
71 ACTIVITY_COMPLETED_BY_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
72 ACTIVITY_COMPLETED_BY_USER_L2_TEAM_ID BIGINT 8
73 ACTIVITY_COMPLETED_BY_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
74 ACTIVITY_COMPLETED_BY_USER_L3_TEAM_ID BIGINT 8
75 ACTIVITY_COMPLETED_BY_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
76 ACTIVITY_COMPLETED_BY_USER_L4_TEAM_ID BIGINT 8
77 ACTIVITY_COMPLETED_BY_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
78 ACTIVITY_COMPLETED_BY_USER_L5_TEAM_ID BIGINT 8
79 ACTIVITY_COMPLETED_BY_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
80 ACTIVITY_COMPLETED_BY_USER_L6_TEAM_ID BIGINT 8
81 ACTIVITY_COMPLETED_BY_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
82 ACTIVITY_COMPLETED_BY_USER_L7_TEAM_ID BIGINT 8
83 ACTIVITY_COMPLETED_BY_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
84 ACTIVITY_COMPLETED_BY_USER_L8_TEAM_ID BIGINT 8
85 ACTIVITY_COMPLETED_BY_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
86 ACTIVITY_COMPLETED_BY_USER_L9_TEAM_ID BIGINT 8
87 ACTIVITY_COMPLETED_BY_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
88 ACTIVITY_COMPLETED_BY_USER_L10_TEAM_ID BIGINT 8
89 ACTIVITY_COMPLETED_BY_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
90 ACTIVITY_COMPLETED_BY_USER_L11_TEAM_ID BIGINT 8
91 ACTIVITY_COMPLETED_BY_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
92 ACTIVITY_UPDATE_BY_USER_ID BIGINT 8
93 ACTIVITY_UPDATE_BY_USER_NAME CHARACTER VARYING(181) 181
94 ACTIVITY_UPDATE_BY_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
95 ACTIVITY_UPDATE_BY_USER_TEAM_ID BIGINT 8
96 ACTIVITY_UPDATE_BY_USER_TEAM_NAME CHARACTER VARYING(100) 100
97 ACTIVITY_UPDATE_BY_USER_GROUP_TYPE_ID BIGINT 8
98 ACTIVITY_UPDATE_BY_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
99 ACTIVITY_UPDATE_BY_USER_L1_TEAM_ID BIGINT 8
100 ACTIVITY_UPDATE_BY_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
101 ACTIVITY_UPDATE_BY_USER_L2_TEAM_ID BIGINT 8
102 ACTIVITY_UPDATE_BY_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
103 ACTIVITY_UPDATE_BY_USER_L3_TEAM_ID BIGINT 8
104 ACTIVITY_UPDATE_BY_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
105 ACTIVITY_UPDATE_BY_USER_L4_TEAM_ID BIGINT 8
106 ACTIVITY_UPDATE_BY_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
107 ACTIVITY_UPDATE_BY_USER_L5_TEAM_ID BIGINT 8
108 ACTIVITY_UPDATE_BY_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
109 ACTIVITY_UPDATE_BY_USER_L6_TEAM_ID BIGINT 8
110 ACTIVITY_UPDATE_BY_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
111 ACTIVITY_UPDATE_BY_USER_L7_TEAM_ID BIGINT 8
112 ACTIVITY_UPDATE_BY_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
113 ACTIVITY_UPDATE_BY_USER_L8_TEAM_ID BIGINT 8
114 ACTIVITY_UPDATE_BY_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
115 ACTIVITY_UPDATE_BY_USER_L9_TEAM_ID BIGINT 8
116 ACTIVITY_UPDATE_BY_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
117 ACTIVITY_UPDATE_BY_USER_L10_TEAM_ID BIGINT 8
118 ACTIVITY_UPDATE_BY_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
119 ACTIVITY_UPDATE_BY_USER_L11_TEAM_ID BIGINT 8
120 ACTIVITY_UPDATE_BY_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
121 ACTIVITY_ASSIGNED_BY_USER_ID BIGINT 8
122 ACTIVITY_ASSIGNED_BY_USER_NAME CHARACTER VARYING(181) 181
123 ACTIVITY_ASSIGNED_BY_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
124 ACTIVITY_ASSIGNED_BY_USER_TEAM_ID BIGINT 8
125 ACTIVITY_ASSIGNED_BY_USER_TEAM_NAME CHARACTER VARYING(100) 100
126 ACTIVITY_ASSIGNED_BY_USER_GROUP_TYPE_ID BIGINT 8
127 ACTIVITY_ASSIGNED_BY_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
128 ACTIVITY_ASSIGNED_BY_USER_L1_TEAM_ID BIGINT 8
129 ACTIVITY_ASSIGNED_BY_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
130 ACTIVITY_ASSIGNED_BY_USER_L2_TEAM_ID BIGINT 8
131 ACTIVITY_ASSIGNED_BY_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
132 ACTIVITY_ASSIGNED_BY_USER_L3_TEAM_ID BIGINT 8
133 ACTIVITY_ASSIGNED_BY_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
134 ACTIVITY_ASSIGNED_BY_USER_L4_TEAM_ID BIGINT 8
135 ACTIVITY_ASSIGNED_BY_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
136 ACTIVITY_ASSIGNED_BY_USER_L5_TEAM_ID BIGINT 8
137 ACTIVITY_ASSIGNED_BY_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
138 ACTIVITY_ASSIGNED_BY_USER_L6_TEAM_ID BIGINT 8
139 ACTIVITY_ASSIGNED_BY_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
140 ACTIVITY_ASSIGNED_BY_USER_L7_TEAM_ID BIGINT 8
141 ACTIVITY_ASSIGNED_BY_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
142 ACTIVITY_ASSIGNED_BY_USER_L8_TEAM_ID BIGINT 8
143 ACTIVITY_ASSIGNED_BY_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
144 ACTIVITY_ASSIGNED_BY_USER_L9_TEAM_ID BIGINT 8
145 ACTIVITY_ASSIGNED_BY_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
146 ACTIVITY_ASSIGNED_BY_USER_L10_TEAM_ID BIGINT 8
147 ACTIVITY_ASSIGNED_BY_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
148 ACTIVITY_ASSIGNED_BY_USER_L11_TEAM_ID BIGINT 8
149 ACTIVITY_ASSIGNED_BY_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
150 ACTIVITY_PREVIOUS_ASSIGNED_USER_ID BIGINT 8
151 ACTIVITY_PREVIOUS_ASSIGNED_USER_NAME CHARACTER VARYING(181) 181
152 ACTIVITY_PREVIOUS_ASSIGNED_USER_EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
153 ACTIVITY_PREVIOUS_ASSIGNED_USER_TEAM_ID BIGINT 8
154 ACTIVITY_PREVIOUS_ASSIGNED_USER_TEAM_NAME CHARACTER VARYING(100) 100
155 ACTIVITY_PREVIOUS_ASSIGNED_USER_GROUP_TYPE_ID BIGINT 8
156 ACTIVITY_PREVIOUS_ASSIGNED_USER_GROUP_TYPE_NAME CHARACTER VARYING(256) 256
157 ACTIVITY_PREVIOUS_ASSIGNED_USER_L1_TEAM_ID BIGINT 8
158 ACTIVITY_PREVIOUS_ASSIGNED_USER_L1_TEAM_NAME CHARACTER VARYING(100) 100
159 ACTIVITY_PREVIOUS_ASSIGNED_USER_L2_TEAM_ID BIGINT 8
160 ACTIVITY_PREVIOUS_ASSIGNED_USER_L2_TEAM_NAME CHARACTER VARYING(100) 100
161 ACTIVITY_PREVIOUS_ASSIGNED_USER_L3_TEAM_ID BIGINT 8
162 ACTIVITY_PREVIOUS_ASSIGNED_USER_L3_TEAM_NAME CHARACTER VARYING(100) 100
163 ACTIVITY_PREVIOUS_ASSIGNED_USER_L4_TEAM_ID BIGINT 8
164 ACTIVITY_PREVIOUS_ASSIGNED_USER_L4_TEAM_NAME CHARACTER VARYING(100) 100
165 ACTIVITY_PREVIOUS_ASSIGNED_USER_L5_TEAM_ID BIGINT 8
166 ACTIVITY_PREVIOUS_ASSIGNED_USER_L5_TEAM_NAME CHARACTER VARYING(100) 100
167 ACTIVITY_PREVIOUS_ASSIGNED_USER_L6_TEAM_ID BIGINT 8
168 ACTIVITY_PREVIOUS_ASSIGNED_USER_L6_TEAM_NAME CHARACTER VARYING(100) 100
169 ACTIVITY_PREVIOUS_ASSIGNED_USER_L7_TEAM_ID BIGINT 8
170 ACTIVITY_PREVIOUS_ASSIGNED_USER_L7_TEAM_NAME CHARACTER VARYING(100) 100
171 ACTIVITY_PREVIOUS_ASSIGNED_USER_L8_TEAM_ID BIGINT 8
172 ACTIVITY_PREVIOUS_ASSIGNED_USER_L8_TEAM_NAME CHARACTER VARYING(100) 100
173 ACTIVITY_PREVIOUS_ASSIGNED_USER_L9_TEAM_ID BIGINT 8
174 ACTIVITY_PREVIOUS_ASSIGNED_USER_L9_TEAM_NAME CHARACTER VARYING(100) 100
175 ACTIVITY_PREVIOUS_ASSIGNED_USER_L10_TEAM_ID BIGINT 8
176 ACTIVITY_PREVIOUS_ASSIGNED_USER_L10_TEAM_NAME CHARACTER VARYING(100) 100
177 ACTIVITY_PREVIOUS_ASSIGNED_USER_L11_TEAM_ID BIGINT 8
178 ACTIVITY_PREVIOUS_ASSIGNED_USER_L11_TEAM_NAME CHARACTER VARYING(100) 100
179 ACTIVITY_PREVIOUS_GROUP_ID BIGINT 8
180 ACTIVITY_PREVIOUS_GROUP_NAME CHARACTER VARYING(100) 100