dbo.SXAObjectType 
Default Table Name  SXAObjectType 
Definition  This table defines the types of objects that may be processed by the completion and tracking modules. 

dbo.SXAObjectType Columns 
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(PK)    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. 

dbo.SXAObjectType Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAObjectTypePK  PrimaryKey  ObjectTypeID