| Hazardous Material Identifier |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Hazardous Material Identifier |
| Logical Rolename | |
| ColumnName | HAZ_MAT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Hazardous Material Identifier Logical Attribute Properties |
| Logical Attribute Name | Hazardous Material Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Hazardous Material Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Hazardous Material Identifier Security Types |
| Name | Current Value |
| Hazardous Material Identifier Bound Attachments |
| Name | Current Value |
| Hazardous Material Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Hazardous Material Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Hazardous Material Identifier |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB HAZ_MAT_ID |
NO |
| Hazardous Material Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazardous Material Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazardous Material Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazardous Material Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Symbol |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Symbol |
| Logical Rolename | |
| ColumnName | SYM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Symbol Logical Attribute Properties |
| Logical Attribute Name | Symbol |
| Datatype | VARCHAR(5) |
| Nullable | YES |
| Symbol Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Symbol Security Types |
| Name | Current Value |
| Symbol Bound Attachments |
| Name | Current Value |
| Symbol Data Movement Rules |
| Name | Type | Rule Text/Value |
| Symbol Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Symbol |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB SYM |
NO |
| Symbol Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Symbol Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Symbol Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Symbol Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazardous Material Description |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Hazardous Material Description |
| Logical Rolename | |
| ColumnName | HAZ_MAT_DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| Hazardous Material Description Logical Attribute Properties |
| Logical Attribute Name | Hazardous Material Description |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Hazardous Material Description Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Hazardous Material Description Security Types |
| Name | Current Value |
| Hazardous Material Description Bound Attachments |
| Name | Current Value |
| Hazardous Material Description Data Movement Rules |
| Name | Type | Rule Text/Value |
| Hazardous Material Description Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Hazardous Material Description |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB HAZ_MAT_DESCR |
NO |
| Hazardous Material Description Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazardous Material Description Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazardous Material Description Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazardous Material Description Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazard Class |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Hazard Class |
| Logical Rolename | |
| ColumnName | HAZ_CLASS |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Hazard Class Logical Attribute Properties |
| Logical Attribute Name | Hazard Class |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Hazard Class Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Hazard Class Security Types |
| Name | Current Value |
| Hazard Class Bound Attachments |
| Name | Current Value |
| Hazard Class Data Movement Rules |
| Name | Type | Rule Text/Value |
| Hazard Class Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Hazard Class |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB HAZ_CLASS |
NO |
| Hazard Class Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazard Class Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazard Class Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hazard Class Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Identification Number |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Identification Number |
| Logical Rolename | |
| ColumnName | ID_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Identification Number Logical Attribute Properties |
| Logical Attribute Name | Identification Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Identification Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Identification Number Security Types |
| Name | Current Value |
| Identification Number Bound Attachments |
| Name | Current Value |
| Identification Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Identification Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Identification Number |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB ID_NBR |
NO |
| Identification Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Identification Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Identification Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Identification Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packing Group Identifier |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Packing Group Identifier |
| Logical Rolename | |
| ColumnName | PKG_GRP_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Packing Group Identifier Logical Attribute Properties |
| Logical Attribute Name | Packing Group Identifier |
| Datatype | VARCHAR(3) |
| Nullable | YES |
| Packing Group Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Packing Group Identifier Security Types |
| Name | Current Value |
| Packing Group Identifier Bound Attachments |
| Name | Current Value |
| Packing Group Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Packing Group Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Packing Group Identifier |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB PKG_GRP_ID |
NO |
| Packing Group Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packing Group Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packing Group Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packing Group Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Label Code |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Label Code |
| Logical Rolename | |
| ColumnName | LABEL_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Label Code Logical Attribute Properties |
| Logical Attribute Name | Label Code |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Label Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Label Code Security Types |
| Name | Current Value |
| Label Code Bound Attachments |
| Name | Current Value |
| Label Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Label Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Label Code |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB LABEL_CD |
NO |
| Label Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Label Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Label Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Label Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Provision |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Special Provision |
| Logical Rolename | |
| ColumnName | SPEC_PROV |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Special Provision Logical Attribute Properties |
| Logical Attribute Name | Special Provision |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Special Provision Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Special Provision Security Types |
| Name | Current Value |
| Special Provision Bound Attachments |
| Name | Current Value |
| Special Provision Data Movement Rules |
| Name | Type | Rule Text/Value |
| Special Provision Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Special Provision |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB SPEC_PROV |
NO |
| Special Provision Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Provision Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Provision Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Provision Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Exception |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Packaging Exception |
| Logical Rolename | |
| ColumnName | PKG_EXC |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Packaging Exception Logical Attribute Properties |
| Logical Attribute Name | Packaging Exception |
| Datatype | VARCHAR(4) |
| Nullable | YES |
| Packaging Exception Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Packaging Exception Security Types |
| Name | Current Value |
| Packaging Exception Bound Attachments |
| Name | Current Value |
| Packaging Exception Data Movement Rules |
| Name | Type | Rule Text/Value |
| Packaging Exception Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Packaging Exception |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB PKG_EXC |
NO |
| Packaging Exception Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Exception Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Exception Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Exception Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Non-Bulk |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Packaging Non-Bulk |
| Logical Rolename | |
| ColumnName | PKG_NON_BLK |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Packaging Non-Bulk Logical Attribute Properties |
| Logical Attribute Name | Packaging Non-Bulk |
| Datatype | VARCHAR(4) |
| Nullable | YES |
| Packaging Non-Bulk Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Packaging Non-Bulk Security Types |
| Name | Current Value |
| Packaging Non-Bulk Bound Attachments |
| Name | Current Value |
| Packaging Non-Bulk Data Movement Rules |
| Name | Type | Rule Text/Value |
| Packaging Non-Bulk Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Packaging Non-Bulk |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB PKG_NON_BLK |
NO |
| Packaging Non-Bulk Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Non-Bulk Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Non-Bulk Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Non-Bulk Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Bulk |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Packaging Bulk |
| Logical Rolename | |
| ColumnName | PKG_BULK |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Packaging Bulk Logical Attribute Properties |
| Logical Attribute Name | Packaging Bulk |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| Packaging Bulk Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Packaging Bulk Security Types |
| Name | Current Value |
| Packaging Bulk Bound Attachments |
| Name | Current Value |
| Packaging Bulk Data Movement Rules |
| Name | Type | Rule Text/Value |
| Packaging Bulk Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Packaging Bulk |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB PKG_BULK |
NO |
| Packaging Bulk Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Bulk Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Bulk Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Packaging Bulk Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Passenger Air Rail |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Quantity Limit Passenger Air Rail |
| Logical Rolename | |
| ColumnName | QTY_LIM_PASS_AIR_RAIL |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Quantity Limit Passenger Air Rail Logical Attribute Properties |
| Logical Attribute Name | Quantity Limit Passenger Air Rail |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Quantity Limit Passenger Air Rail Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Quantity Limit Passenger Air Rail Security Types |
| Name | Current Value |
| Quantity Limit Passenger Air Rail Bound Attachments |
| Name | Current Value |
| Quantity Limit Passenger Air Rail Data Movement Rules |
| Name | Type | Rule Text/Value |
| Quantity Limit Passenger Air Rail Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Quantity Limit Passenger Air Rail |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB QTY_LIM_PASS_AIR_RAIL |
NO |
| Quantity Limit Passenger Air Rail Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Passenger Air Rail Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Passenger Air Rail Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Passenger Air Rail Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Cargo Air |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Quantity Limit Cargo Air |
| Logical Rolename | |
| ColumnName | QTY_LMT_CARGO_AIR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Quantity Limit Cargo Air Logical Attribute Properties |
| Logical Attribute Name | Quantity Limit Cargo Air |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Quantity Limit Cargo Air Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Quantity Limit Cargo Air Security Types |
| Name | Current Value |
| Quantity Limit Cargo Air Bound Attachments |
| Name | Current Value |
| Quantity Limit Cargo Air Data Movement Rules |
| Name | Type | Rule Text/Value |
| Quantity Limit Cargo Air Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Quantity Limit Cargo Air |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB QTY_LMT_CARGO_AIR |
NO |
| Quantity Limit Cargo Air Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Cargo Air Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Cargo Air Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Quantity Limit Cargo Air Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Location |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Vessel Stowage Location |
| Logical Rolename | |
| ColumnName | VESS_STOW_LOC |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Vessel Stowage Location Logical Attribute Properties |
| Logical Attribute Name | Vessel Stowage Location |
| Datatype | VARCHAR(2) |
| Nullable | YES |
| Vessel Stowage Location Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Vessel Stowage Location Security Types |
| Name | Current Value |
| Vessel Stowage Location Bound Attachments |
| Name | Current Value |
| Vessel Stowage Location Data Movement Rules |
| Name | Type | Rule Text/Value |
| Vessel Stowage Location Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Vessel Stowage Location |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB VESS_STOW_LOC |
NO |
| Vessel Stowage Location Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Location Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Location Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Location Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Other |
| Base Entity | DOT Hazardous Material Table |
| Attribute Name | Vessel Stowage Other |
| Logical Rolename | |
| ColumnName | VESS_STOW_OTHER |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Vessel Stowage Other Logical Attribute Properties |
| Logical Attribute Name | Vessel Stowage Other |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Vessel Stowage Other Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Vessel Stowage Other Security Types |
| Name | Current Value |
| Vessel Stowage Other Bound Attachments |
| Name | Current Value |
| Vessel Stowage Other Data Movement Rules |
| Name | Type | Rule Text/Value |
| Vessel Stowage Other Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical DOT Hazardous Material Table Vessel Stowage Other |
NO | ||
| SMPL (Oracle) DOT_HAZ_MAT_TAB VESS_STOW_OTHER |
NO |
| Vessel Stowage Other Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Other Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Other Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Vessel Stowage Other Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |