| Atomic Warehouse Model Data Model |
| Description | A location resource that can be scheduled for an appointment. For example: Meeting rooms Operating rooms Procedure rooms |
| Relationship | |
 Appointment Location Detail_Appointment Resource_FK |
|
| Primary Key | |
 Appointment Resource Location PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
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 |
Appointment Resource Sk
| Description | Surrogate Key for Appointment Resource. |
| 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 |
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 |
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 |
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 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 |
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 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 |
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 |
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 |
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 Location Detail_Appointment Resource_FK
| Is Identifying Relationship | true |
| Child Table | Appointment Resource Location |
| 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 Resource |
| 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 Resource Location PK
| Key Attribute | Appointment Resource Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |