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 | 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 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 | 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 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 |