Entity Provider Dimension

DescriptionAn organization that provides some aspect of medical care.

Attributes
Accesses Personal Health Records IndAccesses Personal Health Records Ind
Accounting Period End DtAccounting Period End Dt
Accounting Period Start DtAccounting Period Start Dt
Address Line 1 DescrAddress Line 1 Descr
Address Line 2 DescrAddress Line 2 Descr
Address Line 3 DescrAddress Line 3 Descr
Address Line 4 DescrAddress Line 4 Descr
Address Text DescrAddress Text Descr
Address Type CdAddress Type Cd
Address Type Code DescrAddress Type Code Descr
Address Type Code SkAddress Type Code Sk
Address Type DescrAddress Type Descr
Address Use CdAddress Use Cd
Address Use Code DescrAddress Use Code Descr
Address Use Code SkAddress Use Code Sk
Address Use DescrAddress Use Descr
Aggregate Performance ScoreAggregate Performance Score
Annual RevenueAnnual Revenue
Attachments Allowed IndAttachments Allowed Ind
AWM Load Info SkAWM Load Info Sk
Bed Size CntBed Size Cnt
Boarded IndBoarded Ind
Capital City IndCapital City Ind
Center of Excellence IndCenter of Excellence Ind
City NmCity Nm
CLIA Certified CdCLIA Certified Cd
CLIA Certified Code DescrCLIA Certified Code Descr
CLIA Certified Code SkCLIA Certified Code Sk
CLIA Certified DescrCLIA Certified Descr
Company Type CdCompany Type Cd
Company Type Code DescrCompany Type Code Descr
Company Type Code SkCompany Type Code Sk
Competitor IndCompetitor Ind
Contact InstructionsContact Instructions
Contact Preference Priority CdContact Preference Priority Cd
Contact Preference Priority Code DescrContact Preference Priority Code Descr
Contact Preference Priority Code SkContact Preference Priority Code Sk
Country NmCountry Nm
County NmCounty Nm
Current IndCurrent Ind
DEA Identification NumDEA Identification Num
Display NmDisplay Nm
Dissolution DtDissolution Dt
DUNS NumDUNS Num
DWM Load Info SkDWM Load Info Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Electronic Medical Records IndElectronic Medical Records Ind
Email Address Resource Locator NmEmail Address Resource Locator Nm
Email Type CdEmail Type Cd
Email Type Code DescrEmail Type Code Descr
Email Type Code SkEmail Type Code Sk
Email Type DescrEmail Type Descr
Email Use CdEmail Use Cd
Email Use Code DescrEmail Use Code Descr
Email Use Code SkEmail Use Code Sk
Email Use DescrEmail Use Descr
End DtEnd Dt
Equipment Type CdEquipment Type Cd
Equipment Type Code DescrEquipment Type Code Descr
Equipment Type Code SkEquipment Type Code Sk
Equipment Type DescrEquipment Type Descr
External IndExternal Ind
Fiscal Year EndFiscal Year End
Foundation DtFoundation Dt
Franchised IndFranchised Ind
Full NmFull Nm
GL Business Unit CdGL Business Unit Cd
GL Business Unit Code DescrGL Business Unit Code Descr
GL Business Unit Code SkGL Business Unit Code Sk
GL Department CdGL Department Cd
GL Department Code DescrGL Department Code Descr
GL Department Code SkGL Department Code Sk
GL Location CdGL Location Cd
GL Location Code DescrGL Location Code Descr
GL Location Code SkGL Location Code Sk
Group SizeGroup Size
Group Type CdGroup Type Cd
Group Type Code DescrGroup Type Code Descr
Group Type Code SkGroup Type Code Sk
Guideline Compliance Rating CdGuideline Compliance Rating Cd
Guideline Compliance Rating Code DescrGuideline Compliance Rating Code Descr
Guideline Compliance Rating Code SkGuideline Compliance Rating Code Sk
Healthcare Provider Specialty CdHealthcare Provider Specialty Cd
Healthcare Provider Specialty Code DescrHealthcare Provider Specialty Code Descr
Healthcare Provider Specialty Code SkHealthcare Provider Specialty Code Sk
Health Rating CdHealth Rating Cd
Health Rating Code DescrHealth Rating Code Descr
Health Rating Code SkHealth Rating Code Sk
HIBCC Subscriber IndHIBCC Subscriber Ind
HIN Status CdHIN Status Cd
HIN Status Code DescrHIN Status Code Descr
HIN Status Code SkHIN Status Code Sk
HIN Status DescrHIN Status Descr
Language CdLanguage Cd
Language Code DescrLanguage Code Descr
Language Code SkLanguage Code Sk
Leapfrog Safe Practices ScoreLeapfrog Safe Practices Score
Maximum Message SizeMaximum Message Size
Membership FeeMembership Fee
Name Type CdName Type Cd
Name Type Code DescrName Type Code Descr
Name Type Code SkName Type Code Sk
Name Type DescrName Type Descr
Name Usage CdName Usage Cd
Name Usage Code DescrName Usage Code Descr
Name Usage Code SkName Usage Code Sk
Name Usage DescrName Usage Descr
National Provider Identifier NumNational Provider Identifier Num
Number Of Beds LicensedNumber Of Beds Licensed
Number Of CustomersNumber Of Customers
Number Of EmployeesNumber Of Employees
Number Of MembersNumber Of Members
Number Of OutletsNumber Of Outlets
Online Fee Access IndOnline Fee Access Ind
Organization Legal Form CdOrganization Legal Form Cd
Organization Legal Form Code DescrOrganization Legal Form Code Descr
Organization Legal Form Code SkOrganization Legal Form Code Sk
Organization Master NumOrganization Master Num
Organization Purpose CdOrganization Purpose Cd
Organization Purpose Code DescrOrganization Purpose Code Descr
Organization Purpose Code SkOrganization Purpose Code Sk
Organization Status Reason CdOrganization Status Reason Cd
Organization Status Reason Code DescrOrganization Status Reason Code Descr
Organization Status Reason Code SkOrganization Status Reason Code Sk
Organization Type CdOrganization Type Cd
Organization Type Code DescrOrganization Type Code Descr
Organization Type Code SkOrganization Type Code Sk
Organization Type DescrOrganization Type Descr
Outcomes Performance Rating CdOutcomes Performance Rating Cd
Outcomes Performance Rating Code DescrOutcomes Performance Rating Code Descr
Outcomes Performance Rating Code SkOutcomes Performance Rating Code Sk
Outpatient Clinic Type CdOutpatient Clinic Type Cd
Outpatient Clinic Type Code DescrOutpatient Clinic Type Code Descr
Outpatient Clinic Type Code SkOutpatient Clinic Type Code Sk
Outpatient Clinic Type DescrOutpatient Clinic Type Descr
Party Introduction Method CdParty Introduction Method Cd
Party Introduction Method Code DescrParty Introduction Method Code Descr
Party Introduction Method Code SkParty Introduction Method Code Sk
Patient Safety Performance Rating CdPatient Safety Performance Rating Cd
Patient Safety Performance Rating Code DescrPatient Safety Performance Rating Code Descr
Patient Safety Performance Rating Code SkPatient Safety Performance Rating Code Sk
Pharmacy NmPharmacy Nm
Phone Area CdPhone Area Cd
Phone Country CdPhone Country Cd
Phone Exchange CdPhone Exchange Cd
Phone Extension NumPhone Extension Num
Phone Line NumPhone Line Num
Phone NumPhone Num
Phone Speed Dial NumPhone Speed Dial Num
Phone Text DescrPhone Text Descr
Phone Type CdPhone Type Cd
Phone Type Code DescrPhone Type Code Descr
Phone Type Code SkPhone Type Code Sk
Phone Type DescrPhone Type Descr
Phone Use CdPhone Use Cd
Phone Use Code DescrPhone Use Code Descr
Phone Use Code SkPhone Use Code Sk
Phone Use DescrPhone Use Descr
Postal CdPostal Cd
Preferred Payment Method CdPreferred Payment Method Cd
Preferred Payment Method Code DescrPreferred Payment Method Code Descr
Preferred Payment Method Code SkPreferred Payment Method Code Sk
Prescriber IndPrescriber Ind
Previous Refusal IndPrevious Refusal Ind
Primary Role CdPrimary Role Cd
Primary Role Code DescrPrimary Role Code Descr
Primary Role Code SkPrimary Role Code Sk
Professional Service Area CdProfessional Service Area Cd
Professional Service Area Code DescrProfessional Service Area Code Descr
Professional Service Area Code SkProfessional Service Area Code Sk
Professional Service Area DescrProfessional Service Area Descr
Profit After TaxProfit After Tax
Provider Affiliation Group DescrProvider Affiliation Group Descr
Provider Affiliation Group NmProvider Affiliation Group Nm
Provider Affiliation Group SizeProvider Affiliation Group Size
Provider Affiliation Group Type CdProvider Affiliation Group Type Cd
Provider Affiliation Group Type Code DescrProvider Affiliation Group Type Code Descr
Provider Affiliation Group Type Code SkProvider Affiliation Group Type Code Sk
Provider BkProvider Bk
Provider DescrProvider Descr
Provider DkProvider Dk
Provider Hierarchy Category NmProvider Hierarchy Category Nm
Provider Hierarchy Region NmProvider Hierarchy Region Nm
Provider Hierarchy System NmProvider Hierarchy System Nm
Provider Network DescrProvider Network Descr
Provider Network NmProvider Network Nm
Provider Service ShareProvider Service Share
Provider SkProvider Sk
Provider Status CdProvider Status Cd
Provider Status Code DescrProvider Status Code Descr
Provider Status Code SkProvider Status Code Sk
Provider Status DescrProvider Status Descr
Public Private IndPublic Private Ind
Retail Pharmacy Segment CdRetail Pharmacy Segment Cd
Retail Pharmacy Segment Code DescrRetail Pharmacy Segment Code Descr
Retail Pharmacy Segment Code SkRetail Pharmacy Segment Code Sk
RevenueRevenue
Source CdSource Cd
Source Code DescrSource Code Descr
Source Code SkSource Code Sk
Staffing Type CdStaffing Type Cd
Staffing Type Code DescrStaffing Type Code Descr
Staffing Type Code SkStaffing Type Code Sk
State Province CdState Province Cd
Taxonomy CdTaxonomy Cd
Taxonomy Code DescrTaxonomy Code Descr
Taxonomy Code SkTaxonomy Code Sk
Teaching Institution IndTeaching Institution Ind
Teaching Provider IndTeaching Provider Ind
Teaching Type CdTeaching Type Cd
Teaching Type Code DescrTeaching Type Code Descr
Teaching Type Code SkTeaching Type Code Sk
Teaching Type DescrTeaching Type Descr
Tenant SkTenant Sk
Text Only IndText Only Ind
TurnoverTurnover
Type CdType Cd
Type Code DescrType Code Descr
Type Code SkType Code Sk
Type Of Pharmacy CdType Of Pharmacy Cd
Type Of Pharmacy Code DescrType Of Pharmacy Code Descr
Type Of Pharmacy Code SkType Of Pharmacy Code Sk
Valid From TsValid From Ts
Validity Check DtValidity Check Dt
Validity Check Result CdValidity Check Result Cd
Validity Check Result Code DescrValidity Check Result Code Descr
Validity Check Result Code SkValidity Check Result Code Sk
Valid To TsValid To Ts

Primary Key
Provider Dimension PKProvider Dimension PK

Dependencies
 
 
 
 
 
 
 
 
 
 
 
 

Reverse Dependencies
 

Attribute Details

 Accesses Personal Health Records Ind
DescriptionIndicates that the healthcare provider accesses the Personal Health Records (PHR) of its patients.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Period End Dt
DescriptionDate 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 TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Accounting Period Start Dt
DescriptionDate upon which the accounting period of the organization starts.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Line 1 Descr
DescriptionFirst line of the address. Use for Primary Street and Building Number
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Line 2 Descr
DescriptionSecond line of the address
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Line 3 Descr
DescriptionThird line of the address
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Line 4 Descr
DescriptionFourth line of the address
Data TypeStandards - Data Domains.ddm/Data Domains/Address Line [VARCHAR(100)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Text Descr
DescriptionFree form textual comments with respect to the telephone number.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Cd
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Code Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Code Sk
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Type Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Cd
DescriptionCode for the contact use.
e.g.
Mailing
Default
Billing
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Code Descr
DescriptionCode for the contact use.
e.g.
Mailing
Default
Billing
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Code Sk
DescriptionCode for the contact use.
e.g.
Mailing
Default
Billing
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Address Use Descr
DescriptionCode for the contact use.
e.g.
Mailing
Default
Billing
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Aggregate Performance Score
DescriptionThe aggregate score after adding together all individual performance measures for a healthcare provider.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Annual Revenue
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Attachments Allowed Ind
DescriptionIndicates whether the e-mail address accepts attachments.

For example:
0 No
1 Yes
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 AWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Bed Size Cnt
DescriptionTotal number of beds in a health care facility.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Boarded Ind
DescriptionIndicates that an organization has a board of directors.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Capital City Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Center of Excellence Ind
DescriptionIndicates that a hospital or other institutional provider has one or more externally recognized centers of excellence.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 City Nm
DescriptionName for the city of the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 CLIA Certified Cd
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 CLIA Certified Code Descr
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 CLIA Certified Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 CLIA Certified Descr
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Company Type Cd
DescriptionIndicates the primary type of activity undertaken by the organization.

For example:
Mail Order Company
Pharmacy Company
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Company Type Code Descr
DescriptionIndicates the primary type of activity undertaken by the organization.

For example:
Mail Order Company
Pharmacy Company
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Company Type Code Sk
DescriptionIndicates the primary type of activity undertaken by the organization.

For example:
Mail Order Company
Pharmacy Company
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Competitor Ind
DescriptionIndicates whether or not the organization competes with the modeled healthcare organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Instructions
DescriptionThe recorded advice which may be helpful when contacting the party using this email address.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Preference Priority Cd
DescriptionContact 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Preference Priority Code Descr
DescriptionContact 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Preference Priority Code Sk
DescriptionContact 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Country Nm
DescriptionName of the country for the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 County Nm
DescriptionName of the county for the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Current Ind
DescriptionSet to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 DEA Identification Num
DescriptionThe Drug Enforcement Agency Number (DEA) of the healthcare provider.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Display Nm
DescriptionThe complete name (first, middle, last) for a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Dissolution Dt
DescriptionThe date upon which this organization ceased to legally exist.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DUNS Num
DescriptionThe number assigned to the organization by Dun & Bradstreet.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DWM Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Electronic Medical Records Ind
DescriptionIndicates if the provider retains and uses electronic records for distributing patient data.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Address Resource Locator Nm
DescriptionEmail address string, representing the contact email address
Data TypeStandards - Data Domains.ddm/Data Domains/URL [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Cd
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Code Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Code Sk
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Type Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Cd
DescriptionIndicates the way an address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Code Descr
DescriptionIndicates the way an address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Code Sk
DescriptionIndicates the way an address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Email Use Descr
DescriptionIndicates the way an address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 End Dt
DescriptionThe date upon which the organization becomes unavailable for use.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Equipment Type Cd
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Equipment Type Code Descr
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Equipment Type Code Sk
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Equipment Type Descr
DescriptionIndicates the kind of telephone represented by the number.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 External Ind
DescriptionIndicates if this organization is external or part of the enterprise.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fiscal Year End
DescriptionThe day and month upon which the company's fiscal year ends.
Data TypeStandards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Foundation Dt
DescriptionThe date upon which the organization was founded or created.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Franchised Ind
DescriptionIndicates whether or not the organization has a franchise for one or more companies.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Full Nm
DescriptionThe complete name (first, middle, last) for a person.
Data TypeStandards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Business Unit Cd
DescriptionIdentifies the organization business unit for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Business Unit Code Descr
DescriptionIdentifies the organization business unit for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Business Unit Code Sk
DescriptionIdentifies the organization business unit for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Department Cd
DescriptionIdentifies the organization department for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Department Code Descr
DescriptionIdentifies the organization department for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Department Code Sk
DescriptionIdentifies the organization department for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Location Cd
DescriptionIdentifies the organization location for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Location Code Descr
DescriptionIdentifies the organization location for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 GL Location Code Sk
DescriptionIdentifies the organization location for general ledger reference.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Group Size
DescriptionThe size of a group practice, to which a provider affiliation group belongs.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Group Type Cd
DescriptionThe type of provider affiliation group to which a healthcare provider belongs.

For example:
Anesthesiologists
Physicians
Radiologists
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Group Type Code Descr
DescriptionThe type of provider affiliation group to which a healthcare provider belongs.

For example:
Anesthesiologists
Physicians
Radiologists
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Group Type Code Sk
DescriptionThe type of provider affiliation group to which a healthcare provider belongs.

For example:
Anesthesiologists
Physicians
Radiologists
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Guideline Compliance Rating Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Guideline Compliance Rating Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Guideline Compliance Rating Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Healthcare Provider Specialty Cd
DescriptionIndicates the primary form of health treatment or service provided by the healthcare provider organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Healthcare Provider Specialty Code Descr
DescriptionIndicates the primary form of health treatment or service provided by the healthcare provider organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Healthcare Provider Specialty Code Sk
DescriptionIndicates the primary form of health treatment or service provided by the healthcare provider organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Health Rating Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Health Rating Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Health Rating Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 HIBCC Subscriber Ind
DescriptionIndicates if the organization subscribes to the Health Industry Business Communication Council.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 HIN Status Cd
DescriptionIndicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN).
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 HIN Status Code Descr
DescriptionIndicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN).
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 HIN Status Code Sk
DescriptionIndicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN).
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 HIN Status Descr
DescriptionIndicates the status of the organization in the NIH Heart, Lung and Blood Institute Health Information Network (HIN).
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Language Cd
DescriptionIndicates the natural language used in communication with the organization.

