DOT_CLASS_NBR |
Base Object | DOT_HAZ_MAT_CLASS |
Attribute Name | DOT Class Number |
ColumnName | DOT_CLASS_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DOT_CLASS_NBR Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DOT_CLASS_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
DOT_CLASS_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DOT_CLASS_NBR Security Types |
Name | Current Value |
DOT_CLASS_NBR Bound Attachments |
Name | Current Value |
DOT_CLASS_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
DOT_CLASS_NBR 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_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT_CLASS_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT_CLASS_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT_CLASS_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT_DIV_NBR |
Base Object | DOT_HAZ_MAT_CLASS |
Attribute Name | DOT Division Number |
ColumnName | DOT_DIV_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DOT_DIV_NBR Column Properties |
Datatype | CHAR(3) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DOT_DIV_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
DOT_DIV_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DOT_DIV_NBR Security Types |
Name | Current Value |
DOT_DIV_NBR Bound Attachments |
Name | Current Value |
DOT_DIV_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
DOT_DIV_NBR 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_DIV_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT_DIV_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT_DIV_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT_DIV_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NM |
Base Object | DOT_HAZ_MAT_CLASS |
Attribute Name | Name |
ColumnName | NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NM Security Types |
Name | Current Value |
NM Bound Attachments |
Name | Current Value |
NM Data Movement Rules |
Name | Type | Rule Text/Value |
NM 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 |
NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PLAC_IMG |
Base Object | DOT_HAZ_MAT_CLASS |
Attribute Name | Placard Image |
ColumnName | PLAC_IMG |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PLAC_IMG Column Properties |
Datatype | BLOB |
Nullable | YES |
Not Null Constraint |
PLAC_IMG Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2048 |
Percent Null | 0 |
PLAC_IMG Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PLAC_IMG Security Types |
Name | Current Value |
PLAC_IMG Bound Attachments |
Name | Current Value |
PLAC_IMG Data Movement Rules |
Name | Type | Rule Text/Value |
PLAC_IMG 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 |
PLAC_IMG Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PLAC_IMG Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PLAC_IMG Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PLAC_IMG Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |