| Atomic Warehouse Model Data Model |
| Description | An equipment resource that can be scheduled for an appointment. For example: Electrocardiogram Machine Ultrasound Machine Electroencephalogram |
| Relationship | |
 Appointment General Resource Detail_Appointment General Resource_FK |
|
| Primary Key | |
 Equipment Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Allow Substitution Code Sk
| Description | Indicates whether the identified Equipment can be substituted with other equivalent equipment. For example: No - Substitution of this resource is not allowed. Confirm -Contact the Placer Contact Person prior to making any substitutions of this resource. Notify - Notify the Placer Contact Person, through normal institutional procedures, that a substitution of this resource has been made. Yes - Substitution of this resource 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 |
Duration Qty
| Description | Indicates the duration for which the 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 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. |
| 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 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 |
Equipment Sk
| Description | The surrogate key for anchor Equipment. |
| 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 |
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 |
Resource Code Sk
| Description | Indicates the resource being requested or scheduled for an 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 |
Resource Qty
| Description | The quantity of the specified equipment. |
| 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 |
Resource Type Code Sk
| Description | Indicates the type of equipment that should be scheduled by the filler. |
| 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 UOM Code Sk
| Description | Indicates the units of the equipment requested. |
| 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 |
Start Date Time Offset
| Description | The offset that the equipment 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 Code Sk
| Description | Indicates the units of time used for Start date/time offsets for resource. |
| 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 equipment 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 General Resource Detail_Appointment General Resource_FK
| Is Identifying Relationship | true |
| Child Table | Equipment 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 | Equipment |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Equipment Detail PK
| Key Attribute | Equipment Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |