| Proposal Identifier |
| Base Entity | Experiment Sample |
| Attribute Name | Proposal Identifier |
| Logical Rolename | |
| ColumnName | PRPSL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Proposal Identifier Logical Attribute Properties |
| Logical Attribute Name | Proposal Identifier |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| Proposal Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Proposal Identifier Security Types |
| Name | Current Value |
| Proposal Identifier Bound Attachments |
| Name | Current Value |
| Proposal Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proposal Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Proposal Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL PRPSL_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL PRPSL_ID |
NO |
| Proposal Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number |
| Base Entity | Experiment Sample |
| Attribute Name | Submission Number |
| Logical Rolename | |
| ColumnName | SUBMISS_NBR |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Submission Number Logical Attribute Properties |
| Logical Attribute Name | Submission Number |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Submission Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Submission Number Security Types |
| Name | Current Value |
| Submission Number Bound Attachments |
| Name | Current Value |
| Submission Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Submission Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Submission Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SUBMISS_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SUBMISS_NBR |
NO |
| Submission Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submission Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Identifier |
| Base Entity | Experiment Sample |
| Attribute Name | Sample Identifier |
| Logical Rolename | |
| ColumnName | SMPL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sample Identifier: A sequential numeric identifier for the proposal samples. |
| Note |
| Sample Identifier Logical Attribute Properties |
| Logical Attribute Name | Sample Identifier |
| Datatype | NUMERIC(10, 0) |
| Nullable | NO |
| Sample Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Identifier Security Types |
| Name | Current Value |
| Sample Identifier Bound Attachments |
| Name | Current Value |
| Sample Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Sample Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SMPL_ID |
NO |
| Sample Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Name |
| Base Entity | Experiment Sample |
| Attribute Name | Sample Name |
| Logical Rolename | |
| ColumnName | SMPL_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| 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 Sample Name |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_NM |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Sample Description |
| Logical Rolename | |
| ColumnName | SMPL_DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| 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 Sample Description |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_DESCR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Sample Formula |
| Logical Rolename | |
| ColumnName | SMPL_FMLA |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sample Formula: Any sensible chemical formula. |
| 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 Sample Formula |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_FMLA |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Sample Length |
| Logical Rolename | |
| ColumnName | SMPL_LNGTH |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sample Length: Length of sample in centimeters. |
| Note |
| Sample Length Logical Attribute Properties |
| Logical Attribute Name | Sample Length |
| Datatype | NUMERIC(7, 2) |
| Nullable | YES |
| Sample Length Domain Restrictions |
| CheckConstraint | SMPL_LNGTH > 0 | ||
| Check Constraint Name | CK_SMPL_LNGTH | ||
| 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 Sample Length |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_LNGTH |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Sample Width |
| Logical Rolename | |
| ColumnName | SMPL_WIDTH |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sample Width: Width of sample in centimeters. |
| Note |
| Sample Width Logical Attribute Properties |
| Logical Attribute Name | Sample Width |
| Datatype | NUMERIC(7, 2) |
| Nullable | YES |
| Sample Width Domain Restrictions |
| CheckConstraint | SMPL_WIDTH > 0 | ||
| Check Constraint Name | CK_SMPL_WIDTH | ||
| 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 Sample Width |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_WIDTH |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Sample Height |
| Logical Rolename | |
| ColumnName | SMPL_HGT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sample Height: Height of sample in centimeters. |
| Note |
| Sample Height Logical Attribute Properties |
| Logical Attribute Name | Sample Height |
| Datatype | NUMERIC(7, 2) |
| Nullable | YES |
| Sample Height Domain Restrictions |
| CheckConstraint | SMPL_HGT > 0 | ||
| Check Constraint Name | CK_SMPL_HGT | ||
| 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 Sample Height |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_HGT |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Sample Mass |
| Logical Rolename | |
| ColumnName | SMPL_MASS |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sample Mass: Mass of sample in grams. |
| Note |
| Sample Mass Logical Attribute Properties |
| Logical Attribute Name | Sample Mass |
| Datatype | NUMERIC(14, 4) |
| Nullable | YES |
| Sample Mass Domain Restrictions |
| CheckConstraint | SMPL_MASS > 0 | ||
| Check Constraint Name | CK_SMPL_MASS | ||
| 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 Sample Mass |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_MASS |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Sample Total Number |
| Logical Rolename | |
| ColumnName | SMPL_TOT_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Sample Total Number: Total number of samples for this description. |
| 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 Sample Total Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_TOT_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Equipment |
| Base Entity | Experiment Sample |
| Attribute Name | Equipment |
| Logical Rolename | |
| ColumnName | EQUIP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Equipment: Experimenter supplied equipment or sample environments. |
| 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 Equipment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL EQUIP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Local Equipment |
| Logical Rolename | |
| ColumnName | LOCAL_EQUIP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Local Equipment: On-site equipment needed for the experiment. |
| 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 Local Equipment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL LOCAL_EQUIP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Length Unit Identifier |
| Logical Rolename | |
| ColumnName | LEN_UNIT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| 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 Length Unit Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL LEN_UNIT_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | Mass Unit Identifier |
| Logical Rolename | |
| ColumnName | MASS_UNIT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Mass Unit Identifier: Abbreviated unit of mass. |
| 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 Mass Unit Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL MASS_UNIT_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Attribute Name | State Id |
| Logical Rolename | |
| ColumnName | ST_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | State Identifier: The material state. |
| 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 State Id |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL ST_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Temperature |
| Base Entity | Experiment Sample |
| Attribute Name | Temperature |
| Logical Rolename | |
| ColumnName | TEMP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Temperature: Temperature of which the sample should be mesured. Currently only used by Mail-In BL-11A proposals. |
| Note |
| Temperature Logical Attribute Properties |
| Logical Attribute Name | Temperature |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Temperature Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Temperature Security Types |
| Name | Current Value |
| Temperature Bound Attachments |
| Name | Current Value |
| Temperature Data Movement Rules |
| Name | Type | Rule Text/Value |
| Temperature Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Temperature |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL TEMP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL TEMP |
NO |
| Temperature Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Temperature Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Temperature Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Temperature Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Temperature Unit Identifier |
| Base Entity | Experiment Sample |
| Attribute Name | Temperature Unit Identifier |
| Logical Rolename | |
| ColumnName | TEMP_UNIT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Unit Identifier: Abbreviated unit of mass. |
| Note |
| Temperature Unit Identifier Logical Attribute Properties |
| Logical Attribute Name | Temperature Unit Identifier |
| Datatype | CHAR(1) |
| Nullable | YES |
| Temperature Unit Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Temperature Unit Identifier Security Types |
| Name | Current Value |
| Temperature Unit Identifier Bound Attachments |
| Name | Current Value |
| Temperature Unit Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Temperature Unit Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Temperature Unit Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL TEMP_UNIT_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL TEMP_UNIT_ID |
NO |
| Temperature Unit Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Temperature Unit Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Temperature Unit Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Temperature Unit Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Descriptor Identifier |
| Base Entity | Experiment Sample |
| 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 Sample Descriptor Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_DESC_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 Containment |
| Base Entity | Experiment Sample |
| Attribute Name | Sample Containment |
| Logical Rolename | |
| ColumnName | SMPL_CONTAINMENT |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Containment Logical Attribute Properties |
| Logical Attribute Name | Sample Containment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Sample Containment Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Containment Security Types |
| Name | Current Value |
| Sample Containment Bound Attachments |
| Name | Current Value |
| Sample Containment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Containment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Sample Containment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_CONTAINMENT |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SMPL_CONTAINMENT |
NO |
| Sample Containment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Containment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Containment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Containment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Irradiation History |
| Base Entity | Experiment Sample |
| Attribute Name | Irradiation History |
| Logical Rolename | |
| ColumnName | IRRAD_HIST |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Irradiation History Logical Attribute Properties |
| Logical Attribute Name | Irradiation History |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Irradiation History Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Irradiation History Security Types |
| Name | Current Value |
| Irradiation History Bound Attachments |
| Name | Current Value |
| Irradiation History Data Movement Rules |
| Name | Type | Rule Text/Value |
| Irradiation History Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Irradiation History |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL IRRAD_HIST |
NO | ||
| PRPSL (Oracle) EXPT_SMPL IRRAD_HIST |
NO |
| Irradiation History Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Irradiation History Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Irradiation History Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Irradiation History Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Disposition |
| Base Entity | Experiment Sample |
| Attribute Name | Sample Disposition |
| Logical Rolename | |
| ColumnName | SMPL_DISP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Sample Disposition Logical Attribute Properties |
| Logical Attribute Name | Sample Disposition |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Sample Disposition Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Sample Disposition Security Types |
| Name | Current Value |
| Sample Disposition Bound Attachments |
| Name | Current Value |
| Sample Disposition Data Movement Rules |
| Name | Type | Rule Text/Value |
| Sample Disposition Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Sample Disposition |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_DISP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SMPL_DISP |
NO |
| Sample Disposition Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Disposition Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Disposition Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Disposition Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minor Modification Notes |
| Base Entity | Experiment Sample |
| Attribute Name | Minor Modification Notes |
| Logical Rolename | |
| ColumnName | MIN_MOD_NOTES |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Minor Modification Notes Logical Attribute Properties |
| Logical Attribute Name | Minor Modification Notes |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Minor Modification Notes Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Minor Modification Notes Security Types |
| Name | Current Value |
| Minor Modification Notes Bound Attachments |
| Name | Current Value |
| Minor Modification Notes Data Movement Rules |
| Name | Type | Rule Text/Value |
| Minor Modification Notes Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Minor Modification Notes |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL MIN_MOD_NOTES |
NO | ||
| PRPSL (Oracle) EXPT_SMPL MIN_MOD_NOTES |
NO |
| Minor Modification Notes Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minor Modification Notes Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minor Modification Notes Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minor Modification Notes Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Sample Density |
| Base Entity | Experiment Sample |
| 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 Sample Density |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_DENS |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| Container Identifier |
| Base Entity | Experiment Sample |
| Attribute Name | Container Identifier |
| Logical Rolename | |
| ColumnName | CONT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Container Identifier Logical Attribute Properties |
| Logical Attribute Name | Container Identifier |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Container Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Container Identifier Security Types |
| Name | Current Value |
| Container Identifier Bound Attachments |
| Name | Current Value |
| Container Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Container Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Container Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL CONT_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL CONT_ID |
NO |
| Container Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Container Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Container Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Container Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension A |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension A |
| Logical Rolename | |
| ColumnName | SNGL_CRYST_DIM_A |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension A Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension A |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| Single Crystal Dimension A Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension A Security Types |
| Name | Current Value |
| Single Crystal Dimension A Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension A Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension A Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension A |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SNGL_CRYST_DIM_A |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SNGL_CRYST_DIM_A |
NO |
| Single Crystal Dimension A Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension A Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension A Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension A Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension B |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension B |
| Logical Rolename | |
| ColumnName | SNGL_CRYST_DIM_B |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension B Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension B |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| Single Crystal Dimension B Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension B Security Types |
| Name | Current Value |
| Single Crystal Dimension B Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension B Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension B Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension B |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SNGL_CRYST_DIM_B |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SNGL_CRYST_DIM_B |
NO |
| Single Crystal Dimension B Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension B Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension B Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension B Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension C |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension C |
| Logical Rolename | |
| ColumnName | SNGL_CRYST_DIM_C |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension C Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension C |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| Single Crystal Dimension C Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension C Security Types |
| Name | Current Value |
| Single Crystal Dimension C Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension C Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension C Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension C |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SNGL_CRYST_DIM_C |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SNGL_CRYST_DIM_C |
NO |
| Single Crystal Dimension C Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension C Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension C Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension C Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension V |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension V |
| Logical Rolename | |
| ColumnName | SNGL_CRYST_DIM_V |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension V Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension V |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| Single Crystal Dimension V Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension V Security Types |
| Name | Current Value |
| Single Crystal Dimension V Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension V Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension V Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension V |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SNGL_CRYST_DIM_V |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SNGL_CRYST_DIM_V |
NO |
| Single Crystal Dimension V Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension V Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension V Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension V Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Alpha |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension Alpha |
| Logical Rolename | |
| ColumnName | SNGL_CRYST_DIM_ALPHA |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension Alpha Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension Alpha |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| Single Crystal Dimension Alpha Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension Alpha Security Types |
| Name | Current Value |
| Single Crystal Dimension Alpha Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension Alpha Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension Alpha Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension Alpha |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SNGL_CRYST_DIM_ALPHA |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SNGL_CRYST_DIM_ALPHA |
NO |
| Single Crystal Dimension Alpha Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Alpha Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Alpha Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Alpha Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Beta |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension Beta |
| Logical Rolename | |
| ColumnName | SGNL_CRYST_DIM_BETA |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension Beta Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension Beta |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| Single Crystal Dimension Beta Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension Beta Security Types |
| Name | Current Value |
| Single Crystal Dimension Beta Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension Beta Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension Beta Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension Beta |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SGNL_CRYST_DIM_BETA |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SGNL_CRYST_DIM_BETA |
NO |
| Single Crystal Dimension Beta Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Beta Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Beta Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Beta Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Gamma |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension Gamma |
| Logical Rolename | |
| ColumnName | SGNL_CRYST_DIM_GAMMA |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension Gamma Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension Gamma |
| Datatype | NUMERIC(10, 2) |
| Nullable | YES |
| Single Crystal Dimension Gamma Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension Gamma Security Types |
| Name | Current Value |
| Single Crystal Dimension Gamma Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension Gamma Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension Gamma Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension Gamma |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SGNL_CRYST_DIM_GAMMA |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SGNL_CRYST_DIM_GAMMA |
NO |
| Single Crystal Dimension Gamma Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Gamma Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Gamma Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Gamma Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Space Group |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Dimension Space Group |
| Logical Rolename | |
| ColumnName | SGNL_CRYST_DIM_SP_GRP |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Dimension Space Group Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Dimension Space Group |
| Datatype | VARCHAR(8) |
| Nullable | YES |
| Single Crystal Dimension Space Group Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Dimension Space Group Security Types |
| Name | Current Value |
| Single Crystal Dimension Space Group Bound Attachments |
| Name | Current Value |
| Single Crystal Dimension Space Group Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Dimension Space Group Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Dimension Space Group |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SGNL_CRYST_DIM_SP_GRP |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SGNL_CRYST_DIM_SP_GRP |
NO |
| Single Crystal Dimension Space Group Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Space Group Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Space Group Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Dimension Space Group Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date |
| Base Entity | Experiment Sample |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Modify Date Logical Attribute Properties |
| Logical Attribute Name | Modify Date |
| Datatype | DATE |
| Nullable | YES |
| Modify Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | SYSDATE |
| Bound Default |
| Modify Date Security Types |
| Name | Current Value |
| Modify Date Bound Attachments |
| Name | Current Value |
| Modify Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modify Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Modify Date |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL MOD_DTE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL MOD_DTE |
NO |
| Modify Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Confirm Date |
| Base Entity | Experiment Sample |
| Attribute Name | Confirm Date |
| Logical Rolename | |
| ColumnName | CONFIRM_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | |
| Note |
| Confirm Date Logical Attribute Properties |
| Logical Attribute Name | Confirm Date |
| Datatype | DATE |
| Nullable | YES |
| Confirm Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Confirm Date Security Types |
| Name | Current Value |
| Confirm Date Bound Attachments |
| Name | Current Value |
| Confirm Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Confirm Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Confirm Date |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL CONFIRM_DTE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL CONFIRM_DTE |
NO |
| Confirm Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Confirm Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Confirm Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Confirm Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Neutron Beam Indicator |
| Base Entity | Experiment Sample |
| Attribute Name | Neutron Beam Indicator |
| Logical Rolename | |
| ColumnName | NEUTRON_BEAM_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Neutron Beam Indicator Logical Attribute Properties |
| Logical Attribute Name | Neutron Beam Indicator |
| Datatype | CHAR(1) |
| Nullable | YES |
| Neutron Beam Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Neutron Beam 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 |
| Neutron Beam Indicator Security Types |
| Name | Current Value |
| Neutron Beam Indicator Bound Attachments |
| Name | Current Value |
| Neutron Beam Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Neutron Beam Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Neutron Beam Indicator |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL NEUTRON_BEAM_IND |
NO | ||
| PRPSL (Oracle) EXPT_SMPL NEUTRON_BEAM_IND |
NO |
| Neutron Beam Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Neutron Beam Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Neutron Beam Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Neutron Beam Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Comment |
| Base Entity | Experiment Sample |
| Attribute Name | Justification Comment |
| Logical Rolename | |
| ColumnName | JUST_CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | |
| Note |
| Justification Comment Logical Attribute Properties |
| Logical Attribute Name | Justification Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Justification Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Justification Comment Security Types |
| Name | Current Value |
| Justification Comment Bound Attachments |
| Name | Current Value |
| Justification Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Justification Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Justification Comment |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL JUST_CMNT |
NO | ||
| PRPSL (Oracle) EXPT_SMPL JUST_CMNT |
NO |
| Justification Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Justification Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Atom Unit Number |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Atom Unit Number |
| Logical Rolename | |
| ColumnName | SGNL_CRYST_ATOM_UNIT_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Atom Unit Number Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Atom Unit Number |
| Datatype | INTEGER |
| Nullable | YES |
| Single Crystal Atom Unit Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Single Crystal Atom Unit Number Security Types |
| Name | Current Value |
| Single Crystal Atom Unit Number Bound Attachments |
| Name | Current Value |
| Single Crystal Atom Unit Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Atom Unit Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Atom Unit Number |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SGNL_CRYST_ATOM_UNIT_NBR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SGNL_CRYST_ATOM_UNIT_NBR |
NO |
| Single Crystal Atom Unit Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Atom Unit Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Atom Unit Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Atom Unit Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Skip Indicator |
| Base Entity | Experiment Sample |
| Attribute Name | Single Crystal Skip Indicator |
| Logical Rolename | |
| ColumnName | SNGL_CRYST_SKIP_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Single Crystal Skip Indicator Logical Attribute Properties |
| Logical Attribute Name | Single Crystal Skip Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Single Crystal Skip Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Single Crystal Skip 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 |
| Single Crystal Skip Indicator Security Types |
| Name | Current Value |
| Single Crystal Skip Indicator Bound Attachments |
| Name | Current Value |
| Single Crystal Skip Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Single Crystal Skip Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Single Crystal Skip Indicator |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SNGL_CRYST_SKIP_IND |
NO | ||
| PRPSL (Oracle) EXPT_SMPL SNGL_CRYST_SKIP_IND |
NO |
| Single Crystal Skip Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Skip Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Skip Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Single Crystal Skip Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Approve Identifer |
| Base Entity | Experiment Sample |
| Attribute Name | Approve Identifer |
| Logical Rolename | |
| ColumnName | APPRV_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Approve Identifer Logical Attribute Properties |
| Logical Attribute Name | Approve Identifer |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Approve Identifer Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Approve Identifer Security Types |
| Name | Current Value |
| Approve Identifer Bound Attachments |
| Name | Current Value |
| Approve Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Approve Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Approve Identifer |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL APPRV_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL APPRV_ID |
NO |
| Approve Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Approve Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Approve Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Approve Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Thin Film Shape and Surface |
| Base Entity | Experiment Sample |
| Attribute Name | Thin Film Shape and Surface |
| Logical Rolename | |
| ColumnName | THIN_FILM_SHAPE_SURF |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Thin Film Shape and Surface Logical Attribute Properties |
| Logical Attribute Name | Thin Film Shape and Surface |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| Thin Film Shape and Surface Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Thin Film Shape and Surface Security Types |
| Name | Current Value |
| Thin Film Shape and Surface Bound Attachments |
| Name | Current Value |
| Thin Film Shape and Surface Data Movement Rules |
| Name | Type | Rule Text/Value |
| Thin Film Shape and Surface Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Thin Film Shape and Surface |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL THIN_FILM_SHAPE_SURF |
NO | ||
| PRPSL (Oracle) EXPT_SMPL THIN_FILM_SHAPE_SURF |
NO |
| Thin Film Shape and Surface Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Thin Film Shape and Surface Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Thin Film Shape and Surface Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Thin Film Shape and Surface Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delete Indicator |
| Base Entity | Experiment Sample |
| Attribute Name | Delete Indicator |
| Logical Rolename | |
| ColumnName | DEL_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Delete Indicator Logical Attribute Properties |
| Logical Attribute Name | Delete Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Delete Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Delete 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 |
| Delete Indicator Security Types |
| Name | Current Value |
| Delete Indicator Bound Attachments |
| Name | Current Value |
| Delete Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Delete Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Delete Indicator |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL DEL_IND |
NO | ||
| PRPSL (Oracle) EXPT_SMPL DEL_IND |
NO |
| Delete Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delete Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delete Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Delete Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Exist Indicator |
| Base Entity | Experiment Sample |
| Attribute Name | Crystal Exist Indicator |
| Logical Rolename | |
| ColumnName | CRYST_EXIST_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Crystal Exist Indicator Logical Attribute Properties |
| Logical Attribute Name | Crystal Exist Indicator |
| Datatype | CHAR(1) |
| Nullable | YES |
| Crystal Exist Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Crystal Exist 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 |
| Crystal Exist Indicator Security Types |
| Name | Current Value |
| Crystal Exist Indicator Bound Attachments |
| Name | Current Value |
| Crystal Exist Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Crystal Exist Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Crystal Exist Indicator |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL CRYST_EXIST_IND |
NO | ||
| PRPSL (Oracle) EXPT_SMPL CRYST_EXIST_IND |
NO |
| Crystal Exist Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Exist Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Exist Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Exist Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Alignment Needed Indicator |
| Base Entity | Experiment Sample |
| Attribute Name | Crystal Alignment Needed Indicator |
| Logical Rolename | |
| ColumnName | CRYST_ALIGN_NEED_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Crystal Alignment Needed Indicator Logical Attribute Properties |
| Logical Attribute Name | Crystal Alignment Needed Indicator |
| Datatype | CHAR(1) |
| Nullable | YES |
| Crystal Alignment Needed Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Crystal Alignment Needed 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 |
| Crystal Alignment Needed Indicator Security Types |
| Name | Current Value |
| Crystal Alignment Needed Indicator Bound Attachments |
| Name | Current Value |
| Crystal Alignment Needed Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Crystal Alignment Needed Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Crystal Alignment Needed Indicator |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL CRYST_ALIGN_NEED_IND |
NO | ||
| PRPSL (Oracle) EXPT_SMPL CRYST_ALIGN_NEED_IND |
NO |
| Crystal Alignment Needed Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Alignment Needed Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Alignment Needed Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Crystal Alignment Needed Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Minimum |
| Base Entity | Experiment Sample |
| Attribute Name | Data Minimum |
| Logical Rolename | |
| ColumnName | DATA_MIN |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Data Miniimum: The low value of the data values to be captured on the sample. (Currently used only for BL-11A Mail-In) |
| Note |
| Data Minimum Logical Attribute Properties |
| Logical Attribute Name | Data Minimum |
| Datatype | NUMERIC(38, 2) |
| Nullable | YES |
| Data Minimum Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Data Minimum Security Types |
| Name | Current Value |
| Data Minimum Bound Attachments |
| Name | Current Value |
| Data Minimum Data Movement Rules |
| Name | Type | Rule Text/Value |
| Data Minimum Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Data Minimum |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL DATA_MIN |
NO | ||
| PRPSL (Oracle) EXPT_SMPL DATA_MIN |
NO |
| Data Minimum Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Minimum Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Minimum Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Minimum Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Maximum |
| Base Entity | Experiment Sample |
| Attribute Name | Data Maximum |
| Logical Rolename | |
| ColumnName | DATA_MAX |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Data Maximum: The high value of the data values to be captured on the sample. (Currently used only for BL-11A Mail-In) |
| Note |
| Data Maximum Logical Attribute Properties |
| Logical Attribute Name | Data Maximum |
| Datatype | NUMERIC(38, 2) |
| Nullable | YES |
| Data Maximum Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Data Maximum Security Types |
| Name | Current Value |
| Data Maximum Bound Attachments |
| Name | Current Value |
| Data Maximum Data Movement Rules |
| Name | Type | Rule Text/Value |
| Data Maximum Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Data Maximum |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL DATA_MAX |
NO | ||
| PRPSL (Oracle) EXPT_SMPL DATA_MAX |
NO |
| Data Maximum Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Maximum Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Maximum Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Data Maximum Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Can Size |
| Base Entity | Experiment Sample |
| Attribute Name | Can Size |
| Logical Rolename | |
| ColumnName | CAN_SIZE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Can Size: The size of can requested for BL-11A Mail-In proposals. |
| Note |
| Can Size Logical Attribute Properties |
| Logical Attribute Name | Can Size |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Can Size Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Can Size Security Types |
| Name | Current Value |
| Can Size Bound Attachments |
| Name | Current Value |
| Can Size Data Movement Rules |
| Name | Type | Rule Text/Value |
| Can Size Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Can Size |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL CAN_SIZE |
NO | ||
| PRPSL (Oracle) EXPT_SMPL CAN_SIZE |
NO |
| Can Size Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Can Size Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Can Size Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Can Size Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Return Shipping Address |
| Base Entity | Experiment Sample |
| Attribute Name | Return Shipping Address |
| Logical Rolename | |
| ColumnName | RET_SHIP_ADDR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Return Shipping Address: The sample return shipping address for mail-in proposals. |
| Note |
| Return Shipping Address Logical Attribute Properties |
| Logical Attribute Name | Return Shipping Address |
| Datatype | VARCHAR(1000) |
| Nullable | YES |
| Return Shipping Address Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Return Shipping Address Security Types |
| Name | Current Value |
| Return Shipping Address Bound Attachments |
| Name | Current Value |
| Return Shipping Address Data Movement Rules |
| Name | Type | Rule Text/Value |
| Return Shipping Address Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Sample Return Shipping Address |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL RET_SHIP_ADDR |
NO | ||
| PRPSL (Oracle) EXPT_SMPL RET_SHIP_ADDR |
NO |
| Return Shipping Address Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Return Shipping Address Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Return Shipping Address Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Return Shipping Address Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |