Policy
Overview
The Policy subject area is used to define and manage rules that govern how business processes operate within the system. A policy represents a configurable set of conditions, parameters, and outcomes that guide decision-making in areas such as billing, payments, adjustments, collections, or customer management. Each policy record specifies the type of policy, its effective dates, and any associated algorithms or characteristics.
Conforming Layers
The conforming layers of this subject area are the following:
POLICY_OBJ
| Column | Column Description | Data Type | Data Length |
|---|---|---|---|
| POLICY_ID | Unique identifier for the policy. | VARCHAR | 14 |
| POLICY_NBR | External number assigned to a policy that is often used in documentation, billing, and communication. This may differ from the system-generated ID. | VARCHAR | 64 |
| BO_STATUS_CD | Current status of the business object representing the policy. | VARCHAR | 12 |
| STATUS_UPD_DTTM | Date and time when the policy’s status was last updated. | TIMESTAMP | |
| POLICY_TYPE_CD | Category or type of policy, such as health, dental, or vision. | VARCHAR | 30 |
| SRC_SYSTEM_CD | Source system from which the policy originated. | VARCHAR | 10 |
| BO_STATUS_REASON_CD | Reason code associated with the policy’s current business object status. | VARCHAR | 30 |
| CRE_DTTM | Date and time when the policy was created. | TIMESTAMP | |
| PAID_THR_DT | Date when the payments have been made on the policy. | TIMESTAMP | |
| START_DT | Start date of the policy coverage. | TIMESTAMP | |
| END_DT | Date when the policy coverage ends. | TIMESTAMP | |
| DESCR | Description of the policy. | VARCHAR | 60 |
| RENEWAL_DT | Date when the policy is due for renewal. | TIMESTAMP | |
| RUNOUT_END_DT | End date for the policy's run-out period, typically used in insurance to cover expenses after termination. | TIMESTAMP | |
| RUNOUT_ADM_OPT_FLG | Indicator whether the administrative services are allowed during the run-out period. | VARCHAR | 4 |
| PER_ROLE_CD_1 | Additional descriptive value or reference related to the specific mapping row. | VARCHAR | 254 |
| PER_ID_1 | Primary key of the related person and identifies the person or organization that is linked to a given policy record. | VARCHAR | 10 |
| PER_ROLE_CD_2 | Additional descriptive value or reference related to the specific mapping row. | VARCHAR | 254 |
| PER_ID_2 | Primary key of the related person and identifies the person or organization that is linked to a given policy record. | VARCHAR | 10 |
| CDC_LOAD_DTTM | Timestamp when the record was loaded into the data warehouse. | TIMESTAMP | |
| CDC_FLAG | Type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| COMPOSITE_KEY | Unique identifier in POLICY_ID format. This is the primary key. |
VARCHAR | 14 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP | |
| 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 |
POLICY_LOG_OBJ
| Column | Column Description | Data Type | Data Length |
|---|---|---|---|
| PARM_SEQ | Parameter sequence number that orders multiple parameters within the same log. | DECIMAL(3,0) | (3,0) |
| POLICY_ID | Unique identifier that links the policy record to its associated log entry. | VARCHAR | 14 |
| SEQNO | Sequence number of the log entry used to identify the order in operations and tracking. | DECIMAL(5,0) | (5,0) |
| LOG_ENTRY_TYPE_FLG | Type of log entry, such as, change, error, or informational. | VARCHAR | 4 |
| LOG_DTTM | Date and time when the log entry was created. Critical for audit trails and issue analysis. | TIMESTAMP | |
| BO_STATUS_CD | Status code of the business object at the time of the log. Allows rollback or history tracking. | VARCHAR | 12 |
| MESSAGE_CAT_NBR | Category number of the message logged. This is used to classify system messages for diagnostics or UI rendering. | DECIMAL(5,0) | (5,0) |
| MESSAGE_NBR | Identifier corresponding to a specific message associated with the record. | DECIMAL(5,0) | (5,0) |
| USER_ID | Unique identifier for the user who made the log entry. | VARCHAR | 8 |
| BO_STATUS_REASON_CD | Reason code for the business object status logged at the time. | VARCHAR | 30 |
| MSG_PARM_TYP_FLG | Type of message parameter. | VARCHAR | 4 |
| MESSAGE_PARM | Actual value or content of the message parameter. This is typically displayed in logs, messages, or audit trails. | VARCHAR | 2000 |
| CDC_LOAD_DTTM | Timestamp when the record was loaded into the data warehouse. | TIMESTAMP | |
| CDC_FLAG | Type of data change captured in the record during the Change Data Capture (CDC) process. | VARCHAR | 1 |
| COMPOSITE_KEY | Unique identifier in the PARM_SEQ | POLICY_ID | SEQNO format. This is the primary key. |
VARCHAR | 64 |
| CREATE_DTTM | Date and time when the record was created in the system. | TIMESTAMP | |
| UPDATE_DTTM | Date and time when the record was last updated. | TIMESTAMP |