CFD_TCFDD_USER

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CMPY_CODE CHARACTER VARYING(20) 20
2 CMPY_CUST_NUM CHARACTER VARYING(20) 20
3 EFF_STRT_DATE TIMESTAMP 8
4 SITE_CODE CHARACTER VARYING(10) 10
5 CMPY_ID BIGINT 8
6 USER_NAM CHARACTER VARYING(100) 100
7 USER_EMAIL_TEXT CHARACTER VARYING(300) 300
8 MGR_USER_NUM CHARACTER VARYING(20) 20
9 USER_GRP_ID BIGINT 8
10 USER_GRP_CODE CHARACTER VARYING(20) 20
11 USER_ATHRTY_CODE INTEGER 4
12 USER_DETL_ADD_ID BIGINT 8
13 USER_DETL_DEL_ID BIGINT 8
14 USER_DETL_CODE INTEGER 4
15 USER_SEC_CODE INTEGER 4
16 USER_LANG_CODE CHARACTER VARYING(10) 10
17 USER_CMPTR_NAM CHARACTER VARYING(50) 50
18 USER_LST_LOGIN_DATE TIMESTAMP 8
19 RECORD_STAT_CODE INTEGER 4
20 INSERT_UID CHARACTER VARYING(300) 300
21 INSERT_DATE TIMESTAMP 8
22 UPD_UID CHARACTER VARYING(300) 300
23 UPD_DATE TIMESTAMP 8
24 EFF_END_DATE TIMESTAMP 8
25 DATA_LOAD_DATE TIMESTAMP 8
26 SNPSHT_DATE TIMESTAMP 8
27 SRC_SYS_ID CHARACTER VARYING(5) 5
28 LOAD_ID BIGINT 8
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