| SMPL_SHIP_ID |
| Base Object | SMPL_SHIP |
| Attribute Name | Sample Shipment Identifier |
| ColumnName | SMPL_SHIP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_SHIP_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_SHIP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SMPL_SHIP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_SHIP_ID Security Types |
| Name | Current Value |
| SMPL_SHIP_ID Bound Attachments |
| Name | Current Value |
| SMPL_SHIP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_SHIP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Shipment Sample Shipment Identifier |
NO | ||
| SMPL (Oracle) SMPL_SHIP SMPL_SHIP_ID |
NO |
| SMPL_SHIP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SHIP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SHIP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_SHIP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE |
| Base Object | SMPL_SHIP |
| Attribute Name | Current Date |
| ColumnName | CUR_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| CUR_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CUR_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| CUR_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| CUR_DTE Security Types |
| Name | Current Value |
| CUR_DTE Bound Attachments |
| Name | Current Value |
| CUR_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| CUR_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Shipment Current Date |
NO | ||
| SMPL (Oracle) SMPL_SHIP CUR_DTE |
NO |
| CUR_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CUR_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_FACIL_ID |
| Base Object | SMPL_SHIP |
| 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 | YES |
| 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 Sample Shipment Shipment Facility Identifier |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 |
| STAT_ID |
| Base Object | SMPL_SHIP |
| Attribute Name | Status Identifier |
| ColumnName | STAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| STAT_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| STAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STAT_ID Security Types |
| Name | Current Value |
| STAT_ID Bound Attachments |
| Name | Current Value |
| STAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| STAT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Shipment Status Identifier |
NO | ||
| SMPL (Oracle) SMPL_SHIP STAT_ID |
NO |
| STAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACIL_NM |
| Base Object | SMPL_SHIP |
| 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 | YES |
| 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 Sample Shipment Facility Name |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 | SMPL_SHIP |
| 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 Sample Shipment Facility Department |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 |
| ADDR1 |
| Base Object | SMPL_SHIP |
| Attribute Name | Address 1 |
| ColumnName | ADDR1 |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Street: Street address of institute. |
| Note |
| ADDR1 Column Properties |
| Datatype | VARCHAR2(100) |
| 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 Sample Shipment Address 1 |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 | SMPL_SHIP |
| Attribute Name | Address 2 |
| ColumnName | ADDR2 |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ADDR2 Column Properties |
| Datatype | VARCHAR2(25) |
| 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 Sample Shipment Address 2 |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 |
| CITY |
| Base Object | SMPL_SHIP |
| 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 Sample Shipment City |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 | SMPL_SHIP |
| 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 Sample Shipment State |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 | SMPL_SHIP |
| 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 Sample Shipment Postal Code |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 | SMPL_SHIP |
| 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 Sample Shipment Phone Number |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 | SMPL_SHIP |
| 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 Sample Shipment Email Addr |
NO | ||
| SMPL (Oracle) SMPL_SHIP 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 |
| HAZ_MAT_IND |
| Base Object | SMPL_SHIP |
| Attribute Name | Hazardous Material Indicator |
| ColumnName | HAZ_MAT_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| HAZ_MAT_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| HAZ_MAT_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| HAZ_MAT_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| HAZ_MAT_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| HAZ_MAT_IND Security Types |
| Name | Current Value |
| HAZ_MAT_IND Bound Attachments |
| Name | Current Value |
| HAZ_MAT_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| HAZ_MAT_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Shipment Hazardous Material Indicator |
NO | ||
| SMPL (Oracle) SMPL_SHIP HAZ_MAT_IND |
NO |
| HAZ_MAT_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HAZ_MAT_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HAZ_MAT_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HAZ_MAT_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRACK_NBR |
| Base Object | SMPL_SHIP |
| Attribute Name | Tracking Number |
| ColumnName | TRACK_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TRACK_NBR Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TRACK_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| TRACK_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TRACK_NBR Security Types |
| Name | Current Value |
| TRACK_NBR Bound Attachments |
| Name | Current Value |
| TRACK_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| TRACK_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Shipment Tracking Number |
NO | ||
| SMPL (Oracle) SMPL_SHIP TRACK_NBR |
NO |
| TRACK_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRACK_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRACK_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TRACK_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN |
| Base Object | SMPL_SHIP |
| Attribute Name | Badge Number |
| ColumnName | MOD_BY_BN |
| Logical Rolename | Modified By Badge Number |
| RoleName | MOD_BY_BN |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_BY_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_BY_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| MOD_BY_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_BY_BN Security Types |
| Name | Current Value |
| MOD_BY_BN Bound Attachments |
| Name | Current Value |
| MOD_BY_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_BY_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Shipment Badge Number |
NO | ||
| SMPL (Oracle) SMPL_SHIP MOD_BY_BN |
NO |
| MOD_BY_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_ORD_ORIG_BY_BN |
| Base Object | SMPL_SHIP |
| Attribute Name | Badge Number |
| ColumnName | SHIP_ORD_ORIG_BY_BN |
| Logical Rolename | Ship Order Originated By Badge Number |
| RoleName | SHIP_ORD_ORIG_BY_BN |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SHIP_ORD_ORIG_BY_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SHIP_ORD_ORIG_BY_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| SHIP_ORD_ORIG_BY_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SHIP_ORD_ORIG_BY_BN Security Types |
| Name | Current Value |
| SHIP_ORD_ORIG_BY_BN Bound Attachments |
| Name | Current Value |
| SHIP_ORD_ORIG_BY_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| SHIP_ORD_ORIG_BY_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Shipment Badge Number |
NO | ||
| SMPL (Oracle) SMPL_SHIP SHIP_ORD_ORIG_BY_BN |
NO |
| SHIP_ORD_ORIG_BY_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_ORD_ORIG_BY_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_ORD_ORIG_BY_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SHIP_ORD_ORIG_BY_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |