SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. 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. 

PullSetCatalogID 
Definition  Auto generated unique primary key value. 

InternalName 
Definition  Internal name for the Pull Set 

DisplayName 
Definition  Display name for the Pull Set 

Description 
Definition  Description 

PullSetType 
Definition  Pull Set type - allergies, cancer staging, etc 

ChartScope 
Definition  This Visit, This Chart or All Available. Enumeration information is stored in SXACDPullSetCatalogItemEnum 

ShowDisplayNameinNote 
Definition  Show DisplayName in Note - Yes/No 

Position 
Definition  Position of the Set on Note 

Font 
Definition  Font of the Set on Note 

IsUnderline 
Definition  Underline Set on Note 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsUsedByUI 
Definition  Bit value 1 or 0 depending on if this pull set is used by UI 

TimeInterval 
Definition  Saves the TimeFrame(Start of Chart, Two Days, etc) 

IsIncludeDiagnosis 
Definition  Stores 0 or 1 ,Stores 1 to show associated/differential diagnosis with the Health Issues Pull Set on UI , 0 otherwise. 

PullSetSelection 
Definition  Stores the PullSetSelections value for the Results 

IsHidden 
Definition  Prevent Pull Set from displaying in the Pull Set Catalog 

IsRTFBullet 
Definition  If true the RTF for pullset will be rendered with bullet. 

RTFDisplayFormatType 
Definition  This will store enum values for the Format Type. Currently supported are Text[enumValue = 0] and Table[enumValue = 1] format. The enum definitions will be stored in CV3EnumReference. 

PrimaryIssueLabel 
Definition  Field will store the visit reason for a Health Issue Pull Set. 

IsRTFConcatenate 
Definition  When Concatenate check box is unchecked then the value of "IsRTFConcatenate" field will be "0" .
When Concatenate check box is checked then the value of "IsRTFConcatenate" field will be "1" .
 

HMAgeRangeFrom 
Definition  Health Management record age range from 

HMAgeRangeTo 
Definition  Health Management record age range to 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsSelectUponRefresh 
Definition  Stores true if the user checked the Selected Upon Refresh checkbox in pullset catalog.