Dimensional Warehouse Model Data Model

Entity

Entity Service Dimension

Description

A healthcare event that involves the use, rental, purchase or supply of durable medical equipment or ancillary supports to a person.

Attributes
Ambulance Transport Reason Cd
Ambulance Transport Reason Code Sk
Ambulance Transport Reason Descr
AWM Load Info Sk
Benefits Assigned Ind
Capitated Service Ind
Certification Revision Dt
Current Ind
Delivery Pattern Time Cd
Delivery Pattern Time Code Sk
Delivery Pattern Time Descr
Description
Duration Of Visits Cnt
Duration of Visits Unit Cd
Duration Of Visits Unit Code Sk
Duration of Visits Unit Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Emergency Ind
Event Num
Event Seq
Frequency Cnt
Last Certification Dt
Last Service Dt
Level Of Service Rating Cd
Level Of Service Rating Code Descr
Level Of Service Rating Code Sk
Locale Country Cd
Locale Country Code Sk
Locale Country Descr
Locale Language Cd
Locale Language Code Sk
Locale Language Descr
Medical Service Purchased Service Ind
Name
Occurred Ts
Out Of Area Treatment Ind
Oxygen Flow Rate Qty
Oxygen Flow Rate UOM Cd
Oxygen Flow Rate UOM Code Sk
Performed At Patient Home Ind
Planned Ts
Reason Cd
Reason Code Sk
Reason Descr
Recorded Ts
Related Hospitalization Discharge Dt
Request Dt
Round Trip Purpose Descr
Service Bk
Service Cd
Service Code Sk
Service Delivery Pattern Cd
Service Delivery Pattern Code Sk
Service Delivery Pattern Descr
Service Descr
Service Dk
Service Sk
Shipped Dt
Source Cd
Source Code Descr
Source Code Sk
Stretcher Purpose Descr
Tenant Sk
Transport Distance Qty
Transport Distance UOM Cd
Transport Distance UOM Code Sk
Transport Type Cd
Transport Type Code Descr
Transport Type Code Sk
Type Cd
Type Code Descr
Type Code Sk
Urgency Rating Cd
Urgency Rating Code Descr
Urgency Rating Code Sk
Valid From Ts
Valid To Ts
Visit Cnt
X-Ray Availability Ind

Primary Key
Service Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Ambulance Transport Reason Cd

Description	Indicates the reason for an ambulance transport.
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

Ambulance Transport Reason Code Sk

Description	Indicates the reason for an ambulance transport.
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

Ambulance Transport Reason Descr

Description	Indicates the reason for an ambulance transport.
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

Benefits Assigned Ind

Description	Indicates whether the provider has authorization from the member patient, signed form or otherwise, authorizing the payer to pay the provider for services rendered. For example: Yes No
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

Capitated Service Ind

Description	Indicates whether the Healthcare Event is covered under a capitation agreement. For example: 0 = Non-Capitated Service 1 = Capitated Service
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

Certification Revision Dt

Description	The date upon which the healthcare event certification for the service was revised.
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

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

Delivery Pattern Time Cd

Description	Indicates the time delivery pattern of the services. For example: A.M. P.M. As Directed
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

Delivery Pattern Time Code Sk

Description	Indicates the time delivery pattern of the services. For example: A.M. P.M. As Directed
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

Delivery Pattern Time Descr

Description	Indicates the time delivery pattern of the services. For example: A.M. P.M. As Directed
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

Description

Description	The textual representation of information about an occurrence of Healthcare Event.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Duration Of Visits Cnt

Description	The number of units (month, week, etc.) over which home health visits occur. For example: 1 visit every 3 days for 21 days. This element indicates the number of units, in this case - 21 days.
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

Duration of Visits Unit Cd

Description	The type of unit (month, week, etc.) used to measure the duration of visits. For example: 1 visit every 3 days for 21 days. This element indicates the type of units, in this case - days.
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

Duration Of Visits Unit Code Sk

Description	The type of unit (month, week, etc.) used to measure the duration of visits. For example: 1 visit every 3 days for 21 days. This element indicates the type of units, in this case - days.
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

Duration of Visits Unit Descr

Description	The type of unit (month, week, etc.) used to measure the duration of visits. For example: 1 visit every 3 days for 21 days. This element indicates the type of units, in this case - days.
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

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

Emergency Ind

Description	Indicates whether emergency care was rendered in response to the sudden and unexpected onset of a medical condition, a severe injury, or an acute exacerbation of a chronic condition which was threatening to life, limb or sight.
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

Event Num

Description	A sequence of alphanumeric characters that uniquely identifies the event.
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

Event Seq

Description	A positive integer which when present can assist in determining the order of related events.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Frequency Cnt

Description	The count of the frequency units of home health visits. For example: 1 visit every 3 days for 21 days. This element indicates the frequency, in this case - 3 day intervals.
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

Last Certification Dt

Description	The most recent date upon which the service certification was completed.
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

Last Service Dt

Description	The most recent date upon which the certified service was provided.
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

Level Of Service Rating Cd

Description	An indication of the intensity of service involved in a particular Healthcare Event.
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

Level Of Service Rating Code Descr

Description	An indication of the intensity of service involved in a particular Healthcare Event.
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

Level Of Service Rating Code Sk

Description	An indication of the intensity of service involved in a particular Healthcare Event.
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

