OEB_FND_USER

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 USER_ID BIGINT 8
2 USER_NAME CHARACTER VARYING(100) 100
3 LAST_UPDATE_DATE TIMESTAMP 8
4 LAST_UPDATED_BY BIGINT 8
5 CREATION_DATE TIMESTAMP 8
6 CREATED_BY BIGINT 8
7 LAST_UPDATE_LOGIN BIGINT 8
8 ENCRYPTED_FOUNDATION_PASSWORD CHARACTER VARYING(100) 100
9 ENCRYPTED_USER_PASSWORD CHARACTER VARYING(100) 100
10 SESSION_NUMBER BIGINT 8
11 START_DATE TIMESTAMP 8
12 END_DATE TIMESTAMP 8
13 DESCRIPTION CHARACTER VARYING(240) 240
14 LAST_LOGON_DATE TIMESTAMP 8
15 PASSWORD_DATE TIMESTAMP 8
16 PASSWORD_ACCESSES_LEFT BIGINT 8
17 PASSWORD_LIFESPAN_ACCESSES BIGINT 8
18 PASSWORD_LIFESPAN_DAYS BIGINT 8
19 EMPLOYEE_ID BIGINT 8
20 EMAIL_ADDRESS CHARACTER VARYING(240) 240
21 FAX CHARACTER VARYING(80) 80
22 CUSTOMER_ID BIGINT 8
23 SUPPLIER_ID BIGINT 8
24 WEB_PASSWORD CHARACTER VARYING(240) 240
25 USER_GUID CHARACTER VARYING(16) 16
26 GCN_CODE_COMBINATION_ID BIGINT 8
27 PERSON_PARTY_ID BIGINT 8
28 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
31 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8