Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HAssessment Details on the patient's assessments.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL Object ID(such as patient, order, etc.). This field is always a primary key for the associated table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL This column is not used.
Descriptionvarchar(1)NULL This column is not used.
IsVersionedbitNOT NULL When set to True(1), indicates that the object is modified.
CreatedUserIdintNULL ID of the user who created the assessment
CreationTimesmalldatetimeNULL Date and time when the assessment was created.
AssessmentIDintNOT NULLID of the assessment.
VersionsmallintNULL Version of the assessment.
EndDTsmalldatetimeNULL Last date and time when the assessment is available for selection or processing.
AssessmentStatusCodetinyintNOT NULLCode 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.
AssessmentStatusvarchar(35)NOT NULLStatus of the assessment. Refer to the AssessmentStatusCode column for values.
CreatedDTsmalldatetimeNOT NULLDate and time when the assessment was created.
EnteredDTsmalldatetimeNOT NULLDate and time when the information about the assessment was entered in the application.
CollectedDTsmalldatetimeNOT NULLDate and time when the information about the assessment was collected.
ChartedForvarchar(64)NULL Name of the clinician for whom the assessment was charted.
ReasonRevisedvarchar(255)NULL Reason the assessment details were modified.
NoteLinkintNULL ID of the clinical note associated with the assessment.
FormDateTimesmalldatetimeNULL Date and time used to instantiate the form from the Documentation Builder module.
FormUsagevarchar(50)NULL Form usage that was assigned to the assessment as defined in the Documentation Builder Module.
ScheduledDTsmalldatetimeNULL Date and time scheduled for the order, when the order was placed for the assessment.
UserTitlevarchar(20)NULL Title of the user who entered the assessment.
UserAbbrNamevarchar(92)NULL Name of the user who entered the assessment.
FormTypeIDintNULL ID of the form type as defined in Documentation Builder module.
FormUsageIDintNULL ID of the form usage as defined in the Documentation Builder module.
Form_oidintNOT NULLID of the form associated with the assessment.
Order_oidintNULL ID of the order based on which assessment was charted.
ReccurringOrder_oidbigintNULL ID of the recurring order for which the assessment was charted.
Patient_oidintNOT NULLID of the patient for whom the assessment was charted.
PatientVisit_oidintNULL ID of the patient visit associated with the patient for whom the assessment was charted.
HealthCareUnit_oidintNULL ID of the healthcare unit where the assessment was charted.
User_oidintNULL ID of the user who entered the assessment.
FormUsageDisplayNamevarchar(100)NULL The display name for the form usage of the assessment.
LinkHFCIDintNULL HFC ID of the HFC(Healthcare Foundation Class) that was linked to the instance of the assessment.
LinkObjectIDbigintNULL ID of the object that was linked to the instance of the assessment.
DocumentIDintNULL ID for the assessment.
DocumentVersionintNULL ID assigned to each version of the assessment. Document ID remains the same across different versions for a particular assessment.
LinkContextvarchar(255)NULL The context to open the order detail form if nursing findings are placed on an order detail form.
PortLevelsmallintNULL The level of the current data.
OrdersAsWrittenTextvarchar(300)NULL Display name of the PRN order.
ReviewedsmallintNULL If the assessment was reviewed it is set to 1 from the Service provider workspace(SPW).
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates