| Business Data Model Data Model |
| Description | A part of a communication that a plan sponsor sends to a health plan organization explaining a specific component of the premium payments in relation to a group agreement. |
| Attributes | |
Line Item Amt |
|
Line Item Descr |
|
Line Item Identification |
|
Line Item Memo |
|
Line Item Num |
|
Line Item Short Descr |
|
Origination Date |
|
Payment Plan Strategy |
|
Period Covered |
|
Posted Date |
|
Premium Due Date |
|
| Relationship | |
Premium Remittance Advice contains Premium Remittance Advice Line Item |
|
Premium Remittance Advice Line Item_Insurance Policy_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Line Item Amt
| Description | Amount and currency of a sub-amount of the subtotal summarized in the bill summary. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Item Descr
| Description | Description of the type of the sub-amount of the premium summary. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Item Identification
| Description | Reference number or code given to the bill summary sub-total for identification. To be used as reference in communications. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Item Memo
| Description | A free-form message that is used by the originator of the bill to pass a message, related to the subamount on the premium summary to the receiver of the premium. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Item Num
| Description | External reference number or code identifying a detail line on a premium settlement. The reference is used for communication purposes. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Line Item Short Descr
| Description | Short description of the type of the sub-amount of the summary. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Origination Date
| Description | Date upon which the advice line was originated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Payment Plan Strategy
| Description | Specifies the payment strategy being applied. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Period Covered
| Description | The period represented by advice note. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Posted Date
| Description | Date upon which the transaction represented by the advice line was posted. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Premium Due Date
| Description | The date upon which the premium payment was due for payment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Premium Remittance Advice contains Premium Remittance Advice Line Item
| Is Identifying Relationship | false |
| Child Table | Premium Remittance Advice Line Item |
| Child Role Name | is contained in |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Premium Remittance Advice |
| Parent Role Name | contains |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Premium Remittance Advice Line Item_Insurance Policy_FK
| Is Identifying Relationship | false |
| Child Table | Premium Remittance Advice Line Item |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Insurance Policy |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |