OBP24_HST_FLX_PR_OFF_ELM_SET_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OFFERING_ELEMENT_CODE CHARACTER VARYING(40) 40
2 OFF_SET_CODE CHARACTER VARYING(40) 40
3 ELEMENT_TYPE CHARACTER VARYING(20) 20
4 POLICY_CHART_CODE CHARACTER VARYING(50) 50
5 POLICY_CHART_EFFT_DATE TIMESTAMP 8
6 PRICE_CODE CHARACTER VARYING(128) 128
7 PRICE_EFFT_DATE TIMESTAMP 8
8 FIX_RATE_CHART_CODE CHARACTER VARYING(128) 128
9 FIX_RATE_CHART_EFFT_DATE TIMESTAMP 8
10 VAR_RATE_CHART_CODE CHARACTER VARYING(128) 128
11 VAR_RATE_CHART_EFFT_DATE TIMESTAMP 8
12 OVERRIDDEN_CHARGE_ATTR_CODE CHARACTER VARYING(200) 200
13 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
14 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
15 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
16 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8