Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
NRS_Document Details about the document used to chart an assessment with an Inter Module Adaptability (IMA) element valued.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL The primary key for the associated table.
InstanceHFCIDsmallintNOT NULL HFC(Healthcare Foundation Class) ID of the object.
RecordIdintNULL This column is not used.
Descriptionvarchar(255)NULL This column is not used.
IsDeletedtinyintNOT NULL When set to True(1) indicates the document is deleted.
IsVersionedbitNOT NULL When set to True(1), indicates that the object was modified.
CreatedUserIdintNULL Object ID of the user who created the object.
CreationTimesmalldatetimeNULL Date and time when the object was created.
DocumentIDintNOT NULLID of the document used to chart items having an IMA(Inter Module Adaptability) element.
VersionIDintNULL Version of the document.
Typevarchar(50)NULL Type of the document.
ParentDocumentIDintNULL ID of the parent document.
TopLevelDocumentIDintNULL The top level document id.
ValidFromsmalldatetimeNULL Date from which the document was valid.
ValidTosmalldatetimeNULL Date to which the document is valid.
Statevarchar(20)NULL This column is not used.
UserOIDintNULL The same as CreatedUserId.
PatientOIDintNULL Object ID of the patient.
VisitOIDintNULL Object ID of the visit.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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