Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
VersionObjectID | int | NOT NULL | Version ObjectID unique to that letter OID |
CreatedStaffOID | int | NOT NULL | ObjectID of the staff who created this letter version |
CreationTime | smalldatetime | NOT NULL | Time of the letter version creation |
OldStatus | varchar(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. |
NewStatus | varchar(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. |
XMLDocument | text | NOT NULL | Content of the letter for this Version |
LetterOID | int | NOT NULL | ObjectID of the letter for which versions are getting created |