Atomic Warehouse Model Data Model

Entity

Entity Provider Detail

Description

An organization that provides some aspect of medical care.

Attributes
Accesses Personal Health Records Ind
Accounting Period End Dt
Accounting Period Start Dt
Aggregate Performance Score
Annual Revenue
Bed Size Cnt
Center of Excellence Ind
CLIA Certified Code Sk
CLIA Certified Ind
CMS Branch Id Num
CMS Branch State Code Sk
CMS Certification Num
Company Type Code Sk
Competitor Ind
DEA Identification Num
Dissolution Dt
DUNS Num
Effective From Dt
Effective To Dt
Electronic Medical Records Ind
End Dt
External Ind
Fiscal Year End
Foundation Dt
Franchised Ind
GL Business Unit Code Sk
GL Department Code Sk
GL Location Code Sk
Guideline Compliance Rating Code Sk
Healthcare Provider Specialty Code Sk
Health Rating Code Sk
HIN Status Code Sk
Language Code Sk
Leapfrog Safe Practices Score
Load Info Sk
Membership Fee
NPI Num
Number Of Beds Licensed
Number Of Customers
Number Of Employees
Number Of Members
Number Of Outlets
Online Fee Access Ind
Organization Descr
Organization Legal Form Code Sk
Organization Master Num
Organization Purpose Code Sk
Organization Sk
Organization Status Code Sk
Organization Status Reason Code Sk
Organization Type Code Sk
Outcomes Performance Rating Code Sk
Outpatient Clinic Type Code Sk
Party Introduction Method Code Sk
Patient Safety Performance Rating Code Sk
Pharmacy Nm
Preferred Payment Method Code Sk
Prescriber Ind
Previous Refusal Ind
Primary Role Code Sk
Professional Service Area Code Sk
Profit After Tax
Provider Service Share
Public Private Ind
Retail Pharmacy Segment Code Sk
Revenue
Source Code Sk
Staffing Type Code Sk
Taxonomy Code Sk
Teaching Institution Ind
Teaching Type Code Sk
Tenant Sk
Turnover
Type Of Pharmacy Code Sk
Valid From Ts
Valid To Ts

Relationship
Organization Detail_Organization_FK

Primary Key
Provider Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Accesses Personal Health Records Ind

Description	Indicates that the healthcare provider accesses the Personal Health Records (PHR) of its patients.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Accounting Period End Dt

Description	Date upon which the accounting period of the organization ends. Indicates the last date for which account entries will be reported as within the accounting period.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Accounting Period Start Dt

Description	Date upon which the accounting period of the organization starts.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Aggregate Performance Score

Description	The aggregate score after adding together all individual performance measures for a healthcare provider.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Annual Revenue

Description	The approximate monetary amount of the organization's annual revenue. This is typically based on published accounts unless the organization is a subsidiary or affiliate of the modeled healthcare organization in which case revenue values may be derived from management accounts.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Bed Size Cnt

Description	The total number of beds in a health care facility.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Center of Excellence Ind

Description	Indicates that a hospital or other institutional provider has one or more externally recognized centers of excellence.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

CLIA Certified Code Sk

Description	Indicates that the laboratory is certified under the Clinical Laboratory Improvement Amendments (CLIA) program. The Centers for Medicare & Medicaid Services (CMS) regulates all laboratory testing (except research) performed on humans in the U.S. through the Clinical Laboratory Improvement Amendments (CLIA).
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

CLIA Certified Ind

Description	Indicates if the provider is certified under the Clinical Laboratory Improvement Amendments (CLIA) program.The Centers for Medicare & Medicaid Services (CMS) regulates all laboratory testing (except research) performed on humans in the U.S. through the Clinical Laboratory Improvement Amendments (CLIA).
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

CMS Branch Id Num

Description	Specifies the branch identification code, as assigned by Centers for Medicare and Medicaid Services (CMS). The identifier consists of 10 digits – the State code as the first two digits, followed by Q (upper case), followed by the last four digits of the current Medicare provider number, ending with the three-digit CMS-assigned branch 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

CMS Branch State Code Sk

Description	Indicates the standard code for states or provinces assigned by the Centers for Medicare and Medicaid Services (CMS).
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

CMS Certification Num

