Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HProcedure Contains procedure information for the patient visit
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HProcedure Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL Not Used.
Descriptionvarchar(255)NULL Not Used
IsDeletedtinyintNOT NULL Indicates if the row has been deleted. Allowable Values: 0 - False, 1 - True(deleted)
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL 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 Date and time when the object is created.
PatientVisit_oidintNULL Patient Visit_oid. one-to-one relationship between HProcedure and HPatientVisit.
CPTCodevarchar(30)NULL CPT code of the procedure.
CodeDescriptionvarchar(255)NULL Description of the procedure associated with the CPT code
PriorityintNULL Priority of the diagnosis. When set to high, it indicates that the diagnosis of the patient ailment must be immediately completed.
Value of this field can be any number(from 0 to 9 for example) and client can set up ADT preference "Maximumlimitofpriority" to the maximum available number.
It is up to the client to assign that number.
Releasevarchar(5)NULL Release number of the CPT code
Versionvarchar(64)NULL Version number of the CPT code
StartDatedatetimeNULL Start date and time of a procedure to be performed on a patient
EndDatedatetimeNULL Date and time when a procedure performed on a patient would end.
Commentsvarchar(255)NULL Comments(remarks) on a procedure as entered by the user.
LocalizationtinyintNULL Localization for the procedure. For example, if a patient's elbow requires surgery, LeftLocalization could mean that the surgical procedure needs to be performed on the patient's left elbow. Allowable Values: 0, 1, 2, 3, or NULL Key of allowable values: 0 - NoLocalization 1 - LeftLocalization 2 - RightLocalization 3 - BothLocalization
IsPreliminarybitNULL When set to True, indicates that the procedure is in preliminary stage. Allowable Values: 0, 1, or NULL. Key of allowable values: 0 - False 1 - True
IsExtensionbitNULL When set to True, indicates that the procedure performed on the patient would take longer time than anticipated. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
IsNursebitNULL When set to True, indicates that the procedure to be performed on a patient is assigned by a nurse. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
IsSurgicalbitNULL When set to True, indicates that the procedure to be performed on a patient requires surgery. Allowable Values: 0, 1, or NULL Key of allowable values: 0 - False 1 - True
AssignedByvarchar(190)NULL The name of the physician who has assigned the procedure.
ProcedureTimedatetimeNULL The date and time when the procedure is assigned.
ProcedureStatustinyintNULL The status of the procedure. Allowable Values: 3, 4, or 5. Key of allowable values: 3 - Completed, 4 - Aborted, 5 - Erroneous
ExternalIDvarchar(10)NULL The external ID of the procedure that belongs to a third-party application.
ParentProcedureOIDintNULL The object ID of the parent procedure for linked procedure.
AssociatedUnitOIDintNULL The object ID of the unit associated with the patient on whom a procedure is/will be performed. Must exist in HHealthCareUnit Table.
ExternalObjectIDintNULL The object ID provided by a Soarian module.
ExternalObjectTypevarchar(64)NULL Type of the external object. This is a data dictionary item that is set up by client.
CDMvarchar(64)NULL CDM code - the technical service code associated with the CPT code.
PDMvarchar(30)NULL PDM code - the professional service code associated with the CPT code
AssociationLevelTinyIntNULL Not In Use
VisitMoveNumbervarchar(75)NULL Move number of visit. A move occurs in a SAP external system, frequently when a patient changes MRU. For non-SAP users, this column should always be NULL.
LastCngDtimeDATETIMENULL Last system UTC date /time when row was updated.
CodeTypevarchar(16)NULL Type of the code value. Allowable values: 'SNOMED' or NULL
Sourcevarchar(16)NULL Procedure Source - whether this procedure was entered in Soarian Clinicals or it was interfaced from the financial system. Allowable values : 'Clinicals' or client defined external system(for example - 'External')
IncisionDTimeMinssmalldatetimeNULL Incision date time(if the procedure was surgical)
AnesthesiaTypevarchar(64)NULL Type of the anesthesia. The allowable value list is based on a data dictionary item with item type code "Ord.AnesthesiaType"
AnesthesiaStartDTimeMinssmalldatetimeNULL The start date and time of the anesthesia
AnesthesiaEndDTimeMinssmalldatetimeNULL The end date and time of the anesthesia
PerformedByStaffNamevarchar(188)NULL Name of the staff who performed the procedure. Format : Last name, First Name, Middle Name.
PerformedByStaffOIDintNULL ObjectID of the staff who performed the procedure. Must exist in HStaff table.
PatientOIDintNOT NULL ObjectID of the patient. Must exist in HPatient Table.
IsPrimarytinyintNULL Primary procedure indicator. Allowable Values: 0 - False, 1 - True
ChangeNosmallintNULL This field can be valued to NUll, 0 or next sequential number when procedure was edited.

Return to Table-Index

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