OBP24_HST_FLX_PR_CONTRACTED_NET_RATES

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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