SiteID |
Definition | Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. |
RepFlags |
Definition | Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. |
Build |
Definition | 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 |
Definition | 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 |
Definition | The date and time that the row was last updated and will be based on the Enterprise time zone. |
CreatedBy |
Definition | 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 |
Definition | The date and time that the row was created and will be based on the Enterprise time zone. |
Active |
Definition | Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. |
GUID |
Definition | Unique primary key value. |
PatientHeaderLineGUID |
Definition | Identifies the parent line |
LineFieldType |
Definition | Enum value indicating the type of field, where 0="Icon start", 1="Text", and 2="Icon end" |
DataItemType |
Definition | Enum value indicating the data item type, such as allergy, comment, etc. |
Description |
Definition | Description of this line field |
SequenceNum |
Definition | Horizontal display sequence. It is per line field type, and not per line. |
MinDataSize |
Definition | Suggested minimum character length of the field value |
DefaultDataSize |
Definition | Suggested default character length of the field value |
MaxDataSize |
Definition | Suggested maximum character length of the field value |
GroupNum |
Definition | Logical group number for the data element. A lower group number implies a higher priority for display |
IsMandatory |
Definition | Whether this field is mandatory for display |
PriorityNum |
Definition | Indicates priority for display within a group |
AllocationRatio |
Definition | Number of characters to allocate to this field if there is extra space available on the patient header line |
AnchorToRight |
Definition | Right align this field |
PrefixText |
Definition | The text to display before the field value |
SuffixText |
Definition | The text to display after the field value |
PrefixForeColor |
Definition | Enum value indicating the prefix text color |
ValueForeColor |
Definition | Enum value indicating the field value color |
SuffixForeColor |
Definition | Enum value indicating the suffix text color |
IsPrefixBold |
Definition | Whether the prefix text is displayed as bold |
IsPrefixItalic |
Definition | Whether the prefix text is displayed as italic |
IsPrefixUnderline |
Definition | Whether the prefix text is displayed as underline |
IsValueBold |
Definition | Whether the value text is displayed as bold |
IsValueItalic |
Definition | Whether the value text is displayed as italic |
IsValueUnderline |
Definition | Whether the value text is displayed as underline |
IsSuffixBold |
Definition | Whether the suffix text is displayed as bold |
IsSuffixItalic |
Definition | Whether the suffix text is displayed as italic |
IsSuffixUnderline |
Definition | Whether the suffix text is displayed as underline |
IsPrefixAlwaysShown |
Definition | Indicates whether the prefix text always show |
IsSuffixOptional |
Definition | Indicates if the suffix can be omitted if there is not enough room to display it |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |