Atomic Warehouse Model Data Model

Entity

Entity Service Detail

Description

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

Attributes
Benefits Assigned Ind
Capitated Service Ind
Description
DME Certification Type Code Sk
Duration Cnt
Duration Unit Code Sk
Effective From Dt
Effective To Dt
Event Num
Event Seq
Insulin Dependent Code Sk
Level Of Service Rating Code Sk
Load Info Sk
Medical Service Purchased Service Ind
Name
Occurred Ts
Out Of Area Treatment Ind
Performed At Patient Home Ind
Planned Ts
Recorded Ts
Related Hospitalization Discharge Dt
Request Dt
Service Code Sk
Service Descr
Service Sk
Shipped Dt
Source Code Sk
Tenant Sk
Transport Distance Qty
Transported Patient Cnt
Transport Type Code Sk
Type Code Sk
Urgency Rating Code Sk
Valid From Ts
Valid To Ts

Relationship
Ancillary Service Detail_Ancillary Service_FK

Primary Key
Service Detail PK

Dependencies

Reverse Dependencies

Attribute Details

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

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

DME Certification Type Code Sk

Description	Indicates the type of the certification for the use of this durable medical equipment or ancillary 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

Duration Cnt

Description	Length of time the durable medical equipment or ancillary services is required.
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 Unit Code Sk

Description	Indicates the unit of measure in which the duration is expressed. For example: Hours Days Months
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

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

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

Insulin Dependent Code Sk

Description	Indicates the nature of insulin dependence relative to this durable medical equipment or ancillary 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

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

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

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

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

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	false
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	Indicates the date upon which the Healthcare Event was requested.
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

Service Code Sk

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

Service Descr

Description	Descriptive text for the use of this durable medical equipment or ancillary 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

Service Sk

Description	Surrogate key for the anchor entity.
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

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

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

Transported Patient Cnt

Description	The number of patients transported.
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

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

Description	Identifies the actual type of the entry based on the entity type hierarchy defined in the business 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 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	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

Ancillary Service Detail_Ancillary Service_FK

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

Primary Key Details

Service Detail PK

Key Attribute	Service Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model