Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 1509. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application. |
RecordId | int | NULL | Not valued in this table. |
Description | varchar(1) | NULL | Not valued in this table. |
IsVersioned | bit | NOT NULL | When set to True, the object was modified. Once this field is set to True, you cannot reset it to False. Allowable Values: 0 - False, 1 - True. Note: The presence of this field in tables depends on the configuration at the time of table design. |
CreatedUserId | int | NULL | Object ID of the logged in user who created this record. |
| | | This field is linked to HSUser table to get details about the user. For more information see description of HSUser table. |
CreationTime | smalldatetime | NULL | Date and time when the record was created. |
CopiesTo | varchar(256) | NULL | This field captures a ";" separated list of StaffNames & HCU's as entered by the user in Order Detail Form. Reports print this to specify where(person or unit) the order information was copied to. |
OrderingDevice | varchar(20) | NULL | The device/workstation from where the order was placed. |
ResearchProgram | varchar(64) | NULL | Clients can tag the orders with some Research programs and use it to fetch these orders for their research. |
Condition | varchar(64) | NULL | Client-defined value for recording a medical condition with the order. Eg. Peripherally Inserted Central Catheter, Blood Glucose greater than 200 less than 60, etc. |
CommentingLevel | varchar(32) | NULL | Client-defined value for comments. |
SpecificView | varchar(32) | NULL | Client-defined value for radiology views. |
TransportMethods | varchar(32) | NULL | The client-defined transport method. Ex. Walk, wheelchair. |
VerbalOrderIndicator | bit | NULL | DEPRICATED : Boolean flag indicating whether the order is verbal. One should use field OrderSourceAbbr=='VERB' to evaluate if order is verbal or not. |
GuideLines | varchar(255) | NULL | Descriptive text specifying guidelines to execute the order. |
ClinicalInformation | varchar(64) | NULL | Free text value specifying some clinical information. |
ReasonForRequest | varchar(64) | NULL | The reason for requesting the order. |
Instruction | varchar(255) | NULL | Special instructions to be followed before, after or during execution of the placed order. |
IsolationFlag | bit | NULL | Flag indicating whether isolation precautions should be taken or not. Allowable Values: 0 - No, 1 - Yes |
TransArrResp | varchar(64) | NULL | Client-defined value for describing the entity/person responsible for arranging the transport for the service ordered. |
ProblemName | varchar(200) | NULL | Free text name of the problem for which the order got placed. |
ConsultNoOfVisitsValues | tinyint | NULL | Client-defined value for recording number of consult visits. |
ConsultRequestValues | varchar(32) | NULL | Client-defined value for recording the consult request. Eg. Evaluate Patient , Routine Check, etc. |
ConsultHistory | varchar(120) | NULL | Free text value which documents the history of consultations. |
ReasonForDiscontinue | varchar(120) | NULL | The reason the order was discontinued. |
ReasonForDupOverride | varchar(64) | NULL | Free text value which documents the reason to override a duplicate order alert. |
PerformedLocation | varchar(10) | NULL | Free text value which documents the location where the order was performed. |
TransportMethodCode | tinyint | NULL | User defined code for Transport method. |
DietModifier1 | varchar(1000) | NULL | Client-defined value for recording the diet modifiers on a diet order. These can contain multiple values which are separated by the unicode character 0X01E |
| | | Eg. Low Sodium, No Hot Beverages, No Breakfast Eggs, etc.(instead of a comma ',' it will be the Unicode character). |
|
DietModifier2 | varchar(1000) | NULL | Client-defined value for recording the diet modifiers on a diet order. These can contain multiple values which are separated by the unicode character 0X01E |
| | | Eg. Low Sodium, No Hot Beverages, No Breakfast Eggs, etc.(instead of a comma ',' it will be the Unicode character). |
|
DietModifier3 | varchar(1000) | NULL | Client-defined value for recording the diet modifiers on a diet order. These can contain multiple values which are separated by the unicode character 0X01E |
| | | Eg. Low Sodium, No Hot Beverages, No Breakfast Eggs, etc.(instead of a comma ',' it will be the Unicode character). |
|
RespiratoryRate | varchar(8) | NULL | Documents respiratory rate on a respiratory order. |
PercentageOfOxygen | varchar(8) | NULL | Documents percentage of oxygen required for a respiratory order. |
PEEP | varchar(8) | NULL | Positive End-Expiratory Pressure(PEEP) is mechanical ventilator parameter set for a respiratory order. |
VolumeTotal | varchar(8) | NULL | Client-defined value indicating lung capacity setting for respiratory equipment. |
Medication | varchar(64) | NULL | The supplemental medication information on a non-med order. |
Dose | varchar(30) | NULL | The dose for the supplemental medication. |
Diluent | varchar(64) | NULL | Any Diluent or solution used for the supplemental medication. |
Mode | varchar(32) | NULL | The Mode/Route for the supplemental medication. |
PIP | varchar(8) | NULL | Peak inspiratory pressure(PIP) is mechanical ventilator parameter set for a respiratory order. |
InspiratoryTime | varchar(15) | NULL | Inspiratory Time is the mechanical ventilator parameter set for a respiratory order. |
Device | varchar(32) | NULL | Device used for the respiratory order. |
PrimaryCDM | varchar(32) | NULL | Primary Charge Description Master Code(CDM). |
SecondaryCDM | varchar(32) | NULL | Secondary Charge Description Master Code(CDM). |
LPM | varchar(8) | NULL | Liters of air per minute(LPM). It is a measurement of the velocity at which air flows into the sample probe. Valued for respiratory orders. |
PressureSupport | varchar(15) | NULL | When the patient takes a breath and the ventilator then adds pressure to that breath to make it easier for the patient to achieve a good tidal volume. This added pressure is captured in this field. |
AttendingPhysician | varchar(188) | NULL | Name of the Staff(HStaff) who is the attending physician for the visit on which the order was placed. |
AdmittingPhysician | varchar(188) | NULL | Name of the Staff(HStaff) who is the admitting physician for the visit on which the order was placed. |
ReasonForRevision | varchar(120) | NULL | Free text reason for the revision of the order. |
DoseUOM | varchar(16) | NULL | Unit of Measure for the Dose value. |
OrderSourceModifierName | varchar(64) | NULL | Name of the Order Source Modifier with which the order was placed. |
SampleToBeCollByStaffOID | int | NULL | Object ID of the Staff(HStaff) planned to collect the sample. |
SampleToBeCollByStaff | varchar(188) | NULL | Name of the Staff(HStaff) planned to collect the sample. |
TargetCosigner1StaffName | varchar(188) | NULL | Name of the Staff(HStaff) planned to cosign the order. |
TargetCosigner2StaffName | varchar(188) | NULL | Name of the Staff(HStaff) planned to cosign the order. |
TargetCosigner3StaffName | varchar(188) | NULL | Name of the Staff(HStaff) planned to cosign the order. |
TargetCosigner1StaffOID | Int | NULL | Object ID of the Staff(HStaff) planned to cosign the order. |
TargetCosigner2StaffOID | Int | NULL | Object ID of the Staff(HStaff) planned to cosign the order. |
TargetCosigner3StaffOID | Int | NULL | Object ID of the Staff(HStaff) planned to cosign the order. |
OrderSourceModifierOID | Int | NULL | Object ID for the Order Source Modifier(HOrderSourceModifier) |
OrderSourceAbbr | char(4) | NULL | Abbreviation of the base order source. |
| | | Allowable Values: |
| | | VERB - Verbal |
| | | WRTN - Written |
| | | PRTL - Per Protocol |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|