Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HService This table has definitional data about various services, findings or both which are given to the patient in a hospital setup.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object Identifier of this record. This field is a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1411. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application.
RecordIdintNULL Not Valued in this table. Column exists as part of persistence framework implementation.
Descriptionvarchar(64)NULL User-defined information provided in the application.
IsDeletedtinyintNOT NULL Specifies whether the record is soft deleted.
Allowable Values
0 - Active
1 - Marked as Deleted.
IsVersionedbitNOT NULL When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design.
CreatedUserIdintNULL Object ID of the logged in user who created this record.
This field is linked to HSUser table to get details about the user. For more information see the description of HSUser table
CreationTimesmalldatetimeNULL Date and time when the record is created.
ServiceNamevarchar(64)NULL Name of the Service.
Abbreviationvarchar(16)NULL Abbreviated name of the Service.
HasSubServicebitNULL Whether this definition represents a set which has child services linked to it. Allowable Values: 0 - No child services , 1 - has child services.
ViewableInFlowsheetbitNULL Whether the service can be viewed in a result flowsheet. Allowable Values: 0 - Not Viewable , 1 - Viewable.
TypeOfDefinitionvarchar(24)NULL The definition type of the service. ie Service, Finding or Service And Finding.
TypeOfDefinitionCodesmallintNULL Code associated with the definition type of the service.
Allowable Values:
0 - Service
1 - Finding
2 - Service and Finding
IsTemplatetinyintNULL Whether a finding associated with the service is system-defined.
Allowable Values:
0 - User Defined
1 - System Defined - no edits allowed
2 - System Defined - Allowed to search and list in catalog browser and allow editing only the finding details of min/max value for graph.
ServiceOrSetTypetinyintNOT NULL Whether this definition is a service or service set.
Allowable Values:
0 - Service(when HasSubService=0) , Convenience Set( when HasSubService = 1)
1 - Orderable Set
2 - Predefined Meds
3 - Predefined IV
4 - None( if it's just a finding .i.e TypeOfDefinitionCode = 1)
ValidityStatusvarchar(16)NULL Validity status of the service.
ValidityStatusCodesmallintNULL Code associated with the validity status of the service.
Allowable Values:
0 - Active
1 - Inactive
2 - Incomplete
3 - Obsolete
DefaultMediaBorrowerUnit_oidintNULL Not Valued.
DefaultMediaBorrower_oidintNULL Not Valued.
ServiceType_oidintNULL ObjectID of HServiceType table. Represents the Type of service definition(eg Laboratory, Nursing etc.).
ServiceSubType_oidintNULL ObjectID of HServiceType table. Represents the Sub-Type for the service(eg Blood Bank, Microbiology etc.).
OwningOrganization_oidintNULL ObjectID of HHealthCareUnit. Represents the organization which defines this service.
SubOwningOrganization_oidintNULL ObjectID of HHealthCareUnit. Represents the sub-organization which defines this service.
FormTypevarchar(32)NULL The adaptable form type associated with the Orderable service. eg Assessment Page Type , Assessment Columnar Type etc.
FormTypeCodesmallintNULL Code associated with the form type Data Dictionary Item.
FormUsagevarchar(32)NULL Usage of form, which determines the number of fields that can be placed in adaptable form. Eg. Admission assessment or shift, Vital signs or I and O etc.
FormUsageCodesmallintNULL Code associated with the form usage.
RevisedDateTimesmalldatetimeNOT NULLDate and time when the service was modified.
HasRefRangebitNOT NULLWhen set to True, indicates that the service has a reference range.
Allowable Values:
0 - False
1 - True.
AsWrittenDescriptionvarchar(300)NULL The description of the service as entered by the user. This information is mandatory for drug services.
SetGroupIndicatorbitNOT NULLWhen set to True, indicates that the service, which is a part of the convenience package, can be reordered.
Allowable Values:
0 - False
1 - True.
IsFreeTextbitNOT NULLWhen set to True, indicates that the service is a free-text service.
Allowable Values:
0 - False
1 - True.
GenericNamevarchar(64)NULL Generic name for a drug service definition.
GenericAbbreviationvarchar(16)NULL Abbreviated generic name for a drug service definition.
MedSuppInfo_oidintNULL Not Valued.
Commondefn_oidintNULL Object ID of HCommonDefinition.
FindingNamevarchar(64)NULL Name of the finding.
DrugIndicatortinyintNOT NULLIndicates the type of drug service.
Allowable Values:
0 - None
1 - Route
2 - Package
PresentationIndicatorvarchar(3)NULL Indicator for the type of service being processed.
Allowable Values:
NRS - Nursing
CRD - CDMS - will not be valued any more
DG - Intervention orders.
Null - If nothing from above
OrderablebitNULL When set to 1, indicates that the service can be ordered.
Allowable Values:
0 - False
1 - True.
LRIndicatorRequiredbitNOT NULL Whether the user should be required to indicate the left or the right side when placing an order for a service.
Allowable Values:
0 - False
1 - True.
ExpandSetbitNOT NULL When set to 1, indicates that the set should be expanded by default.
Allowable Values:
0 - False
1 - True.
SingleSelectsmallintNULL Whether the convenience set is single select or not.
Allowable Values:
0 or NULL - False
1 - True.
IndentItemssmallintNULL Whether the items in convenience set are indented or not.
Allowable Values:
0 or NULL - False
1 - True.
IsPediatricTINYINTNULL 1 if the service is intended for Pediatric patient, 0(default) otherwise.
Allowable Values:
0 - False
1 - True.
ServiceNameAIASServiceName COLLATE Accent Insensitive column for ServiceName.
AbbreviationAIASAbbreviation COLLATE Accent Insensitive column for Abbreviation.
LinkTypeNamevarchar(64)NULL Name of the Link Type the service belongs to.
DisplayAsOrderSetTINYINTNULL Whether the set is displayable as an order set, meaning will be picked up in the current orders sort by order set view. Allowable Values: 0 - False , 1 - True
CancelPACheckbitNULL When canceling no visit pending activation order, whether a check will be performed at the service level when the order type preference is enabled. Allowable Values: 0 - False , 1 - True
DaysToCancelPANoVisitOrdersmallintNULL Number of Days after which no visit pending activation orders for this service can be canceled by the Job, if CancelPACheck is enabled.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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