OBP24_FLX_PR_BENEFIT_TO_OFFER

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRICE_BENEFIT_CHART_ID CHARACTER VARYING(50) 50
2 OFFER_ID CHARACTER VARYING(50) 50
3 INDEX_NUM CHARACTER VARYING(50) 50
4 PRICE_BENEFIT_TYPE CHARACTER VARYING(20) 20
5 STAGE_OR_EVENT_CODE CHARACTER VARYING(50) 50
6 MARGIN_RATE_CHART_OR_PD_ID CHARACTER VARYING(50) 50
7 CURRENCY_CODE CHARACTER VARYING(4) 4
8 ID_STRING CHARACTER VARYING(300) 300
9 VARIANCE_TYPE CHARACTER VARYING(50) 50
10 VARIANCE_VALUE CHARACTER VARYING(50) 50
11 BENEFIT_APPLICATION_TERM CHARACTER VARYING(250) 250
12 APPLICATION_TERM_UNIT CHARACTER VARYING(50) 50
13 DERIVATION_CLAUSE_ID CHARACTER VARYING(128) 128
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8