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