ColumnName |
Domain |
Datatype |
NULL |
Definition |
SiteID |
|
smallint |
NO |
Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. |
Build |
|
int |
NO |
Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. |
TouchedBy |
|
varchar(50) |
NO |
Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. |
TouchedWhen |
|
datetime |
NO |
The date and time that the row was last updated and will be based on the Enterprise time zone. |
CreatedBy |
|
varchar(50) |
NO |
Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. |
CreatedWhen |
|
datetime |
NO |
The date and time that the row was created and will be based on the Enterprise time zone. |
ObjectTypeID |
|
int |
NO |
Auto generated unique primary key value. |
Active |
|
bit |
NO |
Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. |
ObjectTypeCategory |
|
varchar(25) |
NO |
This field indicates the general category of the object type. Valid values (Order, Task, Document) will be defined in a Codes table in Q4. This category will be stored on the EventHistory table. |
ObjectTypeName |
|
char(25) |
NO |
The name of the type of object. |
DocumentTypeCode |
|
char(12) |
YES |
A code used to identify the document during scanning. |
DocumentBarCode |
|
char(12) |
YES |
A user defined barcode used for document indexing. |
DocumentFormID |
|
char(12) |
YES |
A value used to index the document. |
DocumentAppendRule |
|
varchar(25) |
YES |
A coded value which defines the method to be used when creating documents. Valid values such as (New = Each page is for a new document. Append = Pages scanned sequentially are indexed to same document until a different document type or separator cover is |
DocumentPrintFooter |
|
bit |
NO |
Indicates whether a footer will be printed with the document. 0 = No, 1 = Yes. |
DocumentRotateAllFronts |
|
varchar(25) |
YES |
Indicates whether the front pages of the documents of this type need to be rotated. Valid values (None,Right, Left, Flip) . |
DocumentRotateAllBacks |
|
varchar(25) |
YES |
Indicates whether the back pages of the documents of this type need to be rotated. Valid values (None, Right, Left, Flip). |
CompletionObjectCategory |
|
varchar(25) |
YES |
This field indicates the general category of the completion object. If null, then this type is not tracked as a completion object. Valid values (Order, Task, Document). |
AgingPolicy |
|
varchar(25) |
YES |
This defines how to age the completion object. Valid values (Not aged nightly,Age nightly based on discharge date, Age nightly based on deficiency create date Age nightly based on the client visit create date) will be defined in a Codes table for Q4. N |
SigningPolicy |
|
varchar(25) |
YES |
This defines how residents and attendings must sign documents. Valid values (N/A, Resident must sign before attending, Resident and attending must sign in any order, Resident and attending must sign in any order, and if attending signs, it completes both |
IsUserModifiable |
|
bit |
NO |
An indicator of whether users can edit this object. 0 = False, 1 = True. (Must have the right to add a record with a value of 0 since it is for required data.) |
IsDateNeeded |
|
bit |
NO |
An indicator whether or not this completion object type requires a date in order to identify it. 0 = False; 1 = True |
MSrepl_tran_version |
|
uniqueidentifier |
NO |
Optimistic lock identifier. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |