I_SubstBsdCmpstnCompActiveDrft

Substances as components in compositions | view: ISCOMPACTVDRAFT | TRAN | Extraction: Not supported | Component: Sustainability Foundation
Tables used: EHFNDW_MCMPS_SCP
Column Name Description
ChmlCompUUID Chemical Component
Column Name Description
Column Name Description
📏 Concentration Unit of Measure (ChmlCompQtyUnit):
ChmlCompQty Concentration Value of Chemical Component
ChmlCompQtyLowerLimit Lower Limit of Chemical Component
ChmlCompQtyUpperLimit Upper Limit of Chemical Component
Column Name Description
Column Name Description
ChmlCompOperatorLowerLimit Operator for Lower Limit Show values
ChmlCompOperatorUpperLimit Operator for Upper Limit Show values
ChmlCompIsRemoved Removed Indicator for Chemical Component Show values
Column Name Description Domain name
ActiveChmlCompUUID Chemical Component SYSUUID
ChmlCmplncInfoUUID Chemical Compliance Information SYSUUID
ChmlCompositionUUID Chemical Composition SYSUUID
CreationUTCDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CreatedByUser User Name UNAME
LastChangeUTCDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LastChangedByUser User Name UNAME
SubstanceUUID Substance SYSUUID
ChmlCompType Role of Ingredient in Composition EHFND_CCI_CCOMP_TYPE_NCE
ChmlCompQtyAsText Concentration Value of a Chemical Component EHFND_CONCENTRATION_VALUE_CHAR
ChmlCompQtyLowerLimitAsText Lower Limit of the Concentration for a Chemical Component EHFND_CONCENTRATION_VALUE_CHAR
ChmlCompQtyUpperLimitAsText Upper Limit of the Concentration for a Chemical Component EHFND_CONCENTRATION_VALUE_CHAR