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 |
|
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 |
|
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 |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3ClientVisit table. |
DocumentName |
|
varchar(60) |
YES |
The name of document. |
ClientGUID |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |