Dimensional Warehouse Model Data Model

Entity

Entity Practitioner Dimension

Description

A doctor, nurse, pharmacist, therapist, or other health professional that provides medical care.

Attributes
Accepting New Patients Ind
Address Line 1 Descr
Address Line 2 Descr
Address Line 3 Descr
Address Line 4 Descr
Address Type Cd
Address Type Code Sk
Address Type Descr
Address Use Cd
Address Use Code Sk
Address Use Descr
AWM Load Info Sk
City Nm
Country Nm
County Nm
Current Ind
Date Of Death Ts
Deactivate Dt
DEA Identification Num
Degree Nm
Disallow Autofill Ind
Display Nm
DWM Load Info Sk
Effective From Dt
Effective To Dt
Email Address Resource Locator Nm
Email Type Cd
Email Type Code Sk
Email Type Descr
Email Use Cd
Email Use Code Sk
Email Use Descr
End Dt
Equipment Type Cd
Equipment Type Code Sk
Equipment Type Descr
First Nm
Formulary Compliance Rating Cd
Formulary Compliance Rating Code Descr
Formulary Compliance Rating Code Sk
Full Nm
Government Billing Eligibility Cd
Government Billing Eligibility Code Sk
Government Billing Eligibility Descr
Last Nm
Middle Nm
Name Type Cd
Name Type Code Sk
Name Type Descr
National Provider Identifier Num
NPI Num
Phone Area Cd
Phone Country Cd
Phone Exchange Cd
Phone Extension Num
Phone Line Num
Phone Num
Phone Speed Dial Num
Phone Type Cd
Phone Type Code Sk
Phone Type Descr
Phone Use Cd
Phone Use Code Sk
Phone Use Descr
Postal Cd
Practitioner Bk
Practitioner Dk
Practitioner End Date
Practitioner Primary Specialty Dk
Practitioner Primary Specialty Sk
Practitioner Sk
Practitioner Start Date
Preferred Contact Method Cd
Preferred Contact Method Code Sk
Preferred Contact Method Descr
Prefix Nm
Primary Clinic DEA Num
Primary Specialty Cd
Primary Specialty Code Sk
Primary Specialty Descr
Primary Specialty Nm
Restriction Status Cd
Restriction Status Code Sk
Restriction Status Descr
Retail Location Num
Retire Dt
Social Security Num
Source Cd
Source Code Descr
Source Code Sk
Start Dt
State Province Cd
Suffix Nm
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Practitioner Dimension_Practitioner Specialty Dimension_FK

Primary Key
Practitioner Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Accepting New Patients Ind

Description	Indicates whether or not a practitioner, designated as a primary care provider, is accepting new 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

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 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 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	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

Address 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

Address 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

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

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

Country Nm

Description	Name of the country for the address.
Data Type	Standards - Data Domains.ddm/Data Domains/Area Name [VARCHAR(50)]
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

Date Of Death Ts

Description	The date and time the practitioner died.
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

Deactivate Dt

Description	Date the practitioner's status is set to inactive.
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

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

Degree Nm

Description	The party name component indicating degrees and certifications a Party uses in their formal name.
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

Disallow Autofill Ind

Description	Indicates that the practitioner is not permitted to write autofill prescriptions.
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

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

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

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 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 email 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 Sk

Description	Indicates the way an email 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 email 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 the practitioner ended or intends to end practicing at the given institution (e.g., at hospital, at physician organization, at managed care network).
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 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

First Nm

Description	First name of a person.
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

Formulary Compliance Rating Cd

Description	Indicates a rating based on the number of prescriptions issued by a practitioner that comply with the health care organization's pharmaceutical formulary.
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

Formulary Compliance Rating Code Descr

Description	Indicates a rating based on the number of prescriptions issued by a practitioner that comply with the health care organization's pharmaceutical formulary.
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

Formulary Compliance Rating Code Sk

Description	Indicates a rating based on the number of prescriptions issued by a practitioner that comply with the health care organization's pharmaceutical formulary.
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

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

Government Billing Eligibility Cd

Description	Identifies the agency that the practitioner is authorized to bill for medical services.
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

Government Billing Eligibility Code Sk

Description	Identifies the agency that the practitioner is authorized to bill for medical services.
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

Government Billing Eligibility Descr

Description	Identifies the agency that the practitioner is authorized to bill for medical services.
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

Last Nm

Description	Last name of a person.
Data Type	Standards - Data Domains.ddm/Data Domains/Last Name [VARCHAR(75)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Middle Nm

Description	The middle name of 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

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 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

National Provider Identifier Num

Description	The national provider identifier (NPI) of an individual practitioner.
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

NPI Num

Description	The national provider identifier (NPI) of an individual practitioner.
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 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 Type Cd

Description	Represents the type of telephone for example home, office, cellular, pager.
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 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 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

Practitioner 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

Practitioner 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

Practitioner End Date

Description	The date upon which the practitioner ceases to practice at the associated provider organization or facility such as hospital, physician organization, managed care network.
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

Practitioner Primary Specialty 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	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Practitioner Primary Specialty 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

Practitioner 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

Practitioner Start Date

Description	The date upon which the practitioner starts to practice at the associated provider organization or facility such as hospital, physician organization, managed care network.
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

Preferred Contact Method Cd

Description	Indicates the preferred method to use when communicating with a practitioner. For example: Beeper Number Cellular Phone Number E-Mail Address FAX Number Home Phone Number Office Phone 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

Preferred Contact Method Code Sk

Description	Indicates the preferred method to use when communicating with a practitioner. For example: Beeper Number Cellular Phone Number E-Mail Address FAX Number Home Phone Number Office Phone 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

Preferred Contact Method Descr

Description	Indicates the preferred method to use when communicating with a practitioner. For example: Beeper Number Cellular Phone Number E-Mail Address FAX Number Home Phone Number Office Phone 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

Prefix Nm

Description	A prefix name refers to titles that precede a name. For Example: Mr. Mrs. Ms. Miss Dr.
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

Primary Clinic DEA Num

Description	DEA number for the primary medical patient care location for this practitioner.
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

Primary Specialty Cd

Description	Indicates the provider or practitioner's specialty.
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 Specialty Code Sk

Description	Indicates the provider or practitioner's specialty.
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

Primary Specialty Descr

Description	Indicates the provider or practitioner's specialty.
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 Specialty Nm

Description	The description of this Code.
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

Restriction Status Cd

Description	Indicates the current state of any permanent or temporary prohibitions a doctor is under against practicing given forms of 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

Restriction Status Code Sk

Description	Indicates the current state of any permanent or temporary prohibitions a doctor is under against practicing given forms of 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

Restriction Status Descr

Description	Indicates the current state of any permanent or temporary prohibitions a doctor is under against practicing given forms of 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

Retail Location Num

Description	Primary place of care delivery for retail practitioners, especially pharmacists.
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

Retire Dt

Description	The date upon which the practitioner ceases to be an active practitioner at a facility due to retirement.
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

Social Security Num

Description	Primary alpha-numeric identifier for a role player's registration
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

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

Start Dt

Description	The date the practitioner began practicing at the present institution (e.g., at hospital, at physician organization, at managed care network).
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

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

Suffix Nm

Description	A name suffix follows a person's full name and provides additional information about the person. For Example: Jr for Junior MD for Medical Doctor
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

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

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

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

Relationship Details

Practitioner Dimension_Practitioner Specialty Dimension_FK

Is Identifying Relationship	false
Child Table	Practitioner Dimension
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Specialty Dimension
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Practitioner Dimension PK

Key Attribute

Practitioner Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model