dbo.CV3PatientHeaderLineField 
Default Table Name  CV3PatientHeaderLineField 
Definition  Definition of a field to be displayed on a patient header line. 

dbo.CV3PatientHeaderLineField Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
RepFlags    tinyint  NO  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)  NO  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)  NO  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. 
PatientHeaderLineGUID    HVCIDdt  NO  Identifies the parent line 
LineFieldType    smallint  NO  Enum value indicating the type of field, where 0="Icon start", 1="Text", and 2="Icon end" 
DataItemType    smallint  NO  Enum value indicating the data item type, such as allergy, comment, etc. 
Description    varchar(80)  YES  Description of this line field 
SequenceNum    smallint  NO  Horizontal display sequence. It is per line field type, and not per line. 
MinDataSize    smallint  YES  Suggested minimum character length of the field value 
DefaultDataSize    smallint  YES  Suggested default character length of the field value 
MaxDataSize    smallint  YES  Suggested maximum character length of the field value 
GroupNum    smallint  YES  Logical group number for the data element. A lower group number implies a higher priority for display 
IsMandatory    bit  NO  Whether this field is mandatory for display 
PriorityNum    smallint  NO  Indicates priority for display within a group 
AllocationRatio    smallint  NO  Number of characters to allocate to this field if there is extra space available on the patient header line 
AnchorToRight    bit  NO  Right align this field 
PrefixText    varchar(30)  YES  The text to display before the field value 
SuffixText    varchar(30)  YES  The text to display after the field value 
PrefixForeColor    int  YES  Enum value indicating the prefix text color 
ValueForeColor    int  YES  Enum value indicating the field value color 
SuffixForeColor    int  YES  Enum value indicating the suffix text color 
IsPrefixBold    bit  NO  Whether the prefix text is displayed as bold 
IsPrefixItalic    bit  NO  Whether the prefix text is displayed as italic 
IsPrefixUnderline    bit  NO  Whether the prefix text is displayed as underline 
IsValueBold    bit  NO  Whether the value text is displayed as bold 
IsValueItalic    bit  NO  Whether the value text is displayed as italic 
IsValueUnderline    bit  NO  Whether the value text is displayed as underline 
IsSuffixBold    bit  NO  Whether the suffix text is displayed as bold 
IsSuffixItalic    bit  NO  Whether the suffix text is displayed as italic 
IsSuffixUnderline    bit  NO  Whether the suffix text is displayed as underline 
IsPrefixAlwaysShown    bit  NO  Indicates whether the prefix text always show 
IsSuffixOptional    bit  NO  Indicates if the suffix can be omitted if there is not enough room to display it 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3PatientHeaderLineField Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3PatientHeaderLineFieldPK  PrimaryKey  GUID