| Dimensional Warehouse Model Data Model |
Description | An organization that provides some aspect of medical care. |
Primary Key | |
![]() |
Dependencies | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | Indicates that the healthcare provider accesses the Personal Health Records (PHR) of its patients. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Date upon which the accounting period of the organization ends. Indicates the last date for which account entries will be reported as within the accounting period. |
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 |
Description | Date upon which the accounting period of the organization starts. |
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 |
Description | First line of the address. Use for Primary Street and Building Number |
Data Type | Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Second line of the address |
Data Type | Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Third line of the address |
Data Type | Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Fourth line of the address |
Data Type | Standards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Free form textual comments with respect to the telephone number. |
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 |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Code for the contact use. e.g. Mailing Default Billing |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Code for the contact use. e.g. Mailing Default Billing |
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 |
Description | Code for the contact use. e.g. Mailing Default Billing |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Code for the contact use. e.g. Mailing Default Billing |
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 |
Description | The aggregate score after adding together all individual performance measures for a healthcare provider. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The approximate monetary amount of the organization's annual revenue. This is typically based on published accounts unless the organization is a subsidiary or affiliate of the modeled healthcare organization in which case revenue values may be derived from management accounts. |
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 |
Description | Indicates whether the e-mail address accepts attachments. For example: 0 No 1 Yes |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Total number of beds in a health care facility. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates that an organization has a board of directors. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether or not a city is the capital city of a country. This applies only to a place whose administrative level corresponds to a city. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates that a hospital or other institutional provider has one or more externally recognized centers of excellence. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Name for the city of the address. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The Centers for Medicare & Medicaid Services (CMS) regulates all laboratory testing (except research) performed on humans in the U.S. through the Clinical Laboratory Improvement Amendments (CLIA). This flag indicated the Lab is certified under this program. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The Centers for Medicare & Medicaid Services (CMS) regulates all laboratory testing (except research) performed on humans in the U.S. through the Clinical Laboratory Improvement Amendments (CLIA). This flag indicated the Lab is certified under this program. |
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 |
Description | The Centers for Medicare & Medicaid Services (CMS) regulates all laboratory testing (except research) performed on humans in the U.S. through the Clinical Laboratory Improvement Amendments (CLIA). This flag indicated the Lab is certified under this program. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The Centers for Medicare & Medicaid Services (CMS) regulates all laboratory testing (except research) performed on humans in the U.S. through the Clinical Laboratory Improvement Amendments (CLIA). This flag indicated the Lab is certified under this program. |
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 |
Description | Indicates the primary type of activity undertaken by the organization. For example: Mail Order Company Pharmacy Company |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the primary type of activity undertaken by the organization. For example: Mail Order Company Pharmacy Company |
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 |
Description | Indicates the primary type of activity undertaken by the organization. For example: Mail Order Company Pharmacy Company |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether or not the organization competes with the modeled healthcare organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The recorded advice which may be helpful when contacting the party using this email address. |
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 |
Description | Contact preference priority classifies the email address according to the relative priority of the email address with respect to other email addresses. For example: 1 (Main/primary preference) 5 (Low preference) |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Contact preference priority classifies the email address according to the relative priority of the email address with respect to other email addresses. For example: 1 (Main/primary preference) 5 (Low preference) |
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 |
Description | Contact preference priority classifies the email address according to the relative priority of the email address with respect to other email addresses. For example: 1 (Main/primary preference) 5 (Low preference) |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Name of the country for the address. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Name of the county for the address. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Set to 'Y' if this is the most recent row of a group having the same Surrogate Key. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The Drug Enforcement Agency Number (DEA) of the healthcare provider. |
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 |
Description | The complete name (first, middle, last) for a person. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The date upon which this organization ceased to legally exist. |
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 |
Description | The number assigned to the organization by Dun & Bradstreet. |
Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Establishes a period where a set of attributes are true according to the business. |
Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Ends a period of effectivity. |
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 |
Description | Indicates if the provider retains and uses electronic records for distributing patient data. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Email address string, representing the contact email address |
Data Type | Standards - Data Domains.ddm/Data Domains/URL [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours |
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 |
Description | Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the way an address is used by a party. For example: Default Mailing Billing Delivery Statement Alert Contact After Hours |
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 |
Description | The date upon which the organization becomes unavailable for use. |
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 |
Description | Indicates the kind of telephone represented by the number. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the kind of telephone represented by the number. |
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 |
Description | Indicates the kind of telephone represented by the number. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the kind of telephone represented by the number. |
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 |
Description | Indicates if this organization is external or part of the enterprise. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The day and month upon which the company's fiscal year ends. |
Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The date upon which the organization was founded or created. |
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 |
Description | Indicates whether or not the organization has a franchise for one or more companies. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The complete name (first, middle, last) for a person. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the organization business unit for general ledger reference. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the organization business unit for general ledger reference. |
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 |
Description | Identifies the organization business unit for general ledger reference. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the organization department for general ledger reference. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the organization department for general ledger reference. |
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 |
Description | Identifies the organization department for general ledger reference. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the organization location for general ledger reference. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the organization location for general ledger reference. |
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 |
Description | Identifies the organization location for general ledger reference. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The size of a group practice, to which a provider affiliation group belongs. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The type of provider affiliation group to which a healthcare provider belongs. For example: Anesthesiologists Physicians Radiologists |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The type of provider affiliation group to which a healthcare provider belongs. For example: Anesthesiologists Physicians Radiologists |
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 |
Description | The type of provider affiliation group to which a healthcare provider belongs. For example: Anesthesiologists Physicians Radiologists |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates how often, based on applicable treatments, a healthcare provider renders care in accordance with applicable evidence-based clinical practice guidelines during a one year measurement period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates how often, based on applicable treatments, a healthcare provider renders care in accordance with applicable evidence-based clinical practice guidelines during a one year measurement period. |
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 |
Description | Indicates how often, based on applicable treatments, a healthcare provider renders care in accordance with applicable evidence-based clinical practice guidelines during a one year measurement period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the primary form of health treatment or service provided by the healthcare provider organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the primary form of health treatment or service provided by the healthcare provider organization. |
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 |
Description | Indicates the primary form of health treatment or service provided by the healthcare provider organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members. |
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 |
Description | Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates if the organization subscribes to the Health Industry Business Communication Council. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN). |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN). |
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 |
Description | Indicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN). |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN). |
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 |
Description | Indicates the natural language used in communication with the organization. For example: Chinese Dutch French Japanese US English |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the natural language used in communication with the organization. For example: Chinese Dutch French Japanese US English |
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 |
Description | Indicates the natural language used in communication with the organization. For example: Chinese Dutch French Japanese US English |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The score given to the hospital by The Leapfrog Group on its Safe Practices Score. This measures the hospital's compliance with 27 given procedures to reduce preventable medical mistakes. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The maximum size (in bytes) of an e-mail accepted by the email address. The size includes the body, all headers and attachments. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The monetary amount of a single fee paid to become a member of an organization or affinity group. |
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 |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
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 |
Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates how a role player uses a name. For example: Default Mailing Legal DBA Alias |
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 |
Description | National Provider Identifier (NPI). |
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 |
Description | Registered number of licensed beds in a hospital. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A count of the customers dealing with the organization. This information is derived and its value depends on the organization's definition of what a customer is. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A count of persons employed by the organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A count of people who are members of the organization. This number often is an approximate number, because the number of members may in general change over time without the modeled organization being brought up to date. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A count of the outlets (customer touch point locations) owned or operated by the organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether a healthcare provider's fees are viewable online by health plan members, potential members or other patients. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the legal form or structure of the organization. For example: Limited company Public limited company |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the legal form or structure of the organization. For example: Limited company Public limited company |
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 |
Description | Indicates the legal form or structure of the organization. For example: Limited company Public limited company |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Universal business identifier for the Organization. |
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 |
Description | Indicates the purpose or format of the organization. For example: Supporting dangerous hobbies Travel assistance |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the purpose or format of the organization. For example: Supporting dangerous hobbies Travel assistance |
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 |
Description | Indicates the purpose or format of the organization. For example: Supporting dangerous hobbies Travel assistance |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the reason why an organization is currently in a given organization status. For example: Risky investment Insolvent |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the reason why an organization is currently in a given organization status. For example: Risky investment Insolvent |
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 |
Description | Indicates the reason why an organization is currently in a given organization status. For example: Risky investment Insolvent |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the kind of organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the kind of Organization represented by the anchor row |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the kind of Organization represented by the anchor row |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The description of the kind of organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the performance of the healthcare provider with respect to outcomes. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the performance of the healthcare provider with respect to outcomes. |
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 |
Description | Indicates the performance of the healthcare provider with respect to outcomes. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the nature of the services provided in an outpatient clinic. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Uniquely represents the services provided in an outpatient clinic. |
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 |
Description | Uniquely represents the services provided in an outpatient clinic. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The description of the Outpatient Clinic Type. |
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 |
Description | Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement |
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 |
Description | Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the performance of the healthcare provider with respect to the safety of its patients. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the performance of the healthcare provider with respect to the safety of its patients. |
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 |
Description | Indicates the performance of the healthcare provider with respect to the safety of its patients. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The name of the pharmacy. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the area code for the telephone, cell, or pager number. |
Data Type | Standards - Data Domains.ddm/Data Domains/Phone Area Code [VARCHAR(8)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the country code for the telephone, cell, or pager number. |
Data Type | Standards - Data Domains.ddm/Data Domains/Phone Country Code [CHAR(3)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the telephone exchange code for the telephone, cell, or pager number. Â For US telephone numbers the exchange code or Central Office Code refers to the first 3 digits of the local number (NNN-xxxx). |
Data Type | Standards - Data Domains.ddm/Data Domains/Phone Exchange Code [VARCHAR(3)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A suffix for a telephone number to reach a specific phone in a main telephone network |
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 |
Description | Represents the telephone line number for the telephone, cell, or pager number. Â For US telephone numbers the line number refers to the last 4 digits of the local number (xxx-NNNN). |
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 |
Description | Represents the actual number (without formatting) for the telephone, cell, or pager number. |
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 |
Description | The characters established within a company's internal telephone system used in place of the (external) telephone number to facilitate calling because its length is shorter than that of the telephone number. Note that digits, as well as special characters (for example, *, #) may be used. |
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 |
Description | Free form textual comments with respect to the telephone number. |
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 |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Identifies the type of the relationship as defined in the business data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the type of the relationship as defined in the business data model. |
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 |
Description | Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours |
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 |
Description | Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the way a telephone number is used by a party. For example: Default Alert Contact After Hours |
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 |
Description | Zip code and International Postal Code for the address. |
Data Type | Standards - Data Domains.ddm/Data Domains/Postal Code [VARCHAR(15)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check |
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 |
Description | Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates that the healthcare provider is authorized to prescribe drugs. For example, a physician or other clinician. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether (1) or not (0) the party has been refused a relationship with the modeled organization in the past. For example, a person may have been refused insurance or has had a policy cancelled or special terms imposed by a health insurance organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber |
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 |
Description | Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Uniquely represents the service provided by a physician or center |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Uniquely represents the service provided by a physician or center |
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 |
Description | Uniquely represents the service provided by a physician or center |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Uniquely represents the service provided by a physician or center |
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 |
Description | The monetary amount of the most recently reported profit after tax for the company. |
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 |
Description | Indicates a description of the provider affiliation group. |
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 |
Description | Indicates name of the provider affiliation group. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The size of a group practice, to which a provider affiliation group belongs. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the type of provider affiliation group to which a healthcare provider belongs. For example: Anesthesiologists Physicians Radiologists |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the type of provider affiliation group to which a healthcare provider belongs. For example: Anesthesiologists Physicians Radiologists |
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 |
Description | Indicates the type of provider affiliation group to which a healthcare provider belongs. For example: Anesthesiologists Physicians Radiologists |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Concatenated values of a set of business attributes that uniquely identify the row. |
Data Type | Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | A textual description of the organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | true |
Description | Identifies the organization category to which the Provider is attached. Examples would be Wholly owner facilities, joint venture facilities, affiliated clinics. |
Data Type | Standards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the organizational region to which the Provider is attached. |
Data Type | Standards - Data Domains.ddm/Data Domains/Login Name [VARCHAR(75)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the system or network to which the Provider is attached. |
Data Type | Standards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates a description of the provider network group. |
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 |
Description | Indicates name of the provider network. |
Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The percentage of the healthcare provider's total patient load or revenue that is accounted for by the health plan organization's members. |
Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the atomic model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the current state of the organization. It is used for all statuses other than foundation and dissolution. For example: Trading Liquidated |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the current state of the organization. It is used for all statuses other than foundation and dissolution. For example: Trading Liquidated |
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 |
Description | Indicates the current state of the organization. It is used for all statuses other than foundation and dissolution. For example: Trading Liquidated |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the current state of the organization. It is used for all statuses other than foundation and dissolution. For example: Trading Liquidated |
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 |
Description | Indicates whether the organization is publicly or privately funded. For example: Private Public |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether a retail pharmacy is independent or part of a retail pharmacy company or other organization. For example: Chain drug store Food store Independent Mass merchandiser |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether a retail pharmacy is independent or part of a retail pharmacy company or other organization. For example: Chain drug store Food store Independent Mass merchandiser |
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 |
Description | Indicates whether a retail pharmacy is independent or part of a retail pharmacy company or other organization. For example: Chain drug store Food store Independent Mass merchandiser |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The monetary amount of the total income received by a company over a period of one year. |
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 |
Description | The code that corresponds to the Source Code Sk. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The description that corresponds to the Source Type Cd. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the manner in which the organization is staffed. For example: Employees Family-Run Volunteers |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the manner in which the organization is staffed. For example: Employees Family-Run Volunteers |
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 |
Description | Indicates the manner in which the organization is staffed. For example: Employees Family-Run Volunteers |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the state or province for the address using a recognized set of codes or abbreviations. |
Data Type | Standards - Data Domains.ddm/Data Domains/State Code [CHAR(2)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the provider type, classification, and specialization. For example: Family medicine Surgery Ophthalmology Oncology Anesthesiology Gynecology Internal medicine Emergent medicine |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the provider type, classification, and specialization. For example: Family medicine Surgery Ophthalmology Oncology Anesthesiology Gynecology Internal medicine Emergent medicine |
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 |
Description | Identifies the provider type, classification, and specialization. For example: Family medicine Surgery Ophthalmology Oncology Anesthesiology Gynecology Internal medicine Emergent medicine |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates that an institutional provider provides clinical training for medical students. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates that the provider is a teaching organization. |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the level of medical training offered at a provider facility. For example: Major teaching: Hospital is an important part of the teaching program of a medical school and the majority of medical students rotate through multiple clinical services. Graduate teaching: Hospital is used by the medical school for graduate training programs only; i.e., residency and/or fellowships. Limited teaching: Hospital is used in the medical school's teaching program only to a limited extent. Non teaching |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the level of medical training offered at a provider facility. For example: Major teaching: Hospital is an important part of the teaching program of a medical school and the majority of medical students rotate through multiple clinical services. Graduate teaching: Hospital is used by the medical school for graduate training programs only; i.e., residency and/or fellowships. Limited teaching: Hospital is used in the medical school's teaching program only to a limited extent. Non teaching |
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 |
Description | Indicates the level of medical training offered at a provider facility. For example: Major teaching: Hospital is an important part of the teaching program of a medical school and the majority of medical students rotate through multiple clinical services. Graduate teaching: Hospital is used by the medical school for graduate training programs only; i.e., residency and/or fellowships. Limited teaching: Hospital is used in the medical school's teaching program only to a limited extent. Non teaching |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the level of medical training offered at a provider facility. For example: Major teaching: Hospital is an important part of the teaching program of a medical school and the majority of medical students rotate through multiple clinical services. Graduate teaching: Hospital is used by the medical school for graduate training programs only; i.e., residency and/or fellowships. Limited teaching: Hospital is used in the medical school's teaching program only to a limited extent. Non teaching |
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 |
Description | The surrogate key of the entry identifying the legal owner of the data. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether the e-mail address accepts text only e-mails (otherwise it could accept HTML or other embedded objects). For example: 0 No (HTML/other objects allowed) 1 Yes (text only allowed) |
Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The frequency with which employees resign, are fired or retired from a company, usually computed as the percentage of a company's employees at the beginning of the calendar year. |
Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The code that corresponds to the Type Code Sk. |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The description that corresponds to the Type Cd. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The code identifying the actual type of the entity as per the type hierarchy defined in the analysis data model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital. For example: Hospital Retail |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital. For example: Hospital Retail |
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 |
Description | Indicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital. For example: Hospital Retail |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The date on which the validity of the contact preference was last checked. |
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 |
Description | The conclusion of the most recent validity check. For example: Invalid Invalid but accepted Valid |
Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The conclusion of the most recent validity check. For example: Invalid Invalid but accepted Valid |
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 |
Description | The conclusion of the most recent validity check. For example: Invalid Invalid but accepted Valid |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Ends a period of validity. |
Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Primary Key Details |
Key Attribute | Provider Dk |
| Dimensional Warehouse Model Data Model |