OBP24_HST_FLX_DD_EARMARK_PARAMETERS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 EARMARK_PARAMETERS_ID CHARACTER VARYING(36) 36
2 EARMARK_INIT_BY CHARACTER VARYING(6) 6
3 EARMARK_PERMISSION CHARACTER VARYING(21) 21
4 EARMARK_PERIOD_TYPE CHARACTER VARYING(8) 8
5 EARMARK_DURATION_YEARS DOUBLE PRECISION 8
6 EARMARK_DURATION_MONTHS DOUBLE PRECISION 8
7 EARMARK_DURATION_DAYS DOUBLE PRECISION 8
8 EARMARK_PRIORITY DOUBLE PRECISION 8
9 IS_MANUAL_REMOVE CHARACTER(1) 1
10 IS_PARTIAL_BALANCE CHARACTER(1) 1
11 USER_EARMARK_TYPE CHARACTER VARYING(40) 40
12 SYSTEM_EARMARK_TYPE CHARACTER VARYING(40) 40
13 DESCRIPTION CHARACTER VARYING(200) 200
14 INFINITE_END_DATE_VAL TIMESTAMP 8
15 ENTITY_STATUS CHARACTER VARYING(1) 1
16 CREATED_BY CHARACTER VARYING(254) 254
17 LAST_UPDATED_BY CHARACTER VARYING(254) 254
18 CREATION_DATE TIMESTAMP 8
19 LAST_UPDATE_DATE TIMESTAMP 8
20 OBJECT_VERSION_NUMBER BIGINT 8
21 RECOVERY_INTIMATOR CHARACTER VARYING(800) 800
22 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8