OCH24_S_CON_XPERIENCE

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 CON_ID CHARACTER VARYING(15) 15
9 FIRM_NAME CHARACTER VARYING(100) 100
10 START_DT TIMESTAMP 8
11 BANK_EMPL_FLG CHARACTER(1) 1
12 DB_LAST_UPD TIMESTAMP 8
13 END_DT TIMESTAMP 8
14 OFCR_DIR_FLG CHARACTER(1) 1
15 SELF_EMPL_FLG CHARACTER(1) 1
16 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
17 EMP_CONTACT_NAME CHARACTER VARYING(15) 15
18 FIRM_DESC CHARACTER VARYING(100) 100
19 FIRM_ID CHARACTER VARYING(15) 15
20 FIRM_PHONE_NUM CHARACTER VARYING(40) 40
21 RESPONSIBILITY CHARACTER VARYING(250) 250
22 TITLE CHARACTER VARYING(40) 40
23 X_BU_NAME CHARACTER VARYING(100) 100
24 X_CREATED_BY CHARACTER VARYING(100) 100
25 X_CREATED_SYS CHARACTER VARYING(100) 100
26 X_DELETED_BY CHARACTER VARYING(100) 100
27 X_EMPL_TYPE CHARACTER VARYING(50) 50
28 X_EMPLOYEE_NUMBER CHARACTER VARYING(50) 50
29 X_EMPLOYER_NAME CHARACTER VARYING(255) 255
30 X_EMPLOYER_PHONE CHARACTER VARYING(30) 30
31 X_INT_ID CHARACTER VARYING(100) 100
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_OCC_CLASS CHARACTER VARYING(100) 100
36 X_OCC_CODEL_ID CHARACTER VARYING(15) 15
37 X_OCC_STATUS CHARACTER VARYING(30) 30
38 X_OCC_TITLE CHARACTER VARYING(100) 100
39 X_RECORD_END_DT TIMESTAMP 8
40 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
41 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
42 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
43 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
44 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
45 X_VICTIM_EMP_FLG CHARACTER VARYING(15) 15