Atomic Warehouse Model Data Model

Entity

Entity Practitioner Detail

Description

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

Attributes
Accepting New Patients Ind
Date Of Death Ts
Deactivate Dt
DEA Identification Num
Disallow Autofill Ind
Effective From Dt
Effective To Dt
Employee Ind
End Dt
Formulary Compliance Rating
Government Billing Eligibility Code Sk
Load Info Sk
Medically Certified Ind
NPI Num
PPS Hold Ind
Practitioner End Date
Practitioner Sk
Practitioner Start Date
Preferred Contact Method Code Sk
Primary Discipline Code Sk
Restriction Status Cd
Retire Dt
Signs Inital Plan Of Care Ind
Signs Verbal Orders Ind
Source Code Sk
Start Dt
Status Code Sk
Target Productivity Cnt
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
is Detail for

Primary Key
Practitioner Detail 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

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

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

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

Employee Ind

Description	Indicates if the practitioner is an employee.
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

End Dt

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

Formulary Compliance Rating

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/Enumeration [VARCHAR(20)]
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

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

Medically Certified Ind

Description	Indicates if this person has been formally trained to provide medical services.
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

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

PPS Hold Ind

Description	Indicates if procedures are held for prospective payment system (PPS) processing.
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

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 Sk

Description	The ID assigned to uniquely identify all staff associated with provider, research, clinical care and associated users of the system.
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	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 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

Primary Discipline Code Sk

Description	Indicates the leading medical skill area for the practitioner.
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 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/Enumeration [VARCHAR(20)]
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

Signs Inital Plan Of Care Ind

Description	Indicates if this practitioner signs or is authorized to sign the initial care plan for a patient.
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

Signs Verbal Orders Ind

Description	Indicates if the practitioner can sign to verify a verbal order.
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

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

Status Code Sk

Description	Indicates the current state of an individual in relation to the practice of medical care. For example: Active Inactive Retired Suspended
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

Target Productivity Cnt

Description	A goal for amount of health care to be delivered within a practitioner's primary specialty. This may be expressed in number of patients, encounters or procedures or in some work measure equivalent such as relevant value units (RVUs).
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

is Detail for

Is Identifying Relationship	true
Child Table	Practitioner Detail
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
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Practitioner Detail PK

Key Attribute	Practitioner Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model