dbo.SXACDFSParamFanoutXRef 
Default Table Name  SXACDFSParamFanoutXRef 
Definition  This table is used to store the fanout mappings of Structured Notes parameters to Flowsheet parameters and Flowsheet parameters to Flowsheet parameters. 

dbo.SXACDFSParamFanoutXRef Columns 
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(PK)    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], 

dbo.SXACDFSParamFanoutXRef Primary and Unique Keys 
Key Name  Key Type  Keys 
SXACDFSParamFanoutXRefPK  PrimaryKey  ParamFanoutXRefID