For example:
Chinese
Dutch
French
Japanese
US English
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Language Code Descr
DescriptionIndicates the natural language used in communication with the organization.

For example:
Chinese
Dutch
French
Japanese
US English
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Language Code Sk
DescriptionIndicates the natural language used in communication with the organization.

For example:
Chinese
Dutch
French
Japanese
US English
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Leapfrog Safe Practices Score
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Maximum Message Size
DescriptionThe maximum size (in bytes) of an e-mail accepted by the email address. The size includes the body, all headers and attachments.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Membership Fee
DescriptionThe monetary amount of a single fee paid to become a member of an organization or affinity group.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Cd
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Code Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Code Sk
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Type Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Cd
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Code Descr
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Code Sk
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Name Usage Descr
DescriptionIndicates how a role player uses a name.

For example:
Default
Mailing
Legal
DBA
Alias
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 National Provider Identifier Num
DescriptionNational Provider Identifier (NPI).
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Beds Licensed
DescriptionRegistered number of licensed beds in a hospital.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Customers
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Employees
DescriptionA count of persons employed by the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Members
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Outlets
DescriptionA count of the outlets (customer touch point locations) owned or operated by the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Online Fee Access Ind
DescriptionIndicates whether a healthcare provider's fees are viewable online by health plan members, potential members or other patients.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Legal Form Cd
DescriptionIndicates the legal form or structure of the organization.

