Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HPatientClass Contains all available patient visit types. Can be edited by the client.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Architecture generated unique id for the table row
InstanceHFCIDsmallintNOT NULL Architecture generated instance HFC(Healthcare Foundation Class) ID.
RecordIdintNULL Not used.
Descriptionvarchar(50)NULL Description of the row being created by the client. It can be valued the same as the Name.
IsVersionedbitNOT NULL Indicates whether a row has been modified or not. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL Architecture generated ID of the user who created the row.
CreationTimesmalldatetimeNULL Date/Time of when the row is created in the table.
Namevarchar(30)NULL Name of the Visit Type set up by the client.
For example: OutPatient, InPatient, Preadmit,IP-Ward,PreReg,PreArrival,Urgent Care
CanAllocateBedbitNULL Indicates whether a bed can be allotted for a particular visit type. Allowable Values: 0 - False, 1 - True
CanHaveLeaveofAbsencebitNULL Indicates whether leave of absence is permitted for a particular visit type. Allowable Values: 0 - False, 1 - True
CanHaveSubVisitsbitNULL Indicates whether sub visits can be created for a particular visit type. Allowable Values: Null- not valued, 0 - False, 1 - True
CanHaveMultipleActiveVisitsbitNULL Indicates whether multiple active visits can be created of a particular visit type.Allowable Values: 0 - False, 1 - True
CandoPatientTransferbitNULL Indicates whether transfer is allowed for a particular visit type. Allowable Values: 0 - False, 1 - True
CanbeScheduledbitNULL Indicates whether a particular visit type can be used for scheduling or not. Allowable Values: 0 - False, 1 - True
BedcanbeReleasedonLOAbitNULL Indicates whether a bed can released for leave of absence of a particular visit type. Allowable Values: Null - Not valued, 0 - False, 1 - True
EditablebitNULL Indicates whether a row is editable in the table. Allowable Values:Null - Not Valued, 0 - False, 1 - True
Codevarchar(30)NULL internal code of the visit type that's created by client.
For Example: OP,Preadmit,IP,IP-Ward,PreReg,BVC.
ActivebitNULL Indicates whether a row is active or not. Allowable Values: 0 - Not Active 1 - Active
BedAllocationOptionalbitNULL Indicates whether bed allocation is optional or not for a visit type. Allowable Values: 0 - False, 1 - True
CanExpireAtMidnightbitNULL Indicates whether a visit can be closed automatically at midnight. Allowable Values: 0 - False, 1 - True
CanAllowDischargebitNULL Indicates whether a particular visit type can be allowed to discharge or not. Allowable Values: 0 - False, 1 - True
LikeIPbitNULL Indicates whether a visit type is Like Inpatient or not. Allowable Values: 0 - False, 1 - True
DeltaValueintNULL Value in this column specifies how long the visit info can be retained even after closure. Set up by the client.
ActiveDaysforOPintNULL Number of days that a visit has to be kept active before auto closing. Set up by the client.
IncludeInDischargeReportssmallintNOT NULL Indicates whether to include a visit type in discharge reports or not. Allowable Values: 0 - False, 1 - True
UrgentCaresmallintNOT NULL Indicates whether a visit is of Urgent care type or not. Allowable Values: 0 - False, 1 - True
IsHiddenbitNOT NULL Indicates whether a visit type is hidden from common UI. Allowable Values: 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