Sample Identifier |
Base Entity | Sample |
Attribute Name | Sample Identifier |
Logical Rolename | |
ColumnName | SMPL_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Sample Identifier Logical Attribute Properties |
Logical Attribute Name | Sample Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Sample Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sample Identifier Security Types |
Name | Current Value |
Sample Identifier Bound Attachments |
Name | Current Value |
Sample Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Sample Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Family Sample Identifier |
Base Entity | Sample |
Attribute Name | Sample Identifier |
Logical Rolename | Family Sample Identifier |
ColumnName | FAM_SMPL_ID |
RoleName | FAM_SMPL_ID |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Family Sample Identifier Logical Attribute Properties |
Logical Attribute Name | Sample Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | YES |
Family Sample Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Family Sample Identifier Security Types |
Name | Current Value |
Family Sample Identifier Bound Attachments |
Name | Current Value |
Family Sample Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Family Sample Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Family Sample Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Family Sample Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Family Sample Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Family Sample Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Type Indicator |
Base Entity | Sample |
Attribute Name | Sample Type Indicator |
Logical Rolename | |
ColumnName | SMPL_TYPE_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Sample Type Indicator Logical Attribute Properties |
Logical Attribute Name | Sample Type Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Sample Type Indicator Domain Restrictions |
CheckConstraint | SMPL_TYPE_IND IN('L','B') |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'L' |
Bound Default |
Sample Type Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Sample Type Indicator Security Types |
Name | Current Value |
Sample Type Indicator Bound Attachments |
Name | Current Value |
Sample Type Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Type Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Sample Type Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Type Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Type Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Type Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Name |
Base Entity | Sample |
Attribute Name | Sample Name |
Logical Rolename | |
ColumnName | SMPL_NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
Sample Name Logical Attribute Properties |
Logical Attribute Name | Sample Name |
Datatype | VARCHAR(120) |
Nullable | NO |
Sample Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sample Name Security Types |
Name | Current Value |
Sample Name Bound Attachments |
Name | Current Value |
Sample Name Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Sample Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Formula |
Base Entity | Sample |
Attribute Name | Sample Formula |
Logical Rolename | |
ColumnName | SMPL_FMLA |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Sample Formula: Any sensible chemical formula. |
Note |
Sample Formula Logical Attribute Properties |
Logical Attribute Name | Sample Formula |
Datatype | VARCHAR(2000) |
Nullable | YES |
Sample Formula Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sample Formula Security Types |
Name | Current Value |
Sample Formula Bound Attachments |
Name | Current Value |
Sample Formula Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Formula Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Sample Formula Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Formula Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Formula Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Formula Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Description |
Base Entity | Sample |
Attribute Name | Sample Description |
Logical Rolename | |
ColumnName | SMPL_DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Sample Description Logical Attribute Properties |
Logical Attribute Name | Sample Description |
Datatype | VARCHAR(2000) |
Nullable | NO |
Sample Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Sample Description Security Types |
Name | Current Value |
Sample Description Bound Attachments |
Name | Current Value |
Sample Description Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Sample Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Weight Amount |
Base Entity | Sample |
Attribute Name | Volume Weight Amount |
Logical Rolename | |
ColumnName | VOL_WGT_AMT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Volume Weight Amount Logical Attribute Properties |
Logical Attribute Name | Volume Weight Amount |
Datatype | NUMERIC(8, 2) |
Nullable | NO |
Volume Weight Amount Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Volume Weight Amount Security Types |
Name | Current Value |
Volume Weight Amount Bound Attachments |
Name | Current Value |
Volume Weight Amount Data Movement Rules |
Name | Type | Rule Text/Value |
Volume Weight Amount Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Volume Weight Amount Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Weight Amount Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Weight Amount Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Volume Weight Amount Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mass Unit Identifier |
Base Entity | Sample |
Attribute Name | Mass Unit Identifier |
Logical Rolename | |
ColumnName | MASS_UNIT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Unit Identifier: Abbreviated unit of mass. |
Note |
Mass Unit Identifier Logical Attribute Properties |
Logical Attribute Name | Mass Unit Identifier |
Datatype | VARCHAR(3) |
Nullable | NO |
Mass Unit Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Mass Unit Identifier Security Types |
Name | Current Value |
Mass Unit Identifier Bound Attachments |
Name | Current Value |
Mass Unit Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Mass Unit Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mass Unit Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Mass Unit Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mass Unit Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Height |
Base Entity | Sample |
Attribute Name | Sample Height |
Logical Rolename | |
ColumnName | SMPL_HGT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Sample Height Logical Attribute Properties |
Logical Attribute Name | Sample Height |
Datatype | VARCHAR(5) |
Nullable | YES |
Sample Height Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sample Height Security Types |
Name | Current Value |
Sample Height Bound Attachments |
Name | Current Value |
Sample Height Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Height Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Sample Height Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Height Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Height Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Height Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Length Unit Identifier |
Base Entity | Sample |
Attribute Name | Length Unit Identifier |
Logical Rolename | |
ColumnName | LEN_UNIT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Length Unit Identifier: Abbreviated unit of length. |
Note |
Length Unit Identifier Logical Attribute Properties |
Logical Attribute Name | Length Unit Identifier |
Datatype | VARCHAR(3) |
Nullable | YES |
Length Unit Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Length Unit Identifier Security Types |
Name | Current Value |
Length Unit Identifier Bound Attachments |
Name | Current Value |
Length Unit Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Length Unit Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Length Unit Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Length Unit Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Length Unit Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Length Unit Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Neutron Beam Indicator |
Base Entity | Sample |
Attribute Name | Neutron Beam Indicator |
Logical Rolename | |
ColumnName | NEUTRON_BEAM_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Neutron Beam Indicator Logical Attribute Properties |
Logical Attribute Name | Neutron Beam Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Neutron Beam Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Neutron Beam Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Neutron Beam Indicator Security Types |
Name | Current Value |
Neutron Beam Indicator Bound Attachments |
Name | Current Value |
Neutron Beam Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Neutron Beam Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Neutron Beam Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Neutron Beam Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Neutron Beam Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ControlArea Identifier |
Base Entity | Sample |
Attribute Name | ControlArea Identifier |
Logical Rolename | |
ColumnName | CTRL_AREA_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
ControlArea Identifier Logical Attribute Properties |
Logical Attribute Name | ControlArea Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
ControlArea Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ControlArea Identifier Security Types |
Name | Current Value |
ControlArea Identifier Bound Attachments |
Name | Current Value |
ControlArea Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
ControlArea Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
ControlArea Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ControlArea Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ControlArea Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ControlArea Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea Identifier |
Base Entity | Sample |
Attribute Name | SubArea Identifier |
Logical Rolename | |
ColumnName | SUBAREA_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
SubArea Identifier Logical Attribute Properties |
Logical Attribute Name | SubArea Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | YES |
SubArea Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SubArea Identifier Security Types |
Name | Current Value |
SubArea Identifier Bound Attachments |
Name | Current Value |
SubArea Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
SubArea Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea1 Identifier |
Base Entity | Sample |
Attribute Name | SubArea1 Identifier |
Logical Rolename | |
ColumnName | SUBAREA1_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
SubArea1 Identifier Logical Attribute Properties |
Logical Attribute Name | SubArea1 Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | YES |
SubArea1 Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SubArea1 Identifier Security Types |
Name | Current Value |
SubArea1 Identifier Bound Attachments |
Name | Current Value |
SubArea1 Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
SubArea1 Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea1 Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea1 Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea1 Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea2 Identifier |
Base Entity | Sample |
Attribute Name | SubArea2 Identifier |
Logical Rolename | |
ColumnName | SUBAREA2_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
SubArea2 Identifier Logical Attribute Properties |
Logical Attribute Name | SubArea2 Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | YES |
SubArea2 Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SubArea2 Identifier Security Types |
Name | Current Value |
SubArea2 Identifier Bound Attachments |
Name | Current Value |
SubArea2 Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
SubArea2 Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea2 Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea2 Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SubArea2 Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Disposition |
Base Entity | Sample |
Attribute Name | Sample Disposition |
Logical Rolename | |
ColumnName | SMPL_DISP |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Sample Disposition Logical Attribute Properties |
Logical Attribute Name | Sample Disposition |
Datatype | VARCHAR(2000) |
Nullable | YES |
Sample Disposition Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sample Disposition Security Types |
Name | Current Value |
Sample Disposition Bound Attachments |
Name | Current Value |
Sample Disposition Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Disposition Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Sample Disposition Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Disposition Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Disposition Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Disposition Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Container Identifier |
Base Entity | Sample |
Attribute Name | Container Identifier |
Logical Rolename | |
ColumnName | CONT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Container Identifier Logical Attribute Properties |
Logical Attribute Name | Container Identifier |
Datatype | VARCHAR(25) |
Nullable | NO |
Container Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Container Identifier Security Types |
Name | Current Value |
Container Identifier Bound Attachments |
Name | Current Value |
Container Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Container Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Container Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Container Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Container Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Container Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier |
Base Entity | Sample |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | VARCHAR(25) |
Nullable | NO |
Status Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Material State Identifier |
Base Entity | Sample |
Attribute Name | State Id |
Logical Rolename | Material State Identifier |
ColumnName | ST_ID |
RoleName | ST_ID |
Domain | |
Logical Only | NO |
Definition | State Identifier: The material state. |
Note |
Material State Identifier Logical Attribute Properties |
Logical Attribute Name | State Id |
Datatype | VARCHAR(6) |
Nullable | NO |
Material State Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Material State Identifier Security Types |
Name | Current Value |
Material State Identifier Bound Attachments |
Name | Current Value |
Material State Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Material State Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Material State Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Material State Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Material State Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Material State Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requirement Identifier |
Base Entity | Sample |
Attribute Name | Requirement Identifier |
Logical Rolename | |
ColumnName | REQ_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Requirement Identifier Logical Attribute Properties |
Logical Attribute Name | Requirement Identifier |
Datatype | VARCHAR(25) |
Nullable | NO |
Requirement Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Requirement Identifier Security Types |
Name | Current Value |
Requirement Identifier Bound Attachments |
Name | Current Value |
Requirement Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Requirement Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Requirement Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requirement Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Requirement Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Requirement Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Group Identifier |
Base Entity | Sample |
Attribute Name | Group Identifier |
Logical Rolename | |
ColumnName | GRP_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Group Identifier Logical Attribute Properties |
Logical Attribute Name | Group Identifier |
Datatype | VARCHAR(128) |
Nullable | YES |
Group Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Group Identifier Security Types |
Name | Current Value |
Group Identifier Bound Attachments |
Name | Current Value |
Group Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Group Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Group Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Group Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Group Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Group Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment |
Base Entity | Sample |
Attribute Name | Comment |
Logical Rolename | |
ColumnName | CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Comment Logical Attribute Properties |
Logical Attribute Name | Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Comment Security Types |
Name | Current Value |
Comment Bound Attachments |
Name | Current Value |
Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date |
Base Entity | Sample |
Attribute Name | Modify Date |
Logical Rolename | |
ColumnName | MOD_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Modify Date Logical Attribute Properties |
Logical Attribute Name | Modify Date |
Datatype | DATE |
Nullable | NO |
Modify Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Modify Date Security Types |
Name | Current Value |
Modify Date Bound Attachments |
Name | Current Value |
Modify Date Data Movement Rules |
Name | Type | Rule Text/Value |
Modify Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical 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 |
Modify Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify By Userid |
Base Entity | Sample |
Attribute Name | Modify By Userid |
Logical Rolename | |
ColumnName | MOD_BY_USERID |
RoleName | |
Domain | Userid |
Logical Only | NO |
Definition | |
Note |
Modify By Userid Logical Attribute Properties |
Logical Attribute Name | Modify By Userid |
Datatype | VARCHAR(64) |
Nullable | NO |
Modify By Userid Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Modify By Userid Security Types |
Name | Current Value |
Modify By Userid Bound Attachments |
Name | Current Value |
Modify By Userid Data Movement Rules |
Name | Type | Rule Text/Value |
Modify By Userid Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Modify By Userid Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify By Userid Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify By Userid Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify By Userid Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Identifier |
Base Entity | Sample |
Attribute Name | Disposition Identifier |
Logical Rolename | |
ColumnName | DISP_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Disposition Identifier Logical Attribute Properties |
Logical Attribute Name | Disposition Identifier |
Datatype | VARCHAR(25) |
Nullable | NO |
Disposition Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Disposition Identifier Security Types |
Name | Current Value |
Disposition Identifier Bound Attachments |
Name | Current Value |
Disposition Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Disposition Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Disposition Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Resource Conservation and Recovery Act Waste Code |
Base Entity | Sample |
Attribute Name | Resource Conservation and Recovery Act Waste Code |
Logical Rolename | |
ColumnName | RCRA_WASTE_CD |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Resource Conservation and Recovery Act Waste Code: |
Note |
Resource Conservation and Recovery Act Waste Code Logical Attribute Properties |
Logical Attribute Name | Resource Conservation and Recovery Act Waste Code |
Datatype | VARCHAR(50) |
Nullable | YES |
Resource Conservation and Recovery Act Waste Code Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Resource Conservation and Recovery Act Waste Code Security Types |
Name | Current Value |
Resource Conservation and Recovery Act Waste Code Bound Attachments |
Name | Current Value |
Resource Conservation and Recovery Act Waste Code Data Movement Rules |
Name | Type | Rule Text/Value |
Resource Conservation and Recovery Act Waste Code Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Resource Conservation and Recovery Act Waste Code Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Resource Conservation and Recovery Act Waste Code Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Resource Conservation and Recovery Act Waste Code Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Resource Conservation and Recovery Act Waste Code Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UN Identifier |
Base Entity | Sample |
Attribute Name | UN Identifier |
Logical Rolename | |
ColumnName | UN_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | UN Identifier: |
Note |
UN Identifier Logical Attribute Properties |
Logical Attribute Name | UN Identifier |
Datatype | VARCHAR(50) |
Nullable | YES |
UN Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
UN Identifier Security Types |
Name | Current Value |
UN Identifier Bound Attachments |
Name | Current Value |
UN Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
UN Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UN Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UN Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UN Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Division Number |
Base Entity | Sample |
Attribute Name | DOT Division Number |
Logical Rolename | |
ColumnName | DOT_DIV_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
DOT Division Number Logical Attribute Properties |
Logical Attribute Name | DOT Division Number |
Datatype | CHAR(3) |
Nullable | YES |
DOT Division Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
DOT Division Number Security Types |
Name | Current Value |
DOT Division Number Bound Attachments |
Name | Current Value |
DOT Division Number Data Movement Rules |
Name | Type | Rule Text/Value |
DOT Division Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Division Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Division Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Division Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Division Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub-Hazard Division Number |
Base Entity | Sample |
Attribute Name | DOT Division Number |
Logical Rolename | DOT Sub-Hazard Division Number |
ColumnName | DOT_SUB_HAZ_DIV_NBR |
RoleName | DOT_SUB_HAZ_DIV_NBR |
Domain | |
Logical Only | NO |
Definition | |
Note |
DOT Sub-Hazard Division Number Logical Attribute Properties |
Logical Attribute Name | DOT Division Number |
Datatype | CHAR(3) |
Nullable | YES |
DOT Sub-Hazard Division Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
DOT Sub-Hazard Division Number Security Types |
Name | Current Value |
DOT Sub-Hazard Division Number Bound Attachments |
Name | Current Value |
DOT Sub-Hazard Division Number Data Movement Rules |
Name | Type | Rule Text/Value |
DOT Sub-Hazard Division Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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-Hazard Division Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub-Hazard Division Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub-Hazard Division Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub-Hazard Division Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Packing Group Identifier |
Base Entity | Sample |
Attribute Name | Packing Group Identifier |
Logical Rolename | |
ColumnName | PKG_GRP_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Packing Group Identifier Logical Attribute Properties |
Logical Attribute Name | Packing Group Identifier |
Datatype | VARCHAR(3) |
Nullable | YES |
Packing Group Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Packing Group Identifier Security Types |
Name | Current Value |
Packing Group Identifier Bound Attachments |
Name | Current Value |
Packing Group Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Packing Group Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Packing Group Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Packing Group Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Packing Group Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Packing Group Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Characterization Comment |
Base Entity | Sample |
Attribute Name | Waste Characterization Comment |
Logical Rolename | |
ColumnName | WASTE_CHAR_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Waste Characterization Comment Logical Attribute Properties |
Logical Attribute Name | Waste Characterization Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Waste Characterization Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Waste Characterization Comment Security Types |
Name | Current Value |
Waste Characterization Comment Bound Attachments |
Name | Current Value |
Waste Characterization Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Waste Characterization Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Characterization Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Characterization Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Characterization Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Waste Characterization Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Lab Waste Certification Indicator |
Base Entity | Sample |
Attribute Name | Lab Waste Certification Indicator |
Logical Rolename | |
ColumnName | LWS_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Lab Waste Certification Indicator Logical Attribute Properties |
Logical Attribute Name | Lab Waste Certification Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Lab Waste Certification Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Lab Waste Certification Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Lab Waste Certification Indicator Security Types |
Name | Current Value |
Lab Waste Certification Indicator Bound Attachments |
Name | Current Value |
Lab Waste Certification Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Lab Waste Certification Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Lab Waste Certification Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Lab Waste Certification Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Lab Waste Certification Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Lab Waste Certification Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Class Number |
Base Entity | Sample |
Attribute Name | DOT Class Number |
Logical Rolename | |
ColumnName | DOT_CLASS_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
DOT Class Number Logical Attribute Properties |
Logical Attribute Name | DOT Class Number |
Datatype | CHAR(1) |
Nullable | YES |
DOT Class Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
DOT Class Number Security Types |
Name | Current Value |
DOT Class Number Bound Attachments |
Name | Current Value |
DOT Class Number Data Movement Rules |
Name | Type | Rule Text/Value |
DOT Class Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Class Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Class Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Class Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub Class Number |
Base Entity | Sample |
Attribute Name | DOT Class Number |
Logical Rolename | DOT Sub Class Number |
ColumnName | DOT_SUB_CLASS_NBR |
RoleName | DOT_SUB_CLASS_NBR |
Domain | |
Logical Only | NO |
Definition | |
Note |
DOT Sub Class Number Logical Attribute Properties |
Logical Attribute Name | DOT Class Number |
Datatype | CHAR(1) |
Nullable | YES |
DOT Sub Class Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
DOT Sub Class Number Security Types |
Name | Current Value |
DOT Sub Class Number Bound Attachments |
Name | Current Value |
DOT Sub Class Number Data Movement Rules |
Name | Type | Rule Text/Value |
DOT Sub Class Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub Class Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub Class Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOT Sub Class Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Owner Person Identifier |
Base Entity | Sample |
Attribute Name | Person Identifier |
Logical Rolename | Sample Owner Person Identifier |
ColumnName | smpl_owner_person_id |
RoleName | smpl_owner_person_id |
Domain | |
Logical Only | NO |
Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
Note |
Sample Owner Person Identifier Logical Attribute Properties |
Logical Attribute Name | Person Identifier |
Datatype | VARCHAR(10) |
Nullable | YES |
Sample Owner Person Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sample Owner Person Identifier Security Types |
Name | Current Value |
Sample Owner Person Identifier Bound Attachments |
Name | Current Value |
Sample Owner Person Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Owner Person Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Sample Owner Person Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Owner Person Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Owner Person Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Owner Person Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Verified Indicator |
Base Entity | Sample |
Attribute Name | Disposition Verified Indicator |
Logical Rolename | |
ColumnName | DISP_VERIF_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | Disposition Verified Indicator: Simple placeholder indicating that all sample disposition items have been checked. |
Note |
Disposition Verified Indicator Logical Attribute Properties |
Logical Attribute Name | Disposition Verified Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Disposition Verified Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Disposition Verified Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Disposition Verified Indicator Security Types |
Name | Current Value |
Disposition Verified Indicator Bound Attachments |
Name | Current Value |
Disposition Verified Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Disposition Verified Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Disposition Verified Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Verified Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Verified Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Verified Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Name |
Base Entity | Sample |
Attribute Name | Sample Return Name |
Logical Rolename | |
ColumnName | SMPL_RET_NM |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Item Return Name: The name of the person to which the experiment samples are to be returned. |
Note |
Sample Return Name Logical Attribute Properties |
Logical Attribute Name | Sample Return Name |
Datatype | VARCHAR(75) |
Nullable | YES |
Sample Return Name Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sample Return Name Security Types |
Name | Current Value |
Sample Return Name Bound Attachments |
Name | Current Value |
Sample Return Name Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Return Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Sample Return Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Address |
Base Entity | Sample |
Attribute Name | Sample Return Address |
Logical Rolename | |
ColumnName | SMPL_RET_ADDR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Item Return Address: The address to which the experiment samples ae to be returned. |
Note |
Sample Return Address Logical Attribute Properties |
Logical Attribute Name | Sample Return Address |
Datatype | VARCHAR(500) |
Nullable | YES |
Sample Return Address Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Sample Return Address Security Types |
Name | Current Value |
Sample Return Address Bound Attachments |
Name | Current Value |
Sample Return Address Data Movement Rules |
Name | Type | Rule Text/Value |
Sample Return Address Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Sample Return Address Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Address Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Address Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Sample Return Address Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Can Identifier |
Base Entity | Sample |
Attribute Name | Can Identifier |
Logical Rolename | |
ColumnName | CAN_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Can Identifier Logical Attribute Properties |
Logical Attribute Name | Can Identifier |
Datatype | VARCHAR(20) |
Nullable | YES |
Can Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Can Identifier Security Types |
Name | Current Value |
Can Identifier Bound Attachments |
Name | Current Value |
Can Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Can Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Can Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Can Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Can Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Comment |
Base Entity | Sample |
Attribute Name | Disposition Comment |
Logical Rolename | |
ColumnName | DISP_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
Disposition Comment Logical Attribute Properties |
Logical Attribute Name | Disposition Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
Disposition Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Disposition Comment Security Types |
Name | Current Value |
Disposition Comment Bound Attachments |
Name | Current Value |
Disposition Comment Data Movement Rules |
Name | Type | Rule Text/Value |
Disposition Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Disposition Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Disposition Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Special Handling Plan Indicator |
Base Entity | Sample |
Attribute Name | Special Handling Plan Indicator |
Logical Rolename | |
ColumnName | SPEC_HAND_PLAN_IND |
RoleName | |
Domain | Indicator |
Logical Only | NO |
Definition | |
Note |
Special Handling Plan Indicator Logical Attribute Properties |
Logical Attribute Name | Special Handling Plan Indicator |
Datatype | CHAR(1) |
Nullable | NO |
Special Handling Plan Indicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
Special Handling Plan Indicator Reference Value (Bound to Domain) |
Name | Standard Indicator |
Description | These are the standard values for the Indicator domain. |
Type | By List |
Value | Value Description |
Y | Yes |
N | No |
Special Handling Plan Indicator Security Types |
Name | Current Value |
Special Handling Plan Indicator Bound Attachments |
Name | Current Value |
Special Handling Plan Indicator Data Movement Rules |
Name | Type | Rule Text/Value |
Special Handling Plan Indicator Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Special Handling Plan Indicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Special Handling Plan Indicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Special Handling Plan Indicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Special Handling Plan Indicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Theoretical Mass Density |
Base Entity | Sample |
Attribute Name | Theoretical Mass Density |
Logical Rolename | |
ColumnName | THEOR_MASS_DENS |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Theoretical Mass Density: Measured in grams per centimeter cube (g/cm^3) |
Note |
Theoretical Mass Density Logical Attribute Properties |
Logical Attribute Name | Theoretical Mass Density |
Datatype | NUMERIC(7, 5) |
Nullable | YES |
Theoretical Mass Density Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Theoretical Mass Density Security Types |
Name | Current Value |
Theoretical Mass Density Bound Attachments |
Name | Current Value |
Theoretical Mass Density Data Movement Rules |
Name | Type | Rule Text/Value |
Theoretical Mass Density Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
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 |
Theoretical Mass Density Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Theoretical Mass Density Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Theoretical Mass Density Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Theoretical Mass Density Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |