| PRPSL_ID |
| Base Entity | Experiment Sample History |
| Attribute Name | PRPSL_ID |
| Logical Rolename | |
| ColumnName | PRPSL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| PRPSL_ID Logical Attribute Properties |
| Logical Attribute Name | PRPSL_ID |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| PRPSL_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| PRPSL_ID Security Types |
| Name | Current Value |
| PRPSL_ID Bound Attachments |
| Name | Current Value |
| PRPSL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PRPSL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History PRPSL_ID |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST PRPSL_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST PRPSL_ID |
NO |
| PRPSL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRPSL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRPSL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PRPSL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_ID |
| Base Entity | Experiment Sample History |
| Attribute Name | SMPL_ID |
| Logical Rolename | |
| ColumnName | SMPL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| SMPL_ID Logical Attribute Properties |
| Logical Attribute Name | SMPL_ID |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| SMPL_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| SMPL_ID Security Types |
| Name | Current Value |
| SMPL_ID Bound Attachments |
| Name | Current Value |
| SMPL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History SMPL_ID |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_ID |
NO |
| SMPL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Current Date |
| Base Entity | Experiment Sample History |
| Attribute Name | Current Date |
| Logical Rolename | |
| ColumnName | CUR_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| 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 | |
| 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 Experiment Sample History Current Date |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST CUR_DTE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST 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 |
| Sample Name |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Name |
| Logical Rolename | |
| ColumnName | SMPL_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Name Logical Attribute Properties |
| Logical Attribute Name | Sample Name |
| Datatype | VARCHAR(120) |
| Nullable | NO |
| Sample Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Sample Name Security Types |
| Name | Current Value |
| Sample Name Bound Attachments |
| Name | Current Value |
| Sample Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Name |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_NM |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_NM |
NO |
| Sample Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Description |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Description |
| Logical Rolename | |
| ColumnName | SMPL_DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Description Logical Attribute Properties |
| Logical Attribute Name | Sample Description |
| Datatype | VARCHAR(2000) |
| Nullable | NO |
| Sample Description Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Sample Description Security Types |
| Name | Current Value |
| Sample Description Bound Attachments |
| Name | Current Value |
| Sample Description Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Description Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Description |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_DESCR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_DESCR |
NO |
| Sample Description Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Description Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Description Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Description Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Formula |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Formula |
| Logical Rolename | |
| ColumnName | SMPL_FMLA |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Formula Logical Attribute Properties |
| Logical Attribute Name | Sample Formula |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Sample Formula Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Formula Security Types |
| Name | Current Value |
| Sample Formula Bound Attachments |
| Name | Current Value |
| Sample Formula Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Formula Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Formula |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_FMLA |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_FMLA |
NO |
| Sample Formula Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Formula Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Formula Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Formula Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Length |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Length |
| Logical Rolename | |
| ColumnName | SMPL_LNGTH |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Length Logical Attribute Properties |
| Logical Attribute Name | Sample Length |
| Datatype | NUMERIC(7, 2) |
| Nullable | YES |
| Sample Length Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Length Security Types |
| Name | Current Value |
| Sample Length Bound Attachments |
| Name | Current Value |
| Sample Length Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Length Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Length |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_LNGTH |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_LNGTH |
NO |
| Sample Length Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Length Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Length Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Length Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Width |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Width |
| Logical Rolename | |
| ColumnName | SMPL_WIDTH |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Width Logical Attribute Properties |
| Logical Attribute Name | Sample Width |
| Datatype | NUMERIC(7, 2) |
| Nullable | YES |
| Sample Width Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Width Security Types |
| Name | Current Value |
| Sample Width Bound Attachments |
| Name | Current Value |
| Sample Width Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Width Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Width |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_WIDTH |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_WIDTH |
NO |
| Sample Width Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Width Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Width Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Width Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Height |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Height |
| Logical Rolename | |
| ColumnName | SMPL_HGT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Height Logical Attribute Properties |
| Logical Attribute Name | Sample Height |
| Datatype | NUMERIC(7, 2) |
| Nullable | YES |
| Sample Height Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Height Security Types |
| Name | Current Value |
| Sample Height Bound Attachments |
| Name | Current Value |
| Sample Height Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Height Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Height |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_HGT |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_HGT |
NO |
| Sample Height Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Height Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Height Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Height Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Mass |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Mass |
| Logical Rolename | |
| ColumnName | SMPL_MASS |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Mass Logical Attribute Properties |
| Logical Attribute Name | Sample Mass |
| Datatype | NUMERIC(12, 2) |
| Nullable | YES |
| Sample Mass Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Mass Security Types |
| Name | Current Value |
| Sample Mass Bound Attachments |
| Name | Current Value |
| Sample Mass Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Mass Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Mass |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_MASS |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_MASS |
NO |
| Sample Mass Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Mass Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Mass Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Mass Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Total Number |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Total Number |
| Logical Rolename | |
| ColumnName | SMPL_TOT_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Total Number Logical Attribute Properties |
| Logical Attribute Name | Sample Total Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| Sample Total Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Total Number Security Types |
| Name | Current Value |
| Sample Total Number Bound Attachments |
| Name | Current Value |
| Sample Total Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Total Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Total Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_TOT_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_TOT_NBR |
NO |
| Sample Total Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Total Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Total Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Total Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Currently Available Number |
| Base Entity | Experiment Sample History |
| Attribute Name | Currently Available Number |
| Logical Rolename | |
| ColumnName | CUR_AVAIL_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Currently Available Number Logical Attribute Properties |
| Logical Attribute Name | Currently Available Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| Currently Available Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Currently Available Number Security Types |
| Name | Current Value |
| Currently Available Number Bound Attachments |
| Name | Current Value |
| Currently Available Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Currently Available Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Currently Available Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST CUR_AVAIL_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST CUR_AVAIL_NBR |
NO |
| Currently Available Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Currently Available Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Currently Available Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Currently Available Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabricated Number |
| Base Entity | Experiment Sample History |
| Attribute Name | Fabricated Number |
| Logical Rolename | |
| ColumnName | FAB_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Fabricated Number Logical Attribute Properties |
| Logical Attribute Name | Fabricated Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| Fabricated Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Fabricated Number Security Types |
| Name | Current Value |
| Fabricated Number Bound Attachments |
| Name | Current Value |
| Fabricated Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Fabricated Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Fabricated Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST FAB_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST FAB_NBR |
NO |
| Fabricated Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabricated Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabricated Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabricated Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabrication Date |
| Base Entity | Experiment Sample History |
| Attribute Name | Fabrication Date |
| Logical Rolename | |
| ColumnName | FAB_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Fabrication Date Logical Attribute Properties |
| Logical Attribute Name | Fabrication Date |
| Datatype | DATE |
| Nullable | YES |
| Fabrication Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Fabrication Date Security Types |
| Name | Current Value |
| Fabrication Date Bound Attachments |
| Name | Current Value |
| Fabrication Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Fabrication Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Fabrication Date |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST FAB_DTE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST FAB_DTE |
NO |
| Fabrication Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabrication Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabrication Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Fabrication Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Number |
| Base Entity | Experiment Sample History |
| Attribute Name | Purchase Number |
| Logical Rolename | |
| ColumnName | PUR_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Purchase Number Logical Attribute Properties |
| Logical Attribute Name | Purchase Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| Purchase Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Purchase Number Security Types |
| Name | Current Value |
| Purchase Number Bound Attachments |
| Name | Current Value |
| Purchase Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Purchase Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Purchase Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST PUR_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST PUR_NBR |
NO |
| Purchase Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Date |
| Base Entity | Experiment Sample History |
| Attribute Name | Purchase Date |
| Logical Rolename | |
| ColumnName | PUR_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Purchase Date Logical Attribute Properties |
| Logical Attribute Name | Purchase Date |
| Datatype | DATE |
| Nullable | YES |
| Purchase Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Purchase Date Security Types |
| Name | Current Value |
| Purchase Date Bound Attachments |
| Name | Current Value |
| Purchase Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Purchase Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Purchase Date |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST PUR_DTE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST PUR_DTE |
NO |
| Purchase Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Purchase Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hand Carry Number |
| Base Entity | Experiment Sample History |
| Attribute Name | Hand Carry Number |
| Logical Rolename | |
| ColumnName | HAND_CARRY_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Hand Carry Number Logical Attribute Properties |
| Logical Attribute Name | Hand Carry Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| Hand Carry Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Hand Carry Number Security Types |
| Name | Current Value |
| Hand Carry Number Bound Attachments |
| Name | Current Value |
| Hand Carry Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Hand Carry Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Hand Carry Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST HAND_CARRY_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST HAND_CARRY_NBR |
NO |
| Hand Carry Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hand Carry Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hand Carry Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hand Carry Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USPS Number |
| Base Entity | Experiment Sample History |
| Attribute Name | USPS Number |
| Logical Rolename | |
| ColumnName | USPS_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| USPS Number Logical Attribute Properties |
| Logical Attribute Name | USPS Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| USPS Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| USPS Number Security Types |
| Name | Current Value |
| USPS Number Bound Attachments |
| Name | Current Value |
| USPS Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| USPS Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History USPS Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST USPS_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST USPS_NBR |
NO |
| USPS Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USPS Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USPS Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USPS Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPS Number |
| Base Entity | Experiment Sample History |
| Attribute Name | UPS Number |
| Logical Rolename | |
| ColumnName | UPS_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| UPS Number Logical Attribute Properties |
| Logical Attribute Name | UPS Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| UPS Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| UPS Number Security Types |
| Name | Current Value |
| UPS Number Bound Attachments |
| Name | Current Value |
| UPS Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| UPS Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History UPS Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST UPS_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST UPS_NBR |
NO |
| UPS Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPS Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPS Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPS Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FedEx Number |
| Base Entity | Experiment Sample History |
| Attribute Name | FedEx Number |
| Logical Rolename | |
| ColumnName | FEDEX_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| FedEx Number Logical Attribute Properties |
| Logical Attribute Name | FedEx Number |
| Datatype | NUMERIC(5, 0) |
| Nullable | YES |
| FedEx Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| FedEx Number Security Types |
| Name | Current Value |
| FedEx Number Bound Attachments |
| Name | Current Value |
| FedEx Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| FedEx Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History FedEx Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST FEDEX_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST FEDEX_NBR |
NO |
| FedEx Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FedEx Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FedEx Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FedEx Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Number |
| Base Entity | Experiment Sample History |
| Attribute Name | Other Number |
| Logical Rolename | |
| ColumnName | OTHER_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Other Number Logical Attribute Properties |
| Logical Attribute Name | Other Number |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| Other Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Other Number Security Types |
| Name | Current Value |
| Other Number Bound Attachments |
| Name | Current Value |
| Other Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Other Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Other Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST OTHER_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST OTHER_NBR |
NO |
| Other Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Transportation |
| Base Entity | Experiment Sample History |
| Attribute Name | Other Transportation |
| Logical Rolename | |
| ColumnName | OTHER_TRANS |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Other Transportation Logical Attribute Properties |
| Logical Attribute Name | Other Transportation |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Other Transportation Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Other Transportation Security Types |
| Name | Current Value |
| Other Transportation Bound Attachments |
| Name | Current Value |
| Other Transportation Data Movement Rules |
| Name | Type | Rule Text/Value |
| Other Transportation Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Other Transportation |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST OTHER_TRANS |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST OTHER_TRANS |
NO |
| Other Transportation Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Transportation Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Transportation Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Transportation Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample MSDS |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample MSDS |
| Logical Rolename | |
| ColumnName | SMPL_MSDS |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample MSDS Logical Attribute Properties |
| Logical Attribute Name | Sample MSDS |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Sample MSDS Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample MSDS Security Types |
| Name | Current Value |
| Sample MSDS Bound Attachments |
| Name | Current Value |
| Sample MSDS Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample MSDS Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample MSDS |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_MSDS |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_MSDS |
NO |
| Sample MSDS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample MSDS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample MSDS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample MSDS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Post Experiment Sample Management Plan |
| Base Entity | Experiment Sample History |
| Attribute Name | Post Experiment Sample Management Plan |
| Logical Rolename | |
| ColumnName | POST_EXPT_MGMT_PLAN |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Post Experiment Sample Management Plan Logical Attribute Properties |
| Logical Attribute Name | Post Experiment Sample Management Plan |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Post Experiment Sample Management Plan Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Post Experiment Sample Management Plan Security Types |
| Name | Current Value |
| Post Experiment Sample Management Plan Bound Attachments |
| Name | Current Value |
| Post Experiment Sample Management Plan Data Movement Rules |
| Name | Type | Rule Text/Value |
| Post Experiment Sample Management Plan Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Post Experiment Sample Management Plan |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST POST_EXPT_MGMT_PLAN |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST POST_EXPT_MGMT_PLAN |
NO |
| Post Experiment Sample Management Plan Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Post Experiment Sample Management Plan Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Post Experiment Sample Management Plan Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Post Experiment Sample Management Plan Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equipment |
| Base Entity | Experiment Sample History |
| Attribute Name | Equipment |
| Logical Rolename | |
| ColumnName | EQUIP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Equipment Logical Attribute Properties |
| Logical Attribute Name | Equipment |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Equipment Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Equipment Security Types |
| Name | Current Value |
| Equipment Bound Attachments |
| Name | Current Value |
| Equipment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equipment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Equipment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST EQUIP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST EQUIP |
NO |
| Equipment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equipment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equipment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equipment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Local Equipment |
| Base Entity | Experiment Sample History |
| Attribute Name | Local Equipment |
| Logical Rolename | |
| ColumnName | LOCAL_EQUIP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Local Equipment Logical Attribute Properties |
| Logical Attribute Name | Local Equipment |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Local Equipment Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Local Equipment Security Types |
| Name | Current Value |
| Local Equipment Bound Attachments |
| Name | Current Value |
| Local Equipment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Local Equipment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Local Equipment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST LOCAL_EQUIP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST LOCAL_EQUIP |
NO |
| Local Equipment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Local Equipment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Local Equipment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Local Equipment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Length Unit Identifier |
| Base Entity | Experiment Sample History |
| Attribute Name | Length Unit Identifier |
| Logical Rolename | |
| ColumnName | LEN_UNIT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Length Unit Identifier Logical Attribute Properties |
| Logical Attribute Name | Length Unit Identifier |
| Datatype | VARCHAR(3) |
| Nullable | YES |
| Length Unit Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Length Unit Identifier Security Types |
| Name | Current Value |
| Length Unit Identifier Bound Attachments |
| Name | Current Value |
| Length Unit Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Length Unit Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Length Unit Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST LEN_UNIT_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST LEN_UNIT_ID |
NO |
| Length Unit Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Length Unit Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Length Unit Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Length Unit Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mass Unit Identifier |
| Base Entity | Experiment Sample History |
| Attribute Name | Mass Unit Identifier |
| Logical Rolename | |
| ColumnName | MASS_UNIT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Mass Unit Identifier Logical Attribute Properties |
| Logical Attribute Name | Mass Unit Identifier |
| Datatype | VARCHAR(3) |
| Nullable | YES |
| Mass Unit Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Mass Unit Identifier Security Types |
| Name | Current Value |
| Mass Unit Identifier Bound Attachments |
| Name | Current Value |
| Mass Unit Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mass Unit Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Mass Unit Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST MASS_UNIT_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST MASS_UNIT_ID |
NO |
| Mass Unit Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mass Unit Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mass Unit Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mass Unit Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Id |
| Base Entity | Experiment Sample History |
| Attribute Name | State Id |
| Logical Rolename | |
| ColumnName | ST_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| State Id Logical Attribute Properties |
| Logical Attribute Name | State Id |
| Datatype | VARCHAR(6) |
| Nullable | YES |
| State Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| State Id Security Types |
| Name | Current Value |
| State Id Bound Attachments |
| Name | Current Value |
| State Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| State Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History State Id |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST ST_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST ST_ID |
NO |
| State Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| State Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Descriptor Identifier |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Descriptor Identifier |
| Logical Rolename | |
| ColumnName | SMPL_DESC_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Descriptor Identifier Logical Attribute Properties |
| Logical Attribute Name | Sample Descriptor Identifier |
| Datatype | VARCHAR(5) |
| Nullable | YES |
| Sample Descriptor Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Descriptor Identifier Security Types |
| Name | Current Value |
| Sample Descriptor Identifier Bound Attachments |
| Name | Current Value |
| Sample Descriptor Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Descriptor Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Descriptor Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_DESC_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_DESC_ID |
NO |
| Sample Descriptor Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Descriptor Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Descriptor Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Descriptor Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Density |
| Base Entity | Experiment Sample History |
| Attribute Name | Sample Density |
| Logical Rolename | |
| ColumnName | SMPL_DENS |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Density Logical Attribute Properties |
| Logical Attribute Name | Sample Density |
| Datatype | NUMERIC(7, 2) |
| Nullable | YES |
| Sample Density Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Density Security Types |
| Name | Current Value |
| Sample Density Bound Attachments |
| Name | Current Value |
| Sample Density Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Density Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample History Sample Density |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL_HIST SMPL_DENS |
NO | ||
| PRPSL (Oracle) EXPT_SMPL_HIST SMPL_DENS |
NO |
| Sample Density Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Density Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Density Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Density Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |