Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HLeaveOfAbsence Contains patient Leave of Absence Information.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HLeaveOfAbsence Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(18)NULL Not Used
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HLeaveOfAbsence row
CreationTimesmalldatetimeNULL Date and time when the object is created.
Remarksvarchar(512)NULL Remarks specified on the patient's leave of absence.
StartDatedatetimeNULL Date and time when the patient's leave of absence began.
EndDatedatetimeNULL Date and time when the patient's leave of absence ends.
PatientVisit_oidintNULL Patient Visit Oid associated with LOA, same as Objectid for the visit in HPatientVisit Table.
LastCngDtimedatetimeNULL Last system UTC date /time when row was updated.
ExpReturnDateDATETIMENULL Date and time when the patient's leave of absence expected to end.
IsCanceledBITNULL Indicates if the patient's leave of absence was canceled. Allowable Values: 0 - Not Canceled, 1 - Canceled, NULL - not valued.
IsActiveBITNULL Indicates if the patient's leave of absence is active. Allowable Values: 0 - Not Active, 1 - Active.
LOAOccurrenceNamevarchar(50)NULL Patient's leave of absence occurrence name , for example : "1st Leave"
LeaveContactInfovarchar(255)NULL Patient's leave of absence contact Information
LevelOfCarevarchar(64)NULL Level of care

Return to Table-Index

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