OCH24_HST_S_USER

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ROW_ID CHARACTER VARYING(15) 15
2 CREATED TIMESTAMP 8
3 CREATED_BY CHARACTER VARYING(15) 15
4 LAST_UPD TIMESTAMP 8
5 LAST_UPD_BY CHARACTER VARYING(15) 15
6 MODIFICATION_NUM BIGINT 8
7 CONFLICT_ID CHARACTER VARYING(15) 15
8 PAR_ROW_ID CHARACTER VARYING(15) 15
9 INTEG_USER_FLG CHARACTER(1) 1
10 LOGIN CHARACTER VARYING(50) 50
11 USER_FLG CHARACTER(1) 1
12 TRNG_DL_ADMIN_FLG CHARACTER(1) 1
13 AMS_LAST_UPD_DT TIMESTAMP 8
14 AMS_PWD_EXPR_DT TIMESTAMP 8
15 DAYS_COMP_TRNG BIGINT 8
16 DAYS_INV_AUDIT BIGINT 8
17 DAYS_OVERDUE_ACK BIGINT 8
18 DAYS_REPORT_LOSS BIGINT 8
19 DAYS_SMPL_WARNING BIGINT 8
20 DAYS_TRANSFER_IN BIGINT 8
21 DAYS_TRSFR_DISCR BIGINT 8
22 DAY_OVERDUE_INVCHK BIGINT 8
23 DB_LAST_UPD TIMESTAMP 8
24 LAST_LOGIN_TS TIMESTAMP 8
25 LAST_UNCOMPRESS_DT TIMESTAMP 8
26 LAST_UPD_AMSPWD_DT TIMESTAMP 8
27 MAX_SAMPLE_CALL BIGINT 8
28 MIN_INVENTORY BIGINT 8
29 NUM_NWS_ARCHV_DAYS BIGINT 8
30 NUM_NWS_HDLNS_DISP BIGINT 8
31 PW_LAST_UPD TIMESTAMP 8
32 AMS_PWD_FREQ_CD CHARACTER VARYING(10) 10
33 CHALLENGE_ANSWER CHARACTER VARYING(100) 100
34 CHALLENGE_QUESTION CHARACTER VARYING(100) 100
35 COMMENTS CHARACTER VARYING(250) 250
36 CTI_ACD_USERID CHARACTER VARYING(15) 15
37 CTI_PWD CHARACTER VARYING(30) 30
38 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
39 EXCHNG_PROF_NAME CHARACTER VARYING(254) 254
40 EXCHNG_PROF_PWD CHARACTER VARYING(250) 250
41 EXCHNG_STOREID CHARACTER VARYING(250) 250
42 EXCHNG_SYNC_TYPE CHARACTER VARYING(30) 30
43 LOGIN_DOMAIN CHARACTER VARYING(50) 50
44 PASSWORD CHARACTER VARYING(30) 30
45 PR_TAG_ID CHARACTER VARYING(15) 15
46 RPT_SRVR_PWD CHARACTER VARYING(30) 30
47 STATUS_CD CHARACTER VARYING(30) 30
48 TRNG_CAL_CD CHARACTER VARYING(30) 30
49 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
50 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
51 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
52 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8