OBP24_HST_FLX_PR_NET_RATES_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 UUID CHARACTER VARYING(128) 128
2 PLAN_EFFT_DATE TIMESTAMP 8
3 MODIFICATION_NUM DOUBLE PRECISION 8
4 ARRANGEMENT_CODE CHARACTER VARYING(128) 128
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 BASE_INDEX_EFFECTIVE_DATE TIMESTAMP 8
30 REFRESH_FROM_DATE TIMESTAMP 8
31 REFRESH_FREQ_ANNIV_DAY_MONTH CHARACTER VARYING(50) 50
32 STEP_UP_UDM_RATE DOUBLE PRECISION 8
33 CUSTOMIZED_RATE_PLAN_CODE CHARACTER VARYING(128) 128
34 REFRESH_FREQ_TYPE CHARACTER VARYING(40) 40
35 REFRESH_ON_BASIS CHARACTER VARYING(40) 40
36 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8