Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
| | | The information is then used by Quantity and Time calculation API's(CommonQT APIs) to calculate administration times |
|
ObjectID | int | NOT NULL | The object ID of the object(such as patient, order, etc.). This field is always a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | The HFC(Healthcare Foundation Class) ID of the object(3104). Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application |
RecordId | int | NULL | The record ID. Modules in the application can use this field to group all objects having something in common and then assign the same RecordId to all the objects. For example, all related information for a patient, such as patient address, patient visits, patient name, etc., can be assigned the same RecordId. The modules can then query on this RecordId to retrieve the related information for that patient |
Description | varchar(64) | NULL | User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not used |
IsDeleted | tinyint | NOT NULL | Indicates whether the record is soft deleted. Allowable Values: 0 - Active , 1 - Marked as Deleted |
IsVersioned | bit | NOT NULL | Indicates whether the record was modified through persistent layer after it's initial creation. Once this field is set to True, you cannot reset it to False. If this field is set to True in a table, another table with the name HRecurrenceInstance_Ver is created |
CreatedUserId | int | NULL | The Object ID of the user who created the object. This field is linked to HSUser table to get details about the user. For more information on HSUser table |
CreationTime | smalldatetime | NULL | The date and time when the object is created |
Occurrences | int | NULL | Declares the number of ocurrences the method creates |
ParsingSign | varchar(40) | NULL | Copy of HRecurrenceTemplate.ParsingSign field |
Presentation | tinyint | NULL | Defines the presentation order of the dosage method |
| | | Allowable values: |
| | | 0 - Addition |
| | | 1 - DoseParser |
| | | 2 - ParserDose |
| | | 3 - Parser |
| | | 4 - Dose |
RecurrenceMethod | tinyint | NULL | Specifies which basic method is used for this recurrence method |
| | | Allowable values: |
| | | 0 - Repetable |
| | | 1 - Interval |
| | | 2 - Unspecified |
| | | 3 - Once |
| | | 4 - Simple notation |
OccurrenceTimes | varchar(192) | NULL | Number of times administration is given in 24 hrs . Not applicable for Interval and Unspecified recurrence methods |
TimeCalculationMethod | tinyint | NULL | This attribute is an enumeration specifying if the method should calculate the recurrence times and if they should be distributed evenly during the granularity unit. |
| | | Allowable values: |
| | | 0 - NoCalculation |
| | | 1 - DistributeEvenly |
| | | 2 - DistributeEvenlyExternalStartTime |
ShiftFlag | bit | NULL | Defines if succeeding occurrence will be shifted upon time delay |
PRN | bit | NULL | Flag indicating if medication should be administered as needed. Allowable values: 0 - Cannot be administered as needed, 1 - Can be administered as needed |
IntervalSeconds | int | NULL | If method interval is being used this attribute describes the interval in seconds |
QuantityType | tinyint | NULL | Defines what kind of quantity is defined |
| | | Allowable values: |
| | | 0 - None |
| | | 1 - Quantity |
| | | 2 - ExternalQuantity |
| | | 3 - PM |
ShiftSeconds | int | NULL | If ShiftFlag is 1 this is considered to shift the succeeding occurrence |
SchemaName | varchar(40) | NULL | Name of RecurrenceSchema |
SchemaGranularityPattern | varchar(124) | NULL | Pattern is a string containing a repeat pattern used with Granularity |
| | | e.g. |
| | | 10 - every second day |
| | | 1 - every day |
SchemaDayOfMonthPattern | varchar(124) | NULL | Pattern is a string containing a repeat pattern used on day of month(e.g 11000000.... first & second every month) |
SchemaDayOfWeekPattern | varchar(42) | NULL | Pattern is a string containing a repeat pattern used on day of week(e.g 11000000.... mon & tue every week) |
SchemaMonthOfYearPattern | varchar(12) | NULL | Pattern is a string containing a repeat pattern used on month of year.(e.g 11000000.... jan,feb) |
SchemaPatternMask | int | NULL | Defines which of the four pattern will be used |
| | | Allowable values: |
| | | 1 - GranularityPattern |
| | | 2 - DayOfWeekPattern |
| | | 3 - DayOfMonthPattern |
| | | 4 - MonthOfYearPattern |
StartDateTime | datetime | NULL | The date and time of the recurrence start |
StopDateTime | datetime | NULL | The end datetime to be set for the RecurrenceInstance object |
Duration | int | NULL | The Duration value |
TotalOccurrences | int | NULL | The Total number of ocurrences the connected order will repeat |
| | | This field is valued when duration unit is specified in terms of count . eg for 2 doses(meds) , 2 Times(non-meds) |
| | | For such units, the duration is to be fetched from this field, instead of the Duration field |
| | | For other units like Days, Week etc, this field is not valued, instead Duration field is used |
RecurrenceStopType | tinyint | NULL | The Integer value from the EHRecurrenceStopType enum determining what kind of time unit the duration value is referring to |
| | | Allowable values: |
| | | 0 - None |
| | | 1 - StopDate |
| | | 2 - TotalOccurrences |
| | | 3 - DurationInSeconds |
| | | 4 - DurationInMinutes |
| | | 5 - DurationInHours |
| | | 6 - DurationInDays |
| | | 7 - DurationInWeeks |
Granularity_oid | int | NOT NULL | Object ID of Granularity object(HGranularity) |
SchemaTemplateRelation | tinyint | NOT NULL | Type of relation between Schema and Template |
| | | Allowable values: |
| | | 0 - Standard |
| | | 1 - AlteredSchema |
| | | 2 - AlteredTemplate |
| | | 3 - AlteredSchemaAndTemplate |
RecurrenceAsWritten | varchar(300) | NULL | To capture the Recurrences for an order "As written" |
Template_OID | int | NULL | Object ID of Template object defined at Enterprise Level(HRecurrenceTemplate) |
Schema_OID | int | NULL | Object ID of Schema object defined at Enterprise level(HRecurrenceSchema) |
SchemaIntervalPattern | Varchar(6) | NULL | Pattern defined in the RecurrenceSchema |
IsContinuousProcessing | tinyint | NULL | Whether selected frequency is of type ContinuousIV or not(1/0) |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|