OBP24_HST_FLX_PR_ARRNGMT_PLAN_LINKAGE_H

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 EFFECTIVE_DATE TIMESTAMP 8
4 INIT_PLAN_CREATION_DATE TIMESTAMP 8
5 DOMAIN_CATEGORY_CODE CHARACTER VARYING(128) 128
6 BULK_FLAG CHARACTER(1) 1
7 BULK_FREQ_CODE CHARACTER VARYING(100) 100
8 NSF_TREATMENT_CODE CHARACTER VARYING(100) 100
9 SINGLE_CHARGE_FLAG CHARACTER(1) 1
10 CHARGE_BASIS_CODE CHARACTER VARYING(100) 100
11 FEE_CHARGE_DAY DOUBLE PRECISION 8
12 PRICING_PLAN_CODE CHARACTER VARYING(128) 128
13 VARIANCE_PLAN_CODE CHARACTER VARYING(128) 128
14 CREATED_BY CHARACTER VARYING(100) 100
15 CREATION_DATE TIMESTAMP 8
16 LAST_UPDATED_BY CHARACTER VARYING(100) 100
17 LAST_UPDATE_DATE TIMESTAMP 8
18 ENTITY_STATUS CHARACTER VARYING(100) 100
19 BENEFIT_APPLICATION_STATUS CHARACTER VARYING(128) 128
20 VERSION_NUM BIGINT 8
21 BUNDLE_ID CHARACTER VARYING(50) 50
22 CAMPAIGN_ID CHARACTER VARYING(50) 50
23 POLICY_USAGE_CODE CHARACTER VARYING(128) 128
24 FEE_CON_PLAN_CODE CHARACTER VARYING(40) 40
25 CUSTOMIZED_RATE_PLAN_CODE CHARACTER VARYING(128) 128
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
28 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
29 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8