Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectID of HBed table generated by Architecture |
InstanceHFCID | smallint | NOT NULL | InstanceHFCID of HBed table generated by Architecture |
RecordId | int | NULL | RecordID of HBed table generated by Architecture |
Description | varchar(255) | NULL | Description of the bed that is being created. Client can value that field as a descriptive name of the bed. |
IsVersioned | bit | NOT NULL | Indicates if the row in the table is modified or not. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserID of the user who created the row in the database |
CreationTime | smalldatetime | NULL | Date and Time when row was created. |
BedTypeName | varchar(75) | NOT NULL | Bed display name created by Admin user, this is a combination of RoomCode & BedCode columns |
BedStatus | tinyint | NOT NULL | Bed Status. Allowable Values: 0 - Occupied, 1- House keeping, 2-vacant |
Active | bit | NOT NULL | Active indicator. Allowable Values: 1-Active, 0-Non Active |
IsSchedulable | bit | NULL | Is Schedulable indicator. |
BedType | tinyint | NOT NULL | Bed type Allowable Values: 0- Non Technical, 1- Technical |
BedPath | varchar(2000) | NOT NULL | Hospital Organization path till the bed name right from enterprise |
HealthCareUnit_oid | int | NULL | ObjectID of HHealthCareUnit under which this bed is created |
SeqNo | int | NULL | Sequence Number of the Bed |
RoomCode | varchar(40) | NULL | Room Code where the Bed exists |
BedCode | varchar(75) | NOT NULL | Bed Code of the Bed |
BedExternalAbb | varchar(75) | NOT NULL | Similar to BedTypeName column. Used for inbound and outbound interfaces. Indicates the abbreviation of the bed as known by the external systems like Invision,SF etc. |
StatusModifier | varchar(64) | NULL | Stores one of additional Bed Statuses like Needs Cleaning, Needs Terminal Cleaning, Closed, Hold etc. |
Comments | varchar(256) | NULL | General Comments entered on the Bed that's being created |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|