OCH24_HST_S_CON_EDU

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 DB_LAST_UPD TIMESTAMP 8
10 END_DT TIMESTAMP 8
11 GRAD_DT TIMESTAMP 8
12 SEQ_NUM BIGINT 8
13 START_DT TIMESTAMP 8
14 CREDENTIAL_TYPE_CD CHARACTER VARYING(30) 30
15 DB_LAST_UPD_SRC CHARACTER VARYING(50) 50
16 DEGREE_CD CHARACTER VARYING(30) 30
17 SCHOOL_NAME CHARACTER VARYING(100) 100
18 UNIVERSITY_ID CHARACTER VARYING(15) 15
19 X_ACCOM_TYPE_CD CHARACTER VARYING(30) 30
20 X_BU_NAME CHARACTER VARYING(100) 100
21 X_CREATED_BY CHARACTER VARYING(100) 100
22 X_CREATED_SYS CHARACTER VARYING(100) 100
23 X_DELETED_BY CHARACTER VARYING(100) 100
24 X_FIELD_STUDY_CD CHARACTER VARYING(30) 30
25 X_INT_ID CHARACTER VARYING(100) 100
26 X_LAST_UPD_BY CHARACTER VARYING(100) 100
27 X_LAST_UPD_SYS CHARACTER VARYING(100) 100
28 X_RECORD_END_DT TIMESTAMP 8
29 X_RECORD_STATUS_CD CHARACTER VARYING(30) 30
30 X_SCHOOL_NAME CHARACTER VARYING(120) 120
31 X_SCORE_GRADE CHARACTER VARYING(10) 10
32 X_UNIVERSITY CHARACTER VARYING(100) 100
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8