Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object ID(such as patient, order, etc.). This field is always a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | HFC(Healthcare Foundation Class) ID of the object. |
RecordId | int | NULL | This column is not used. |
Description | varchar(1) | NULL | This column is not used. |
IsVersioned | bit | NOT NULL | When set to True(1), indicates that the object is modified. |
CreatedUserId | int | NULL | ID of the user who created the assessment |
CreationTime | smalldatetime | NULL | Date and time when the assessment was created. |
AssessmentID | int | NOT NULL | ID of the assessment. |
Version | smallint | NULL | Version of the assessment. |
EndDT | smalldatetime | NULL | Last date and time when the assessment is available for selection or processing. |
AssessmentStatusCode | tinyint | NOT NULL | Code associated with the status of the assessment. Allowable values: 0, 1, 2, 3, 4, 5. Key of allowable values: 0 - Uncharted, 1 - In progress, 2 - Unable to complete, 3 - Complete, 4 - Erroneous, 5 - Draft. |
AssessmentStatus | varchar(35) | NOT NULL | Status of the assessment. Refer to the AssessmentStatusCode column for values. |
CreatedDT | smalldatetime | NOT NULL | Date and time when the assessment was created. |
EnteredDT | smalldatetime | NOT NULL | Date and time when the information about the assessment was entered in the application. |
CollectedDT | smalldatetime | NOT NULL | Date and time when the information about the assessment was collected. |
ChartedFor | varchar(64) | NULL | Name of the clinician for whom the assessment was charted. |
ReasonRevised | varchar(255) | NULL | Reason the assessment details were modified. |
NoteLink | int | NULL | ID of the clinical note associated with the assessment. |
FormDateTime | smalldatetime | NULL | Date and time used to instantiate the form from the Documentation Builder module. |
FormUsage | varchar(50) | NULL | Form usage that was assigned to the assessment as defined in the Documentation Builder Module. |
ScheduledDT | smalldatetime | NULL | Date and time scheduled for the order, when the order was placed for the assessment. |
UserTitle | varchar(20) | NULL | Title of the user who entered the assessment. |
UserAbbrName | varchar(92) | NULL | Name of the user who entered the assessment. |
FormTypeID | int | NULL | ID of the form type as defined in Documentation Builder module. |
FormUsageID | int | NULL | ID of the form usage as defined in the Documentation Builder module. |
Form_oid | int | NOT NULL | ID of the form associated with the assessment. |
Order_oid | int | NULL | ID of the order based on which assessment was charted. |
ReccurringOrder_oid | bigint | NULL | ID of the recurring order for which the assessment was charted. |
Patient_oid | int | NOT NULL | ID of the patient for whom the assessment was charted. |
PatientVisit_oid | int | NULL | ID of the patient visit associated with the patient for whom the assessment was charted. |
HealthCareUnit_oid | int | NULL | ID of the healthcare unit where the assessment was charted. |
User_oid | int | NULL | ID of the user who entered the assessment. |
FormUsageDisplayName | varchar(100) | NULL | The display name for the form usage of the assessment. |
LinkHFCID | int | NULL | HFC ID of the HFC(Healthcare Foundation Class) that was linked to the instance of the assessment. |
LinkObjectID | bigint | NULL | ID of the object that was linked to the instance of the assessment. |
DocumentID | int | NULL | ID for the assessment. |
DocumentVersion | int | NULL | ID assigned to each version of the assessment. Document ID remains the same across different versions for a particular assessment. |
LinkContext | varchar(255) | NULL | The context to open the order detail form if nursing findings are placed on an order detail form. |
PortLevel | smallint | NULL | The level of the current data. |
OrdersAsWrittenText | varchar(300) | NULL | Display name of the PRN order. |
Reviewed | smallint | NULL | If the assessment was reviewed it is set to 1 from the Service provider workspace(SPW). |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|