OBP24_HST_FLX_PR_RATES

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 UUID CHARACTER VARYING(128) 128
2 ARRANGEMENT_CODE CHARACTER VARYING(128) 128
3 PLAN_EFFT_DATE TIMESTAMP 8
4 PRICING_ELEMENT_TYPE CHARACTER VARYING(20) 20
5 STAGE_CODE CHARACTER VARYING(128) 128
6 START_AMT DOUBLE PRECISION 8
7 END_AMT DOUBLE PRECISION 8
8 START_DATE TIMESTAMP 8
9 END_DATE TIMESTAMP 8
10 TIER_EVAL_CODE CHARACTER VARYING(20) 20
11 AMT_LOOKUP_CODE CHARACTER VARYING(100) 100
12 RATE_TYPE_CODE CHARACTER VARYING(30) 30
13 REFRESH_FREQ_CODE CHARACTER VARYING(100) 100
14 REFRESH_FREQ_VALUE INTEGER 4
15 BASE_INDEX_CODE CHARACTER VARYING(128) 128
16 BASE_RATE DOUBLE PRECISION 8
17 MARGIN_CODES CHARACTER VARYING(200) 200
18 MARGIN_RATE DOUBLE PRECISION 8
19 ACCT_UDM_RATE DOUBLE PRECISION 8
20 BUNDLE_UDM_RATE DOUBLE PRECISION 8
21 CAMP_UDM_RATE DOUBLE PRECISION 8
22 BROKER_REBATE_UDM_RATE DOUBLE PRECISION 8
23 BENEFIT_APPLICATION_STATUS CHARACTER VARYING(20) 20
24 NET_RATE_ANALYSIS_ID CHARACTER VARYING(150) 150
25 ANALYSIS_TIMESTAMP DOUBLE PRECISION 8
26 BUNDLE_MARGIN_CODES CHARACTER VARYING(100) 100
27 CAMP_MARGIN_CODES CHARACTER VARYING(100) 100
28 BASE_INDEX_EFFECTIVE_DATE TIMESTAMP 8
29 REFRESH_FROM_DATE TIMESTAMP 8
30 REFRESH_FREQ_ANNIV_DAY_MONTH CHARACTER VARYING(50) 50
31 STEP_UP_UDM_RATE DOUBLE PRECISION 8
32 CUSTOMIZED_RATE_PLAN_CODE CHARACTER VARYING(128) 128
33 REFRESH_FREQ_TYPE CHARACTER VARYING(40) 40
34 REFRESH_ON_BASIS CHARACTER VARYING(40) 40
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8