ColumnName |
Domain |
Datatype |
NULL |
Definition |
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. |
TouchedWhenUTC |
|
datetimeoffset(3) |
NO |
The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is 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. |
CreatedWhenUTC |
|
datetimeoffset(3) |
NO |
The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is 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. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
ParamFanoutXRefID |
|
int |
NO |
Auto generated unique primary key value. |
SourceObsEntryItemGuid |
|
HVCIDdt |
NO |
Source Observation Entry Item GUID from which fanout originates. It refers to GUID column from CV3ObservationEntryItem table. |
TargetObsEntryItemGuid |
|
HVCIDdt |
YES |
Target Observation Entry Item GUID to which fanout value go. It refers to GUID column from CV3ObservationEntryItem table. |
IsSuppressFanOut |
|
bit |
NO |
Specifies if fanout is suppressed between source and target parameters. 0 means fanout works and 1 means fanout will not occur. |
FanoutType |
|
int |
YES |
An enumerated type with the following list of possible values: 1 = [Value only],2 = [Add parameter with charting], |
FanoutLinkType |
|
int |
YES |
An enumerated type with the following list of possible values: 1 = [Observation],2 = [Set],3 = [Set with Linked Sets], |