Locale Country Cd

Description	Indicates the country where the event has occurred. This can be used in determining aspects of the event that are locale specific.
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

Locale Country Code Sk

Description	Indicates the country where the event has occurred. This can be used in determining aspects of the event that are locale specific.
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

Locale Country Descr

Description	Indicates the country where the event has occurred. This can be used in determining aspects of the event that are locale specific.
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

Locale Language Cd

Description	Indicates the primary language of the event. All text fields contained in the event are assumed to be in this language.
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

Locale Language Code Sk

Description	Indicates the primary language of the event. All text fields contained in the event are assumed to be in this language.
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

Locale Language Descr

Description	Indicates the primary language of the event. All text fields contained in the event are assumed to be in this language.
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

Medical Service Purchased Service Ind

Description	Indicates whether a medical service was purchased directly from a third party organization where the Healthcare Provider cannot provide the given service itself.
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

Name

Description	The word or phrase identifying an occurrence of Healthcare Event.
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

Occurred Ts

Description	Date and time upon which the event actually occurred.
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

Out Of Area Treatment Ind

Description	Indicates whether or not the healthcare event occurred outside of the healthcare organization's normal service area or geography in which they normally do business. For example: 0 = In Area Treatment 1 = Out Of Area Treatment
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

Oxygen Flow Rate Qty

Description	The oxygen flow rate typically expressed in liters per minute.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Oxygen Flow Rate UOM Cd

Description	Identifies the units in which the Oxygen Flow Rate is measured. Common Units are Liters per Minute.
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

Oxygen Flow Rate UOM Code Sk

Description	Identifies the units in which the Oxygen Flow Rate is measured. Common Units are Liters per Minute.
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

Performed At Patient Home Ind

Description	Indicates whether the healthcare event occurred in the patient's residence, outside any healthcare facility. For example: Yes No
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

Planned Ts

Description	The date and time of upon which the event was planned to take place.
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

Reason Cd

Description	Indicates the reason for a procedure being carried out. A procedure can be triggered at a patient's or practitioner's request and is normally done on the basis of medical need.
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

Reason Code Sk

Description	Indicates the reason for a procedure being carried out. A procedure can be triggered at a patient's or practitioner's request and is normally done on the basis of medical need.
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

Reason Descr

Description	Indicates the reason for a procedure being carried out. A procedure can be triggered at a patient's or practitioner's request and is normally done on the basis of medical need.
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

Recorded Ts

Description	The date and time upon which the event was recorded in the clinical system.
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

Related Hospitalization Discharge Dt

Description	The date upon which the patient was discharged from the inpatient care related to current service.
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

Request Dt

Description	The date upon which the request is made.
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

Round Trip Purpose Descr

Description	A free form description of the purpose of the ambulance transport round trip.
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

Service 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

Service Cd

Description	Indicates the nature of an event. For example: Clinical event Patient safety event
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

Service Code 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 [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Delivery Pattern Cd

Description	Indicates the delivery schedule pattern of the services. For example: 1st Week of the Month 1st & 3rd Weeks of the Month Monday through Friday Tuesday through Saturday Whenever Necessary
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

Service Delivery Pattern Code Sk

Description	Indicates the delivery schedule pattern of the services. For example: 1st Week of the Month 1st & 3rd Weeks of the Month Monday through Friday Tuesday through Saturday Whenever Necessary
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

Service Delivery Pattern Descr

Description	Indicates the delivery schedule pattern of the services. For example: 1st Week of the Month 1st & 3rd Weeks of the Month Monday through Friday Tuesday through Saturday Whenever Necessary
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

Service Descr

Description	Indicates the nature of an event. For example: Clinical event Patient safety event
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

Service 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

Service 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

Shipped Dt

Description	Date upon which the durable medical piece of equipment is shipped to the patient.
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

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

Stretcher Purpose Descr

Description	A free form description of the purpose of the use of a stretcher during ambulance service.
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

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

Transport Distance Qty

Description	Distance traveled during the ambulance transport.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transport Distance UOM Cd

Description	Identifies the unit of measure in which the transport distance is reported. Common Units are Miles or Kilometers.
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

Transport Distance UOM Code Sk

Description	Identifies the unit of measure in which the transport distance is reported. Common Units are Miles or Kilometers.
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

Transport Type Cd

Description	Indicates the type of the transport.
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

Transport Type Code Descr

Description	Indicates the type of the transport.
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

Transport Type Code Sk

Description	Indicates the type of the transport.
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

Type Cd

Description	The code that corresponds to the Type Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Type Code Descr

Description	The description that corresponds to the Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Type Code Sk

Description	The code identifying the actual type of the entity as per the type hierarchy defined in the analysis data model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Urgency Rating Cd

Description	An indication of the urgency of a particular Healthcare Event.
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

Urgency Rating Code Descr

Description	An indication of the urgency of a particular Healthcare Event.
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

Urgency Rating Code Sk

Description	An indication of the urgency of a particular Healthcare Event.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

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

Visit Cnt

Description	The number of home health visits. e.g.: 1 visit every 3 days for 21 days. This element indicates the number of visits, in this case - 1 visit.
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

X-Ray Availability Ind

Description	Indicates if X-Ray images are on file for the 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

Primary Key Details

Service Dimension PK

Key Attribute

Service Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model