Dimensional Warehouse Model Data Model

Entity

Entity Appointment Timing Quantity Array

Description

The information that describes an appointment's quantity, frequency, priority and timing.

Attributes
Appointment Fact Dk
Appointment Fact Sk
AWM Load Info Sk
Condition Txt
Conjunction Cd
Conjunction Code Sk
Conjunction Descr
Current Ind
Duration Qty
Duration UOM Cd
Duration UOM Code Sk
Duration UOM Descr
DWM Load Info Sk
Effective From Dt
Effective To Dt
Explicit Tm
Instruction Txt
Occurrence Duration Qty
Occurrence Duration UOM Cd
Occurrence Duration UOM Code Sk
Occurrence Duration UOM Descr
Priority Cd
Priority Code Sk
Priority Descr
Relative Time Qty
Relative Time UOM Cd
Relative Time UOM Code Sk
Relative Time UOM Descr
Repeat Frequency Cd
Repeat Frequency Code Sk
Repeat Frequency Descr
Requested Start Ts
Requested Stop Ts
Source Code Sk
Tenant Sk
Timing Qty
Timing UOM Cd
Timing UOM Code Sk
Timing UOM Descr
Total Occurrence Cnt
Valid From Ts
Valid To Ts

Relationship
Appointment Timing Quantity Array_Appointment Fact_FK

Primary Key
Appointment Timing Quantity Array PK

Dependencies

Reverse Dependencies

Attribute Details

Appointment Fact 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	false

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

Condition Txt

Description	Describes the conditions under which the appointment is to be carried out.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Conjunction Cd

Description	Indicates that a second Timing Quantity segment is to follow. Values: Synchronous Asynchronous Actuation Time
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

Conjunction Code Sk

Description	Indicates that a second Timing Quantity segment is to follow. Values: Synchronous Asynchronous Actuation Time
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

Conjunction Descr

Description	Indicates that a second Timing Quantity segment is to follow. Values: Synchronous Asynchronous Actuation Time
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

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 service is requested.
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

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

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

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

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

Explicit Tm

Description	Explicitly lists the actual times referenced by the code in 'Service Repeat Frequency Cd'. This field will be used to clarify the 'Service Repeat Frequency Cd' in cases where the actual administration times vary within an institution. If the time of the service request spans more than a single day, this field is only practical if the same times of administration occur for each day of the service request.
Data Type	Standards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Instruction Txt

Description	Indicates the instructions for a specific appointment.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Occurrence Duration Qty

Description	Indicates the duration for which a single performance of a service is requested.
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

Occurrence Duration UOM Cd

Description	Indicates the time unit of measure for the duration of a single performance of a requested service.
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

Occurrence Duration UOM Code Sk

Description	Indicates the time unit of measure for the duration of a single performance of a requested service.
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

Occurrence Duration UOM Descr

Description	Indicates the time unit of measure for the duration of a single performance of a requested service.
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

Priority Cd

Description	Indicates the importance of the request.
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

Priority Code Sk

Description	Indicates the importance of the request.
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

Priority Descr

Description	Indicates the importance of the request.
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

Relative Time Qty

Description	Indicates the interval between schedules for service request.
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

Relative Time UOM Cd

Description	Indicates the time unit of measure used to express the interval between schedules for service request.
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

Relative Time UOM Code Sk

Description	Indicates the time unit of measure used to express the interval between schedules for service request.
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

Relative Time UOM Descr

Description	Indicates the time unit of measure used to express the interval between schedules for service request.
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

Repeat Frequency Cd

Description	Indicates the repeating frequency with which the appointment is repeated.
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

Repeat Frequency Code Sk

Description	Indicates the repeating frequency with which the appointment is repeated.
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

Repeat Frequency Descr

Description	Indicates the repeating frequency with which the appointment is repeated.
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

Requested Start Ts

Description	Indicates the earliest date/time at which the services should be started which is specified by the requester.
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

Requested Stop Ts

Description	Indicates the latest date/time at which the services should be stopped.The requester may not always fill in this value, yet the filling service may fill it in on the basis of the instruction it receives and the actual start time.
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

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

Timing Qty

Description	Specifies the numeric quantity of the service that should be provided at each service interval. For example: If two blood cultures are to be obtained every 4 hours, the quantity would be 2 or if three units of blood are to be typed and cross-matched, the quantity would be 3.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Timing UOM Cd

Description	The unit of measure used to specify the numeric quantity of the service that should be provided at each service interval.
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

Timing UOM Code Sk

Description	The unit of measure used to specify the numeric quantity of the service that should be provided at each service interval.
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

Timing UOM Descr

Description	The unit of measure used to specify the numeric quantity of the service that should be provided at each service interval.
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

Total Occurrence Cnt

Description	Indicates the total number of occurrences of a service that should result from this service request.
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

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 Timing Quantity Array_Appointment Fact_FK

Is Identifying Relationship	true
Child Table	Appointment Timing Quantity Array
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 Fact
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 Timing Quantity Array PK

Key Attribute	Appointment Fact Dk
Key Attribute	Timing Qty
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model