OBP24_HST_FLX_PR_ARRNGMT_PLAN_LINKAGE_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ARRANGEMENT_CODE CHARACTER VARYING(128) 128
2 EFFECTIVE_DATE TIMESTAMP 8
3 INIT_PLAN_CREATION_DATE TIMESTAMP 8
4 DOMAIN_CATEGORY_CODE CHARACTER VARYING(128) 128
5 BULK_FLAG CHARACTER(1) 1
6 BULK_FREQ_CODE CHARACTER VARYING(100) 100
7 NSF_TREATMENT_CODE CHARACTER VARYING(100) 100
8 SINGLE_CHARGE_FLAG CHARACTER(1) 1
9 CHARGE_BASIS_CODE CHARACTER VARYING(100) 100
10 FEE_CHARGE_DAY DOUBLE PRECISION 8
11 PRICING_PLAN_CODE CHARACTER VARYING(128) 128
12 VARIANCE_PLAN_CODE CHARACTER VARYING(128) 128
13 CREATED_BY CHARACTER VARYING(100) 100
14 CREATION_DATE TIMESTAMP 8
15 LAST_UPDATED_BY CHARACTER VARYING(100) 100
16 LAST_UPDATE_DATE TIMESTAMP 8
17 ENTITY_STATUS CHARACTER VARYING(100) 100
18 BENEFIT_APPLICATION_STATUS CHARACTER VARYING(128) 128
19 BUNDLE_ID CHARACTER VARYING(50) 50
20 CAMPAIGN_ID CHARACTER VARYING(50) 50
21 POLICY_USAGE_CODE CHARACTER VARYING(128) 128
22 VERSION_NUM BIGINT 8
23 FEE_CON_PLAN_CODE CHARACTER VARYING(40) 40
24 UNAUTH_VARIANCE_PLAN_CODE CHARACTER VARYING(128) 128
25 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
26 CUSTOMIZED_RATE_PLAN_CODE CHARACTER VARYING(128) 128
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8