| Shipment Facility Identifier |
| Base Entity | Shipment Facility |
| Attribute Name | Shipment Facility Identifier |
| Logical Rolename | |
| ColumnName | SHIP_FACIL_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Shipment Facility Identifier Logical Attribute Properties |
| Logical Attribute Name | Shipment Facility Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Shipment Facility Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Shipment Facility Identifier Security Types |
| Name | Current Value |
| Shipment Facility Identifier Bound Attachments |
| Name | Current Value |
| Shipment Facility Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Shipment Facility Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Shipment Facility Identifier |
NO | ||
| SMPL (Oracle) SHIP_FACIL SHIP_FACIL_ID |
NO |
| Shipment Facility Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shipment Facility Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shipment Facility Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Shipment Facility Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name |
| Base Entity | Shipment Facility |
| Attribute Name | Facility Name |
| Logical Rolename | |
| ColumnName | FACIL_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Facility Name Logical Attribute Properties |
| Logical Attribute Name | Facility Name |
| Datatype | VARCHAR(120) |
| Nullable | NO |
| Facility Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Facility Name Security Types |
| Name | Current Value |
| Facility Name Bound Attachments |
| Name | Current Value |
| Facility Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Facility Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Facility Name |
NO | ||
| SMPL (Oracle) SHIP_FACIL FACIL_NM |
NO |
| Facility Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Department |
| Base Entity | Shipment Facility |
| Attribute Name | Facility Department |
| Logical Rolename | |
| ColumnName | FACIL_DEPT |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Facility Department Logical Attribute Properties |
| Logical Attribute Name | Facility Department |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Facility Department Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Facility Department Security Types |
| Name | Current Value |
| Facility Department Bound Attachments |
| Name | Current Value |
| Facility Department Data Movement Rules |
| Name | Type | Rule Text/Value |
| Facility Department Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Facility Department |
NO | ||
| SMPL (Oracle) SHIP_FACIL FACIL_DEPT |
NO |
| Facility Department Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Department Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Department Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Facility Department Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address Code |
| Base Entity | Shipment Facility |
| Attribute Name | Address Code |
| Logical Rolename | |
| ColumnName | ADDR_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Address Code Logical Attribute Properties |
| Logical Attribute Name | Address Code |
| Datatype | CHAR(1) |
| Nullable | NO |
| Address Code Domain Restrictions |
| CheckConstraint | @var IN ('N','R','A') | ||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'N' | ||
| Bound Default |
| Address Code Security Types |
| Name | Current Value |
| Address Code Bound Attachments |
| Name | Current Value |
| Address Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Address Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Address Code |
NO | ||
| SMPL (Oracle) SHIP_FACIL ADDR_CD |
NO |
| Address Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 1 |
| Base Entity | Shipment Facility |
| Attribute Name | Address 1 |
| Logical Rolename | |
| ColumnName | ADDR1 |
| RoleName | |
| Domain | Address 1 |
| Logical Only | NO |
| Definition | |
| Note |
| Address 1 Logical Attribute Properties |
| Logical Attribute Name | Address 1 |
| Datatype | VARCHAR(500) |
| Nullable | YES |
| Address 1 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Address 1 Security Types |
| Name | Current Value |
| Address 1 Bound Attachments |
| Name | Current Value |
| Address 1 Data Movement Rules |
| Name | Type | Rule Text/Value |
| Address 1 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Address 1 |
NO | ||
| SMPL (Oracle) SHIP_FACIL ADDR1 |
NO |
| Address 1 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 1 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 1 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 1 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 2 |
| Base Entity | Shipment Facility |
| Attribute Name | Address 2 |
| Logical Rolename | |
| ColumnName | ADDR2 |
| RoleName | |
| Domain | Address 2 |
| Logical Only | NO |
| Definition | |
| Note |
| Address 2 Logical Attribute Properties |
| Logical Attribute Name | Address 2 |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Address 2 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Address 2 Security Types |
| Name | Current Value |
| Address 2 Bound Attachments |
| Name | Current Value |
| Address 2 Data Movement Rules |
| Name | Type | Rule Text/Value |
| Address 2 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Address 2 |
NO | ||
| SMPL (Oracle) SHIP_FACIL ADDR2 |
NO |
| Address 2 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 2 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 2 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Address 2 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Contact |
| Base Entity | Shipment Facility |
| Attribute Name | Contact |
| Logical Rolename | |
| ColumnName | CONTACT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Contact Logical Attribute Properties |
| Logical Attribute Name | Contact |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Contact Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Contact Security Types |
| Name | Current Value |
| Contact Bound Attachments |
| Name | Current Value |
| Contact Data Movement Rules |
| Name | Type | Rule Text/Value |
| Contact Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Contact |
NO | ||
| SMPL (Oracle) SHIP_FACIL CONTACT |
NO |
| Contact Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Contact Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Contact Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Contact Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| City |
| Base Entity | Shipment Facility |
| Attribute Name | City |
| Logical Rolename | |
| ColumnName | CITY |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | City: City the institute is located. |
| Note |
| City Logical Attribute Properties |
| Logical Attribute Name | City |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| City Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| City Security Types |
| Name | Current Value |
| City Bound Attachments |
| Name | Current Value |
| City Data Movement Rules |
| Name | Type | Rule Text/Value |
| City Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility City |
NO | ||
| SMPL (Oracle) SHIP_FACIL CITY |
NO |
| City Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| City Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| City Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| City Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| State |
| Base Entity | Shipment Facility |
| Attribute Name | State |
| Logical Rolename | |
| ColumnName | STATE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | State: State or provience the institute is located. |
| Note |
| State Logical Attribute Properties |
| Logical Attribute Name | State |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| State Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| State Security Types |
| Name | Current Value |
| State Bound Attachments |
| Name | Current Value |
| State Data Movement Rules |
| Name | Type | Rule Text/Value |
| State Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility State |
NO | ||
| SMPL (Oracle) SHIP_FACIL STATE |
NO |
| State Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code |
| Base Entity | Shipment Facility |
| Attribute Name | Postal Code |
| Logical Rolename | |
| ColumnName | POSTAL_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Postal Code: Postal code of the institute. |
| Note |
| Postal Code Logical Attribute Properties |
| Logical Attribute Name | Postal Code |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Postal Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Postal Code Security Types |
| Name | Current Value |
| Postal Code Bound Attachments |
| Name | Current Value |
| Postal Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Postal Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Postal Code |
NO | ||
| SMPL (Oracle) SHIP_FACIL POSTAL_CD |
NO |
| Postal Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Postal Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phone Number |
| Base Entity | Shipment Facility |
| Attribute Name | Phone Number |
| Logical Rolename | |
| ColumnName | PHONE_NBR |
| RoleName | |
| Domain | Phone |
| Logical Only | NO |
| Definition | |
| Note |
| Phone Number Logical Attribute Properties |
| Logical Attribute Name | Phone Number |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Phone Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Phone Number Security Types |
| Name | Current Value |
| Phone Number Bound Attachments |
| Name | Current Value |
| Phone Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Phone Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Phone Number |
NO | ||
| SMPL (Oracle) SHIP_FACIL PHONE_NBR |
NO |
| Phone Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phone Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phone Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Phone Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr |
| Base Entity | Shipment Facility |
| Attribute Name | Email Addr |
| Logical Rolename | |
| ColumnName | EMAIL_ADDR |
| RoleName | |
| Domain | Email Addr |
| Logical Only | NO |
| Definition | Email Address: |
| Note |
| Email Addr Logical Attribute Properties |
| Logical Attribute Name | Email Addr |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Email Addr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Email Addr Security Types |
| Name | Current Value |
| Email Addr Bound Attachments |
| Name | Current Value |
| Email Addr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Email Addr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Email Addr |
NO | ||
| SMPL (Oracle) SHIP_FACIL EMAIL_ADDR |
NO |
| Email Addr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Email Addr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 1 |
| Base Entity | Shipment Facility |
| Attribute Name | Radioactive Address 1 |
| Logical Rolename | |
| ColumnName | RAD_ADDR1 |
| RoleName | |
| Domain | Address 1 |
| Logical Only | NO |
| Definition | |
| Note |
| Radioactive Address 1 Logical Attribute Properties |
| Logical Attribute Name | Radioactive Address 1 |
| Datatype | VARCHAR(500) |
| Nullable | YES |
| Radioactive Address 1 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Radioactive Address 1 Security Types |
| Name | Current Value |
| Radioactive Address 1 Bound Attachments |
| Name | Current Value |
| Radioactive Address 1 Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radioactive Address 1 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive Address 1 |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_ADDR1 |
NO |
| Radioactive Address 1 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 1 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 1 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 1 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 2 |
| Base Entity | Shipment Facility |
| Attribute Name | Radioactive Address 2 |
| Logical Rolename | |
| ColumnName | RAD_ADDR2 |
| RoleName | |
| Domain | Address 2 |
| Logical Only | NO |
| Definition | |
| Note |
| Radioactive Address 2 Logical Attribute Properties |
| Logical Attribute Name | Radioactive Address 2 |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Radioactive Address 2 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Radioactive Address 2 Security Types |
| Name | Current Value |
| Radioactive Address 2 Bound Attachments |
| Name | Current Value |
| Radioactive Address 2 Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radioactive Address 2 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive Address 2 |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_ADDR2 |
NO |
| Radioactive Address 2 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 2 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 2 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Address 2 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiactive Contact |
| Base Entity | Shipment Facility |
| Attribute Name | Radiactive Contact |
| Logical Rolename | |
| ColumnName | RAD_CONTACT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Radiactive Contact Logical Attribute Properties |
| Logical Attribute Name | Radiactive Contact |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Radiactive Contact Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Radiactive Contact Security Types |
| Name | Current Value |
| Radiactive Contact Bound Attachments |
| Name | Current Value |
| Radiactive Contact Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radiactive Contact Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radiactive Contact |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_CONTACT |
NO |
| Radiactive Contact Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiactive Contact Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiactive Contact Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radiactive Contact Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive City |
| Base Entity | Shipment Facility |
| Attribute Name | Radioactive City |
| Logical Rolename | |
| ColumnName | RAD_CITY |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | City: City the institute is located. |
| Note |
| Radioactive City Logical Attribute Properties |
| Logical Attribute Name | Radioactive City |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| Radioactive City Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Radioactive City Security Types |
| Name | Current Value |
| Radioactive City Bound Attachments |
| Name | Current Value |
| Radioactive City Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radioactive City Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive City |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_CITY |
NO |
| Radioactive City Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive City Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive City Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive City Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive State |
| Base Entity | Shipment Facility |
| Attribute Name | Radioactive State |
| Logical Rolename | |
| ColumnName | RAD_STATE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | State: State or provience the institute is located. |
| Note |
| Radioactive State Logical Attribute Properties |
| Logical Attribute Name | Radioactive State |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| Radioactive State Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Radioactive State Security Types |
| Name | Current Value |
| Radioactive State Bound Attachments |
| Name | Current Value |
| Radioactive State Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radioactive State Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive State |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_STATE |
NO |
| Radioactive State Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive State Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive State Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive State Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Postal Code |
| Base Entity | Shipment Facility |
| Attribute Name | Radioactive Postal Code |
| Logical Rolename | |
| ColumnName | RAD_POSTAL_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Postal Code: Postal code of the institute. |
| Note |
| Radioactive Postal Code Logical Attribute Properties |
| Logical Attribute Name | Radioactive Postal Code |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Radioactive Postal Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Radioactive Postal Code Security Types |
| Name | Current Value |
| Radioactive Postal Code Bound Attachments |
| Name | Current Value |
| Radioactive Postal Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radioactive Postal Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive Postal Code |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_POSTAL_CD |
NO |
| Radioactive Postal Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Postal Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Postal Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Postal Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Phone Number |
| Base Entity | Shipment Facility |
| Attribute Name | Radioactive Phone Number |
| Logical Rolename | |
| ColumnName | RAD_PHONE_NBR |
| RoleName | |
| Domain | Phone |
| Logical Only | NO |
| Definition | |
| Note |
| Radioactive Phone Number Logical Attribute Properties |
| Logical Attribute Name | Radioactive Phone Number |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Radioactive Phone Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Radioactive Phone Number Security Types |
| Name | Current Value |
| Radioactive Phone Number Bound Attachments |
| Name | Current Value |
| Radioactive Phone Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radioactive Phone Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive Phone Number |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_PHONE_NBR |
NO |
| Radioactive Phone Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Phone Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Phone Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Phone Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Email Addr |
| Base Entity | Shipment Facility |
| Attribute Name | Radioactive Email Addr |
| Logical Rolename | |
| ColumnName | RAD_EMAIL_ADDR |
| RoleName | |
| Domain | Email Addr |
| Logical Only | NO |
| Definition | Email Address: |
| Note |
| Radioactive Email Addr Logical Attribute Properties |
| Logical Attribute Name | Radioactive Email Addr |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Radioactive Email Addr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Radioactive Email Addr Security Types |
| Name | Current Value |
| Radioactive Email Addr Bound Attachments |
| Name | Current Value |
| Radioactive Email Addr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Radioactive Email Addr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive Email Addr |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_EMAIL_ADDR |
NO |
| Radioactive Email Addr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Email Addr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Email Addr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Radioactive Email Addr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 1 |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits Address 1 |
| Logical Rolename | |
| ColumnName | AUTH_LMT_ADDR1 |
| RoleName | |
| Domain | Address 1 |
| Logical Only | NO |
| Definition | |
| Note |
| Authorized Limits Address 1 Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits Address 1 |
| Datatype | VARCHAR(500) |
| Nullable | YES |
| Authorized Limits Address 1 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Authorized Limits Address 1 Security Types |
| Name | Current Value |
| Authorized Limits Address 1 Bound Attachments |
| Name | Current Value |
| Authorized Limits Address 1 Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits Address 1 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits Address 1 |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_ADDR1 |
NO |
| Authorized Limits Address 1 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 1 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 1 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 1 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 2 |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits Address 2 |
| Logical Rolename | |
| ColumnName | AUTH_LMT_ADDR2 |
| RoleName | |
| Domain | Address 2 |
| Logical Only | NO |
| Definition | |
| Note |
| Authorized Limits Address 2 Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits Address 2 |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Authorized Limits Address 2 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Authorized Limits Address 2 Security Types |
| Name | Current Value |
| Authorized Limits Address 2 Bound Attachments |
| Name | Current Value |
| Authorized Limits Address 2 Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits Address 2 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits Address 2 |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_ADDR2 |
NO |
| Authorized Limits Address 2 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 2 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 2 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Address 2 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Contact |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits Contact |
| Logical Rolename | |
| ColumnName | AUTH_LMT_CONTACT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Authorized Limits Contact Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits Contact |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Authorized Limits Contact Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Authorized Limits Contact Security Types |
| Name | Current Value |
| Authorized Limits Contact Bound Attachments |
| Name | Current Value |
| Authorized Limits Contact Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits Contact Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits Contact |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_CONTACT |
NO |
| Authorized Limits Contact Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Contact Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Contact Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Contact Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits City |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits City |
| Logical Rolename | |
| ColumnName | AUTH_LMT_CITY |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | City: City the institute is located. |
| Note |
| Authorized Limits City Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits City |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| Authorized Limits City Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Authorized Limits City Security Types |
| Name | Current Value |
| Authorized Limits City Bound Attachments |
| Name | Current Value |
| Authorized Limits City Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits City Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits City |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_CITY |
NO |
| Authorized Limits City Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits City Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits City Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits City Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits State |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits State |
| Logical Rolename | |
| ColumnName | AUTH_LMT_ST |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | State: State or provience the institute is located. |
| Note |
| Authorized Limits State Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits State |
| Datatype | VARCHAR(100) |
| Nullable | YES |
| Authorized Limits State Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Authorized Limits State Security Types |
| Name | Current Value |
| Authorized Limits State Bound Attachments |
| Name | Current Value |
| Authorized Limits State Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits State Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits State |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_ST |
NO |
| Authorized Limits State Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits State Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits State Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits State Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Postal Code |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits Postal Code |
| Logical Rolename | |
| ColumnName | AUTH_LMT_POSTAL_CD |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Postal Code: Postal code of the institute. |
| Note |
| Authorized Limits Postal Code Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits Postal Code |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Authorized Limits Postal Code Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Authorized Limits Postal Code Security Types |
| Name | Current Value |
| Authorized Limits Postal Code Bound Attachments |
| Name | Current Value |
| Authorized Limits Postal Code Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits Postal Code Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits Postal Code |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_POSTAL_CD |
NO |
| Authorized Limits Postal Code Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Postal Code Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Postal Code Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Postal Code Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Phone Number |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits Phone Number |
| Logical Rolename | |
| ColumnName | AUTH_LMT_PHONE_NBR |
| RoleName | |
| Domain | Phone |
| Logical Only | NO |
| Definition | |
| Note |
| Authorized Limits Phone Number Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits Phone Number |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Authorized Limits Phone Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Authorized Limits Phone Number Security Types |
| Name | Current Value |
| Authorized Limits Phone Number Bound Attachments |
| Name | Current Value |
| Authorized Limits Phone Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits Phone Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits Phone Number |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_PHONE_NBR |
NO |
| Authorized Limits Phone Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Phone Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Phone Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Phone Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Email Addr |
| Base Entity | Shipment Facility |
| Attribute Name | Authorized Limits Email Addr |
| Logical Rolename | |
| ColumnName | AUTH_LMT_EMAIL_ADDR |
| RoleName | |
| Domain | Email Addr |
| Logical Only | NO |
| Definition | Email Address: |
| Note |
| Authorized Limits Email Addr Logical Attribute Properties |
| Logical Attribute Name | Authorized Limits Email Addr |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| Authorized Limits Email Addr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Authorized Limits Email Addr Security Types |
| Name | Current Value |
| Authorized Limits Email Addr Bound Attachments |
| Name | Current Value |
| Authorized Limits Email Addr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Authorized Limits Email Addr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Authorized Limits Email Addr |
NO | ||
| SMPL (Oracle) SHIP_FACIL AUTH_LMT_EMAIL_ADDR |
NO |
| Authorized Limits Email Addr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Email Addr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Email Addr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Authorized Limits Email Addr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Country Identifier |
| Base Entity | Shipment Facility |
| Attribute Name | Country Identifier |
| Logical Rolename | |
| ColumnName | CNTRY_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Country Identifier: Abbreviated identrifier for a country. |
| Note |
| Country Identifier Logical Attribute Properties |
| Logical Attribute Name | Country Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Country Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Country Identifier Security Types |
| Name | Current Value |
| Country Identifier Bound Attachments |
| Name | Current Value |
| Country Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Country Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Country Identifier |
NO | ||
| SMPL (Oracle) SHIP_FACIL CNTRY_ID |
NO |
| Country Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Country Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Country Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Country Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |