Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PendingLocation_OID | int | NOT NULL | Primary Key |
CreationDTimeMins | smalldatetime | NOT NULL | DateTime stamp when the row was created in the database. |
PatientVisit_oid | int | NOT NULL | Visit_oid of patient for this pending location request |
BedReqPatLoc_OID | int | NOT NULL | Location unit objectid for the pending patient. |
BedReqPatLocName | varchar(75) | NULL | Location unit name for the pending patient. |
BedRequested_OID | int | NULL | Holds oid of bed requested. |
BedRequestedName | varchar(75) | NULL | Name of the bed requested for the patient. |
BedReqMRU_OID | int | NULL | Medically responsible unit(MRU) objectid requested for the patient. |
BedReqMRUName | varchar(75) | NULL | Medically responsible unit(MRU) name requested for the patient. |
BedReqDTimeMins | smalldatetime | NULL | DateTime when the pending location is desired for the patient. |
PendingStatus | varchar(10) | NOT NULL | status of the pending location request(Inactive, Active, Canceled, Fulfilled) |
LastCngDtime | datetime | NULL | Indicates the current Universal Time Coordinate or Greenwich Mean Time |
|
|