Dimensional Warehouse Model Data Model

Entity

Entity Appointment Personnel Dimension

Description

A member of personnel that can be scheduled for an appointment.

For example:
Respiratory Technician
Physicians
Nurses

Attributes
Allow Substitution Cd
Allow Substitution Code Sk
Allow Substitution Descr
Appointment Personnel Dk
Appointment Personnel Sk
AWM Load Info Sk
Current Ind
Duration Qty
Duration Unit Cd
Duration Unit Code Sk
Duration Unit Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Filler Status Cd
Filler Status Code Sk
Filler Status Descr
Resource Group Cd
Resource Group Code Sk
Resource Group Descr
Resource Type Cd
Resource Type Code Sk
Resource Type Descr
Source Cd
Source Code Descr
Source Code Sk
Start Date Time Offset
Start Date Time Offset Unit Cd
Start Date Time Offset Unit Code Sk
Start Date Time Offset Unit Descr
Start Date Time Ts
Tenant Sk
Valid From Ts
Valid To Ts

Primary Key
Appointment Personnel Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Allow Substitution Cd

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

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

Duration Qty

Description	Indicates the duration for which the personnel 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 personnel 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 personnel 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

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

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

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

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

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

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

Resource Group Cd

Description	Identifies the requested resource as a member of the indicated group.
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

Resource Group Code Sk

Description	Identifies the requested resource as a member of the indicated group.
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

Resource Group Descr

Description	Identifies the requested resource as a member of the indicated group.
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

Resource Type Cd

Description	Identifies the type of the personnel requested/scheduled for an appointment. For example: Physician Nurse Therapist
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

Resource Type Code Sk

Description	Identifies the type of the personnel requested/scheduled for an appointment. For example: Physician Nurse Therapist
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

Resource Type Descr

Description	Identifies the type of the personnel requested/scheduled for an appointment. For example: Physician Nurse Therapist
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

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

Start Date Time Offset

Description	The offset that the personnel 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/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Start Date Time Offset Unit Cd

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

Start Date Time Offset Unit Code Sk

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

Start Date Time Offset Unit Descr

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

Start Date Time Ts

Description	The date and time upon which a particular personnel 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

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 Personnel Dimension PK

Key Attribute

Appointment Personnel Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model