dbo.SXACDTaskFSParamFanoutXRef 
Default Table Name  SXACDTaskFSParamFanoutXRef 
Definition  This table is used to store the fanout mappings between Order Task Form fields and Flowsheet parameters. 

dbo.SXACDTaskFSParamFanoutXRef 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. 
TaskFSParamFanoutXRefID(PK)    int  NO  Auto generated unique primary key value. 
OrderCatalogMasterItemGUID    HVCIDdt  NO  A foreign key to the GUID column in the CV3OrderCatalogMasterItem table.  
CatalogItemTaskGUID    HVCIDdt  NO  Represents Task associated with the Order. It refers to GUID column from CV3CatalogItemTask table 
OrderEntryFormGUID    HVCIDdt  NO  Represents Entry Form associated to the Task. It refers to FormGUID column from CV3OrderEntryForm table. 
DataItemGUID    HVCIDdt  NO  Represents Data Item associated to the Task Entry Form. It refers to GUID column from CV3DataItem table. 
ObservationEntryItemGUID    HVCIDdt  NO  Represents the Flowsheet Observation Entry Item to which the data item value should fanout. It refers to GUID column from CV3ObservationEntryItem table. 
FanoutType    int  NO  An enumerated type with the following list of possible values: 1 = [Value only],2 = [Add parameter with charting], 
FanoutLinkType    int  NO  An enumerated type with the following list of possible values: 1 = [Observation],2 = [Set],3 = [Set with Linked Sets], 
ObsEntryItemSubType    int  NO  This column will be used to store the subtype for the Intake, Output, Net or Drip observations. The value saved in this column is based on the Enum 0. None 1.In 2.Out 3. Rate 4. Dose. 

dbo.SXACDTaskFSParamFanoutXRef Primary and Unique Keys 
Key Name  Key Type  Keys 
SXACDTaskFSParamFanoutXRefPK  PrimaryKey  TaskFSParamFanoutXRefID