Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HLeaveOfAbsence Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | RecordId of the Patient |
Description | varchar(18) | NULL | Not Used |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HLeaveOfAbsence row |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
Remarks | varchar(512) | NULL | Remarks specified on the patient's leave of absence. |
StartDate | datetime | NULL | Date and time when the patient's leave of absence began. |
EndDate | datetime | NULL | Date and time when the patient's leave of absence ends. |
PatientVisit_oid | int | NULL | Patient Visit Oid associated with LOA, same as Objectid for the visit in HPatientVisit Table. |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
ExpReturnDate | DATETIME | NULL | Date and time when the patient's leave of absence expected to end. |
IsCanceled | BIT | NULL | Indicates if the patient's leave of absence was canceled. Allowable Values: 0 - Not Canceled, 1 - Canceled, NULL - not valued. |
IsActive | BIT | NULL | Indicates if the patient's leave of absence is active. Allowable Values: 0 - Not Active, 1 - Active. |
LOAOccurrenceName | varchar(50) | NULL | Patient's leave of absence occurrence name , for example : "1st Leave" |
LeaveContactInfo | varchar(255) | NULL | Patient's leave of absence contact Information |
LevelOfCare | varchar(64) | NULL | Level of care |
|