| CHEM_RECID |
| Base Object | HMMIS_CHEM |
| Attribute Name | Chemical recId |
| ColumnName | CHEM_RECID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | The record ID for the chemical - uniquely identifies the entry |
| Note |
| CHEM_RECID Column Properties |
| Datatype | VARCHAR2(6) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CHEM_RECID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| CHEM_RECID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CHEM_RECID Security Types |
| Name | Current Value |
| CHEM_RECID Bound Attachments |
| Name | Current Value |
| CHEM_RECID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CHEM_RECID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical Chemical recId |
NO | ||
| SMPL (Oracle) HMMIS_CHEM CHEM_RECID |
NO |
| CHEM_RECID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CHEM_RECID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CHEM_RECID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CHEM_RECID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| primaryName |
| Base Object | HMMIS_CHEM |
| Attribute Name | primaryName |
| ColumnName | primaryName |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Primary or official name of the chemical |
| Note |
| primaryName Column Properties |
| Datatype | VARCHAR2(80) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| primaryName Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 80 |
| Percent Null | 0 |
| primaryName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| primaryName Security Types |
| Name | Current Value |
| primaryName Bound Attachments |
| Name | Current Value |
| primaryName Data Movement Rules |
| Name | Type | Rule Text/Value |
| primaryName Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical primaryName |
NO | ||
| SMPL (Oracle) HMMIS_CHEM primaryName |
NO |
| primaryName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| primaryName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| primaryName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| primaryName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| casNumber |
| Base Object | HMMIS_CHEM |
| Attribute Name | casNumber |
| ColumnName | casNumber |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | CAS number |
| Note |
| casNumber Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| casNumber Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| casNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| casNumber Security Types |
| Name | Current Value |
| casNumber Bound Attachments |
| Name | Current Value |
| casNumber Data Movement Rules |
| Name | Type | Rule Text/Value |
| casNumber Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical casNumber |
NO | ||
| SMPL (Oracle) HMMIS_CHEM casNumber |
NO |
| casNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| casNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| casNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| casNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| pure |
| Base Object | HMMIS_CHEM |
| Attribute Name | pure |
| ColumnName | pure |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | ***Indicates that the chemical is pure (not a mixture) |
| Note |
| pure Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| pure Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| pure Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | ((0)) |
| Bound Default |
| pure Security Types |
| Name | Current Value |
| pure Bound Attachments |
| Name | Current Value |
| pure Data Movement Rules |
| Name | Type | Rule Text/Value |
| pure Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical pure |
NO | ||
| SMPL (Oracle) HMMIS_CHEM pure |
NO |
| pure Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| pure Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| pure Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| pure Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| carcinogen |
| Base Object | HMMIS_CHEM |
| Attribute Name | carcinogen |
| ColumnName | carcinogen |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Indicates that the chemical is a carcinogen |
| Note |
| carcinogen Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| carcinogen Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| carcinogen Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | ((0)) |
| Bound Default |
| carcinogen Security Types |
| Name | Current Value |
| carcinogen Bound Attachments |
| Name | Current Value |
| carcinogen Data Movement Rules |
| Name | Type | Rule Text/Value |
| carcinogen Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical carcinogen |
NO | ||
| SMPL (Oracle) HMMIS_CHEM carcinogen |
NO |
| carcinogen Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| carcinogen Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| carcinogen Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| carcinogen Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| specialCondition |
| Base Object | HMMIS_CHEM |
| Attribute Name | specialCondition |
| ColumnName | specialCondition |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Indicates that the chemical represents a special condition as defined by ORNL |
| Note |
| specialCondition Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| specialCondition Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| specialCondition Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | ((0)) |
| Bound Default |
| specialCondition Security Types |
| Name | Current Value |
| specialCondition Bound Attachments |
| Name | Current Value |
| specialCondition Data Movement Rules |
| Name | Type | Rule Text/Value |
| specialCondition Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical specialCondition |
NO | ||
| SMPL (Oracle) HMMIS_CHEM specialCondition |
NO |
| specialCondition Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| specialCondition Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| specialCondition Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| specialCondition Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLife |
| Base Object | HMMIS_CHEM |
| Attribute Name | shelfLife |
| ColumnName | shelfLife |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Lists the default shelf life of the chemical (if any) |
| Note |
| shelfLife Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| shelfLife Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| shelfLife Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| shelfLife Security Types |
| Name | Current Value |
| shelfLife Bound Attachments |
| Name | Current Value |
| shelfLife Data Movement Rules |
| Name | Type | Rule Text/Value |
| shelfLife Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical shelfLife |
NO | ||
| SMPL (Oracle) HMMIS_CHEM shelfLife |
NO |
| shelfLife Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLife Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLife Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLife Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLifeComments |
| Base Object | HMMIS_CHEM |
| Attribute Name | shelfLifeComments |
| ColumnName | shelfLifeComments |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Comments about the shelf life. Often used to explain the value provided in the shelfLife field (i.e. units) |
| Note |
| shelfLifeComments Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| shelfLifeComments Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| shelfLifeComments Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| shelfLifeComments Security Types |
| Name | Current Value |
| shelfLifeComments Bound Attachments |
| Name | Current Value |
| shelfLifeComments Data Movement Rules |
| Name | Type | Rule Text/Value |
| shelfLifeComments Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical shelfLifeComments |
NO | ||
| SMPL (Oracle) HMMIS_CHEM shelfLifeComments |
NO |
| shelfLifeComments Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLifeComments Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLifeComments Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| shelfLifeComments Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| trackInventory |
| Base Object | HMMIS_CHEM |
| Attribute Name | trackInventory |
| ColumnName | trackInventory |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Indicates that inventory is to be tracked for this chemical |
| Note |
| trackInventory Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| trackInventory Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| trackInventory Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | ((1)) |
| Bound Default |
| trackInventory Security Types |
| Name | Current Value |
| trackInventory Bound Attachments |
| Name | Current Value |
| trackInventory Data Movement Rules |
| Name | Type | Rule Text/Value |
| trackInventory Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical trackInventory |
NO | ||
| SMPL (Oracle) HMMIS_CHEM trackInventory |
NO |
| trackInventory Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| trackInventory Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| trackInventory Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| trackInventory Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| sortableName |
| Base Object | HMMIS_CHEM |
| Attribute Name | sortableName |
| ColumnName | sortableName |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | A sortable/comparable name for the chemical. Similar to primaryName however without spaces or any special characters |
| Note |
| sortableName Column Properties |
| Datatype | VARCHAR2(80) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| sortableName Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 80 |
| Percent Null | 0 |
| sortableName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| sortableName Security Types |
| Name | Current Value |
| sortableName Bound Attachments |
| Name | Current Value |
| sortableName Data Movement Rules |
| Name | Type | Rule Text/Value |
| sortableName Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical sortableName |
NO | ||
| SMPL (Oracle) HMMIS_CHEM sortableName |
NO |
| sortableName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| sortableName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| sortableName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| sortableName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| rtecsNumber |
| Base Object | HMMIS_CHEM |
| Attribute Name | rtecsNumber |
| ColumnName | rtecsNumber |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | RTECS number |
| Note |
| rtecsNumber Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| rtecsNumber Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| rtecsNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| rtecsNumber Security Types |
| Name | Current Value |
| rtecsNumber Bound Attachments |
| Name | Current Value |
| rtecsNumber Data Movement Rules |
| Name | Type | Rule Text/Value |
| rtecsNumber Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical rtecsNumber |
NO | ||
| SMPL (Oracle) HMMIS_CHEM rtecsNumber |
NO |
| rtecsNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| rtecsNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| rtecsNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| rtecsNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid |
| Base Object | HMMIS_CHEM |
| Attribute Name | rowguid |
| ColumnName | rowguid |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| rowguid Column Properties |
| Datatype | RAW(16) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| rowguid Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 16 |
| Percent Null | 0 |
| rowguid Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | (newid()) |
| Bound Default |
| rowguid Security Types |
| Name | Current Value |
| rowguid Bound Attachments |
| Name | Current Value |
| rowguid Data Movement Rules |
| Name | Type | Rule Text/Value |
| rowguid Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical rowguid |
NO | ||
| SMPL (Oracle) HMMIS_CHEM rowguid |
NO |
| rowguid Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| rowguid Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| hideFromQueries |
| Base Object | HMMIS_CHEM |
| Attribute Name | hideFromQueries |
| ColumnName | hideFromQueries |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| hideFromQueries Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| hideFromQueries Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| hideFromQueries Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | ((0)) |
| Bound Default |
| hideFromQueries Security Types |
| Name | Current Value |
| hideFromQueries Bound Attachments |
| Name | Current Value |
| hideFromQueries Data Movement Rules |
| Name | Type | Rule Text/Value |
| hideFromQueries Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical hideFromQueries |
NO | ||
| SMPL (Oracle) HMMIS_CHEM hideFromQueries |
NO |
| hideFromQueries Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| hideFromQueries Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| hideFromQueries Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| hideFromQueries Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| flammability |
| Base Object | HMMIS_CHEM |
| Attribute Name | flammability |
| ColumnName | flammability |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| flammability Column Properties |
| Datatype | VARCHAR2(2) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| flammability Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| flammability Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| flammability Security Types |
| Name | Current Value |
| flammability Bound Attachments |
| Name | Current Value |
| flammability Data Movement Rules |
| Name | Type | Rule Text/Value |
| flammability Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical flammability |
NO | ||
| SMPL (Oracle) HMMIS_CHEM flammability |
NO |
| flammability Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| flammability Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| flammability Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| flammability Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| epaGroup |
| Base Object | HMMIS_CHEM |
| Attribute Name | epaGroup |
| ColumnName | epaGroup |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| epaGroup Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| epaGroup Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| epaGroup Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| epaGroup Security Types |
| Name | Current Value |
| epaGroup Bound Attachments |
| Name | Current Value |
| epaGroup Data Movement Rules |
| Name | Type | Rule Text/Value |
| epaGroup Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical epaGroup |
NO | ||
| SMPL (Oracle) HMMIS_CHEM epaGroup |
NO |
| epaGroup Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| epaGroup Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| epaGroup Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| epaGroup Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| classificationsCompleted |
| Base Object | HMMIS_CHEM |
| Attribute Name | classificationsCompleted |
| ColumnName | classificationsCompleted |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| classificationsCompleted Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| classificationsCompleted Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| classificationsCompleted Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| classificationsCompleted Security Types |
| Name | Current Value |
| classificationsCompleted Bound Attachments |
| Name | Current Value |
| classificationsCompleted Data Movement Rules |
| Name | Type | Rule Text/Value |
| classificationsCompleted Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical classificationsCompleted |
NO | ||
| SMPL (Oracle) HMMIS_CHEM classificationsCompleted |
NO |
| classificationsCompleted Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| classificationsCompleted Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| classificationsCompleted Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| classificationsCompleted Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| mistFormOnly |
| Base Object | HMMIS_CHEM |
| Attribute Name | mistFormOnly |
| ColumnName | mistFormOnly |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| mistFormOnly Column Properties |
| Datatype | NUMBER(1, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| mistFormOnly Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| mistFormOnly Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | ((0)) |
| Bound Default |
| mistFormOnly Security Types |
| Name | Current Value |
| mistFormOnly Bound Attachments |
| Name | Current Value |
| mistFormOnly Data Movement Rules |
| Name | Type | Rule Text/Value |
| mistFormOnly Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical mistFormOnly |
NO | ||
| SMPL (Oracle) HMMIS_CHEM mistFormOnly |
NO |
| mistFormOnly Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| mistFormOnly Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| mistFormOnly Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| mistFormOnly Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| status |
| Base Object | HMMIS_CHEM |
| Attribute Name | status |
| ColumnName | status |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| status Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| status Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| status Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| status Security Types |
| Name | Current Value |
| status Bound Attachments |
| Name | Current Value |
| status Data Movement Rules |
| Name | Type | Rule Text/Value |
| status Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical HMMIS Chemical status |
NO | ||
| SMPL (Oracle) HMMIS_CHEM status |
NO |
| status Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| status Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| status Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| status Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |