Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HServiceDetail This table holds the details of the Service definition in HService table.
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 1412. 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 Not Valued in this table. Column exists as part of persistence framework implementation.
IsDeletedtinyintNOT NULL Specifies whether the record is soft deleted.
Allowable Values
0 - Active
1 - Marked as Deleted.
IsVersionedbitNOT NULL Whether the table data is Versioned or not.
Allowable Values:
0 - No version data captured.
1 - Version changes available in _Ver table.
Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HServiceDetail_Ver.
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 description of HSUser table
CreationTimesmalldatetimeNULL Date and time when the record is created.
MinimumTimeBetweenServicesintNULL When the Order for the same service for the same HCU is placed and duplicate check indicator is on, the value stored on this attribute is used to validate whether Order should be allowed to place again.
UnitOfMinimumTimeBetweenServicesvarchar(16)NULL holds the unit of Minimum Time Between Services.Valued from Name field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user.
UnitOfMinimumTimeBetweenServicesCodesmallintNULL Code for unit of Minimum Time Between Services. Valued from ItemCode field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user.
RequiresSchedulingbitNULL determines if the service is schedule-able or not. Not used in Clinical workflows
PatientPresenceRequiredbitNULL whether patient must be presence to have the test performed. Not used in Clinical workflows
PatientCanPerformbitNULL whether patient can perform the service. Not used in Clinical workflows
DuplicateCheckbitNULL whether service can undergo duplicate checking. Allowable Values: 0 - False, 1 - True.
MaximumDurationsmallintNULL the maximum duration for the service. A licensed person who is authorized to place an order can check the order duration entered or calculated against this value and issues a message if the user is over the maximum duration permitted
UnitOfMaximumDurationvarchar(16)NULL holds the unit of Maximum duration. Valued from Name field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user.
UnitOfMaximumDurationCodesmallintNULL holds the code of the unit of Maximum duration. Valued from ItemCode field of Dictionary Item of Type OaR.EnumDuration.This is system defined DDI and can't be changed by user.
ReasonForRequestRequiredbitNULL whether the reason for request should be charted or not during during order entry. Allowable Values: 0 - False, 1 - True.
IndividuallyOrderablebitNULL whether the order can be placed individually.
Allowable Values :
0 - Order for the service can't be placed individually but only as part of a set.
1 - Order for the service can be placed individually.
ServiceDescriptionOverriderbitNULL whether user is able to change the Name of the Order on the Order Detail Form during order entry. Allowable Value: 0-False, 1-True
MustReviewIndicatorbitNULL Whether the user should review the details of the order for the service during order entry.Allowable Value: 0-False, 1-True
ChargeablebitNULL Whether the service is chargeable. Allowable Value: 0-False, 1-True
ChargeCodevarchar(32)NULL Primary Charge Description Master Code
HasMaterialsbitNULL whether the service has materials . Allowable Value: 0-False, 1-True
StartDateTimesmalldatetimeNULL Start date time since when the detail of the service became active.
EndDateTimesmalldatetimeNULL End date time till when the detail of the service will be active.
ObsoleteDateTimesmalldatetimeNULL Date time when the detail of the service was made obsolete.
MedicalNecessityRequiredbitNULL Whether Order for the service should undergo Medical Necessity Check. Allowable Value: 0-False, 1-True
AutomaticCreditIndicatorbitNULL Whether the Chargeable service allows automatic Credits. Allowable Value: 0-False, 1-True
ChargeDescriptionOverrideIndicatorbitNULL Whether user can modify the charge description. Allowable Value: 0-False, 1-True
TimeChargeIndicatorbitNULL Whether the service will be time charged.
Allowable Values:
0 - False
1 - True
PriorityIndicatorvarchar(32)NULL Default Priority on the order entry. If an order is of high priority, indicates that it must be performed immediately.
PriorityIndicatorCodesmallintNULL Indicates the code associated with the priority.
Allowable Values:
0 - Routine
1 - Timing Critical
2 - Now Routine
3 - As Soon As possible
4 - Preoperative
5 - Call Back
6 - Stat
TransportIndicatorvarchar(32)NULL whether a transportation charge should be applied for the service, and how to apply the transportation charge
TransportIndicatorCodesmallintNULL Code for the Transport Indicator
Allowable values:
0= no charge(Default)
1= charge 1X for order
2= Apply charge 1X for each member
3= Apply charge 1X for each quantity
MethodIndicatorvarchar(32)NULL whether a method charge should be applied for the service
MethodIndicatorCodesmallintNULL Code for the Method Indicator
Allowable values:
0= no charge(Default)
1= charge 1X for order
2= Apply charge 1X for each member
3= Apply charge 1X for each quantity
SecondaryChargeDescriptionMasterCodevarchar(32)NULL Secondary Charge Description Master Code.
ChargeForEachMemberInPackagebitNULL Whether each member in package should be charged.Allowable Value: 0-False, 1-True
MaxOrderableQuantityintNULL Maximum orderable quantity of the service.
UnitOfQuantityvarchar(16)NULL Unit for Maximum orderable quantity
IsRestrictedtinyintNULL Whether the service is restricted. Order for restricted services are only visible to the clinical users who have enough security privileges to view them.
Allowable Values:
0 - False
1 - True
Instructionsvarchar(255)NULL Freetext instructions for performing the service. If valued ,will get defaulted on the order during order entry.
LevelOfSignaturetinyintNULL Signature levels can be 0-9 and set at User's security settings. This field represents the level of signature required for this service to be Co-signed by the user. It's applicable only when CoSignatureRequired field is True.
NumberOfSignaturetinyintNULL Number of signatures required for the order to become active or co-signed.
ContrastIndicatorbitNULL Whether the service requires contrast media e.g. dye .It serves as warning to service provider.Allowable Value: 0-False, 1-True
SubVisitRequiredbitNULL whether sub visit processing is required for service or not.Allowable Value: 0-False, 1-True
SubVisitIndicatorvarchar(255)NULL Indicator describing how the sub visit should be created when order is placed.
SubVisitIndicatorCodesmallintNULL Code for the Sub Visit Indicator
Allowable Values:
0 - No Sub Visit
1 - Add Sub Visit
2 - Add Sub Visit per day
3 - Add Sub Visit always
4 - New Sub Visit
LevelOfSignatureForActivetinyintNULL Signature levels can be 0-9 and set at User's security settings. This field represents the level of signature required for this service to be Activated. It's applicable only when CoSignatureRequired field is True.
AcknowledgeRequiredbitNULL Whether the order for the service is required to be acknowledged.
Allowable Values:
0 - False
1 - True
CoSignatureRequiredbitNULL Whether the order for the service is required to be co-signed.
Allowable Values:
0 - False
1 - True
DefaultServiceProviderTypevarchar(20)NULL Valued from Dictionary Item of Type OaR.DefaultServiceProviderType.This is system defined DDI and can't be changed by user. Represents the type of the default service provider set on the service.
DefaultServiceProviderTypeCodesmallintNULL Code for the Default Service Provider Type. It's the ItemCode field of the DDI
Allowable Values:
0 - Service requestor
1 - Service provider
2 - Other.
UnitOfMinQtyOfSpecimenRequiredvarchar(16)NULL Unit for the Minimum Quantity of specimen required.
SpecimenRequiredbitNULL Whether the specimen sample is required to be collected for this service.
Allowable Values:
0 - False
1 - True
MinQtyOfSpecimenRequiredVarchar(12)NULL The minimum quantity of the specimen sample required to be collected.
StrainTypebitNULL Whether service is of strain type or not. For strain type services, the system mandates that enddatetme be valued while capturing sample collection.
Allowable Values
0 - False
1 - True.
SampleCollectorvarchar(20)NULL who(unit) will be the sample collector. eg ServiceRequestor,ServiceProvider or None
SampleCollectorCodesmallintNULL Code for the Sample Collector
Allowable Value:
0 - Service Requestor . On Order entry , this will default the Medically responsible unit(MRU) of the Visit as Sample Collector
1 - Service Provider. On Order entry ,this will default the service provider defaulted on the order as sample collector
2 - None . On Order entry , system will look at the Default Sample Collector preference under Log Specimen Collection category for defaulting the sample collector on the order.
ValidityStatusvarchar(16)NULL Validity status of the service. eg Active,Inactive etc
ValidityStatusCodesmallintNULL Code for the Validity Status of the service
Allowable Values:
0 - Active
1 - Inactive
2 - Incomplete
3 - Obsolete
DefaultServiceProvider_oidintNULL ObjectID of HHealthcareUnit table. Represents the default service provider set in the Service Provider tab of service catalog.
Service_oidintNOT NULLObjectID of HService table , to which this detail is linked to.
Specimen_oidintNULL ObjectID of HSpecimen table. It's the defaulted specimen on the service.
ViewableInInterventionWklbitNULL Whether the order for the service will be available for Intervention charting. Allowable Value: 0-False, 1-True
PriceOverrideIndicatorbitNULL Whether the system will allow to override the price of the service on the CHarge UI. Allowable Value: 0-False, 1-True
UnitCodeForMinQtyOfSpecimenvarchar(16)NULL Code for the Unit of Minimum quantity of specimen required.
UnitCodeForQuantityvarchar(16)NULL Unit code for the quantity of the service.
MedNecFrequencyIndicatorbitNULL whether the frequency information is to be considered while processing medical necessity check for a service. Allowable Value: 0-False, 1-True
MedNecDurationsmallintNULL Duration for the Frequency check.This is used to check whether the order is performed in the given duration or not
MedNecDurationUnitCodesmallintNULL Duration unit code for the frequency check.
AsWrittenDescriptionvarchar(300)NULL Service as written
ReqmanualchargeChar(1)NOT NULLWhether the service requires to be manually charged. Allowable Value: 0-False, 1-True
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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