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 |
|
HVCIDdt |
NO |
Unique primary key value. |
OwnerGUID |
|
HVCIDdt |
YES |
The link to the flowsheet that owns these reference items. |
ItemType |
|
int |
NO |
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 |
|
HVCIDdt |
YES |
The link to the parent observation item. |
DisplaySequence |
|
int |
NO |
The sequence of the item in relation to all other items at this level. |
ObsMasterItemGUID |
|
HVCIDdt |
YES |
Link to the CV3ObservationMasterItem table |
ObsItemGUID |
|
HVCIDdt |
YES |
Link to the observation catalog item. CV3ObsCatalogMaster. |
ObsSetGUID |
|
HVCIDdt |
YES |
The link to the observation catalog set. |
ObsSetItemGUID |
|
HVCIDdt |
YES |
Link to the observation catalog set. CV3ObsCatalogSet. |
ObsModifierGUID |
|
HVCIDdt |
YES |
Link to the observation modifier item for all items of type observation modifier. CV3ObsModifierItem. |
ObsModifierXrefGUID |
|
HVCIDdt |
YES |
The link to the Observation Catalog Modifier Xref for all items of type Observation Modifier. |
IsMasterItem |
|
bit |
NO |
A flag that indicates if an item of type Observation Item is a master item. 1 = True; 0 = False |
IOSubtype |
|
varchar(60) |
YES |
A dictionary value from either the Intake or Output Subtypes dictionary for the cumulative Item Types. |
CalculateCumulative |
|
bit |
NO |
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 |
|
int |
YES |
The number of hours that observations are to be tallied for a Cumulative calculation before a new calculation is started. |
CumulativeStartOfDayType |
|
int |
NO |
An enumerated type with the following list of possible values: 1 = [None],2 = [First Shift],3 = [Standard], |
UseNumericSeparator |
|
tinyint |
YES |
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 |
|
uniqueidentifier |
YES |
Optimistic lock identifier. |
IsGrouped |
|
smallint |
YES |
An enumerated type with the following list of possible values: 0 = [Unbordered],1 = [Bordered],2 = [Merged], |
MasterEntryItemGUID |
|
HVCIDdt |
YES |
Link to the Master Entry Item table |
IsBorderOn |
|
bit |
YES |
Is a border displayed? Used for sets |
ItemLineNo |
|
smallint |
YES |
Line # observation will appear on in merge set |
ItemCellPositionType |
|
smallint |
YES |
Enumeration to determine whether set item will be displayed on left(1), center(2) or right(3) |
ItemCellSeparator |
|
char(1) |
YES |
Character that is used to separate items |
ParentSetGUID |
|
HVCIDdt |
YES |
Used to indicate the Parent Observation Entry Item for Sets |
MandateDiscriminateGUID |
|
HVCIDdt |
YES |
The ObservationEntryItem that dictates the Item's Discrminatation list values |
PWStatementNo |
|
numeric(12, 2) |
YES |
Used for ProseWriter entries - determines statement and phrase. |
IsPWNewParagraph |
|
bit |
YES |
Used for Prosewriter phrase entries to determine if the phrase begins a new paragraph |
ParentSectionGUID |
|
HVCIDdt |
YES |
Refers to the parent/root ObservationEntryItem GUID that the PW/QA/Obs Sets and their obs parameters belong to for Structured Notes |
IsPositioned |
|
bit |
YES |
Specifies whether the observation section is a positioned section |
MasterObsCatalogSetGUID |
|
HVCIDdt |
YES |
Pointer to Positioned/Non-Positioned Obs Set in CV3ObsCatalogSetItem |
OwnerSetGUID |
|
HVCIDdt |
YES |
Pointer to positioned or non-positioned observation set in CV3ObservationEntryItem |
DisplayNameInNote |
|
bit |
YES |
Provides the ability for the client to control whether or not the Section Names display on the |
ExpandSection |
|
bit |
YES |
Provides the ability for the client to expand all members of the Section as a single unit |
PullSetCatalogID |
|
int |
YES |
A foreign key to the PullSetCatalogID column in the SXACDPullSetCatalog table. |
ObsEntryItemIdentifier |
|
uniqueidentifier |
NO |
Identifies the observation items belonging to a flowsheet and its versions. |
FormID |
|
int |
YES |
A foreign key to the FormID column in the SXAFBForm table. |
InternalTabID |
|
int |
YES |
Refers to InternalTabID to SXAFBTab |
FormElementId |
|
int |
YES |
Refers to InternalFormElementID to SXAFBControl |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
ReusableInternalFormPartID |
|
int |
YES |
Internal form part of ID reusable section from SXAFBFormPart table. |