TIMING
Description: Describes the occurrence of an event (frequency, duration, etc.) that may occur multiple times. ?Timing is used in medication dosage, care plans, activities, orders/requests, etc.

Primary Key
Column Name Ordinal Position

Foreign Key
Column Name Ordinal Position Referenced Table
LKTIMINGABBREVIATIONID 4 LKTIMINGABBREVIATION
REPEATBOUNDSDURATIONQUANTITYID 5 QUANTITY
REPEATBOUNDSRANGELOWQUANTITYID 6 QUANTITY
REPEATBOUNDSRANGEHIGHQUANTITYID 7 QUANTITY
REPEATDURATIONLKUNITOFTIMEID 14 LKUNITOFTIME
REPEATPERIODLKUNITOFTIMEID 19 LKUNITOFTIME

Column Information
Name Type
1 TIMINGID INT
Description: The unique Id for the Timing table
Name Type
2 UUID UNIQUEIDENTIFIER
Description: The unique identifier of a timing
Name Type
3 DISPLAYNAME NVARCHAR
Description: The display name of a timing
Name Type
4 LKTIMINGABBREVIATIONID INT
Description: LkTimingAbbreviationId is a foreign key to the LkTimingAbbreviation table
Name Type
5 REPEATBOUNDSDURATIONQUANTITYID INT
Description: RepeatBoundsDurationQuantityId is a foreign key to the Quantity table
Name Type
6 REPEATBOUNDSRANGELOWQUANTITYID INT
Description: RepeatBoundsRangeLowQuantityId is a foreign key to the Quantity table
Name Type
7 REPEATBOUNDSRANGEHIGHQUANTITYID INT
Description: RepeatBoundsRangeHighQuantityId is a foreign key to the Quantity table
Name Type
8 REPEATBOUNDSPERIODSTARTDATETIME DATETIME2
Description: The start date for when a repeating timing
Name Type
9 REPEATBOUNDSPERIODENDDATETIME DATETIME2
Description: The end date for when a repeating timing
Name Type
10 REPEATCOUNT INT
Description: How many times a timing should repeat
Name Type
11 REPEATCOUNTMAX INT
Description: The max amount of times a timing should repeat
Name Type
12 REPEATDURATION DECIMAL
Description: The duration a timing should repeat
Name Type
13 REPEATDURATIONMAX DECIMAL
Description: The max duration a timing should repeat
Name Type
14 REPEATDURATIONLKUNITOFTIMEID INT
Description: RepeatDurationLkUnitOfTimeId is a foreign key to the LkUnitOfTime table
Name Type
15 REPEATFREQUENCY INT
Description: How often a timing should repeat
Name Type
16 REPEATFREQUENCYMAX INT
Description: The max frequency for how often a timing should repeat
Name Type
17 REPEATPERIOD DECIMAL
Description: The period during which a timing should repeat
Name Type
18 REPEATPERIODMAX DECIMAL
Description: The max period during which a timing should repeat
Name Type
19 REPEATPERIODLKUNITOFTIMEID INT
Description: RepeatPeriodLkUnitOfTimeId is a foreign key to the LkUnitOfTime table
Name Type
20 REPEATOFFSET INT
Description: A value that offsets the repeating timing