OEB_WF_USER_ROLE_ASSIGNMENTS

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 RELATIONSHIP_ID BIGINT 8
4 ASSIGNING_ROLE CHARACTER VARYING(320) 320
5 START_DATE TIMESTAMP 8
6 END_DATE TIMESTAMP 8
7 CREATED_BY BIGINT 8
8 CREATION_DATE TIMESTAMP 8
9 LAST_UPDATED_BY BIGINT 8
10 LAST_UPDATE_DATE TIMESTAMP 8
11 LAST_UPDATE_LOGIN BIGINT 8
12 USER_START_DATE TIMESTAMP 8
13 ROLE_START_DATE TIMESTAMP 8
14 ASSIGNING_ROLE_START_DATE TIMESTAMP 8
15 USER_END_DATE TIMESTAMP 8
16 ROLE_END_DATE TIMESTAMP 8
17 ASSIGNING_ROLE_END_DATE TIMESTAMP 8
18 PARTITION_ID BIGINT 8
19 EFFECTIVE_START_DATE TIMESTAMP 8
20 EFFECTIVE_END_DATE TIMESTAMP 8
21 USER_ORIG_SYSTEM CHARACTER VARYING(30) 30
22 USER_ORIG_SYSTEM_ID BIGINT 8
23 ROLE_ORIG_SYSTEM CHARACTER VARYING(30) 30
24 ROLE_ORIG_SYSTEM_ID BIGINT 8
25 PARENT_ORIG_SYSTEM CHARACTER VARYING(30) 30
26 PARENT_ORIG_SYSTEM_ID BIGINT 8
27 OWNER_TAG CHARACTER VARYING(50) 50
28 ASSIGNMENT_REASON CHARACTER VARYING(4000) 4000
29 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8