Description	Specifies the agency’s Centers for Medicare and Medicaid Services (CMS) certification number (CCN/Medicare provider 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

Company Type Code Sk

Description	Indicates the primary type of activity undertaken by the organization. For example: Mail Order Company Pharmacy Company
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Competitor Ind

Description	Indicates whether or not the organization competes with the modeled healthcare organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Dissolution Dt

Description	The date upon which this organization ceased to legally exist.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

DUNS Num

Description	The number assigned to the organization by Dun & Bradstreet.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Electronic Medical Records Ind

Description	Indicates if the provider retains and uses electronic records for distributing patient data.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

End Dt

Description	The date upon which the organization becomes unavailable for use.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

External Ind

Description	Indicates if this organization is external or part of the modeling enterprise.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Fiscal Year End

Description	The day and month upon which the company's fiscal year ends.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Foundation Dt

Description	The date upon which the organization was founded or created.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Franchised Ind

Description	Indicates whether or not the organization has a franchise for one or more companies.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

GL Business Unit Code Sk

Description	Identifies the organization business unit for general ledger reference.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

GL Department Code Sk

Description	Identifies the organization department for general ledger reference.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

GL Location Code Sk

Description	Identifies the organization location for general ledger reference.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Guideline Compliance Rating Code Sk

Description	Indicates how often, based on applicable treatments, a healthcare provider renders care in accordance with applicable evidence-based clinical practice guidelines during a one year measurement period.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Healthcare Provider Specialty Code Sk

Description	Indicates the primary form of health treatment or service provided by the healthcare provider organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Health Rating Code Sk

Description	Indicates the general level of healthiness that applies to the party where the party is a person. For an organization, this may be an overall rating based on the individual Health Ratings of the organization's members.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

HIN Status Code Sk

Description	Indicates the status of the provider organization in the NIH Heart, Lung and Blood Institute HIN (Health Information Network).
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

Language Code Sk

Description	Indicates the natural language used in communication with the organization. For example: Chinese Dutch French Japanese US English
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Leapfrog Safe Practices Score

Description	The score given to the hospital by The Leapfrog Group on its Safe Practices Score. This measures the hospital's compliance with 27 given procedures to reduce preventable medical mistakes.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Membership Fee

Description	The monetary amount of a single fee paid to become a member of an organization or affinity group.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

NPI Num

Description	National Provider Identifier (NPI).
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Beds Licensed

Description	Registered number of licensed beds in a hospital.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Customers

Description	A count of the customers dealing with the organization. This information is derived and its value depends on the organization's definition of what a customer is.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Employees

Description	A count of persons employed by the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Members

Description	A count of people who are members of the organization. This number often is an approximate number, because the number of members may in general change over time without the modeled organization being brought up to date.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Outlets

Description	A count of the outlets (customer touch point locations) owned or operated by the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Online Fee Access Ind

Description	Indicates whether a healthcare provider's fees are viewable online by health plan members, potential members or other patients.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Descr

Description	A textual description of the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Legal Form Code Sk

Description	Indicates the legal form or structure of the organization. For example: Limited company Public limited company
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Master Num

Description	The universal business identifier for the organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Purpose Code Sk

Description	Indicates the purpose or format of the organization. For example: Supporting dangerous hobbies Travel assistance
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Sk

Description	Anchor surrogate key for the Organization data
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

Organization Status Code Sk

Description	Indicates the current state of the organization. It is used for all statuses other than foundation and dissolution. For example: Trading Liquidated
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Status Reason Code Sk

Description	Indicates the reason why an organization is currently in a given organization status. For example: Risky investment Insolvent
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Organization Type Code Sk

Description	Indicates the type of organization. For example: corporation government non-profit
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

Outcomes Performance Rating Code Sk

Description	Indicates the performance of the healthcare provider with respect to outcomes.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Outpatient Clinic Type Code Sk

Description	Indicates the nature of the services provided in an outpatient clinic.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Party Introduction Method Code Sk

Description	Indicates the manner in which the party is first introduced to the modeled organization. For example: Advertisement Business partner Mailshot campaign Newspaper Personal recommendation Television advertisement
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Safety Performance Rating Code Sk

Description	Indicates the performance of the healthcare provider with respect to the safety of its patients.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pharmacy Nm

Description	The name of the pharmacy.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preferred Payment Method Code Sk

Description	Indicates the preferred method of payment of the party. For example: Cash Credit card Direct debit Standing order Transfer Check
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Prescriber Ind

Description	Indicates that the healthcare provider is authorized to prescribe drugs. For example, a physician or other clinician.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Previous Refusal Ind

Description	Indicates whether (1) or not (0) the party has been refused a relationship with the modeled organization in the past. For example, a person may have been refused insurance or has had a policy cancelled or special terms imposed by a health insurance organization.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Primary Role Code Sk

Description	Indicates the main purpose of the party in relation to the modeled organization. For example: Intermediary Member Premium payer Solicitor Subscriber
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Professional Service Area Code Sk

Description	Uniquely represents the service provided by a physician or center
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Profit After Tax

Description	The monetary amount of the most recently reported profit after tax for the company.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Provider Service Share

Description	The percentage of the healthcare provider's total patient load or revenue that is accounted for by the health plan organization's members.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Public Private Ind

Description	Indicates whether the organization is publicly or privately funded. For example: Private Public
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Retail Pharmacy Segment Code Sk

Description	Indicates whether a retail pharmacy is independent or part of a retail pharmacy company or other organization. For example: Chain drug store Food store Independent Mass merchandiser
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Revenue

Description	The monetary amount of the total income received by a company over a period of one year.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Staffing Type Code Sk

Description	Indicates the manner in which the organization is staffed. For example: Employees Family-Run Volunteers
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Taxonomy Code Sk

Description	Identifies the provider type, classification, and specialization. For example: Family medicine Surgery Ophthalmology Oncology Anesthesiology Gynecology Internal medicine Emergent medicine
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Teaching Institution Ind

Description	Indicates that an institutional provider provides clinical training for medical students.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Teaching Type Code Sk

Description	Indicates the level of medical training offered at a provider facility. For example: Major teaching: Hospital is an important part of the teaching program of a medical school and the majority of medical students rotate through multiple clinical services. Graduate teaching: Hospital is used by the medical school for graduate training programs only; i.e., residency and/or fellowships. Limited teaching: Hospital is used in the medical school's teaching program only to a limited extent. Non teaching
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Turnover

Description	The frequency with which employees resign, are fired or retired from a company, usually computed as the percentage of a company's employees at the beginning of the calendar year.
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Type Of Pharmacy Code Sk

Description	Indicates whether the pharmacy dispenses drugs in a retail location, via the mail, or within a provider facility such as a hospital. For example: Hospital Mail Retail
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	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

Organization Detail_Organization_FK

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

Primary Key Details

Provider Detail PK

Key Attribute	Organization Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model