| SMPL_ID |
| Base Object | SAMPLE |
| Attribute Name | Sample Identifier |
| ColumnName | SMPL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| 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 Sample Sample Identifier |
NO | ||
| Logical Sample Sample Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_ID |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_ID |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| FAM_SMPL_ID |
| Base Object | SAMPLE |
| Attribute Name | Sample Identifier |
| ColumnName | FAM_SMPL_ID |
| Logical Rolename | Family Sample Identifier |
| RoleName | FAM_SMPL_ID |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| FAM_SMPL_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FAM_SMPL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| FAM_SMPL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FAM_SMPL_ID Security Types |
| Name | Current Value |
| FAM_SMPL_ID Bound Attachments |
| Name | Current Value |
| FAM_SMPL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| FAM_SMPL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Sample Identifier |
NO | ||
| Logical Sample Sample Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE FAM_SMPL_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE FAM_SMPL_ID |
NO | ||
| SICAT (Oracle) SAMPLE FAM_SMPL_ID |
NO | ||
| SMPL (Oracle) SAMPLE FAM_SMPL_ID |
NO |
| FAM_SMPL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FAM_SMPL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FAM_SMPL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FAM_SMPL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TYPE_IND |
| Base Object | SAMPLE |
| Attribute Name | Sample Type Indicator |
| ColumnName | SMPL_TYPE_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_TYPE_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_TYPE_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SMPL_TYPE_IND Domain Restrictions |
| CheckConstraint | SMPL_TYPE_IND IN('L','B') |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'L' |
| Bound Default |
| SMPL_TYPE_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 |
| SMPL_TYPE_IND Security Types |
| Name | Current Value |
| SMPL_TYPE_IND Bound Attachments |
| Name | Current Value |
| SMPL_TYPE_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_TYPE_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Sample Type Indicator |
NO | ||
| Logical Sample Sample Type Indicator |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_TYPE_IND |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_TYPE_IND |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_TYPE_IND |
NO | ||
| SMPL (Oracle) SAMPLE SMPL_TYPE_IND |
NO |
| SMPL_TYPE_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TYPE_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TYPE_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_TYPE_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_NM |
| Base Object | SAMPLE |
| 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 | 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 Sample Sample Name |
NO | ||
| Logical Sample Sample Name |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_NM |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_NM |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_NM |
NO | ||
| SMPL (Oracle) SAMPLE 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_FMLA |
| Base Object | SAMPLE |
| 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 Sample Sample Formula |
NO | ||
| Logical Sample Sample Formula |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_FMLA |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_FMLA |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_FMLA |
NO | ||
| SMPL (Oracle) SAMPLE 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_DESCR |
| Base Object | SAMPLE |
| 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 | 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 Sample Sample Description |
NO | ||
| Logical Sample Sample Description |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_DESCR |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_DESCR |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_DESCR |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| VOL_WGT_AMT |
| Base Object | SAMPLE |
| Attribute Name | Volume Weight Amount |
| ColumnName | VOL_WGT_AMT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| VOL_WGT_AMT Column Properties |
| Datatype | NUMBER(8, 2) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| VOL_WGT_AMT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| VOL_WGT_AMT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| VOL_WGT_AMT Security Types |
| Name | Current Value |
| VOL_WGT_AMT Bound Attachments |
| Name | Current Value |
| VOL_WGT_AMT Data Movement Rules |
| Name | Type | Rule Text/Value |
| VOL_WGT_AMT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Volume Weight Amount |
NO | ||
| Logical Sample Volume Weight Amount |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE VOL_WGT_AMT |
NO | ||
| EXPRESS (Oracle) SAMPLE VOL_WGT_AMT |
NO | ||
| SICAT (Oracle) SAMPLE VOL_WGT_AMT |
NO | ||
| SMPL (Oracle) SAMPLE VOL_WGT_AMT |
NO |
| VOL_WGT_AMT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VOL_WGT_AMT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VOL_WGT_AMT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VOL_WGT_AMT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MASS_UNIT_ID |
| Base Object | SAMPLE |
| Attribute Name | Mass Unit Identifier |
| ColumnName | MASS_UNIT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Unit Identifier: Abbreviated unit of mass. |
| Note |
| MASS_UNIT_ID Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | NO |
| 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 Sample Mass Unit Identifier |
NO | ||
| Logical Sample Mass Unit Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE MASS_UNIT_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE MASS_UNIT_ID |
NO | ||
| SICAT (Oracle) SAMPLE MASS_UNIT_ID |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| SMPL_HGT |
| Base Object | SAMPLE |
| Attribute Name | Sample Height |
| ColumnName | SMPL_HGT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SMPL_HGT Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_HGT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| 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 Sample Sample Height |
NO | ||
| Logical Sample Sample Height |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_HGT |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_HGT |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_HGT |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| LEN_UNIT_ID |
| Base Object | SAMPLE |
| 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 Sample Length Unit Identifier |
NO | ||
| Logical Sample Length Unit Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE LEN_UNIT_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE LEN_UNIT_ID |
NO | ||
| SICAT (Oracle) SAMPLE LEN_UNIT_ID |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| NEUTRON_BEAM_IND |
| Base Object | SAMPLE |
| 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 | NO |
| 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 | 'N' |
| 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 Sample Neutron Beam Indicator |
NO | ||
| Logical Sample Neutron Beam Indicator |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE NEUTRON_BEAM_IND |
NO | ||
| EXPRESS (Oracle) SAMPLE NEUTRON_BEAM_IND |
NO | ||
| SICAT (Oracle) SAMPLE NEUTRON_BEAM_IND |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| CTRL_AREA_ID |
| Base Object | SAMPLE |
| Attribute Name | ControlArea Identifier |
| ColumnName | CTRL_AREA_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| CTRL_AREA_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CTRL_AREA_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| CTRL_AREA_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CTRL_AREA_ID Security Types |
| Name | Current Value |
| CTRL_AREA_ID Bound Attachments |
| Name | Current Value |
| CTRL_AREA_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CTRL_AREA_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample ControlArea Identifier |
NO | ||
| Logical Sample ControlArea Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE CTRL_AREA_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE CTRL_AREA_ID |
NO | ||
| SICAT (Oracle) SAMPLE CTRL_AREA_ID |
NO | ||
| SMPL (Oracle) SAMPLE CTRL_AREA_ID |
NO |
| CTRL_AREA_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CTRL_AREA_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CTRL_AREA_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CTRL_AREA_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID |
| Base Object | SAMPLE |
| Attribute Name | SubArea Identifier |
| ColumnName | SUBAREA_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SUBAREA_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBAREA_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SUBAREA_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SUBAREA_ID Security Types |
| Name | Current Value |
| SUBAREA_ID Bound Attachments |
| Name | Current Value |
| SUBAREA_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBAREA_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample SubArea Identifier |
NO | ||
| Logical Sample SubArea Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SUBAREA_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE SUBAREA_ID |
NO | ||
| SICAT (Oracle) SAMPLE SUBAREA_ID |
NO | ||
| SMPL (Oracle) SAMPLE SUBAREA_ID |
NO |
| SUBAREA_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA1_ID |
| Base Object | SAMPLE |
| Attribute Name | SubArea1 Identifier |
| ColumnName | SUBAREA1_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SUBAREA1_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBAREA1_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SUBAREA1_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SUBAREA1_ID Security Types |
| Name | Current Value |
| SUBAREA1_ID Bound Attachments |
| Name | Current Value |
| SUBAREA1_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBAREA1_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample SubArea1 Identifier |
NO | ||
| Logical Sample SubArea1 Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SUBAREA1_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE SUBAREA1_ID |
NO | ||
| SICAT (Oracle) SAMPLE SUBAREA1_ID |
NO | ||
| SMPL (Oracle) SAMPLE SUBAREA1_ID |
NO |
| SUBAREA1_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA1_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA1_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA1_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA2_ID |
| Base Object | SAMPLE |
| Attribute Name | SubArea2 Identifier |
| ColumnName | SUBAREA2_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| SUBAREA2_ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBAREA2_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| SUBAREA2_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SUBAREA2_ID Security Types |
| Name | Current Value |
| SUBAREA2_ID Bound Attachments |
| Name | Current Value |
| SUBAREA2_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBAREA2_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample SubArea2 Identifier |
NO | ||
| Logical Sample SubArea2 Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SUBAREA2_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE SUBAREA2_ID |
NO | ||
| SICAT (Oracle) SAMPLE SUBAREA2_ID |
NO | ||
| SMPL (Oracle) SAMPLE SUBAREA2_ID |
NO |
| SUBAREA2_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA2_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA2_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBAREA2_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_DISP |
| Base Object | SAMPLE |
| 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 Sample Sample Disposition |
NO | ||
| Logical Sample Sample Disposition |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_DISP |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_DISP |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_DISP |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| CONT_ID |
| Base Object | SAMPLE |
| 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 | NO |
| 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 Sample Container Identifier |
NO | ||
| Logical Sample Container Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE CONT_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE CONT_ID |
NO | ||
| SICAT (Oracle) SAMPLE CONT_ID |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| STAT_ID |
| Base Object | SAMPLE |
| Attribute Name | Status Identifier |
| ColumnName | STAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| STAT_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| STAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STAT_ID Security Types |
| Name | Current Value |
| STAT_ID Bound Attachments |
| Name | Current Value |
| STAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| STAT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Status Identifier |
NO | ||
| Logical Sample Status Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE STAT_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE STAT_ID |
NO | ||
| SICAT (Oracle) SAMPLE STAT_ID |
NO | ||
| SMPL (Oracle) SAMPLE STAT_ID |
NO |
| STAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ST_ID |
| Base Object | SAMPLE |
| 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 | NO |
| 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 Sample State Id |
NO | ||
| Logical Sample State Id |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE ST_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE ST_ID |
NO | ||
| SICAT (Oracle) SAMPLE ST_ID |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| REQ_ID |
| Base Object | SAMPLE |
| Attribute Name | Requirement Identifier |
| ColumnName | REQ_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| REQ_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| REQ_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| REQ_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| REQ_ID Security Types |
| Name | Current Value |
| REQ_ID Bound Attachments |
| Name | Current Value |
| REQ_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| REQ_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Requirement Identifier |
NO | ||
| Logical Sample Requirement Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE REQ_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE REQ_ID |
NO | ||
| SICAT (Oracle) SAMPLE REQ_ID |
NO | ||
| SMPL (Oracle) SAMPLE REQ_ID |
NO |
| REQ_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REQ_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID |
| Base Object | SAMPLE |
| Attribute Name | Group Identifier |
| ColumnName | GRP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| GRP_ID Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| GRP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| GRP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GRP_ID Security Types |
| Name | Current Value |
| GRP_ID Bound Attachments |
| Name | Current Value |
| GRP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| GRP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Group Identifier |
NO | ||
| Logical Sample Group Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE GRP_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE GRP_ID |
NO | ||
| SICAT (Oracle) SAMPLE GRP_ID |
NO | ||
| SMPL (Oracle) SAMPLE GRP_ID |
NO |
| GRP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GRP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT |
| Base Object | SAMPLE |
| Attribute Name | Comment |
| ColumnName | CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Comment: General comments. |
| Note |
| CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CMNT Security Types |
| Name | Current Value |
| CMNT Bound Attachments |
| Name | Current Value |
| CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Comment |
NO | ||
| Logical Sample Comment |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE CMNT |
NO | ||
| EXPRESS (Oracle) SAMPLE CMNT |
NO | ||
| SICAT (Oracle) SAMPLE CMNT |
NO | ||
| SMPL (Oracle) SAMPLE CMNT |
NO |
| CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE |
| Base Object | SAMPLE |
| Attribute Name | Modify Date |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| MOD_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| 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 Sample Modify Date |
NO | ||
| Logical Sample Modify Date |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE MOD_DTE |
NO | ||
| EXPRESS (Oracle) SAMPLE MOD_DTE |
NO | ||
| SICAT (Oracle) SAMPLE MOD_DTE |
NO | ||
| SMPL (Oracle) SAMPLE 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 |
| MOD_BY_USERID |
| Base Object | SAMPLE |
| Attribute Name | Modify By Userid |
| ColumnName | MOD_BY_USERID |
| Logical Rolename | |
| RoleName | |
| Domain | Userid |
| Physical Only | NO |
| Definition | |
| Note |
| MOD_BY_USERID Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_BY_USERID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| MOD_BY_USERID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_BY_USERID Security Types |
| Name | Current Value |
| MOD_BY_USERID Bound Attachments |
| Name | Current Value |
| MOD_BY_USERID Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_BY_USERID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Modify By Userid |
NO | ||
| Logical Sample Modify By Userid |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE MOD_BY_USERID |
NO | ||
| EXPRESS (Oracle) SAMPLE MOD_BY_USERID |
NO | ||
| SICAT (Oracle) SAMPLE MOD_BY_USERID |
NO | ||
| SMPL (Oracle) SAMPLE MOD_BY_USERID |
NO |
| MOD_BY_USERID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_USERID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_USERID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_USERID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_ID |
| Base Object | SAMPLE |
| Attribute Name | Disposition Identifier |
| ColumnName | DISP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| DISP_ID Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DISP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| DISP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DISP_ID Security Types |
| Name | Current Value |
| DISP_ID Bound Attachments |
| Name | Current Value |
| DISP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DISP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Disposition Identifier |
NO | ||
| Logical Sample Disposition Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE DISP_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE DISP_ID |
NO | ||
| SICAT (Oracle) SAMPLE DISP_ID |
NO | ||
| SMPL (Oracle) SAMPLE DISP_ID |
NO |
| DISP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCRA_WASTE_CD |
| Base Object | SAMPLE |
| Attribute Name | Resource Conservation and Recovery Act Waste Code |
| ColumnName | RCRA_WASTE_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Resource Conservation and Recovery Act Waste Code: |
| Note |
| RCRA_WASTE_CD Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RCRA_WASTE_CD Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| RCRA_WASTE_CD Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RCRA_WASTE_CD Security Types |
| Name | Current Value |
| RCRA_WASTE_CD Bound Attachments |
| Name | Current Value |
| RCRA_WASTE_CD Data Movement Rules |
| Name | Type | Rule Text/Value |
| RCRA_WASTE_CD Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Resource Conservation and Recovery Act Waste Code |
NO | ||
| Logical Sample Resource Conservation and Recovery Act Waste Code |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE RCRA_WASTE_CD |
NO | ||
| EXPRESS (Oracle) SAMPLE RCRA_WASTE_CD |
NO | ||
| SICAT (Oracle) SAMPLE RCRA_WASTE_CD |
NO | ||
| SMPL (Oracle) SAMPLE RCRA_WASTE_CD |
NO |
| RCRA_WASTE_CD Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCRA_WASTE_CD Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCRA_WASTE_CD Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RCRA_WASTE_CD Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UN_ID |
| Base Object | SAMPLE |
| Attribute Name | UN Identifier |
| ColumnName | UN_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | UN Identifier: |
| Note |
| UN_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| UN_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| UN_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| UN_ID Security Types |
| Name | Current Value |
| UN_ID Bound Attachments |
| Name | Current Value |
| UN_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| UN_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample UN Identifier |
NO | ||
| Logical Sample UN Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE UN_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE UN_ID |
NO | ||
| SICAT (Oracle) SAMPLE UN_ID |
NO | ||
| SMPL (Oracle) SAMPLE UN_ID |
NO |
| UN_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UN_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UN_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UN_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_DIV_NBR |
| Base Object | SAMPLE |
| Attribute Name | DOT Division Number |
| ColumnName | DOT_DIV_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DOT_DIV_NBR Column Properties |
| Datatype | CHAR(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DOT_DIV_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| DOT_DIV_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DOT_DIV_NBR Security Types |
| Name | Current Value |
| DOT_DIV_NBR Bound Attachments |
| Name | Current Value |
| DOT_DIV_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOT_DIV_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample DOT Division Number |
NO | ||
| Logical Sample DOT Division Number |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE DOT_DIV_NBR |
NO | ||
| EXPRESS (Oracle) SAMPLE DOT_DIV_NBR |
NO | ||
| SICAT (Oracle) SAMPLE DOT_DIV_NBR |
NO | ||
| SMPL (Oracle) SAMPLE DOT_DIV_NBR |
NO |
| DOT_DIV_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_DIV_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_DIV_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_DIV_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_HAZ_DIV_NBR |
| Base Object | SAMPLE |
| Attribute Name | DOT Division Number |
| ColumnName | DOT_SUB_HAZ_DIV_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DOT_SUB_HAZ_DIV_NBR Column Properties |
| Datatype | CHAR(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DOT_SUB_HAZ_DIV_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| DOT_SUB_HAZ_DIV_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DOT_SUB_HAZ_DIV_NBR Security Types |
| Name | Current Value |
| DOT_SUB_HAZ_DIV_NBR Bound Attachments |
| Name | Current Value |
| DOT_SUB_HAZ_DIV_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOT_SUB_HAZ_DIV_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample DOT Division Number |
NO | ||
| Logical Sample DOT Division Number |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE DOT_SUB_HAZ_DIV_NBR |
NO | ||
| EXPRESS (Oracle) SAMPLE DOT_SUB_HAZ_DIV_NBR |
NO | ||
| SICAT (Oracle) SAMPLE DOT_SUB_HAZ_DIV_NBR |
NO | ||
| SMPL (Oracle) SAMPLE DOT_SUB_HAZ_DIV_NBR |
NO |
| DOT_SUB_HAZ_DIV_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_HAZ_DIV_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_HAZ_DIV_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_HAZ_DIV_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PKG_GRP_ID |
| Base Object | SAMPLE |
| Attribute Name | Packing Group Identifier |
| ColumnName | PKG_GRP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| PKG_GRP_ID Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PKG_GRP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| PKG_GRP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PKG_GRP_ID Security Types |
| Name | Current Value |
| PKG_GRP_ID Bound Attachments |
| Name | Current Value |
| PKG_GRP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PKG_GRP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Packing Group Identifier |
NO | ||
| Logical Sample Packing Group Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE PKG_GRP_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE PKG_GRP_ID |
NO | ||
| SICAT (Oracle) SAMPLE PKG_GRP_ID |
NO | ||
| SMPL (Oracle) SAMPLE PKG_GRP_ID |
NO |
| PKG_GRP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PKG_GRP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PKG_GRP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PKG_GRP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_CHAR_CMNT |
| Base Object | SAMPLE |
| Attribute Name | Waste Characterization Comment |
| ColumnName | WASTE_CHAR_CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Comment: General comments. |
| Note |
| WASTE_CHAR_CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| WASTE_CHAR_CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| WASTE_CHAR_CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WASTE_CHAR_CMNT Security Types |
| Name | Current Value |
| WASTE_CHAR_CMNT Bound Attachments |
| Name | Current Value |
| WASTE_CHAR_CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| WASTE_CHAR_CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Waste Characterization Comment |
NO | ||
| Logical Sample Waste Characterization Comment |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE WASTE_CHAR_CMNT |
NO | ||
| EXPRESS (Oracle) SAMPLE WASTE_CHAR_CMNT |
NO | ||
| SICAT (Oracle) SAMPLE WASTE_CHAR_CMNT |
NO | ||
| SMPL (Oracle) SAMPLE WASTE_CHAR_CMNT |
NO |
| WASTE_CHAR_CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_CHAR_CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_CHAR_CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WASTE_CHAR_CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LWS_IND |
| Base Object | SAMPLE |
| Attribute Name | Lab Waste Certification Indicator |
| ColumnName | LWS_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| LWS_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LWS_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| LWS_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| LWS_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 |
| LWS_IND Security Types |
| Name | Current Value |
| LWS_IND Bound Attachments |
| Name | Current Value |
| LWS_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| LWS_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Lab Waste Certification Indicator |
NO | ||
| Logical Sample Lab Waste Certification Indicator |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE LWS_IND |
NO | ||
| EXPRESS (Oracle) SAMPLE LWS_IND |
NO | ||
| SICAT (Oracle) SAMPLE LWS_IND |
NO | ||
| SMPL (Oracle) SAMPLE LWS_IND |
NO |
| LWS_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LWS_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LWS_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LWS_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_CLASS_NBR |
| Base Object | SAMPLE |
| Attribute Name | DOT Class Number |
| ColumnName | DOT_CLASS_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DOT_CLASS_NBR Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DOT_CLASS_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| DOT_CLASS_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DOT_CLASS_NBR Security Types |
| Name | Current Value |
| DOT_CLASS_NBR Bound Attachments |
| Name | Current Value |
| DOT_CLASS_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOT_CLASS_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample DOT Class Number |
NO | ||
| Logical Sample DOT Class Number |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE DOT_CLASS_NBR |
NO | ||
| EXPRESS (Oracle) SAMPLE DOT_CLASS_NBR |
NO | ||
| SICAT (Oracle) SAMPLE DOT_CLASS_NBR |
NO | ||
| SMPL (Oracle) SAMPLE DOT_CLASS_NBR |
NO |
| DOT_CLASS_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_CLASS_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_CLASS_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_CLASS_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_CLASS_NBR |
| Base Object | SAMPLE |
| Attribute Name | DOT Class Number |
| ColumnName | DOT_SUB_CLASS_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DOT_SUB_CLASS_NBR Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DOT_SUB_CLASS_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| DOT_SUB_CLASS_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DOT_SUB_CLASS_NBR Security Types |
| Name | Current Value |
| DOT_SUB_CLASS_NBR Bound Attachments |
| Name | Current Value |
| DOT_SUB_CLASS_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOT_SUB_CLASS_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample DOT Class Number |
NO | ||
| Logical Sample DOT Class Number |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE DOT_SUB_CLASS_NBR |
NO | ||
| EXPRESS (Oracle) SAMPLE DOT_SUB_CLASS_NBR |
NO | ||
| SICAT (Oracle) SAMPLE DOT_SUB_CLASS_NBR |
NO | ||
| SMPL (Oracle) SAMPLE DOT_SUB_CLASS_NBR |
NO |
| DOT_SUB_CLASS_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_CLASS_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_CLASS_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOT_SUB_CLASS_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| smpl_owner_person_id |
| Base Object | SAMPLE |
| Attribute Name | Person Identifier |
| ColumnName | smpl_owner_person_id |
| Logical Rolename | Sample Owner Person Identifier |
| RoleName | smpl_owner_person_id |
| Domain | |
| Physical Only | NO |
| Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
| Note |
| smpl_owner_person_id Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| smpl_owner_person_id Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| smpl_owner_person_id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| smpl_owner_person_id Security Types |
| Name | Current Value |
| smpl_owner_person_id Bound Attachments |
| Name | Current Value |
| smpl_owner_person_id Data Movement Rules |
| Name | Type | Rule Text/Value |
| smpl_owner_person_id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Person Identifier |
NO | ||
| Logical Sample Person Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE smpl_owner_person_id |
NO | ||
| EXPRESS (Oracle) SAMPLE smpl_owner_person_id |
NO | ||
| SICAT (Oracle) SAMPLE smpl_owner_person_id |
NO | ||
| SMPL (Oracle) SAMPLE smpl_owner_person_id |
NO |
| smpl_owner_person_id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| smpl_owner_person_id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| smpl_owner_person_id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| smpl_owner_person_id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_VERIF_IND |
| Base Object | SAMPLE |
| Attribute Name | Disposition Verified Indicator |
| ColumnName | DISP_VERIF_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Disposition Verified Indicator: Simple placeholder indicating that all sample disposition items have been checked. |
| Note |
| DISP_VERIF_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DISP_VERIF_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| DISP_VERIF_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| DISP_VERIF_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 |
| DISP_VERIF_IND Security Types |
| Name | Current Value |
| DISP_VERIF_IND Bound Attachments |
| Name | Current Value |
| DISP_VERIF_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| DISP_VERIF_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Disposition Verified Indicator |
NO | ||
| Logical Sample Disposition Verified Indicator |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE DISP_VERIF_IND |
NO | ||
| EXPRESS (Oracle) SAMPLE DISP_VERIF_IND |
NO | ||
| SICAT (Oracle) SAMPLE DISP_VERIF_IND |
NO | ||
| SMPL (Oracle) SAMPLE DISP_VERIF_IND |
NO |
| DISP_VERIF_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_VERIF_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_VERIF_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_VERIF_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_NM |
| Base Object | SAMPLE |
| Attribute Name | Sample Return Name |
| ColumnName | SMPL_RET_NM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Item Return Name: The name of the person to which the experiment samples are to be returned. |
| Note |
| SMPL_RET_NM Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_RET_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| SMPL_RET_NM Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_RET_NM Security Types |
| Name | Current Value |
| SMPL_RET_NM Bound Attachments |
| Name | Current Value |
| SMPL_RET_NM Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_RET_NM Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Sample Return Name |
NO | ||
| Logical Sample Sample Return Name |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_RET_NM |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_RET_NM |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_RET_NM |
NO | ||
| SMPL (Oracle) SAMPLE SMPL_RET_NM |
NO |
| SMPL_RET_NM Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_NM Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_NM Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_NM Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_ADDR |
| Base Object | SAMPLE |
| Attribute Name | Sample Return Address |
| ColumnName | SMPL_RET_ADDR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Item Return Address: The address to which the experiment samples ae to be returned. |
| Note |
| SMPL_RET_ADDR Column Properties |
| Datatype | VARCHAR2(500) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SMPL_RET_ADDR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 500 |
| Percent Null | 0 |
| SMPL_RET_ADDR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SMPL_RET_ADDR Security Types |
| Name | Current Value |
| SMPL_RET_ADDR Bound Attachments |
| Name | Current Value |
| SMPL_RET_ADDR Data Movement Rules |
| Name | Type | Rule Text/Value |
| SMPL_RET_ADDR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Sample Return Address |
NO | ||
| Logical Sample Sample Return Address |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SMPL_RET_ADDR |
NO | ||
| EXPRESS (Oracle) SAMPLE SMPL_RET_ADDR |
NO | ||
| SICAT (Oracle) SAMPLE SMPL_RET_ADDR |
NO | ||
| SMPL (Oracle) SAMPLE SMPL_RET_ADDR |
NO |
| SMPL_RET_ADDR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_ADDR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_ADDR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SMPL_RET_ADDR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAN_ID |
| Base Object | SAMPLE |
| Attribute Name | Can Identifier |
| ColumnName | CAN_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Identifier |
| Physical Only | NO |
| Definition | |
| Note |
| CAN_ID Column Properties |
| Datatype | VARCHAR2(20) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CAN_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| CAN_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CAN_ID Security Types |
| Name | Current Value |
| CAN_ID Bound Attachments |
| Name | Current Value |
| CAN_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| CAN_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Can Identifier |
NO | ||
| Logical Sample Can Identifier |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE CAN_ID |
NO | ||
| EXPRESS (Oracle) SAMPLE CAN_ID |
NO | ||
| SICAT (Oracle) SAMPLE CAN_ID |
NO | ||
| SMPL (Oracle) SAMPLE CAN_ID |
NO |
| CAN_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAN_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAN_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CAN_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_CMNT |
| Base Object | SAMPLE |
| Attribute Name | Disposition Comment |
| ColumnName | DISP_CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Comment: General comments. |
| Note |
| DISP_CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DISP_CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| DISP_CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DISP_CMNT Security Types |
| Name | Current Value |
| DISP_CMNT Bound Attachments |
| Name | Current Value |
| DISP_CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| DISP_CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Disposition Comment |
NO | ||
| Logical Sample Disposition Comment |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE DISP_CMNT |
NO | ||
| EXPRESS (Oracle) SAMPLE DISP_CMNT |
NO | ||
| SICAT (Oracle) SAMPLE DISP_CMNT |
NO | ||
| SMPL (Oracle) SAMPLE DISP_CMNT |
NO |
| DISP_CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DISP_CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_HAND_PLAN_IND |
| Base Object | SAMPLE |
| Attribute Name | Special Handling Plan Indicator |
| ColumnName | SPEC_HAND_PLAN_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | |
| Note |
| SPEC_HAND_PLAN_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SPEC_HAND_PLAN_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| SPEC_HAND_PLAN_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| SPEC_HAND_PLAN_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 |
| SPEC_HAND_PLAN_IND Security Types |
| Name | Current Value |
| SPEC_HAND_PLAN_IND Bound Attachments |
| Name | Current Value |
| SPEC_HAND_PLAN_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| SPEC_HAND_PLAN_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Special Handling Plan Indicator |
NO | ||
| Logical Sample Special Handling Plan Indicator |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE SPEC_HAND_PLAN_IND |
NO | ||
| EXPRESS (Oracle) SAMPLE SPEC_HAND_PLAN_IND |
NO | ||
| SICAT (Oracle) SAMPLE SPEC_HAND_PLAN_IND |
NO | ||
| SMPL (Oracle) SAMPLE SPEC_HAND_PLAN_IND |
NO |
| SPEC_HAND_PLAN_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_HAND_PLAN_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_HAND_PLAN_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SPEC_HAND_PLAN_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| THEOR_MASS_DENS |
| Base Object | SAMPLE |
| Attribute Name | Theoretical Mass Density |
| ColumnName | THEOR_MASS_DENS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Theoretical Mass Density: Measured in grams per centimeter cube (g/cm^3) |
| Note |
| THEOR_MASS_DENS Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| THEOR_MASS_DENS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| THEOR_MASS_DENS Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| THEOR_MASS_DENS Security Types |
| Name | Current Value |
| THEOR_MASS_DENS Bound Attachments |
| Name | Current Value |
| THEOR_MASS_DENS Data Movement Rules |
| Name | Type | Rule Text/Value |
| THEOR_MASS_DENS Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Sample Theoretical Mass Density |
NO | ||
| Logical Sample Theoretical Mass Density |
NO | ||
| CHAN_ARCH (Oracle) SAMPLE THEOR_MASS_DENS |
NO | ||
| EXPRESS (Oracle) SAMPLE THEOR_MASS_DENS |
NO | ||
| SICAT (Oracle) SAMPLE THEOR_MASS_DENS |
NO | ||
| SMPL (Oracle) SAMPLE THEOR_MASS_DENS |
NO |
| THEOR_MASS_DENS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| THEOR_MASS_DENS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| THEOR_MASS_DENS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| THEOR_MASS_DENS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |