Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HLetterVersions This table stores the information for the versions of a clinical letter.
Column Name Column Datatype Column Null Option Column Comment
VersionObjectIDintNOT NULL Version ObjectID unique to that letter OID
CreatedStaffOIDintNOT NULL ObjectID of the staff who created this letter version
CreationTimesmalldatetimeNOT NULL Time of the letter version creation
OldStatusvarchar(10)NOT NULL Last version of that letter OID. Allowable values for version of the letter which is of the format MainStatus, SubStatus(SubStatus will be 0 if the main status has a unique value).
1,0 -> Letter is in draft.
2,2 -> In progress by Physician.
2,3 -> In progress by typist.
3,0 -> Letter is signed.
4,4 -> Letter is completed.
4,5 -> Letter is completed and printed.
5,0 -> Letter status is erroneous.
6,0 -> Letter is cosigned.
0,0 -> This is the value of NewStatus for a discarded letter and the value of OldStatus for a new clinical letter.
NewStatusvarchar(10)NOT NULL New version of that letter OID. Allowable values for version of the letter which is of the format MainStatus, SubStatus(SubStatus will be 0 if the main status has a unique value).
1,0 -> Letter is in draft.
2,2 -> In progress by Physician.
2,3 -> In progress by typist.
3,0 -> Letter is signed.
4,4 -> Letter is completed.
4,5 -> Letter is completed and printed.
5,0 -> Letter status is erroneous.
6,0 -> Letter is cosigned.
0,0 -> This is the value of NewStatus for a discarded letter and the value of OldStatus for a new clinical letter.
XMLDocumenttextNOT NULL Content of the letter for this Version
LetterOIDintNOT NULLObjectID of the letter for which versions are getting created

Return to Table-Index

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