Appointment Slots

Object Description

One record per period of time that is, was, or has some future potential to be available for booking an appointment for an encounter. Multiple appointment slots can be assigned to a single appointment; but the converse is not true (i.e., a single appointment slot cannot be associated with multiple appointments).

Metadata

• Table Name: ursa.no_ursa_core_enc_004
• Layer: NATURAL_OBJECT
• Object Type: Single Stack
• Temporal Class: Interval
• Case ID: Appointment Slot ID
• Interval Start Date: Slot Start Datetime
• Interval End Date: Slot End Datetime
• Primary Key: Appointment Slot ID

Relational Diagram

Dedicated Precursors

• [NO/URSA-CORE] Appointment Slots, Precursor 1 (All Source Records): One record per source system record for a time slot that is or was at some prior point available for booking an appointment for an encounter.