OCH24_S_NOTE_CON

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 DCKING_NUM NUMERIC(22,7) 19
7 MODIFICATION_NUM BIGINT 8
8 CONFLICT_ID CHARACTER VARYING(15) 15
9 SRC_ROW_ID CHARACTER VARYING(15) 15
10 DB_LAST_UPD TIMESTAMP 8
11 DURATION NUMERIC(22,7) 19
12 END_DT TIMESTAMP 8
13 PRIV_FLG CHARACTER(1) 1
14 START_DT TIMESTAMP 8
15 CATEGORY_CD CHARACTER VARYING(30) 30
16 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
17 NOTE_TYPE CHARACTER VARYING(30) 30
18 PRIORITY_CD CHARACTER VARYING(30) 30
19 TARGET_OU_ID CHARACTER VARYING(15) 15
20 UNIT_CD CHARACTER VARYING(30) 30
21 NOTE CHARACTER VARYING(2000) 2000
22 X_ALERT_VAL CHARACTER VARYING(130) 130
23 X_BU_NAME CHARACTER VARYING(100) 100
24 X_CANCELLED_FLG CHARACTER(1) 1
25 X_CLOSED_DT TIMESTAMP 8
26 X_CREATED_BY CHARACTER VARYING(100) 100
27 X_CREATED_SYS CHARACTER VARYING(100) 100
28 X_DELETED_BY CHARACTER VARYING(100) 100
29 X_DESC_TEXT CHARACTER VARYING(350) 350
30 X_INT_ID CHARACTER VARYING(100) 100
31 X_ISSUE_TEXT CHARACTER VARYING(30) 30
32 X_LAST_UPD_BY CHARACTER VARYING(100) 100
33 X_LAST_UPD_DT TIMESTAMP 8
34 X_LAST_UPD_SYS CHARACTER VARYING(100) 100
35 X_NAME CHARACTER VARYING(100) 100
36 X_NARR_DATE TIMESTAMP 8
37 X_RECORD_END_DT TIMESTAMP 8
38 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8