Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HBedTransferHistory 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(15) | NULL | Valued by the User. |
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 performed the transfer |
CreationTime | smalldatetime | NULL | CreationTime of the row creation |
FromDate | datetime | NULL | Start Date and Time for a Transfer. |
UserID | varchar(10) | NULL | UserId of the user who performed the transfer |
PatientVisitOID | int | NOT NULL | ObjectID of the HPatientVisit to which the transfer belongs |
BedTransfer_OID | int | NOT NULL | ObjectID of the HBedTransfer to which the transfer belongs |
ReasonforPatientTransfer | varchar(75) | NULL | A String representing Reason For Patient Transfer |
AccommodationType | varchar(64) | NULL | Accommodation Type of the bed |
BedName | varchar(75) | NULL | BedName of the From bed |
Bed_OID | int | NULL | ObjectID of the FromBed in HBed table |
Location_OID | int | NOT NULL | ObjectID of the Location in HHealthcareunit table |
ExternalID | varchar(75) | NULL | It is the move number associated with a transfer. Will be useful while cancelling a transfer. |
Cancelled | smallint | NULL | Bed transfer Cancel Indicator. Allowable Values: 0 - not cancelled, 1 - Cancelled, Null - Not Valued. |
LastCngDtime | datetime | | System UTC date /time when row was updated. |