For example:
Limited company
Public limited company
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Legal Form Code Descr
DescriptionIndicates the legal form or structure of the organization.

For example:
Limited company
Public limited company
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Legal Form Code Sk
DescriptionIndicates the legal form or structure of the organization.

For example:
Limited company
Public limited company
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Master Num
DescriptionUniversal business identifier for the Organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Purpose Cd
DescriptionIndicates the purpose or format of the organization.

For example:
Supporting dangerous hobbies
Travel assistance
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Purpose Code Descr
DescriptionIndicates the purpose or format of the organization.

For example:
Supporting dangerous hobbies
Travel assistance
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Purpose Code Sk
DescriptionIndicates the purpose or format of the organization.

For example:
Supporting dangerous hobbies
Travel assistance
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Status Reason Cd
DescriptionIndicates the reason why an organization is currently in a given organization status.

For example:
Risky investment
Insolvent
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Status Reason Code Descr
DescriptionIndicates the reason why an organization is currently in a given organization status.

For example:
Risky investment
Insolvent
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Status Reason Code Sk
DescriptionIndicates the reason why an organization is currently in a given organization status.

For example:
Risky investment
Insolvent
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Type Cd
DescriptionIndicates the kind of organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Type Code Descr
DescriptionIndicates the kind of Organization represented by the anchor row
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Type Code Sk
DescriptionIndicates the kind of Organization represented by the anchor row
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Organization Type Descr
DescriptionThe description of the kind of organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Outcomes Performance Rating Cd
DescriptionIndicates the performance of the healthcare provider with respect to outcomes.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outcomes Performance Rating Code Descr
DescriptionIndicates the performance of the healthcare provider with respect to outcomes.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outcomes Performance Rating Code Sk
DescriptionIndicates the performance of the healthcare provider with respect to outcomes.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outpatient Clinic Type Cd
DescriptionIndicates the nature of the services provided in an outpatient clinic.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outpatient Clinic Type Code Descr
DescriptionUniquely represents the services provided in an outpatient clinic.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outpatient Clinic Type Code Sk
DescriptionUniquely represents the services provided in an outpatient clinic.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Outpatient Clinic Type Descr
DescriptionThe description of the Outpatient Clinic Type.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Party Introduction Method Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Party Introduction Method Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Party Introduction Method Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Performance Rating Cd
DescriptionIndicates the performance of the healthcare provider with respect to the safety of its patients.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Performance Rating Code Descr
DescriptionIndicates the performance of the healthcare provider with respect to the safety of its patients.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Safety Performance Rating Code Sk
DescriptionIndicates the performance of the healthcare provider with respect to the safety of its patients.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pharmacy Nm
DescriptionThe name of the pharmacy.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Area Cd
DescriptionIndicates the area code for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Phone Area Code [VARCHAR(8)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Country Cd
DescriptionIndicates the country code for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Phone Country Code [CHAR(3)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Exchange Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Phone Exchange Code [VARCHAR(3)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Extension Num
DescriptionA suffix for a telephone number to reach a specific phone in a main telephone network
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Line Num
DescriptionRepresents 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Num
DescriptionRepresents the actual number (without formatting) for the telephone, cell, or pager number.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Speed Dial Num
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Text Descr
DescriptionFree form textual comments with respect to the telephone number.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Type Cd
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Type Code Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Type Code Sk
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Type Descr
DescriptionIdentifies the type of the relationship as defined in the business data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Use Cd
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Use Code Descr
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Use Code Sk
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Phone Use Descr
DescriptionIndicates the way a telephone number is used by a party.

For example:
Default
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Postal Cd
DescriptionZip code and International Postal Code for the address.
Data TypeStandards - Data Domains.ddm/Data Domains/Postal Code [VARCHAR(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Preferred Payment Method Cd
DescriptionIndicates the preferred method of payment of the party.

For example:
Cash
Credit card
Direct debit
Standing order
Transfer
Check
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Preferred Payment Method Code Descr
DescriptionIndicates the preferred method of payment of the party.

For example:
Cash
Credit card
Direct debit
Standing order
Transfer
Check
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Preferred Payment Method Code Sk
DescriptionIndicates the preferred method of payment of the party.

For example:
Cash
Credit card
Direct debit
Standing order
Transfer
Check
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Prescriber Ind
DescriptionIndicates that the healthcare provider is authorized to prescribe drugs. For example, a physician or other clinician.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Previous Refusal Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Role Cd
DescriptionIndicates the main purpose of the party in relation to the modeled organization.

For example:
Intermediary
Member
Premium payer
Solicitor
Subscriber
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Role Code Descr
DescriptionIndicates the main purpose of the party in relation to the modeled organization.

For example:
Intermediary
Member
Premium payer
Solicitor
Subscriber
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Primary Role Code Sk
DescriptionIndicates the main purpose of the party in relation to the modeled organization.

For example:
Intermediary
Member
Premium payer
Solicitor
Subscriber
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Professional Service Area Cd
DescriptionUniquely represents the service provided by a physician or center
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Professional Service Area Code Descr
DescriptionUniquely represents the service provided by a physician or center
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Professional Service Area Code Sk
DescriptionUniquely represents the service provided by a physician or center
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Professional Service Area Descr
DescriptionUniquely represents the service provided by a physician or center
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Profit After Tax
DescriptionThe monetary amount of the most recently reported profit after tax for the company.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Affiliation Group Descr
DescriptionIndicates a description of the provider affiliation group.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Affiliation Group Nm
DescriptionIndicates name of the provider affiliation group.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Affiliation Group Size
DescriptionThe size of a group practice, to which a provider affiliation group belongs.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Affiliation Group Type Cd
DescriptionIndicates the type of provider affiliation group to which a healthcare provider belongs.

For example:
Anesthesiologists
Physicians
Radiologists
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Affiliation Group Type Code Descr
DescriptionIndicates the type of provider affiliation group to which a healthcare provider belongs.

For example:
Anesthesiologists
Physicians
Radiologists
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Affiliation Group Type Code Sk
DescriptionIndicates the type of provider affiliation group to which a healthcare provider belongs.

For example:
Anesthesiologists
Physicians
Radiologists
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Descr
DescriptionA textual description of the organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Provider Hierarchy Category Nm
DescriptionIdentifies the organization category to which the Provider is attached. Examples would be Wholly owner facilities, joint venture facilities, affiliated clinics.
Data TypeStandards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Hierarchy Region Nm
DescriptionIdentifies the organizational region to which the Provider is attached.
Data TypeStandards - Data Domains.ddm/Data Domains/Login Name [VARCHAR(75)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Hierarchy System Nm
DescriptionIdentifies the system or network to which the Provider is attached.
Data TypeStandards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Network Descr
DescriptionIndicates a description of the provider network group.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Network Nm
DescriptionIndicates name of the provider network.
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Service Share
DescriptionThe percentage of the healthcare provider's total patient load or revenue that is accounted for by the health plan organization's members.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Sk
DescriptionA numeric surrogate key used to uniquely identify entities in the atomic model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Status Cd
DescriptionIndicates the current state of the organization. It is used for all statuses other than foundation and dissolution.

For example:
Trading
Liquidated
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Status Code Descr
DescriptionIndicates the current state of the organization. It is used for all statuses other than foundation and dissolution.

For example:
Trading
Liquidated
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Status Code Sk
DescriptionIndicates the current state of the organization. It is used for all statuses other than foundation and dissolution.

For example:
Trading
Liquidated
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Status Descr
DescriptionIndicates the current state of the organization. It is used for all statuses other than foundation and dissolution.

For example:
Trading
Liquidated
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Public Private Ind
DescriptionIndicates whether the organization is publicly or privately funded.

For example:
Private
Public
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Retail Pharmacy Segment Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Retail Pharmacy Segment Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Retail Pharmacy Segment Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Revenue
DescriptionThe monetary amount of the total income received by a company over a period of one year.
Data TypeStandards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Cd
DescriptionThe code that corresponds to the Source Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Descr
DescriptionThe description that corresponds to the Source Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Staffing Type Cd
DescriptionIndicates the manner in which the organization is staffed.

For example:
Employees
Family-Run
Volunteers
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Staffing Type Code Descr
DescriptionIndicates the manner in which the organization is staffed.

For example:
Employees
Family-Run
Volunteers
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Staffing Type Code Sk
DescriptionIndicates the manner in which the organization is staffed.

For example:
Employees
Family-Run
Volunteers
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 State Province Cd
DescriptionIndicates the state or province for the address using a recognized set of codes or abbreviations.
Data TypeStandards - Data Domains.ddm/Data Domains/State Code [CHAR(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Taxonomy Cd
DescriptionIdentifies the provider type, classification, and specialization.

For example:
Family medicine
Surgery
Ophthalmology
Oncology
Anesthesiology
Gynecology
Internal medicine
Emergent medicine
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Taxonomy Code Descr
DescriptionIdentifies the provider type, classification, and specialization.

For example:
Family medicine
Surgery
Ophthalmology
Oncology
Anesthesiology
Gynecology
Internal medicine
Emergent medicine
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Taxonomy Code Sk
DescriptionIdentifies the provider type, classification, and specialization.

For example:
Family medicine
Surgery
Ophthalmology
Oncology
Anesthesiology
Gynecology
Internal medicine
Emergent medicine
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Teaching Institution Ind
DescriptionIndicates that an institutional provider provides clinical training for medical students.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Teaching Provider Ind
DescriptionIndicates that the provider is a teaching organization.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Teaching Type Cd
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Teaching Type Code Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Teaching Type Code Sk
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Teaching Type Descr
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Text Only Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Turnover
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Type Cd
DescriptionThe code that corresponds to the Type Code Sk.
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Code Descr
DescriptionThe description that corresponds to the Type Cd.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Code Sk
DescriptionThe code identifying the actual type of the entity as per the type hierarchy defined in the analysis data model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Type Of Pharmacy Cd
DescriptionIndicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital.

For example:
Hospital
Mail
Retail
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Type Of Pharmacy Code Descr
DescriptionIndicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital.

For example:
Hospital
Mail
Retail
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Type Of Pharmacy Code Sk
DescriptionIndicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital.

For example:
Hospital
Mail
Retail
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes 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 TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Validity Check Dt
DescriptionThe date on which the validity of the contact preference was last checked.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Validity Check Result Cd
DescriptionThe conclusion of the most recent validity check.

For example:
Invalid
Invalid but accepted
Valid
Data TypeStandards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Validity Check Result Code Descr
DescriptionThe conclusion of the most recent validity check.

For example:
Invalid
Invalid but accepted
Valid
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Validity Check Result Code Sk
DescriptionThe conclusion of the most recent validity check.

For example:
Invalid
Invalid but accepted
Valid
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Primary Key Details

 Provider Dimension PK
Key AttributeProvider Dk