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 |
YES |
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 |
YES |
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. |
Label |
|
varchar(40) |
YES |
The label which appears on the entry form and reports. |
DefaultValue |
|
varchar(2000) |
YES |
The specific value to default. |
DataItemCode |
|
varchar(40) |
YES |
A link to the data item (CV3DataItem)
|
SummaryDelimiter |
|
varchar(80) |
YES |
Delimiter used when this field appears on the orders summary line. |
Sequence |
|
int |
NO |
The display sequence. |
SummaryPosition |
|
int |
NO |
The position in which data will appear in the order summary line. |
SummaryLength |
|
int |
NO |
The maximum number of characters that this field contributes to the order summary line. |
IsMandatoryOrderEntry |
|
bit |
NO |
Indicates if this field is mandatory for order entry. |
IsMandatorySpecimenEntry |
|
bit |
NO |
Indicates if this field is mandatory for specimen entry. |
IsProtected |
|
bit |
NO |
Indicates if this field is protected from modification. |
IsVisible |
|
bit |
NO |
Indicates if this field displays on the form. |
IsInSummary |
|
bit |
NO |
Indicates if this field appears in the order summary line. |
IsPrinted |
|
bit |
NO |
Indicates if this field is printed on the order requisition. |
OrderEntryFormGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3OrderEntryForm table. |
DataItemGUID |
|
HVCIDdt |
YES |
The link to the data item. |
IsModifiable |
|
bit |
NO |
Indicates if this field can be modified after the order is entered. |
MaxModifyStatusCode |
|
varchar(5) |
YES |
The maximum status of the order for which modification of the field is allowed. |
ResendToAncillary |
|
bit |
NO |
Indicates if the order should be resent once the field is modified. |
ReprintSummary |
|
bit |
NO |
Indicates if the order summary report should be reprinted if the field is modified. |
CheckEntryRights |
|
bit |
NO |
If True, entry rights are checked before field can be modified. |
CheckPlaceRights |
|
bit |
NO |
If True, place rights are checked before field is modified. |
CheckRequestRights |
|
tinyint |
YES |
If True, request rights are checked before field is modified. |
ProtectedValue |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [Never],1 = [Selected Items Only],2 = [Always], |
MSrepl_tran_version |
|
uniqueidentifier |
YES |
Optimistic lock identifier. |
LabelPosType |
|
int |
NO |
An enumerated type with the following list of possible values: 0 = [Left],1 = [Top], |
DoesLabelSpanColumns |
|
bit |
NO |
Indicates if the field label should extend into all available columns to the left of the label. |
ColumnNumber |
|
int |
NO |
The logical column number where this field is to appear on the form. |
NumColumnsToSpan |
|
numeric(4, 2) |
NO |
The number of columns that the field can extend into available columns on the left. |
OnDataChangeMLM |
|
varchar(80) |
YES |
The name of the MLM to be called when the filed changes in order entry |
MultiFieldOccNum |
|
int |
NO |
The occurrence number when a data item appears more than once on a multi-order form. This is used to enforce uniqueness |
IsInTaskOrderSummaryLine |
|
bit |
NO |
Indicates if the column appears in the Task order summary line |
IsInObsSummaryLine |
|
bit |
NO |
Determine which fields will be in the ObsSummaryLine. The ObsSummaryLins is displayed in flowsheets. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |