Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HBedTransfer 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 | 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 performed the transfer |
CreationTime | smalldatetime | NULL | Date and time when row was created. |
FromDate | datetime | NULL | Start Date and Time for a Transfer |
ToDate | datetime | NULL | End Date and Time for a Transfer |
Active | bit | NULL | Active indicator. When 0 - Inactive transfer row, when 1 - Active Transfer row |
ReasonforPatientTransfer | varchar(75) | NULL | A String representing Reason For Patient Transfer |
FromBedName | varchar(75) | NULL | Name of the Bed the patient was transferred from. |
ToBedName | varchar(75) | NULL | Name of the Bed the patient was transferred to. |
IsolationIndicator | varchar(64) | NULL | Its a Data Dictionary Item created by client and enterd by the user during transfer. |
UserID | varchar(10) | NULL | UserId of the user who performed the transfer |
AccommodationType | varchar(64) | NULL | It is a Data Dictionary Item created by client and enterd by the user during transfer. |
FormID | int | NULL | ID of the Transfer Form used to perform Transfer from Soarian UI(Obsolete) |
PatientVisit_oid | int | NOT NULL | Visit ObjectID of the HPatientVisit to which the transfer belongs |
FromBed_oid | int | NULL | Bed ObjectID patient was moved from. Must exist in HBed table |
ToBed_oid | int | NULL | Bed ObjectID patient was moved to. Must exist in HBed table |
FromLocation_oid | int | NOT NULL | Location ObjectID patient was moved from. Should exist in HHealthcareunit table |
ToLocation_oid | int | NULL | Location ObjectID patient was moved to. Should exist in HHealthcareunit table |
BedTransferExtension_oid | int | NULL | Not used |
ExternalID | varchar(75) | NULL | It is the move number associated with a transfer. Will be useful while cancelling a transfer. |
Cancelled | smallint | NULL | Cancel Indicator. Allowable Values: 0 - false, null - Not valued, 1 - True(Cancelled). |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|