Policy Plan
Overview
The Policy Plan subject area is used to define and manage policy plans that group together multiple policies under a single structure. A policy plan represents a collection of business rules and configurations that apply to a customer, account, or service agreement, ensuring that related policies are applied consistently. Each policy plan specifies its type, effective period, and the policies that it references, providing a controlled way to organize and manage complex sets of rules.
Conforming Layers
The only conforming layer of this subject area is POLICY_PLAN_OBJ.
POLICY_PLAN_OBJ
| Column | Description | Data Type | Data Length |
|---|---|---|---|
| PLAN_ID | Unique identifier for the policy plan, ensuring each plan can be distinctly referenced. | VARCHAR | 15 |
| POLICY_ID | Unique identifier for the associated policy to which this plan belongs. | VARCHAR | 14 |
| PRICEITEM_CD | Code of the price item that links the plan to specific billing or pricing configurations. | VARCHAR | 30 |
| START_DT | Effective start date from which the plan becomes valid. | TIMESTAMP | |
| END_DT | Date on which the plan expires or is no longer valid. | TIMESTAMP | |
| PLAN_NBR | Plan number assigned for identification and reference purposes. | VARCHAR | 30 |
| BO_DATA_AREA | Business object data in a structured CLOB format for system processing. | CLOB | |
| BUS_OBJ_CD | Business object code defining lifecycle and processing rules for the plan. | VARCHAR | 30 |
| ILM_ARCH_SW | Indicator whether the policy plan is marked for archiving. | VARCHAR | 1 |
| ILM_DT | Date when the policy plan is scheduled to be archived. | TIMESTAMP | |
| PRIMARY_PLAN_SW | Indicator whether the plan is the primary plan for a given policy. | VARCHAR | 1 |
| PLAN_NAME | Descriptive name of the plan. | VARCHAR | 60 |
| ORG_END_DT | Original end date of the plan before any modifications or extensions. | TIMESTAMP | |
| BENEFIT_TYPE_FLG | Code representing the type of benefit associated with the plan. | VARCHAR | 4 |
| BO_STATUS_CD | Code of the current status of the business object linked with the plan. | VARCHAR | 12 |
| BO_STATUS_REASON_CD | Reason code associated with the status of the business object. | VARCHAR | 30 |
| PRICING_RULE_TYPE_CD_1 | First pricing rule type code associated with the policy plan for determining applicable pricing rules | VARCHAR | 70 |
| PRICING_RULE_TYPE_CD_2 | Second pricing rule type code associated with the policy plan for determining applicable pricing rules. | VARCHAR | 70 |
| PRICING_RULE_TYPE_CD_3 | Third pricing rule type code associated with the policy plan for determining applicable pricing rules. | VARCHAR | 70 |
| CDF1_CD CDF2_CD CDF3_CD CDF4_CD CDF5_CD CDF6_CD CDF7_CD CDF8_CD CDF9_CD CDF10_CD CDF11_CD CDF12_CD CDF13_CD CDF14_CD CDF15_CD |
Placeholders for future implementation of ORMB characteristics. | VARCHAR | 254 |
| CDF1_VAL CDF2_VAL CDF3_VAL CDF4_VAL CDF5_VAL CDF6_VAL CDF7_VAL CDF8_VAL CDF9_VAL CDF10_VAL CDF11_VAL CDF12_VAL CDF13_VAL CDF14_VAL CDF15_VAL |
Placeholders for values of future implementation of ORMB characteristics. | VARCHAR | 254 |