OCH24_S_PARTY_REL

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 BOARD_SEAT_FLG CHARACTER(1) 1
9 CLM_INQ_AUTH_FLG CHARACTER(1) 1
10 CONSOLIDATE_FLG CHARACTER(1) 1
11 INQ_AUTH_FLG CHARACTER(1) 1
12 PARTY_ID CHARACTER VARYING(15) 15
13 REL_PARTY_ID CHARACTER VARYING(15) 15
14 REL_TYPE_CD CHARACTER VARYING(30) 30
15 UPD_PRFL_AUTH_FLG CHARACTER(1) 1
16 AFFL_RANK BIGINT 8
17 DB_LAST_UPD TIMESTAMP 8
18 END_DT TIMESTAMP 8
19 INVST_AMT NUMERIC(22,7) 19
20 PERCENT_OWNED NUMERIC(22,7) 19
21 START_DT TIMESTAMP 8
22 AFFL_STATUS_CD CHARACTER VARYING(30) 30
23 AFFL_STATUS_DESC CHARACTER VARYING(100) 100
24 COMMENTS CHARACTER VARYING(250) 250
25 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
26 EMP_MAIL_STOP CHARACTER VARYING(30) 30
27 EMP_STATUS_CD CHARACTER VARYING(30) 30
28 PR_EMP_ADDR_ID CHARACTER VARYING(15) 15
29 ROLE_CD CHARACTER VARYING(30) 30
30 X_BU_NAME CHARACTER VARYING(100) 100
31 X_CREATED_BY CHARACTER VARYING(100) 100
32 X_CREATED_SYS CHARACTER VARYING(100) 100
33 X_DELETED_BY CHARACTER VARYING(100) 100
34 X_GOLDEN_ID CHARACTER VARYING(30) 30
35 X_INTEGRATION_ID CHARACTER VARYING(100) 100
36 X_LAST_UPD_BY CHARACTER VARYING(100) 100
37 X_LAST_UPD_DT TIMESTAMP 8
38 X_LAST_UPD_SYS CHARACTER VARYING(100) 100
39 X_PRIMARY_FLG CHARACTER(1) 1
40 X_RECORD_END_DT TIMESTAMP 8
41 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
42 X_REL_END_CD CHARACTER VARYING(30) 30
43 X_SCORE BIGINT 8
44 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
45 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
46 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
47 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8