dbo.CV3OrderEntryField 
Default Table Name  CV3OrderEntryField 
Definition  Field on an order form or other user-definable form.
 

dbo.CV3OrderEntryField 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  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(PK)    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(FK)    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. 

dbo.CV3OrderEntryField Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderEntryFieldPK  PrimaryKey  GUID