OEB_WF_LOCAL_USER_ROLES

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 USER_NAME CHARACTER VARYING(320) 320
2 ROLE_NAME CHARACTER VARYING(320) 320
3 USER_ORIG_SYSTEM CHARACTER VARYING(30) 30
4 USER_ORIG_SYSTEM_ID BIGINT 8
5 ROLE_ORIG_SYSTEM CHARACTER VARYING(30) 30
6 ROLE_ORIG_SYSTEM_ID BIGINT 8
7 START_DATE TIMESTAMP 8
8 EXPIRATION_DATE TIMESTAMP 8
9 SECURITY_GROUP_ID CHARACTER VARYING(32) 32
10 PARTITION_ID BIGINT 8
11 OWNER_TAG CHARACTER VARYING(50) 50
12 CREATED_BY BIGINT 8
13 CREATION_DATE TIMESTAMP 8
14 LAST_UPDATED_BY BIGINT 8
15 LAST_UPDATE_DATE TIMESTAMP 8
16 LAST_UPDATE_LOGIN BIGINT 8
17 ASSIGNMENT_TYPE CHARACTER VARYING(1) 1
18 PARENT_ORIG_SYSTEM CHARACTER VARYING(30) 30
19 PARENT_ORIG_SYSTEM_ID BIGINT 8
20 USER_START_DATE TIMESTAMP 8
21 ROLE_START_DATE TIMESTAMP 8
22 USER_END_DATE TIMESTAMP 8
23 ROLE_END_DATE TIMESTAMP 8
24 EFFECTIVE_START_DATE TIMESTAMP 8
25 EFFECTIVE_END_DATE TIMESTAMP 8
26 ASSIGNMENT_REASON CHARACTER VARYING(4000) 4000
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8