OBP24_FLX_PR_NET_RATES

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_FLX_PR_NET_RATES

Columns
# Name Data Type Length
1 UUID CHARACTER VARYING(128) 128
2 ARRANGEMENT_CODE CHARACTER VARYING(128) 128
3 PRICING_ELEMENT_TYPE CHARACTER VARYING(20) 20
4 STAGE_CODE CHARACTER VARYING(128) 128
5 START_AMT DOUBLE PRECISION 8
6 END_AMT DOUBLE PRECISION 8
7 START_DATE TIMESTAMP 8
8 END_DATE TIMESTAMP 8
9 TIER_EVAL_CODE CHARACTER VARYING(20) 20
10 AMT_LOOKUP_CODE CHARACTER VARYING(100) 100
11 RATE_TYPE_CODE CHARACTER VARYING(30) 30
12 REFRESH_FREQ_CODE CHARACTER VARYING(100) 100
13 REFRESH_FREQ_VALUE INTEGER 4
14 BASE_INDEX_CODE CHARACTER VARYING(128) 128
15 BASE_RATE DOUBLE PRECISION 8
16 MARGIN_CODES CHARACTER VARYING(200) 200
17 MARGIN_RATE DOUBLE PRECISION 8
18 ACCT_UDM_RATE DOUBLE PRECISION 8
19 BUNDLE_UDM_RATE DOUBLE PRECISION 8
20 CAMP_UDM_RATE DOUBLE PRECISION 8
21 BROKER_REBATE_UDM_RATE DOUBLE PRECISION 8
22 BENEFIT_APPLICATION_STATUS CHARACTER VARYING(20) 20
23 NET_RATE_ANALYSIS_ID CHARACTER VARYING(150) 150
24 ANALYSIS_TIMESTAMP DOUBLE PRECISION 8
25 BUNDLE_MARGIN_CODES CHARACTER VARYING(100) 100
26 CAMP_MARGIN_CODES CHARACTER VARYING(100) 100
27 DOMAIN_OBJECT_EXTN 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