| Dimensional Warehouse Model Data Model |
| Description | An organization that provides some aspect of medical care. |
| Primary Key | |
Provider Dimension PK |
|
| Dependencies | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Accesses Personal Health Records Ind
| 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 |
Accounting Period End Dt
| 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 |
Accounting Period Start Dt
| 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 |
Address Line 1 Descr
| 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 |
Address Line 2 Descr
| 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 |
Address Line 3 Descr
| 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 |
Address Line 4 Descr
| 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 |
Address Text Descr
| 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 |
Address Type Cd
| 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 |
Address Type Code Descr
| 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 |
Address Type Code Sk
| 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 |
Address Type Descr
| 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 |
Address Use Cd
| 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 |
Address Use Code Descr
| 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 |
Address Use Code Sk
| 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 |
Address Use Descr
| 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 |
Aggregate Performance Score
| 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 |
Annual Revenue
| 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 |
Attachments Allowed Ind
| 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 |
AWM Load Info Sk
| 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 |
Bed Size Cnt
| 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 |
Boarded Ind
| 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 |
Capital City Ind
| 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 |
Center of Excellence Ind
| 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 |
City Nm
| 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 |
CLIA Certified Cd
| 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 |
CLIA Certified Code Descr
| 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 |
CLIA Certified Code Sk
| 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 |
CLIA Certified Descr
| 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 |
Company Type Cd
| 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 |
Company Type Code Descr
| 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 |
Company Type Code Sk
| 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 |
Competitor Ind
| 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 |
Contact Instructions
| 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 |
Contact Preference Priority Cd
| 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 |
Contact Preference Priority Code Descr
| 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 |
Contact Preference Priority Code Sk
| 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 |
Country Nm
| 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 |
County Nm
| 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 |
Current Ind
| 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 |
DEA Identification Num
| 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 |
Display Nm
| 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 |
Dissolution Dt
| 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 |
DUNS Num
| 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 |
DWM Load Info Sk
| 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 |
Effective From Dt
| 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 |
Effective To Dt
| 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 |
Electronic Medical Records Ind
| 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 |
Email Address Resource Locator Nm
| 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 |
Email Type Cd
| 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 |
Email Type Code Descr
| 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 |
Email Type Code Sk
| 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 |
Email Type Descr
| 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 |
Email Use Cd
| 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 |
Email Use Code Descr
| 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 |
Email Use Code Sk
| 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 |
Email Use Descr
| 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 |
End Dt
| 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 |
Equipment Type Cd
| 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 |
Equipment Type Code Descr
| 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 |
Equipment Type Code Sk
| 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 |
Equipment Type Descr
| 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 |
External Ind
| 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 |
Fiscal Year End
| 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 |
Foundation Dt
| 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 |
Franchised Ind
| 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 |
Full Nm
| 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 |
GL Business Unit Cd
| 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 |
GL Business Unit Code Descr
| 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 |
GL Business Unit Code Sk
| 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 |
GL Department Cd
| 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 |
GL Department Code Descr
| 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 |
GL Department Code Sk
| 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 |
GL Location Cd
| 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 |
GL Location Code Descr
| 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 |
GL Location Code Sk
| 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 |
Group Size
| 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 |
Group Type Cd
| 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 |
Group Type Code Descr
| 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 |
Group Type Code Sk
| 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 |
Guideline Compliance Rating Cd
| 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 |
Guideline Compliance Rating Code Descr
| 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 |
Guideline Compliance Rating Code Sk
| 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 |
Healthcare Provider Specialty Cd
| 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 |
Healthcare Provider Specialty Code Descr
| 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 |
Healthcare Provider Specialty Code Sk
| 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 |
Health Rating Cd
| 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 |
Health Rating Code Descr
| 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 |
Health Rating Code Sk
| 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 |
HIBCC Subscriber Ind
| 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 |
HIN Status Cd
| 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 |
HIN Status Code Descr
| 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 |
HIN Status Code Sk
| 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 |
HIN Status Descr
| 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 |
Language Cd
| 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 |
Language Code Descr
| 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 |
Language Code Sk
| 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 |
Leapfrog Safe Practices Score
| 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 |
Maximum Message Size
| 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 |
Membership Fee
| 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 |
Name Type Cd
| 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 |
Name Type Code Descr
| 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 |
Name Type Code Sk
| 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 |
Name Type Descr
| 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 |
Name Usage Cd
| 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 |
Name Usage Code Descr
| 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 |
Name Usage Code Sk
| 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 |
Name Usage Descr
| 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 |
National Provider Identifier Num
| 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 |
Number Of Beds Licensed
| 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 |
Number Of Customers
| 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 |
Number Of Employees
| 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 |
Number Of Members
| 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 |
Number Of Outlets
| 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 |
Online Fee Access Ind
| 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 |
Organization Legal Form Cd
| 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 |
Organization Legal Form Code Descr
| 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 |
Organization Legal Form Code Sk
| 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 |
Organization Master Num
| 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 |
Organization Purpose Cd
| 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 |
Organization Purpose Code Descr
| 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 |
Organization Purpose Code Sk
| 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 |
Organization Status Reason Cd
| 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 |
Organization Status Reason Code Descr
| 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 |
Organization Status Reason Code Sk
| 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 |
Organization Type Cd
| 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 |
Organization Type Code Descr
| 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 |
Organization Type Code Sk
| 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 |
Organization Type Descr
| 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 |
Outcomes Performance Rating Cd
| 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 |
Outcomes Performance Rating Code Descr
| 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 |
Outcomes Performance Rating Code Sk
| 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 |
Outpatient Clinic Type Cd
| 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 |
Outpatient Clinic Type Code Descr
| 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 |
Outpatient Clinic Type Code Sk
| 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 |
Outpatient Clinic Type Descr
| 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 |
Party Introduction Method Cd
| 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 |
Party Introduction Method Code Descr
| 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 |
Party Introduction Method Code Sk
| 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 |
Patient Safety Performance Rating Cd
| 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 |
Patient Safety Performance Rating Code Descr
| 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 |
Patient Safety Performance Rating Code Sk
| 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 |
Pharmacy Nm
| 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 |
Phone Area Cd
| 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 |
Phone Country Cd
| 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 |
Phone Exchange Cd
| 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 |
Phone Extension Num
| 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 |
Phone Line Num
| 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 |
Phone Num
| 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 |
Phone Speed Dial Num
| 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 |
Phone Text Descr
| 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 |
Phone Type Cd
| 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 |
Phone Type Code Descr
| 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 |
Phone Type Code Sk
| 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 |
Phone Type Descr
| 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 |
Phone Use Cd
| 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 |
Phone Use Code Descr
| 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 |
Phone Use Code Sk
| 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 |
Phone Use Descr
| 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 |
Postal Cd
| 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 |
Preferred Payment Method Cd
| 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 |
Preferred Payment Method Code Descr
| 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 |
Preferred Payment Method Code Sk
| 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 |
Prescriber Ind
| 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 |
Previous Refusal Ind
| 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 |
Primary Role Cd
| 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 |
Primary Role Code Descr
| 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 |
Primary Role Code Sk
| 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 |
Professional Service Area Cd
| 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 |
Professional Service Area Code Descr
| 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 |
Professional Service Area Code Sk
| 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 |
Professional Service Area Descr
| 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 |
Profit After Tax
| 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 |
Provider Affiliation Group Descr
| 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 |
Provider Affiliation Group Nm
| 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 |
Provider Affiliation Group Size
| 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 |
Provider Affiliation Group Type Cd
| 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 |
Provider Affiliation Group Type Code Descr
| 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 |
Provider Affiliation Group Type Code Sk
| 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 |
Provider Bk
| 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 |
Provider Descr
| 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 |
Provider Dk
| 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 |
Provider Hierarchy Category Nm
| 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 |
Provider Hierarchy Region Nm
| 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 |
Provider Hierarchy System Nm
| 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 |
Provider Network Descr
| 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 |
Provider Network Nm
| 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 |
Provider Service Share
| 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 |
Provider Sk
| 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 |
Provider Status Cd
| 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 |
Provider Status Code Descr
| 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 |
Provider Status Code Sk
| 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 |
Provider Status Descr
| 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 |
Public Private Ind
| 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 |
Retail Pharmacy Segment Cd
| 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 |
Retail Pharmacy Segment Code Descr
| 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 |
Retail Pharmacy Segment Code Sk
| 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 |
Revenue
| 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 |
Source Cd
| 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 |
Source Code Descr
| 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 |
Source Code Sk
| 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 |
Staffing Type Cd
| 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 |
Staffing Type Code Descr
| 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 |
Staffing Type Code Sk
| 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 |
State Province Cd
| 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 |
Taxonomy Cd
| 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 |
Taxonomy Code Descr
| 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 |
Taxonomy Code Sk
| 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 |
Teaching Institution Ind
| 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 |
Teaching Provider Ind
| 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 |
Teaching Type Cd
| 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 |
Teaching Type Code Descr
| 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 |
Teaching Type Code Sk
| 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 |
Teaching Type Descr
| 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 |
Tenant Sk
| 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 |
Text Only Ind
| 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 |
Turnover
| 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 |
Type Cd
| 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 |
Type Code Descr
| 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 |
Type Code Sk
| 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 |
Type Of Pharmacy Cd
| 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 |
Type Of Pharmacy Code Descr
| 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 |
Type Of Pharmacy Code Sk
| 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 |
Valid From Ts
| 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 |
Validity Check Dt
| 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 |
Validity Check Result Cd
| 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 |
Validity Check Result Code Descr
| 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 |
Validity Check Result Code Sk
| 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 |
Valid To Ts
| 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 |
Provider Dimension PK
| Key Attribute | Provider Dk |
| Dimensional Warehouse Model Data Model |