Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObservationID | BIGINT | NOT NULL | This is same as the ObservationID in HObservation, indicates the unique ID assigned to the observation. |
FindingAbbr | VARCHAR(16) | NOT NULL | Abbreviation of the non-diagnostic finding |
Value | VARCHAR(2000) | NULL | Value of the observation |
UOMCode | VARCHAR(16) | NULL | Code associated with the unit of measure used for the observation |
UOM | VARCHAR(16) | NULL | Description of the unit of measure used for the observation |
BaseUnitValue | FLOAT(53) | NULL | The equivalent value of the observations in the base unit of measure. |
UOMType | VARCHAR(16) | NOT NULL | Unit of measure type for the observation |
AssessmentID | INT | NOT NULL | Assessment ID associated with the observation |
AsmtCollectedDTimeMins | SMALLDATETIME | NOT NULL | Date and time when the information about the assessment is collected. |
AsmtStatusCode | TINYINT | NOT NULL | Status code of the assessment |
AsmtEnteredDTimeMins | SMALLDATETIME | NOT NULL | Date and time when the information about the assessment is entered in the application |
Patient_oid | INT | NOT NULL | Object id of HPatient table |
PatientVisit_oid | INT | NOT NULL | Object id of HPatientVisit table |
InternalValue | VARCHAR(500) | NULL | Finding's InternalValue of the encoded observation ex:(Ex:Smoking status -Former smoker(13) Heavy smoker(17)) |
FindingDataType | INT | NULL | Finding's DataType, such as numeric, encoded, etc. |
ProcessingTypeCode | INT | NULL | Finding's ProcessingTypeCode Allowable Values: 0, 1, 2, 3, 4, 5, 6, 7, or NULL Key of allowable values: 0 - Intake 1 - Output 2 - BP 3 - Height 4 - Weight 5 - Temperature 6 - Diagnostic 7 - None |