| Business Data Model Data Model |
| Description | A basic set of information about the patient's health insurance as known to the healthcare provider. This information is used by a provider to file a claim on behalf of the patient and is also used by the receiving health insurance payer to identify the health plan product to which the patient is a member. |
| Attributes | |
NHPI Num |
|
Plan Code |
|
Plan Code Qualifier |
|
Plan Descr |
|
Plan External Reference |
|
Plan Name |
|
Plan Type |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
NHPI Num
| Description | National Health Plan Identifier |
| 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 |
Plan Code
| Description | An alphanumeric code assigned to the plan. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Plan Code Qualifier
| Description | Indicates the format of the plan code. |
| 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 |
Plan Descr
| Description | A free-text statement used to explain the meaning of the plan. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Plan External Reference
| Description | The number or code allocated to a plan for identification and communication purposes. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Plan Name
| Description | The label by which the plan is commonly known. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Plan Type
| Description | Indicates the type of health plan. For example: Medicare Medicaid Blue Cross HMO |
| 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 |
| Business Data Model Data Model |