SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  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 
Definition  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 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  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 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

ObjectTypeID 
Definition  Auto generated unique primary key value. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

ObjectTypeCategory 
Definition  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 
Definition  The name of the type of object. 

DocumentTypeCode 
Definition  A code used to identify the document during scanning. 

DocumentBarCode 
Definition  A user defined barcode used for document indexing. 

DocumentFormID 
Definition  A value used to index the document. 

DocumentAppendRule 
Definition  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 
Definition  Indicates whether a footer will be printed with the document. 0 = No, 1 = Yes. 

DocumentRotateAllFronts 
Definition  Indicates whether the front pages of the documents of this type need to be rotated. Valid values (None,Right, Left, Flip) . 

DocumentRotateAllBacks 
Definition  Indicates whether the back pages of the documents of this type need to be rotated. Valid values (None, Right, Left, Flip). 

CompletionObjectCategory 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  An indicator whether or not this completion object type requires a date in order to identify it. 0 = False; 1 = True 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.