Sample Shipment Identifier |
Base Entity | Sample Shipment |
Attribute Name | Sample Shipment Identifier |
Logical Rolename | |
ColumnName | SMPL_SHIP_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Sample Shipment Identifier Logical Attribute Properties |
Logical Attribute Name | Sample Shipment Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Sample Shipment Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sample Shipment Identifier Security Types |
Name | Current Value |
Sample Shipment Identifier Bound Attachments |
Name | Current Value |
Sample Shipment Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Shipment Identifier 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 |
Sample Shipment Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Shipment Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Shipment Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Shipment Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date |
Base Entity | Sample Shipment |
Attribute Name | Current Date |
Logical Rolename | |
ColumnName | CUR_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Current Date Logical Attribute Properties |
Logical Attribute Name | Current Date |
Datatype | DATE |
Nullable | NO |
Current Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Current Date Security Types |
Name | Current Value |
Current Date Bound Attachments |
Name | Current Value |
Current Date Data Movement Rules |
Name | Type | Rule Text/Value |
Current Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Shipment Current Date |
NO | ||
SMPL (Oracle) SMPL_SHIP CUR_DTE |
NO |
Current Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Shipment Facility Identifier |
Base Entity | Sample Shipment |
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 | YES |
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 Sample Shipment Shipment Facility Identifier |
NO | ||
SMPL (Oracle) SMPL_SHIP 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 |
Status Identifier |
Base Entity | Sample Shipment |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | VARCHAR(25) |
Nullable | NO |
Status Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Shipment Status Identifier |
NO | ||
SMPL (Oracle) SMPL_SHIP STAT_ID |
NO |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Facility Name |
Base Entity | Sample Shipment |
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 | YES |
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 Sample Shipment Facility Name |
NO | ||
SMPL (Oracle) SMPL_SHIP 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 | Sample Shipment |
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 Sample Shipment Facility Department |
NO | ||
SMPL (Oracle) SMPL_SHIP 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 1 |
Base Entity | Sample Shipment |
Attribute Name | Address 1 |
Logical Rolename | |
ColumnName | ADDR1 |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Street: Street address of institute. |
Note |
Address 1 Logical Attribute Properties |
Logical Attribute Name | Address 1 |
Datatype | VARCHAR(100) |
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 Sample Shipment Address 1 |
NO | ||
SMPL (Oracle) SMPL_SHIP 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 | Sample Shipment |
Attribute Name | Address 2 |
Logical Rolename | |
ColumnName | ADDR2 |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Address 2 Logical Attribute Properties |
Logical Attribute Name | Address 2 |
Datatype | VARCHAR(25) |
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 Sample Shipment Address 2 |
NO | ||
SMPL (Oracle) SMPL_SHIP 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 |
City |
Base Entity | Sample Shipment |
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 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 Entity | Sample Shipment |
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 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 Code |
Base Entity | Sample Shipment |
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 Sample Shipment Postal Code |
NO | ||
SMPL (Oracle) SMPL_SHIP 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 | Sample Shipment |
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 Sample Shipment Phone Number |
NO | ||
SMPL (Oracle) SMPL_SHIP 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 | Sample Shipment |
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 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 |
Hazardous Material Indicator |
Base Entity | Sample Shipment |
Attribute Name | Hazardous Material Indicator |
Logical Rolename | |
ColumnName | HAZ_MAT_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Hazardous Material Indicator Logical Attribute Properties |
Logical Attribute Name | Hazardous Material Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Hazardous Material Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Hazardous Material Indicator 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 |
Hazardous Material Indicator Security Types |
Name | Current Value |
Hazardous Material Indicator Bound Attachments |
Name | Current Value |
Hazardous Material Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Hazardous Material Indicator 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 |
Hazardous Material Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Hazardous Material Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Hazardous Material Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Hazardous Material Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Tracking Number |
Base Entity | Sample Shipment |
Attribute Name | Tracking Number |
Logical Rolename | |
ColumnName | TRACK_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Tracking Number Logical Attribute Properties |
Logical Attribute Name | Tracking Number |
Datatype | VARCHAR(25) |
Nullable | YES |
Tracking Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Tracking Number Security Types |
Name | Current Value |
Tracking Number Bound Attachments |
Name | Current Value |
Tracking Number Data Movement Rules |
Name | Type | Rule Text/Value |
Tracking Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Shipment Tracking Number |
NO | ||
SMPL (Oracle) SMPL_SHIP TRACK_NBR |
NO |
Tracking Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Tracking Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Tracking Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Tracking Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By Badge Number |
Base Entity | Sample Shipment |
Attribute Name | Badge Number |
Logical Rolename | Modified By Badge Number |
ColumnName | MOD_BY_BN |
RoleName | MOD_BY_BN |
Domain | |
Logical Only | NO |
Definition | |
Note |
Modified By Badge Number Logical Attribute Properties |
Logical Attribute Name | Badge Number |
Datatype | VARCHAR(10) |
Nullable | NO |
Modified By Badge Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Modified By Badge Number Security Types |
Name | Current Value |
Modified By Badge Number Bound Attachments |
Name | Current Value |
Modified By Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Modified By Badge Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Shipment Badge Number |
NO | ||
SMPL (Oracle) SMPL_SHIP MOD_BY_BN |
NO |
Modified By Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modified By Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Ship Order Originated By Badge Number |
Base Entity | Sample Shipment |
Attribute Name | Badge Number |
Logical Rolename | Ship Order Originated By Badge Number |
ColumnName | SHIP_ORD_ORIG_BY_BN |
RoleName | SHIP_ORD_ORIG_BY_BN |
Domain | |
Logical Only | NO |
Definition | |
Note |
Ship Order Originated By Badge Number Logical Attribute Properties |
Logical Attribute Name | Badge Number |
Datatype | VARCHAR(10) |
Nullable | YES |
Ship Order Originated By Badge Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Ship Order Originated By Badge Number Security Types |
Name | Current Value |
Ship Order Originated By Badge Number Bound Attachments |
Name | Current Value |
Ship Order Originated By Badge Number Data Movement Rules |
Name | Type | Rule Text/Value |
Ship Order Originated By Badge Number 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 Order Originated By Badge Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Ship Order Originated By Badge Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Ship Order Originated By Badge Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Ship Order Originated By Badge Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |