Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HGranularity This table stores the granularities in the system (E.g. 24 h,15 min,1 month). A granularity is a defined time unit which could be applied to a prescription, this is mandatory for the prescriptions
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The object ID for the granularity record
InstanceHFCIDsmallintNOT NULL The HFC(Healthcare Foundation Class) ID of the object(3101). Note: The value specified in the ObjectID field and in this field enables unique indentification of an object across the application
RecordIdintNULL 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.
Descriptionvarchar(64)NULL User-defined information provided by the modules in the application. Note: The length of this field varies with tables. Not used.
IsVersionedbitNOT 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 HGranularity_Ver is created. Allowable Values: 0 - False, 1 - True
CreatedUserIdintNULL 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
CreationTimesmalldatetimeNULL The date and time when the object is created
GranularityUnittinyintNULL The granularity unit. DDI based on OaR.EnumDuration
Allowable Values:
0 - None
1 - Years
2 - Months
3 - Weeks
4 - Days
5 - Hours
6 - Minutes
7 - Seconds
8 - MilliSeconds
GranularityQuantityintNULL The granularity quantity
HeaderPresentationvarchar(20)NULL Format for the header. Example "mm-dd", "yyyy"
GroupHeaderUnittinyintNULL The group header unit. DDI based on OaR.EnumDuration
Allowable Values:
0 - None
1 - Years
2 - Months
3 - Weeks
4 - Days
5 - Hours
6 - Minutes
7 - Seconds
8 - MilliSeconds
GroupHeaderPresentationvarchar(20)NULL Format for the group header. Example "mm-dd", "yyyy"
ActivebitNULL Active flag. Allowable Values: 0 - Inactive, 1 - Active
StartDateTimesmalldatetimeNULL The start date time of defined granularity

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates