OCH24_HST_S_ACCNT_POSTN

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 ACCNT_NAME CHARACTER VARYING(100) 100
9 OU_EXT_ID CHARACTER VARYING(15) 15
10 POSITION_ID CHARACTER VARYING(15) 15
11 ROW_STATUS CHARACTER VARYING(10) 10
12 ASGN_DNRM_FLG CHARACTER(1) 1
13 ASGN_MANL_FLG CHARACTER(1) 1
14 ASGN_SYS_FLG CHARACTER(1) 1
15 CLIENT_FLG CHARACTER(1) 1
16 DOCK_FLG CHARACTER(1) 1
17 FACILITY_FLG CHARACTER(1) 1
18 INVSTR_FLG CHARACTER(1) 1
19 PRIORITY_FLG CHARACTER(1) 1
20 PRTNR_FLG CHARACTER(1) 1
21 SRV_PROVDR_FLG CHARACTER(1) 1
22 DB_LAST_UPD TIMESTAMP 8
23 DNRM_ACCNT_EMP_FLG CHARACTER(1) 1
24 END_DT TIMESTAMP 8
25 INCLUDE_BRIEF_FLG CHARACTER(1) 1
26 LAST_CALL_DT TIMESTAMP 8
27 NEXT_CALL_DT TIMESTAMP 8
28 ORG_REF_CUST_FLG CHARACTER(1) 1
29 START_DT TIMESTAMP 8
30 ACCNT_LOC CHARACTER VARYING(50) 50
31 ACCNT_TYPE_CD CHARACTER VARYING(30) 30
32 ASGN_RULE_GRP_ID CHARACTER VARYING(15) 15
33 ASGN_TERR_ID CHARACTER VARYING(15) 15
34 COMMENTS CHARACTER VARYING(255) 255
35 CVRG_ROLE_CD CHARACTER VARYING(30) 30
36 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
37 NEXT_CALL_OBJECTIV CHARACTER VARYING(1500) 1500
38 PROD_ID CHARACTER VARYING(15) 15
39 RANK_CD CHARACTER VARYING(30) 30
40 ROLE_CD CHARACTER VARYING(30) 30
41 STATUS CHARACTER VARYING(30) 30
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
44 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
45 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8