DIM_CI_USER_TEAM

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 USER_ID BIGINT 8
2 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
3 EMPLOYEE_NUMBER CHARACTER VARYING(255) 255
4 LAST_NAME CHARACTER VARYING(90) 90
5 FIRST_NAME CHARACTER VARYING(90) 90
6 USER_NAME CHARACTER VARYING(181) 181
7 TEAM_ID BIGINT 8
8 TEAM_NAME CHARACTER VARYING(100) 100
9 SC_ISPRIMARYGROUP CHARACTER VARYING(9) 9
10 GROUP_TYPE_ID BIGINT 8
11 GROUP_TYPE_NAME CHARACTER VARYING(256) 256
12 L1_TEAM_ID BIGINT 8
13 L1_TEAM_NAME CHARACTER VARYING(100) 100
14 L2_TEAM_ID BIGINT 8
15 L2_TEAM_NAME CHARACTER VARYING(100) 100
16 L3_TEAM_ID BIGINT 8
17 L3_TEAM_NAME CHARACTER VARYING(100) 100
18 L4_TEAM_ID BIGINT 8
19 L4_TEAM_NAME CHARACTER VARYING(100) 100
20 L5_TEAM_ID BIGINT 8
21 L5_TEAM_NAME CHARACTER VARYING(100) 100
22 L6_TEAM_ID BIGINT 8
23 L6_TEAM_NAME CHARACTER VARYING(100) 100
24 L7_TEAM_ID BIGINT 8
25 L7_TEAM_NAME CHARACTER VARYING(100) 100
26 L8_TEAM_ID BIGINT 8
27 L8_TEAM_NAME CHARACTER VARYING(100) 100
28 L9_TEAM_ID BIGINT 8
29 L9_TEAM_NAME CHARACTER VARYING(100) 100
30 L10_TEAM_ID BIGINT 8
31 L10_TEAM_NAME CHARACTER VARYING(100) 100
32 L11_TEAM_ID BIGINT 8
33 L11_TEAM_NAME CHARACTER VARYING(100) 100