Dimensional Warehouse Model Data Model

Entity

Entity Appointment Dimension

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
Allow Substitution Cd
Allow Substitution Code Sk
Allow Substitution Descr
Appointment Bk
Appointment Dk
Appointment Duration Qty
Appointment Duration Unit Cd
Appointment Duration Unit Code Sk
Appointment Duration Unit Descr
Appointment Filler Status Cd
Appointment Filler Status Code Sk
Appointment Filler Status Descr
Appointment Reason Cd
Appointment Reason Code Sk
Appointment Reason Descr
Appointment Sk
Appointment Type Cd
Appointment Type Code Sk
Appointment Type Descr
AWM Load Info Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Filler Appointment Id
Location Duration Qty
Location Duration Unit Cd
Location Duration Unit Code Sk
Location Duration Unit Descr
Location Duration UOM Cd
Location Duration UOM Code Sk
Location Duration UOM Descr
Location Filler Status Cd
Location Filler Status Code Sk
Location Filler Status Descr
Location Start Date Time Offset
Location Start Date Time Offset Unit Cd
Location Start Date Time Offset Unit Code Sk
Location Start Date Time Offset Unit Descr
Location Start Date Time Ts
Occurrence Num
Parent Filler Appointment Id
Parent Placer Appointment Id
Placer Appointment Id
Placer Group Num
Priority Seq
Repeating Interval Cnt
Repeating Interval Duration Cnt
Request Event Reason Cd
Request Event Reason Code Sk
Request Event Reason Descr
Schedule Cd
Schedule Code Sk
Schedule Descr
Slot Spacing Criteria Num
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Primary Key
Appointment Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Allow Substitution Cd

Description	Indicates whether the identified Location can be substituted with another equivalent location. For example: No - Substitution of this location is not allowed. Confirm -Contact the Placer Contact Person prior to making any substitutions of this location. Notify - Notify the Placer Contact Person, through normal institutional procedures, that a substitution of this location has been made. Yes - Substitution of this location is allowed.
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

Allow Substitution Code Sk

Description	Indicates whether the identified Location can be substituted with another equivalent location. For example: No - Substitution of this location is not allowed. Confirm -Contact the Placer Contact Person prior to making any substitutions of this location. Notify - Notify the Placer Contact Person, through normal institutional procedures, that a substitution of this location has been made. Yes - Substitution of this location is allowed.
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

Allow Substitution Descr

Description	Indicates whether the identified Location can be substituted with another equivalent location. For example: No - Substitution of this location is not allowed. Confirm -Contact the Placer Contact Person prior to making any substitutions of this location. Notify - Notify the Placer Contact Person, through normal institutional procedures, that a substitution of this location has been made. Yes - Substitution of this location is allowed.
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

Appointment 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

Appointment 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

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 Cd

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

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 Duration Unit Descr

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

Appointment Filler Status Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Appointment 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

Appointment Filler Status Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Appointment Reason Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
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	true
Is Derived	false
Is Surrogate Key	false

Appointment Reason Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Appointment 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

Appointment Type Cd

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

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

Appointment Type Descr

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

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

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

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

Location Duration Qty

Description	Indicates the duration for which the location resource is requested/scheduled for an appointment, if different from the overall duration of the requested/scheduled appointment. For example: An unvalued duration indicates that the location resource is required from its start date/time offset (specified in the previous two fields) until the end of the appointment. If no start date/time offset is specified, then the resource is required for the full duration of the appointment. This field must be a positive, non-zero number. A negative number or zero (0) is nonsensical in the context of a duration.
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

Location Duration Unit Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Location 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

Location Duration Unit Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Location Duration UOM Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Location Duration UOM 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

Location Duration UOM Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Location Filler Status Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Location 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

Location Filler Status Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Location Start Date Time Offset

Description	The offset that the location resource needs for the appointment, and is expressed in units of time relative to the scheduled start date/time.
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

Location Start Date Time Offset Unit Cd

Description	Indicates the units of time used for Start date/time offsets for location.
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

Location Start Date Time Offset Unit Code Sk

Description	Indicates the units of time used for Start date/time offsets for location.
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

Location Start Date Time Offset Unit Descr

Description	Indicates the units of time used for Start date/time offsets for location.
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

Location Start Date Time Ts

Description	The date and time upon which a particular location is required for the appointment
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

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

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

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

Repeating Interval Cnt

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 Cnt

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 Cd

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

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

Request Event Reason Descr

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

Schedule Cd

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

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

Schedule Descr

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

Slot Spacing Criteria Num

Description	Indicates the slot spacing for possible appointment slots.The value in this field should be a positive integer, representing the number of minutes between slot starting times. For example: If there is a request that an appointment with a duration of 1.5 hours be scheduled some time between 9:00 AM and 11:30 AM, and the Slot Spacing Criteria field contains a value of 15, then the list of slots returned should read as follows:9:00 - 10:30 ; 9:15 - 10:45; 9:30 - 11:00; 9:45 - 11:15; 10:00 - 11:30
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

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

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

Primary Key Details

Appointment Dimension PK

Key Attribute

Appointment Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model