| DOT Class Number |
| Base Entity | Department of Transportation Hazardous Material Class |
| Attribute Name | DOT Class Number |
| Logical Rolename | |
| ColumnName | DOT_CLASS_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| DOT Class Number Logical Attribute Properties |
| Logical Attribute Name | DOT Class Number |
| Datatype | CHAR(1) |
| Nullable | NO |
| DOT Class Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| DOT Class Number Security Types |
| Name | Current Value |
| DOT Class Number Bound Attachments |
| Name | Current Value |
| DOT Class Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOT Class Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Department of Transportation Hazardous Material Class DOT Class Number |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_CLASS DOT_CLASS_NBR |
NO |
| DOT Class Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT Class Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT Class Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT Class Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT Division Number |
| Base Entity | Department of Transportation Hazardous Material Class |
| Attribute Name | DOT Division Number |
| Logical Rolename | |
| ColumnName | DOT_DIV_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| DOT Division Number Logical Attribute Properties |
| Logical Attribute Name | DOT Division Number |
| Datatype | CHAR(3) |
| Nullable | NO |
| DOT Division Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| DOT Division Number Security Types |
| Name | Current Value |
| DOT Division Number Bound Attachments |
| Name | Current Value |
| DOT Division Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOT Division Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Department of Transportation Hazardous Material Class DOT Division Number |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_CLASS DOT_DIV_NBR |
NO |
| DOT Division Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT Division Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT Division Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT Division Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Name |
| Base Entity | Department of Transportation Hazardous Material Class |
| Attribute Name | Name |
| Logical Rolename | |
| ColumnName | NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Name Logical Attribute Properties |
| Logical Attribute Name | Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Name Security Types |
| Name | Current Value |
| Name Bound Attachments |
| Name | Current Value |
| Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Department of Transportation Hazardous Material Class Name |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_CLASS NM |
NO |
| Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Placard Image |
| Base Entity | Department of Transportation Hazardous Material Class |
| Attribute Name | Placard Image |
| Logical Rolename | |
| ColumnName | PLAC_IMG |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Placard Image Logical Attribute Properties |
| Logical Attribute Name | Placard Image |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Placard Image Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Placard Image Security Types |
| Name | Current Value |
| Placard Image Bound Attachments |
| Name | Current Value |
| Placard Image Data Movement Rules |
| Name | Type | Rule Text/Value |
| Placard Image Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Department of Transportation Hazardous Material Class Placard Image |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_CLASS PLAC_IMG |
NO |
| Placard Image Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Placard Image Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Placard Image Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Placard Image Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |