dbo.CV3ClientDocumentCUR 
Default Table Name  CV3ClientDocumentCUR 
Definition  Contains current document records. This table has the clinical documentation in the form of an assessment, note, or free format observations. 

dbo.CV3ClientDocumentCUR Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  YES  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
RepFlags    tinyint  YES  Indicates the action in a distributed database environment. 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)  YES  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)  YES  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. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
GUID(PK)    HVCIDdt  NO  Unique primary key value. 
Entered    datetime  YES  Visit TimeZone - The date and time the document was entered. 
Status    varchar(10)  YES  The document status. (Not used.) 
ToBeVerified    bit  NO  Indicates if the document needs to be verified. 1 = True; 0 = False 
ToBeSigned    bit  NO  Indicates if the document needs to be signed. 1 = True; 0 = False 
EnterRole    varchar(30)  YES  The role of the entered user. (Not used.) 
UserGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3User table. 
AuthoredDtm    datetime  YES  Visit TimeZone - The date and time the document was authored. 
ClientVisitGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientVisit table. 
DocumentName    varchar(60)  YES  The name of document. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
EntryType    int  NO  The data entry type. 1 = FreeText; 2 = Knowledge Tree; 3 = Flowsheet 
ChartGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Chart table. 
HasBeenModified    bit  NO  Indicates if the document has been modified. 1 = True; 0 = False 
PatCareDocGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3PatientCareDocument table. 
IsCanceled    bit  NO  Indicates if the document is canceled. 1 = True; 0 = False 
AuthoredProviderGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3CareProvider table. 
DocumentSource    varchar(30)  YES  The document source code from the user-defined Document Source dictionary. 
ApplicationSource    varchar(5)  YES  For HL7 support, this is used to identify the application that created the document. 
KTreeRootGUID    HVCIDdt  YES  The link to the Knowledge Tree or flowsheet used to enter this document . 
TextType    int  NO  Represents the type of text this document contains. 1 = Standard Text; 2 = Fixed Text; 3 = Rich Text 
FillerFacilityID    varchar(12)  YES  For HL7 support, this is used to identify the filling facility that sent the document. 
FillerDocumentID    varchar(75)  YES  For HL7 support, this is used to identify document ID that the filling facility that sent the Document uses. 
ArrivalDtm    datetime  YES  Visit TimeZone - Used for replication. 
HasMediaLink    tinyint  YES  Indicates if the document contains
Images. 0=None, 1=Regular Image, 2=Inked Image 
CreatorType    int  YES  Indicates who created the document, because there are several other objects that create documents. 1 = NoCreator; 2 = Order; 3 = OrderTaskOccur; 4 = Variance 
CreatorGUID    HVCIDdt  YES  The link to the object that was responsible for creating this document depending on the Creator Type. 
HasMultipleAuthors    tinyint  YES  Indicates if this document has multiple authors. 1 = True; 0 = False 
HasAuthorSigned    tinyint  YES  Indicates if the main author in this document has signed. 1 = True; 0 = False 
AuthorGroupCounter    int  YES  Tracks which instance of history the author’s belong to. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
IsIncomplete    bit  YES  Flags the document as Incomplete 
IsResultsPending    bit  YES  Flags the document as Results Pending 
IsImportant    bit  YES  Flags the document as Important 
IsDaylightSavings    smallint  YES  a flag to indicate additional set of time columns on flowsheets for 1-2am for the additional hour gained during daylight savings time. 
HasImageType    tinyint  YES  Has an image linked with the record 
ShiftDailyHourlyTotal    int  YES  Denormalised from CV3ObservationDetail 
LocationGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Location table. 
CanceledDtm    datetime  YES  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    HVCIDdt  YES  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(PK)    int  NO  Primary key 
ServiceDtmUTC    datetimeoffset(3)  YES  Visit TimeZone - DateTime field for adding Date of Service 
IsLocked    bit  NO  New column need to add to maintain the state of the document. i.e. 1=Locked/0=Unlocked 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
DS4PStatus    char(1)  NO  This column stores the DS4PStatus value to describe privacy level of client document. Expected values are N, R, V. 
ExchangeDocCategory    int  YES  Store category for exchange document. Categories are defined by the Community(IHE). 
CommunityDocXML    xml  YES  Store Community Documents information in XML format 
CommunityFacility    varchar(500)  YES  Store Community Facility 
SourceType    int  YES  Store Enum value for community document source 
IsChartingInProgress    bit  NO  Stores true if the user is currently charting on the document 
SendDocToPatientPortalType    tinyint  NO  Is This Document Being Sent to Patient Portal (0 - Not marked, 1 - Send, 2 - Do Not Send) 
DoNotSendToPortalReason    varchar(255)  YES  Marking the document and capturing reason from not sending to SPP or FMH 
FDSCategoryType    int  YES  Flowsheet Daily Summary Category Type  
FDSAvailableToPtEffDtmUTC    datetimeoffset(3)  YES  Flowsheet Daily Summary's AvailableTo Patient Portal Effective Date Time  

dbo.CV3ClientDocumentCUR Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3ClientDocumentCURPK  PrimaryKey  GUID, ArcType