| SHIP_FACIL_ID |
| Base Object | SHIP_FACIL |
| Attribute Name | Shipment Facility Identifier |
| ColumnName | SHIP_FACIL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SHIP_FACIL_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SHIP_FACIL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SHIP_FACIL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SHIP_FACIL_ID Security Types |
| Name | Current Value |
| SHIP_FACIL_ID Bound Attachments |
| Name | Current Value |
| SHIP_FACIL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SHIP_FACIL_ID 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 |
| SHIP_FACIL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_FACIL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_FACIL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_FACIL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_NM |
| Base Object | SHIP_FACIL |
| Attribute Name | Facility Name |
| ColumnName | FACIL_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| FACIL_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FACIL_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| FACIL_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FACIL_NM Security Types |
| Name | Current Value |
| FACIL_NM Bound Attachments |
| Name | Current Value |
| FACIL_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| FACIL_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Facility Name |
NO | ||
| SMPL (Oracle) SHIP_FACIL FACIL_NM |
NO |
| FACIL_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_DEPT |
| Base Object | SHIP_FACIL |
| Attribute Name | Facility Department |
| ColumnName | FACIL_DEPT |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| FACIL_DEPT Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FACIL_DEPT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| FACIL_DEPT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FACIL_DEPT Security Types |
| Name | Current Value |
| FACIL_DEPT Bound Attachments |
| Name | Current Value |
| FACIL_DEPT Data Movement Rules |
| Name | Type | Rule Text/Value |
| FACIL_DEPT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Facility Department |
NO | ||
| SMPL (Oracle) SHIP_FACIL FACIL_DEPT |
NO |
| FACIL_DEPT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_DEPT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_DEPT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_DEPT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR_CD |
| Base Object | SHIP_FACIL |
| Attribute Name | Address Code |
| ColumnName | ADDR_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ADDR_CD Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ADDR_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| ADDR_CD Domain Restrictions |
| CheckConstraint | ADDR_CD IN ('N','R','A') |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| ADDR_CD Security Types |
| Name | Current Value |
| ADDR_CD Bound Attachments |
| Name | Current Value |
| ADDR_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| ADDR_CD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Address Code |
NO | ||
| SMPL (Oracle) SHIP_FACIL ADDR_CD |
NO |
| ADDR_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR1 |
| Base Object | SHIP_FACIL |
| Attribute Name | Address 1 |
| ColumnName | ADDR1 |
| Logical Rolename | |
| RoleName | |
| Domain | Address 1 |
| Physical Only | NO |
| Definition | |
| Note |
| ADDR1 Column Properties |
| Datatype | VARCHAR2(500) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ADDR1 Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| ADDR1 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ADDR1 Security Types |
| Name | Current Value |
| ADDR1 Bound Attachments |
| Name | Current Value |
| ADDR1 Data Movement Rules |
| Name | Type | Rule Text/Value |
| ADDR1 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Address 1 |
NO | ||
| SMPL (Oracle) SHIP_FACIL ADDR1 |
NO |
| ADDR1 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR1 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR1 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR1 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR2 |
| Base Object | SHIP_FACIL |
| Attribute Name | Address 2 |
| ColumnName | ADDR2 |
| Logical Rolename | |
| RoleName | |
| Domain | Address 2 |
| Physical Only | NO |
| Definition | |
| Note |
| ADDR2 Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ADDR2 Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| ADDR2 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ADDR2 Security Types |
| Name | Current Value |
| ADDR2 Bound Attachments |
| Name | Current Value |
| ADDR2 Data Movement Rules |
| Name | Type | Rule Text/Value |
| ADDR2 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Address 2 |
NO | ||
| SMPL (Oracle) SHIP_FACIL ADDR2 |
NO |
| ADDR2 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR2 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR2 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADDR2 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONTACT |
| Base Object | SHIP_FACIL |
| Attribute Name | Contact |
| ColumnName | CONTACT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| CONTACT Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CONTACT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| 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 Object | SHIP_FACIL |
| Attribute Name | City |
| ColumnName | CITY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | City: City the institute is located. |
| Note |
| CITY Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CITY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| 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 Object | SHIP_FACIL |
| Attribute Name | State |
| ColumnName | STATE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | State: State or provience the institute is located. |
| Note |
| STATE Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STATE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| 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_CD |
| Base Object | SHIP_FACIL |
| Attribute Name | Postal Code |
| ColumnName | POSTAL_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Postal Code: Postal code of the institute. |
| Note |
| POSTAL_CD Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| POSTAL_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| POSTAL_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| POSTAL_CD Security Types |
| Name | Current Value |
| POSTAL_CD Bound Attachments |
| Name | Current Value |
| POSTAL_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| POSTAL_CD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Postal Code |
NO | ||
| SMPL (Oracle) SHIP_FACIL POSTAL_CD |
NO |
| POSTAL_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| POSTAL_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| POSTAL_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| POSTAL_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR |
| Base Object | SHIP_FACIL |
| Attribute Name | Phone Number |
| ColumnName | PHONE_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | Phone |
| Physical Only | NO |
| Definition | |
| Note |
| PHONE_NBR Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PHONE_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| PHONE_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PHONE_NBR Security Types |
| Name | Current Value |
| PHONE_NBR Bound Attachments |
| Name | Current Value |
| PHONE_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| PHONE_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Phone Number |
NO | ||
| SMPL (Oracle) SHIP_FACIL PHONE_NBR |
NO |
| PHONE_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PHONE_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL_ADDR |
| Base Object | SHIP_FACIL |
| Attribute Name | Email Addr |
| ColumnName | EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | Email Addr |
| Physical Only | NO |
| Definition | Email Address: |
| Note |
| EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| 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 |
| RAD_ADDR1 |
| Base Object | SHIP_FACIL |
| Attribute Name | Radioactive Address 1 |
| ColumnName | RAD_ADDR1 |
| Logical Rolename | |
| RoleName | |
| Domain | Address 1 |
| Physical Only | NO |
| Definition | |
| Note |
| RAD_ADDR1 Column Properties |
| Datatype | VARCHAR2(500) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_ADDR1 Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| RAD_ADDR1 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_ADDR1 Security Types |
| Name | Current Value |
| RAD_ADDR1 Bound Attachments |
| Name | Current Value |
| RAD_ADDR1 Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_ADDR1 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive Address 1 |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_ADDR1 |
NO |
| RAD_ADDR1 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_ADDR1 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_ADDR1 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_ADDR1 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_ADDR2 |
| Base Object | SHIP_FACIL |
| Attribute Name | Radioactive Address 2 |
| ColumnName | RAD_ADDR2 |
| Logical Rolename | |
| RoleName | |
| Domain | Address 2 |
| Physical Only | NO |
| Definition | |
| Note |
| RAD_ADDR2 Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_ADDR2 Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| RAD_ADDR2 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_ADDR2 Security Types |
| Name | Current Value |
| RAD_ADDR2 Bound Attachments |
| Name | Current Value |
| RAD_ADDR2 Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_ADDR2 Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive Address 2 |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_ADDR2 |
NO |
| RAD_ADDR2 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_ADDR2 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_ADDR2 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_ADDR2 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CONTACT |
| Base Object | SHIP_FACIL |
| Attribute Name | Radiactive Contact |
| ColumnName | RAD_CONTACT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| RAD_CONTACT Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_CONTACT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| RAD_CONTACT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_CONTACT Security Types |
| Name | Current Value |
| RAD_CONTACT Bound Attachments |
| Name | Current Value |
| RAD_CONTACT Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_CONTACT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radiactive Contact |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_CONTACT |
NO |
| RAD_CONTACT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CONTACT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CONTACT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CONTACT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CITY |
| Base Object | SHIP_FACIL |
| Attribute Name | Radioactive City |
| ColumnName | RAD_CITY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | City: City the institute is located. |
| Note |
| RAD_CITY Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_CITY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| RAD_CITY Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_CITY Security Types |
| Name | Current Value |
| RAD_CITY Bound Attachments |
| Name | Current Value |
| RAD_CITY Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_CITY Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive City |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_CITY |
NO |
| RAD_CITY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CITY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CITY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_CITY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_STATE |
| Base Object | SHIP_FACIL |
| Attribute Name | Radioactive State |
| ColumnName | RAD_STATE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | State: State or provience the institute is located. |
| Note |
| RAD_STATE Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_STATE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| RAD_STATE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_STATE Security Types |
| Name | Current Value |
| RAD_STATE Bound Attachments |
| Name | Current Value |
| RAD_STATE Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_STATE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Radioactive State |
NO | ||
| SMPL (Oracle) SHIP_FACIL RAD_STATE |
NO |
| RAD_STATE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_STATE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_STATE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_STATE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_POSTAL_CD |
| Base Object | SHIP_FACIL |
| Attribute Name | Radioactive Postal Code |
| ColumnName | RAD_POSTAL_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Postal Code: Postal code of the institute. |
| Note |
| RAD_POSTAL_CD Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_POSTAL_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| RAD_POSTAL_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_POSTAL_CD Security Types |
| Name | Current Value |
| RAD_POSTAL_CD Bound Attachments |
| Name | Current Value |
| RAD_POSTAL_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_POSTAL_CD 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 |
| RAD_POSTAL_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_POSTAL_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_POSTAL_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_POSTAL_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_PHONE_NBR |
| Base Object | SHIP_FACIL |
| Attribute Name | Radioactive Phone Number |
| ColumnName | RAD_PHONE_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | Phone |
| Physical Only | NO |
| Definition | |
| Note |
| RAD_PHONE_NBR Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_PHONE_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| RAD_PHONE_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_PHONE_NBR Security Types |
| Name | Current Value |
| RAD_PHONE_NBR Bound Attachments |
| Name | Current Value |
| RAD_PHONE_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_PHONE_NBR 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 |
| RAD_PHONE_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_PHONE_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_PHONE_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_PHONE_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_EMAIL_ADDR |
| Base Object | SHIP_FACIL |
| Attribute Name | Radioactive Email Addr |
| ColumnName | RAD_EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | Email Addr |
| Physical Only | NO |
| Definition | Email Address: |
| Note |
| RAD_EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RAD_EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| RAD_EMAIL_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RAD_EMAIL_ADDR Security Types |
| Name | Current Value |
| RAD_EMAIL_ADDR Bound Attachments |
| Name | Current Value |
| RAD_EMAIL_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| RAD_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 |
| RAD_EMAIL_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_EMAIL_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_EMAIL_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RAD_EMAIL_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR1 |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits Address 1 |
| ColumnName | AUTH_LMT_ADDR1 |
| Logical Rolename | |
| RoleName | |
| Domain | Address 1 |
| Physical Only | NO |
| Definition | |
| Note |
| AUTH_LMT_ADDR1 Column Properties |
| Datatype | VARCHAR2(500) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_ADDR1 Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| AUTH_LMT_ADDR1 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_ADDR1 Security Types |
| Name | Current Value |
| AUTH_LMT_ADDR1 Bound Attachments |
| Name | Current Value |
| AUTH_LMT_ADDR1 Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_ADDR1 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 |
| AUTH_LMT_ADDR1 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR1 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR1 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR1 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR2 |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits Address 2 |
| ColumnName | AUTH_LMT_ADDR2 |
| Logical Rolename | |
| RoleName | |
| Domain | Address 2 |
| Physical Only | NO |
| Definition | |
| Note |
| AUTH_LMT_ADDR2 Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_ADDR2 Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| AUTH_LMT_ADDR2 Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_ADDR2 Security Types |
| Name | Current Value |
| AUTH_LMT_ADDR2 Bound Attachments |
| Name | Current Value |
| AUTH_LMT_ADDR2 Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_ADDR2 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 |
| AUTH_LMT_ADDR2 Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR2 Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR2 Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ADDR2 Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CONTACT |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits Contact |
| ColumnName | AUTH_LMT_CONTACT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| AUTH_LMT_CONTACT Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_CONTACT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| AUTH_LMT_CONTACT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_CONTACT Security Types |
| Name | Current Value |
| AUTH_LMT_CONTACT Bound Attachments |
| Name | Current Value |
| AUTH_LMT_CONTACT Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_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 |
| AUTH_LMT_CONTACT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CONTACT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CONTACT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CONTACT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CITY |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits City |
| ColumnName | AUTH_LMT_CITY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | City: City the institute is located. |
| Note |
| AUTH_LMT_CITY Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_CITY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| AUTH_LMT_CITY Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_CITY Security Types |
| Name | Current Value |
| AUTH_LMT_CITY Bound Attachments |
| Name | Current Value |
| AUTH_LMT_CITY Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_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 |
| AUTH_LMT_CITY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CITY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CITY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_CITY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ST |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits State |
| ColumnName | AUTH_LMT_ST |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | State: State or provience the institute is located. |
| Note |
| AUTH_LMT_ST Column Properties |
| Datatype | VARCHAR2(100) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_ST Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 100 |
| Percent Null | 0 |
| AUTH_LMT_ST Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_ST Security Types |
| Name | Current Value |
| AUTH_LMT_ST Bound Attachments |
| Name | Current Value |
| AUTH_LMT_ST Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_ST 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 |
| AUTH_LMT_ST Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ST Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ST Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_ST Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_POSTAL_CD |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits Postal Code |
| ColumnName | AUTH_LMT_POSTAL_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Postal Code: Postal code of the institute. |
| Note |
| AUTH_LMT_POSTAL_CD Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_POSTAL_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| AUTH_LMT_POSTAL_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_POSTAL_CD Security Types |
| Name | Current Value |
| AUTH_LMT_POSTAL_CD Bound Attachments |
| Name | Current Value |
| AUTH_LMT_POSTAL_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_POSTAL_CD 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 |
| AUTH_LMT_POSTAL_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_POSTAL_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_POSTAL_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_POSTAL_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_PHONE_NBR |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits Phone Number |
| ColumnName | AUTH_LMT_PHONE_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | Phone |
| Physical Only | NO |
| Definition | |
| Note |
| AUTH_LMT_PHONE_NBR Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_PHONE_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| AUTH_LMT_PHONE_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_PHONE_NBR Security Types |
| Name | Current Value |
| AUTH_LMT_PHONE_NBR Bound Attachments |
| Name | Current Value |
| AUTH_LMT_PHONE_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_PHONE_NBR 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 |
| AUTH_LMT_PHONE_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_PHONE_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_PHONE_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_PHONE_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_EMAIL_ADDR |
| Base Object | SHIP_FACIL |
| Attribute Name | Authorized Limits Email Addr |
| ColumnName | AUTH_LMT_EMAIL_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | Email Addr |
| Physical Only | NO |
| Definition | Email Address: |
| Note |
| AUTH_LMT_EMAIL_ADDR Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AUTH_LMT_EMAIL_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| AUTH_LMT_EMAIL_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AUTH_LMT_EMAIL_ADDR Security Types |
| Name | Current Value |
| AUTH_LMT_EMAIL_ADDR Bound Attachments |
| Name | Current Value |
| AUTH_LMT_EMAIL_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| AUTH_LMT_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 |
| AUTH_LMT_EMAIL_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_EMAIL_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_EMAIL_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AUTH_LMT_EMAIL_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID |
| Base Object | SHIP_FACIL |
| Attribute Name | Country Identifier |
| ColumnName | CNTRY_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Country Identifier: Abbreviated identrifier for a country. |
| Note |
| CNTRY_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CNTRY_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| CNTRY_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CNTRY_ID Security Types |
| Name | Current Value |
| CNTRY_ID Bound Attachments |
| Name | Current Value |
| CNTRY_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CNTRY_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Shipment Facility Country Identifier |
NO | ||
| SMPL (Oracle) SHIP_FACIL CNTRY_ID |
NO |
| CNTRY_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CNTRY_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |