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. 

OwnerGUID 
Definition  The link to the flowsheet that owns these reference items. 

ItemType 
Definition  An enumerated type with the following list of possible values: 1 = [Header],2 = [Intake Subtotal],3 = [Output Subtotal],4 = [Net Balance],5 = [Observation Item],6 = [Observation Set],7 = [Observation Modifier],8 = [Intake Header],9 = [Output Header],10 = [Net Header],11 = [Other Header],12 = [Drip Parameter],13 = [Component],14 = [Blank Line],15 = [ObservationSection],16 = [QASetSection],17 = [QASet],18 = [ProseWriterSection],19 = [ProseWriter],20 = [HealthIssuesSection],21 = [CareProvidersSection],22 = [ReferralsSection],23 = [AllergiesSection],24 = [OrdersSection],25 = [PrescriptionsSection],26 = [MedicationProfilesSection],27 = [LabResultsSection],28 = [OtherResultsSection],29 = [FlowsheetsSection],30 = [AnnotatedImageSection],31 = [AssessmentAndPlanSection],32 = [AddendumSection],33 = [SignificantEventsSection],34 = [Disposition],35 = [OutPatientMedication],36 = [PositionedObservationSection],37 = [Composite Section],38 = [ImmunizationSection],39 = [CancerStagingSection],40 = [PatientEducationLogSection],41 = [WellnessManagerSection],42 = [ResultsByOrderSection],43 = [ResultsByTrendViewSection],44 = [ResultsGridSet],46 = [StaticDataSection],47 = [HealthManagementSection],51 = [PatientInformationSection],52 = [Boolean],53 = [FormSection],54 = [FormSectionTab],56 = [FormReusableSection], 

ParentGUID 
Definition  The link to the parent observation item. 

DisplaySequence 
Definition  The sequence of the item in relation to all other items at this level. 

ObsMasterItemGUID 
Definition  Link to the CV3ObservationMasterItem table 

ObsItemGUID 
Definition  Link to the observation catalog item. CV3ObsCatalogMaster. 

ObsSetGUID 
Definition  The link to the observation catalog set. 

ObsSetItemGUID 
Definition  Link to the observation catalog set. CV3ObsCatalogSet. 

ObsModifierGUID 
Definition  Link to the observation modifier item for all items of type observation modifier. CV3ObsModifierItem. 

ObsModifierXrefGUID 
Definition  The link to the Observation Catalog Modifier Xref for all items of type Observation Modifier. 

IsMasterItem 
Definition  A flag that indicates if an item of type Observation Item is a master item. 1 = True; 0 = False 

IOSubtype 
Definition  A dictionary value from either the Intake or Output Subtypes dictionary for the cumulative Item Types. 

CalculateCumulative 
Definition  A flag that indicates whether cumulative totals will be calculated for the subtotals based on the Reset and StartOfDay fields. 1 = True; 0 = False 

CumulativeCalcHours 
Definition  The number of hours that observations are to be tallied for a Cumulative calculation before a new calculation is started. 

CumulativeStartOfDayType 
Definition  An enumerated type with the following list of possible values: 1 = [None],2 = [First Shift],3 = [Standard], 

UseNumericSeparator 
Definition  A flag that indicates whether the Windows-defined attribute for display of large numbers (comma) will be used for cumulative calculations. 1 = True; 0 = False 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsGrouped 
Definition  An enumerated type with the following list of possible values: 0 = [Unbordered],1 = [Bordered],2 = [Merged], 

MasterEntryItemGUID 
Definition  Link to the Master Entry Item table 

IsBorderOn 
Definition  Is a border displayed? Used for sets 

ItemLineNo 
Definition  Line # observation will appear on in merge set 

ItemCellPositionType 
Definition  Enumeration to determine whether set item will be displayed on left(1), center(2) or right(3) 

ItemCellSeparator 
Definition  Character that is used to separate items 

ParentSetGUID 
Definition  Used to indicate the Parent Observation Entry Item for Sets 

MandateDiscriminateGUID 
Definition  The ObservationEntryItem that dictates the Item's Discrminatation list values 

PWStatementNo 
Definition  Used for ProseWriter entries - determines statement and phrase. 

IsPWNewParagraph 
Definition  Used for Prosewriter phrase entries to determine if the phrase begins a new paragraph 

ParentSectionGUID 
Definition  Refers to the parent/root ObservationEntryItem GUID that the PW/QA/Obs Sets and their obs parameters belong to for Structured Notes 

IsPositioned 
Definition  Specifies whether the observation section is a positioned section 

MasterObsCatalogSetGUID 
Definition  Pointer to Positioned/Non-Positioned Obs Set in CV3ObsCatalogSetItem 

OwnerSetGUID 
Definition  Pointer to positioned or non-positioned observation set in CV3ObservationEntryItem 

DisplayNameInNote 
Definition  Provides the ability for the client to control whether or not the Section Names display on the 

ExpandSection 
Definition  Provides the ability for the client to expand all members of the Section as a single unit 

PullSetCatalogID 
Definition  A foreign key to the PullSetCatalogID column in the SXACDPullSetCatalog table. 

ObsEntryItemIdentifier 
Definition  Identifies the observation items belonging to a flowsheet and its versions. 

FormID 
Definition  A foreign key to the FormID column in the SXAFBForm table. 

InternalTabID 
Definition  Refers to InternalTabID to SXAFBTab 

FormElementId 
Definition  Refers to InternalFormElementID to SXAFBControl 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

ReusableInternalFormPartID 
Definition  Internal form part of ID reusable section from SXAFBFormPart table.