| PRPSL_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Proposal Identifier |
| ColumnName | PRPSL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PRPSL_ID Column Properties |
| Datatype | NUMBER(10, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PRPSL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| 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 Proposal Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL PRPSL_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| SUBMISS_NBR |
| Base Object | EXPT_SMPL |
| Attribute Name | Submission Number |
| ColumnName | SUBMISS_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SUBMISS_NBR Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBMISS_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SUBMISS_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SUBMISS_NBR Security Types |
| Name | Current Value |
| SUBMISS_NBR Bound Attachments |
| Name | Current Value |
| SUBMISS_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBMISS_NBR 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 |
| SUBMISS_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBMISS_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBMISS_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBMISS_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Identifier |
| ColumnName | SMPL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sample Identifier: A sequential numeric identifier for the proposal samples. |
| Note |
| SMPL_ID Column Properties |
| Datatype | NUMBER(10, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| 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 Sample Identifier |
NO | ||
| IPTSv5 (Oracle) EXPT_SMPL SMPL_ID |
NO | ||
| PRPSL (Oracle) EXPT_SMPL 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 |
| SMPL_NM |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Name |
| ColumnName | SMPL_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| SMPL_NM Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| SMPL_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_NM Security Types |
| Name | Current Value |
| SMPL_NM Bound Attachments |
| Name | Current Value |
| SMPL_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_NM 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 |
| SMPL_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESCR |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Description |
| ColumnName | SMPL_DESCR |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| SMPL_DESCR Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_DESCR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| SMPL_DESCR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_DESCR Security Types |
| Name | Current Value |
| SMPL_DESCR Bound Attachments |
| Name | Current Value |
| SMPL_DESCR Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_DESCR 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 |
| SMPL_DESCR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESCR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESCR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESCR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_FMLA |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Formula |
| ColumnName | SMPL_FMLA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sample Formula: Any sensible chemical formula. |
| Note |
| SMPL_FMLA Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_FMLA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| SMPL_FMLA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_FMLA Security Types |
| Name | Current Value |
| SMPL_FMLA Bound Attachments |
| Name | Current Value |
| SMPL_FMLA Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_FMLA 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 |
| SMPL_FMLA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_FMLA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_FMLA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_FMLA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_LNGTH |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Length |
| ColumnName | SMPL_LNGTH |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sample Length: Length of sample in centimeters. |
| Note |
| SMPL_LNGTH Column Properties |
| Datatype | NUMBER(7, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_LNGTH Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SMPL_LNGTH Domain Restrictions |
| CheckConstraint | SMPL_LNGTH > 0 |
| Check Constraint Name | CK_SMPL_LNGTH |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_LNGTH Security Types |
| Name | Current Value |
| SMPL_LNGTH Bound Attachments |
| Name | Current Value |
| SMPL_LNGTH Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_LNGTH 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 |
| SMPL_LNGTH Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_LNGTH Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_LNGTH Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_LNGTH Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_WIDTH |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Width |
| ColumnName | SMPL_WIDTH |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sample Width: Width of sample in centimeters. |
| Note |
| SMPL_WIDTH Column Properties |
| Datatype | NUMBER(7, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_WIDTH Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SMPL_WIDTH Domain Restrictions |
| CheckConstraint | SMPL_WIDTH > 0 |
| Check Constraint Name | CK_SMPL_WIDTH |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_WIDTH Security Types |
| Name | Current Value |
| SMPL_WIDTH Bound Attachments |
| Name | Current Value |
| SMPL_WIDTH Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_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 |
| SMPL_WIDTH Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_WIDTH Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_WIDTH Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_WIDTH Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_HGT |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Height |
| ColumnName | SMPL_HGT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sample Height: Height of sample in centimeters. |
| Note |
| SMPL_HGT Column Properties |
| Datatype | NUMBER(7, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_HGT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SMPL_HGT Domain Restrictions |
| CheckConstraint | SMPL_HGT > 0 |
| Check Constraint Name | CK_SMPL_HGT |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_HGT Security Types |
| Name | Current Value |
| SMPL_HGT Bound Attachments |
| Name | Current Value |
| SMPL_HGT Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_HGT 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 |
| SMPL_HGT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_HGT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_HGT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_HGT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_MASS |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Mass |
| ColumnName | SMPL_MASS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sample Mass: Mass of sample in grams. |
| Note |
| SMPL_MASS Column Properties |
| Datatype | NUMBER(14, 4) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_MASS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| SMPL_MASS Domain Restrictions |
| CheckConstraint | SMPL_MASS > 0 |
| Check Constraint Name | CK_SMPL_MASS |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_MASS Security Types |
| Name | Current Value |
| SMPL_MASS Bound Attachments |
| Name | Current Value |
| SMPL_MASS Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_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 |
| SMPL_MASS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_MASS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_MASS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_MASS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TOT_NBR |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Total Number |
| ColumnName | SMPL_TOT_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Sample Total Number: Total number of samples for this description. |
| Note |
| SMPL_TOT_NBR Column Properties |
| Datatype | NUMBER(5, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_TOT_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| SMPL_TOT_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_TOT_NBR Security Types |
| Name | Current Value |
| SMPL_TOT_NBR Bound Attachments |
| Name | Current Value |
| SMPL_TOT_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_TOT_NBR 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 |
| SMPL_TOT_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TOT_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TOT_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TOT_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP |
| Base Object | EXPT_SMPL |
| Attribute Name | Equipment |
| ColumnName | EQUIP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Equipment: Experimenter supplied equipment or sample environments. |
| Note |
| EQUIP Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EQUIP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| EQUIP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EQUIP Security Types |
| Name | Current Value |
| EQUIP Bound Attachments |
| Name | Current Value |
| EQUIP Data Movement Rules |
| Name | Type | Rule Text/Value |
| EQUIP 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 |
| EQUIP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_EQUIP |
| Base Object | EXPT_SMPL |
| Attribute Name | Local Equipment |
| ColumnName | LOCAL_EQUIP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Local Equipment: On-site equipment needed for the experiment. |
| Note |
| LOCAL_EQUIP Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LOCAL_EQUIP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| LOCAL_EQUIP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LOCAL_EQUIP Security Types |
| Name | Current Value |
| LOCAL_EQUIP Bound Attachments |
| Name | Current Value |
| LOCAL_EQUIP Data Movement Rules |
| Name | Type | Rule Text/Value |
| LOCAL_EQUIP 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_EQUIP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_EQUIP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_EQUIP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LOCAL_EQUIP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LEN_UNIT_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Length Unit Identifier |
| ColumnName | LEN_UNIT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Length Unit Identifier: Abbreviated unit of length. |
| Note |
| LEN_UNIT_ID Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LEN_UNIT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| LEN_UNIT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LEN_UNIT_ID Security Types |
| Name | Current Value |
| LEN_UNIT_ID Bound Attachments |
| Name | Current Value |
| LEN_UNIT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| LEN_UNIT_ID 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 |
| LEN_UNIT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LEN_UNIT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LEN_UNIT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LEN_UNIT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MASS_UNIT_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Mass Unit Identifier |
| ColumnName | MASS_UNIT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Mass Unit Identifier: Abbreviated unit of mass. |
| Note |
| MASS_UNIT_ID Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MASS_UNIT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| MASS_UNIT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MASS_UNIT_ID Security Types |
| Name | Current Value |
| MASS_UNIT_ID Bound Attachments |
| Name | Current Value |
| MASS_UNIT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MASS_UNIT_ID 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_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MASS_UNIT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MASS_UNIT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MASS_UNIT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | State Id |
| ColumnName | ST_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | State Identifier: The material state. |
| Note |
| ST_ID Column Properties |
| Datatype | VARCHAR2(6) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ST_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| ST_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ST_ID Security Types |
| Name | Current Value |
| ST_ID Bound Attachments |
| Name | Current Value |
| ST_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| ST_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 |
| ST_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP |
| Base Object | EXPT_SMPL |
| Attribute Name | Temperature |
| ColumnName | TEMP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Temperature: Temperature of which the sample should be mesured. Currently only used by Mail-In BL-11A proposals. |
| Note |
| TEMP Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| TEMP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP Security Types |
| Name | Current Value |
| TEMP Bound Attachments |
| Name | Current Value |
| TEMP Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP 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 |
| TEMP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Temperature Unit Identifier |
| ColumnName | TEMP_UNIT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Unit Identifier: Abbreviated unit of mass. |
| Note |
| TEMP_UNIT_ID Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TEMP_UNIT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| TEMP_UNIT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TEMP_UNIT_ID Security Types |
| Name | Current Value |
| TEMP_UNIT_ID Bound Attachments |
| Name | Current Value |
| TEMP_UNIT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| TEMP_UNIT_ID 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 |
| TEMP_UNIT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TEMP_UNIT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESC_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Descriptor Identifier |
| ColumnName | SMPL_DESC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_DESC_ID Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_DESC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| SMPL_DESC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_DESC_ID Security Types |
| Name | Current Value |
| SMPL_DESC_ID Bound Attachments |
| Name | Current Value |
| SMPL_DESC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_DESC_ID 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 |
| SMPL_DESC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DESC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_CONTAINMENT |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Containment |
| ColumnName | SMPL_CONTAINMENT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_CONTAINMENT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_CONTAINMENT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| SMPL_CONTAINMENT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_CONTAINMENT Security Types |
| Name | Current Value |
| SMPL_CONTAINMENT Bound Attachments |
| Name | Current Value |
| SMPL_CONTAINMENT Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_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 |
| SMPL_CONTAINMENT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_CONTAINMENT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_CONTAINMENT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_CONTAINMENT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IRRAD_HIST |
| Base Object | EXPT_SMPL |
| Attribute Name | Irradiation History |
| ColumnName | IRRAD_HIST |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| IRRAD_HIST Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| IRRAD_HIST Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| IRRAD_HIST Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IRRAD_HIST Security Types |
| Name | Current Value |
| IRRAD_HIST Bound Attachments |
| Name | Current Value |
| IRRAD_HIST Data Movement Rules |
| Name | Type | Rule Text/Value |
| IRRAD_HIST 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 |
| IRRAD_HIST Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IRRAD_HIST Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IRRAD_HIST Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IRRAD_HIST Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DISP |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Disposition |
| ColumnName | SMPL_DISP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_DISP Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_DISP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| SMPL_DISP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_DISP Security Types |
| Name | Current Value |
| SMPL_DISP Bound Attachments |
| Name | Current Value |
| SMPL_DISP Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_DISP 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 |
| SMPL_DISP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DISP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DISP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DISP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIN_MOD_NOTES |
| Base Object | EXPT_SMPL |
| Attribute Name | Minor Modification Notes |
| ColumnName | MIN_MOD_NOTES |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| MIN_MOD_NOTES Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MIN_MOD_NOTES Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| MIN_MOD_NOTES Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MIN_MOD_NOTES Security Types |
| Name | Current Value |
| MIN_MOD_NOTES Bound Attachments |
| Name | Current Value |
| MIN_MOD_NOTES Data Movement Rules |
| Name | Type | Rule Text/Value |
| MIN_MOD_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 |
| MIN_MOD_NOTES Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIN_MOD_NOTES Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIN_MOD_NOTES Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIN_MOD_NOTES Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DENS |
| Base Object | EXPT_SMPL |
| Attribute Name | Sample Density |
| ColumnName | SMPL_DENS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_DENS Column Properties |
| Datatype | NUMBER(7, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_DENS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SMPL_DENS Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_DENS Security Types |
| Name | Current Value |
| SMPL_DENS Bound Attachments |
| Name | Current Value |
| SMPL_DENS Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_DENS 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 |
| SMPL_DENS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DENS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DENS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DENS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONT_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Container Identifier |
| ColumnName | CONT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| CONT_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CONT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| CONT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CONT_ID Security Types |
| Name | Current Value |
| CONT_ID Bound Attachments |
| Name | Current Value |
| CONT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CONT_ID 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 |
| CONT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_A |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension A |
| ColumnName | SNGL_CRYST_DIM_A |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SNGL_CRYST_DIM_A Column Properties |
| Datatype | NUMBER(10, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNGL_CRYST_DIM_A Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SNGL_CRYST_DIM_A Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNGL_CRYST_DIM_A Security Types |
| Name | Current Value |
| SNGL_CRYST_DIM_A Bound Attachments |
| Name | Current Value |
| SNGL_CRYST_DIM_A Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNGL_CRYST_DIM_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 |
| SNGL_CRYST_DIM_A Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_A Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_A Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_A Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_B |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension B |
| ColumnName | SNGL_CRYST_DIM_B |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SNGL_CRYST_DIM_B Column Properties |
| Datatype | NUMBER(10, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNGL_CRYST_DIM_B Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SNGL_CRYST_DIM_B Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNGL_CRYST_DIM_B Security Types |
| Name | Current Value |
| SNGL_CRYST_DIM_B Bound Attachments |
| Name | Current Value |
| SNGL_CRYST_DIM_B Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNGL_CRYST_DIM_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 |
| SNGL_CRYST_DIM_B Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_B Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_B Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_B Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_C |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension C |
| ColumnName | SNGL_CRYST_DIM_C |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SNGL_CRYST_DIM_C Column Properties |
| Datatype | NUMBER(10, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNGL_CRYST_DIM_C Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SNGL_CRYST_DIM_C Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNGL_CRYST_DIM_C Security Types |
| Name | Current Value |
| SNGL_CRYST_DIM_C Bound Attachments |
| Name | Current Value |
| SNGL_CRYST_DIM_C Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNGL_CRYST_DIM_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 |
| SNGL_CRYST_DIM_C Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_C Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_C Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_C Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_V |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension V |
| ColumnName | SNGL_CRYST_DIM_V |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SNGL_CRYST_DIM_V Column Properties |
| Datatype | NUMBER(10, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNGL_CRYST_DIM_V Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SNGL_CRYST_DIM_V Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNGL_CRYST_DIM_V Security Types |
| Name | Current Value |
| SNGL_CRYST_DIM_V Bound Attachments |
| Name | Current Value |
| SNGL_CRYST_DIM_V Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNGL_CRYST_DIM_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 |
| SNGL_CRYST_DIM_V Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_V Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_V Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_V Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_ALPHA |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension Alpha |
| ColumnName | SNGL_CRYST_DIM_ALPHA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SNGL_CRYST_DIM_ALPHA Column Properties |
| Datatype | NUMBER(10, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNGL_CRYST_DIM_ALPHA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SNGL_CRYST_DIM_ALPHA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SNGL_CRYST_DIM_ALPHA Security Types |
| Name | Current Value |
| SNGL_CRYST_DIM_ALPHA Bound Attachments |
| Name | Current Value |
| SNGL_CRYST_DIM_ALPHA Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNGL_CRYST_DIM_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 |
| SNGL_CRYST_DIM_ALPHA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_ALPHA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_ALPHA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_DIM_ALPHA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_BETA |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension Beta |
| ColumnName | SGNL_CRYST_DIM_BETA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SGNL_CRYST_DIM_BETA Column Properties |
| Datatype | NUMBER(10, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_CRYST_DIM_BETA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SGNL_CRYST_DIM_BETA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_CRYST_DIM_BETA Security Types |
| Name | Current Value |
| SGNL_CRYST_DIM_BETA Bound Attachments |
| Name | Current Value |
| SGNL_CRYST_DIM_BETA Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_CRYST_DIM_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 |
| SGNL_CRYST_DIM_BETA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_BETA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_BETA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_BETA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_GAMMA |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension Gamma |
| ColumnName | SGNL_CRYST_DIM_GAMMA |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SGNL_CRYST_DIM_GAMMA Column Properties |
| Datatype | NUMBER(10, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_CRYST_DIM_GAMMA Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| SGNL_CRYST_DIM_GAMMA Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_CRYST_DIM_GAMMA Security Types |
| Name | Current Value |
| SGNL_CRYST_DIM_GAMMA Bound Attachments |
| Name | Current Value |
| SGNL_CRYST_DIM_GAMMA Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_CRYST_DIM_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 |
| SGNL_CRYST_DIM_GAMMA Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_GAMMA Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_GAMMA Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_GAMMA Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_SP_GRP |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Dimension Space Group |
| ColumnName | SGNL_CRYST_DIM_SP_GRP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SGNL_CRYST_DIM_SP_GRP Column Properties |
| Datatype | VARCHAR2(8) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_CRYST_DIM_SP_GRP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| SGNL_CRYST_DIM_SP_GRP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_CRYST_DIM_SP_GRP Security Types |
| Name | Current Value |
| SGNL_CRYST_DIM_SP_GRP Bound Attachments |
| Name | Current Value |
| SGNL_CRYST_DIM_SP_GRP Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_CRYST_DIM_SP_GRP 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 |
| SGNL_CRYST_DIM_SP_GRP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_SP_GRP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_SP_GRP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_DIM_SP_GRP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE |
| Base Object | EXPT_SMPL |
| Attribute Name | Modify Date |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| MOD_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | SYSDATE |
| Bound Default |
| MOD_DTE Security Types |
| Name | Current Value |
| MOD_DTE Bound Attachments |
| Name | Current Value |
| MOD_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_DTE 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 |
| MOD_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONFIRM_DTE |
| Base Object | EXPT_SMPL |
| Attribute Name | Confirm Date |
| ColumnName | CONFIRM_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | |
| Note |
| CONFIRM_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CONFIRM_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| CONFIRM_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CONFIRM_DTE Security Types |
| Name | Current Value |
| CONFIRM_DTE Bound Attachments |
| Name | Current Value |
| CONFIRM_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| CONFIRM_DTE 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_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONFIRM_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONFIRM_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CONFIRM_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEUTRON_BEAM_IND |
| Base Object | EXPT_SMPL |
| Attribute Name | Neutron Beam Indicator |
| ColumnName | NEUTRON_BEAM_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| NEUTRON_BEAM_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NEUTRON_BEAM_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| NEUTRON_BEAM_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NEUTRON_BEAM_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| NEUTRON_BEAM_IND Security Types |
| Name | Current Value |
| NEUTRON_BEAM_IND Bound Attachments |
| Name | Current Value |
| NEUTRON_BEAM_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| NEUTRON_BEAM_IND 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_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEUTRON_BEAM_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEUTRON_BEAM_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NEUTRON_BEAM_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| JUST_CMNT |
| Base Object | EXPT_SMPL |
| Attribute Name | Justification Comment |
| ColumnName | JUST_CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | |
| Note |
| JUST_CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| JUST_CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| JUST_CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| JUST_CMNT Security Types |
| Name | Current Value |
| JUST_CMNT Bound Attachments |
| Name | Current Value |
| JUST_CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| JUST_CMNT 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 |
| JUST_CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| JUST_CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| JUST_CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| JUST_CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_ATOM_UNIT_NBR |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Atom Unit Number |
| ColumnName | SGNL_CRYST_ATOM_UNIT_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SGNL_CRYST_ATOM_UNIT_NBR Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SGNL_CRYST_ATOM_UNIT_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SGNL_CRYST_ATOM_UNIT_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SGNL_CRYST_ATOM_UNIT_NBR Security Types |
| Name | Current Value |
| SGNL_CRYST_ATOM_UNIT_NBR Bound Attachments |
| Name | Current Value |
| SGNL_CRYST_ATOM_UNIT_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| SGNL_CRYST_ATOM_UNIT_NBR 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 |
| SGNL_CRYST_ATOM_UNIT_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_ATOM_UNIT_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_ATOM_UNIT_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SGNL_CRYST_ATOM_UNIT_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_SKIP_IND |
| Base Object | EXPT_SMPL |
| Attribute Name | Single Crystal Skip Indicator |
| ColumnName | SNGL_CRYST_SKIP_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| SNGL_CRYST_SKIP_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SNGL_CRYST_SKIP_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SNGL_CRYST_SKIP_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| SNGL_CRYST_SKIP_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| SNGL_CRYST_SKIP_IND Security Types |
| Name | Current Value |
| SNGL_CRYST_SKIP_IND Bound Attachments |
| Name | Current Value |
| SNGL_CRYST_SKIP_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SNGL_CRYST_SKIP_IND 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 |
| SNGL_CRYST_SKIP_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_SKIP_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_SKIP_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SNGL_CRYST_SKIP_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_ID |
| Base Object | EXPT_SMPL |
| Attribute Name | Approve Identifer |
| ColumnName | APPRV_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| APPRV_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| APPRV_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| APPRV_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| APPRV_ID Security Types |
| Name | Current Value |
| APPRV_ID Bound Attachments |
| Name | Current Value |
| APPRV_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| APPRV_ID 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 |
| APPRV_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| APPRV_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| THIN_FILM_SHAPE_SURF |
| Base Object | EXPT_SMPL |
| Attribute Name | Thin Film Shape and Surface |
| ColumnName | THIN_FILM_SHAPE_SURF |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| THIN_FILM_SHAPE_SURF Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| THIN_FILM_SHAPE_SURF Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| THIN_FILM_SHAPE_SURF Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| THIN_FILM_SHAPE_SURF Security Types |
| Name | Current Value |
| THIN_FILM_SHAPE_SURF Bound Attachments |
| Name | Current Value |
| THIN_FILM_SHAPE_SURF Data Movement Rules |
| Name | Type | Rule Text/Value |
| THIN_FILM_SHAPE_SURF 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_SURF Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| THIN_FILM_SHAPE_SURF Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| THIN_FILM_SHAPE_SURF Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| THIN_FILM_SHAPE_SURF Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEL_IND |
| Base Object | EXPT_SMPL |
| Attribute Name | Delete Indicator |
| ColumnName | DEL_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| DEL_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DEL_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| DEL_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| DEL_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| DEL_IND Security Types |
| Name | Current Value |
| DEL_IND Bound Attachments |
| Name | Current Value |
| DEL_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| DEL_IND 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 |
| DEL_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEL_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEL_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DEL_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_EXIST_IND |
| Base Object | EXPT_SMPL |
| Attribute Name | Crystal Exist Indicator |
| ColumnName | CRYST_EXIST_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| CRYST_EXIST_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CRYST_EXIST_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| CRYST_EXIST_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CRYST_EXIST_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| CRYST_EXIST_IND Security Types |
| Name | Current Value |
| CRYST_EXIST_IND Bound Attachments |
| Name | Current Value |
| CRYST_EXIST_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| CRYST_EXIST_IND 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 |
| CRYST_EXIST_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_EXIST_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_EXIST_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_EXIST_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_ALIGN_NEED_IND |
| Base Object | EXPT_SMPL |
| Attribute Name | Crystal Alignment Needed Indicator |
| ColumnName | CRYST_ALIGN_NEED_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| CRYST_ALIGN_NEED_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CRYST_ALIGN_NEED_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| CRYST_ALIGN_NEED_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| CRYST_ALIGN_NEED_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| CRYST_ALIGN_NEED_IND Security Types |
| Name | Current Value |
| CRYST_ALIGN_NEED_IND Bound Attachments |
| Name | Current Value |
| CRYST_ALIGN_NEED_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| CRYST_ALIGN_NEED_IND 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 |
| CRYST_ALIGN_NEED_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_ALIGN_NEED_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_ALIGN_NEED_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CRYST_ALIGN_NEED_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MIN |
| Base Object | EXPT_SMPL |
| Attribute Name | Data Minimum |
| ColumnName | DATA_MIN |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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_MIN Column Properties |
| Datatype | NUMBER(38, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DATA_MIN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| DATA_MIN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DATA_MIN Security Types |
| Name | Current Value |
| DATA_MIN Bound Attachments |
| Name | Current Value |
| DATA_MIN Data Movement Rules |
| Name | Type | Rule Text/Value |
| DATA_MIN 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_MIN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MIN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MIN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MIN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MAX |
| Base Object | EXPT_SMPL |
| Attribute Name | Data Maximum |
| ColumnName | DATA_MAX |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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_MAX Column Properties |
| Datatype | NUMBER(38, 2) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DATA_MAX Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| DATA_MAX Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DATA_MAX Security Types |
| Name | Current Value |
| DATA_MAX Bound Attachments |
| Name | Current Value |
| DATA_MAX Data Movement Rules |
| Name | Type | Rule Text/Value |
| DATA_MAX 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_MAX Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MAX Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MAX Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DATA_MAX Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAN_SIZE |
| Base Object | EXPT_SMPL |
| Attribute Name | Can Size |
| ColumnName | CAN_SIZE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Can Size: The size of can requested for BL-11A Mail-In proposals. |
| Note |
| CAN_SIZE Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CAN_SIZE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| 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 |
| RET_SHIP_ADDR |
| Base Object | EXPT_SMPL |
| Attribute Name | Return Shipping Address |
| ColumnName | RET_SHIP_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Return Shipping Address: The sample return shipping address for mail-in proposals. |
| Note |
| RET_SHIP_ADDR Column Properties |
| Datatype | VARCHAR2(1000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RET_SHIP_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1000 |
| Percent Null | 0 |
| RET_SHIP_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RET_SHIP_ADDR Security Types |
| Name | Current Value |
| RET_SHIP_ADDR Bound Attachments |
| Name | Current Value |
| RET_SHIP_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| RET_SHIP_ADDR 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 |
| RET_SHIP_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RET_SHIP_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RET_SHIP_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RET_SHIP_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |