Atomic Warehouse Model Data Model

Entity

Entity Appointment Detail

Description

An appointment is an administrative arrangement that enables patients to see a healthcare practitioner on a set date and time. An appointment is used to deliver patient care.

Attributes
Appointment Duration Qty
Appointment Duration Unit Code Sk
Appointment Reason Code Sk
Appointment Sk
Appointment Type Code Sk
Effective From Dt
Effective To Dt
Encounter Sk
Filler Appointment Id
Filler Status Code Sk
Load Info Sk
Occurrence Num
Parent Filler Appointment Id
Parent Placer Appointment Id
Patient Sk
Placer Appointment Id
Placer Group Num
Priority
Repeating Interval
Repeating Interval Duration Descr
Request Event Reason Code Sk
Schedule Code Sk
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Appointment Detail_Appointment_FK

Primary Key
Appointment Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Appointment Duration Qty

Description	The amount of time requested and allotted for the appointment.This is the duration of one instance of the appointment when there are repeating appointments.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Appointment Duration Unit Code Sk

Description	Time units of measure associated with duration of the appointment.
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

Appointment Reason Code Sk

Description	Identifies the reason for the appointment. This contains a Universal Service ID describing the observation,test,procedure or other activity that is to take place during the requested appointment.
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

Appointment Sk

Description	Surrogate Key for Appointment.
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

Appointment Type Code Sk

Description	Identifies the type of appointment.
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

Encounter Sk

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

Filler Appointment Id

Description	Identifies an individual appointment request, or a booked appointment (when it has been confirmed as a booked slot by the filler).The identifier is assigned by the filler.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Filler Status Code Sk

Description	Indicates the requested/scheduled status of the appointment or associated location, equipment, personnel or other resource, from the point of view of the filler application. For example: Pending - Appointment has not yet been confirmed. Waitlist - Appointment has been placed on a waiting list for a particular slot, or set of slots. Booked - The indicated appointment is booked. Started - The indicated appointment has begun and is currently in progress. Complete - The indicated appointment has completed normally (was not discontinued, canceled, or deleted). Cancelled - The indicated appointment was stopped from occurring (canceled prior to starting). Dc - The indicated appointment was discontinued (Discontinued while in progress, discontinued parent appointment, or discontinued child appointment). Deleted -The indicated appointment was deleted from the filler application. Blocked -The indicated time slot(s) is(are) blocked. Overbook - The appointment has been confirmed; however it is confirmed in an overbooked state. No show - The patient did not show up for the appointment.
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

Occurrence Num

Description	Identifies an individual occurrence of a repeating schedule appointment. An occurrence number is used in conjunction with placer appointment ID and filler appointment ID to uniquely identify the appointment.
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

Parent Filler Appointment Id

Description	Identifies the filler's parent of the appointment request.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Parent Placer Appointment Id

Description	Identifies the placer's parent of the appointment request.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Sk

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

Placer Appointment Id

Description	Identifies an individual appointment request, or a booked appointment (when it has been confirmed as a booked slot by the filler).The identifier is assigned by the placer.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Placer Group Num

Description	Identifies a group of appointment requests.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Priority

Description	The urgency of the appointment request.
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

Repeating Interval

Description	Indicates the interval between repeating appointments.
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

Repeating Interval Duration Descr

Description	Indicates how long the appointment repetitions should continue, once they have started.
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

Request Event Reason Code Sk

Description	Identifies the reason that notification has been triggered. For example: Cancellation Discontinuation Deletion
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

Schedule Code Sk

Description	Identifies the schedule in which this appointment is (or will be) booked.
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

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

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

Appointment Detail_Appointment_FK

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

Primary Key Details

Appointment Detail PK

Key Attribute	Appointment Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model