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

RepFlags 
Definition  Indicates the action in a distributed database environment. 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. 

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

GUID 
Definition  Unique primary key value. 

Entered 
Definition  Visit TimeZone - The date and time the document was entered. 

Status 
Definition  The document status. (Not used.) 

ToBeVerified 
Definition  Indicates if the document needs to be verified. 1 = True; 0 = False 

ToBeSigned 
Definition  Indicates if the document needs to be signed. 1 = True; 0 = False 

EnterRole 
Definition  The role of the entered user. (Not used.) 

UserGUID 
Definition  A foreign key to the GUID column in the CV3User table. 

AuthoredDtm 
Definition  Visit TimeZone - The date and time the document was authored. 

ClientVisitGUID 
Definition  A foreign key to the GUID column in the CV3ClientVisit table. 

DocumentName 
Definition  The name of document. 

ClientGUID 
Definition  A foreign key to the GUID column in the CV3Client table. 

EntryType 
Definition  The data entry type. 1 = FreeText; 2 = Knowledge Tree; 3 = Flowsheet 

ChartGUID 
Definition  A foreign key to the GUID column in the CV3Chart table. 

HasBeenModified 
Definition  Indicates if the document has been modified. 1 = True; 0 = False 

PatCareDocGUID 
Definition  A foreign key to the GUID column in the CV3PatientCareDocument table. 

IsCanceled 
Definition  Indicates if the document is canceled. 1 = True; 0 = False 

AuthoredProviderGUID 
Definition  A foreign key to the GUID column in the CV3CareProvider table. 

DocumentSource 
Definition  The document source code from the user-defined Document Source dictionary. 

ApplicationSource 
Definition  For HL7 support, this is used to identify the application that created the document. 

KTreeRootGUID 
Definition  The link to the Knowledge Tree or flowsheet used to enter this document . 

TextType 
Definition  Represents the type of text this document contains. 1 = Standard Text; 2 = Fixed Text; 3 = Rich Text 

FillerFacilityID 
Definition  For HL7 support, this is used to identify the filling facility that sent the document. 

FillerDocumentID 
Definition  For HL7 support, this is used to identify document ID that the filling facility that sent the Document uses. 

ArrivalDtm 
Definition  Visit TimeZone - Used for replication. 

HasMediaLink 
Definition  Indicates if the document contains
Images. 0=None, 1=Regular Image, 2=Inked Image 

CreatorType 
Definition  Indicates who created the document, because there are several other objects that create documents. 1 = NoCreator; 2 = Order; 3 = OrderTaskOccur; 4 = Variance 

CreatorGUID 
Definition  The link to the object that was responsible for creating this document depending on the Creator Type. 

HasMultipleAuthors 
Definition  Indicates if this document has multiple authors. 1 = True; 0 = False 

HasAuthorSigned 
Definition  Indicates if the main author in this document has signed. 1 = True; 0 = False 

AuthorGroupCounter 
Definition  Tracks which instance of history the author’s belong to. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsIncomplete 
Definition  Flags the document as Incomplete 

IsResultsPending 
Definition  Flags the document as Results Pending 

IsImportant 
Definition  Flags the document as Important 

IsDaylightSavings 
Definition  a flag to indicate additional set of time columns on flowsheets for 1-2am for the additional hour gained during daylight savings time. 

HasImageType 
Definition  Has an image linked with the record 

ShiftDailyHourlyTotal 
Definition  Renormalized from CV3ObservationDetail 

LocationGUID 
Definition  A foreign key to the GUID column in the CV3Location table. 

CanceledDtm 
Definition  Visit TimeZone - When the time column is deleted Canceled DateTime stamp need to be stored to differentiate between columns with same Date/Time, in order to sort the time columns correctly and other purposes. 

FinalizedCareProviderGUID 
Definition  This is a new column. Finalized Provider is the last provider that makes the 'DocumentStatus' become final. It can be null meaning the document has not been finalized yet. 

ArcType 
Definition  Primary key 

ServiceDtmUTC 
Definition  Visit TimeZone - DateTime field for adding Date of Service 

IsLocked 
Definition  New column need to add to maintain the state of the document. i.e. 1=Locked/0=Unlocked 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

DS4PStatus 
Definition  This column stores the DS4PStatus value to describe privacy level of client document. Expected values are N, R, V. 

ExchangeDocCategory 
Definition  Store category for exchange document. Categories are defined by the Community(IHE). 

CommunityDocXML 
Definition  Store Community Documents information in XML format 

CommunityFacility 
Definition  Store Community Facility 

SourceType 
Definition  Store Enum value for community document source 

IsChartingInProgress 
Definition  Stores true if the user is currently charting on the document 

SendDocToPatientPortalType 
Definition  Is This Document Being Sent to Patient Portal (0 - Not marked, 1 - Send, 2 - Do Not Send) 

DoNotSendToPortalReason 
Definition  Marking the document and capturing reason from not sending to SPP or FMH 

FDSCategoryType 
Definition  Flowsheet Daily Summary Category Type  

FDSAvailableToPtEffDtmUTC 
Definition  Flowsheet Daily Summary's AvailableTo Patient Portal Effective Date Time