Sample Identifier |
Base Entity | Sample Irradiation |
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 Irradiation Sample Identifier |
NO | ||
SMPL (Oracle) SMPL_IRRAD 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 |
Instrument Identifier |
Base Entity | Sample Irradiation |
Attribute Name | Instrument Identifier |
Logical Rolename | |
ColumnName | INSTR_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Instrument Identifier: Abbreviated identier for the instrument. |
Note |
Instrument Identifier Logical Attribute Properties |
Logical Attribute Name | Instrument Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Instrument Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Instrument Identifier Security Types |
Name | Current Value |
Instrument Identifier Bound Attachments |
Name | Current Value |
Instrument Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Instrument Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Instrument Identifier |
NO | ||
SMPL (Oracle) SMPL_IRRAD INSTR_ID |
NO |
Instrument Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instrument Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Remove From Beam Date |
Base Entity | Sample Irradiation |
Attribute Name | Remove From Beam Date |
Logical Rolename | |
ColumnName | RMV_BEAM_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Remove From Beam Date Logical Attribute Properties |
Logical Attribute Name | Remove From Beam Date |
Datatype | DATE |
Nullable | NO |
Remove From Beam Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Remove From Beam Date Security Types |
Name | Current Value |
Remove From Beam Date Bound Attachments |
Name | Current Value |
Remove From Beam Date Data Movement Rules |
Name | Type | Rule Text/Value |
Remove From Beam Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Remove From Beam Date |
NO | ||
SMPL (Oracle) SMPL_IRRAD RMV_BEAM_DTE |
NO |
Remove From Beam Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Remove From Beam Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Remove From Beam Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Remove From Beam Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy |
Base Entity | Sample Irradiation |
Attribute Name | Beam Energy |
Logical Rolename | |
ColumnName | BEAM_ENGY |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Beam Energy Logical Attribute Properties |
Logical Attribute Name | Beam Energy |
Datatype | DOUBLE PRECISION |
Nullable | NO |
Beam Energy Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Beam Energy Security Types |
Name | Current Value |
Beam Energy Bound Attachments |
Name | Current Value |
Beam Energy Data Movement Rules |
Name | Type | Rule Text/Value |
Beam Energy Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Beam Energy |
NO | ||
SMPL (Oracle) SMPL_IRRAD BEAM_ENGY |
NO |
Beam Energy Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Unit of Measure Identifier |
Base Entity | Sample Irradiation |
Attribute Name | Beam Energy Unit of Measure Identifier |
Logical Rolename | |
ColumnName | BEAM_ENGY_UOM_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Beam Energy Unit of Measure Identifier Logical Attribute Properties |
Logical Attribute Name | Beam Energy Unit of Measure Identifier |
Datatype | VARCHAR(3) |
Nullable | NO |
Beam Energy Unit of Measure Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Beam Energy Unit of Measure Identifier Security Types |
Name | Current Value |
Beam Energy Unit of Measure Identifier Bound Attachments |
Name | Current Value |
Beam Energy Unit of Measure Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Beam Energy Unit of Measure Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Beam Energy Unit of Measure Identifier |
NO | ||
SMPL (Oracle) SMPL_IRRAD BEAM_ENGY_UOM_ID |
NO |
Beam Energy Unit of Measure Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Unit of Measure Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Unit of Measure Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Unit of Measure Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Normalization Factor |
Base Entity | Sample Irradiation |
Attribute Name | Normalization Factor |
Logical Rolename | |
ColumnName | NORM_FACT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Normalization Factor Logical Attribute Properties |
Logical Attribute Name | Normalization Factor |
Datatype | DOUBLE PRECISION |
Nullable | NO |
Normalization Factor Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Normalization Factor Security Types |
Name | Current Value |
Normalization Factor Bound Attachments |
Name | Current Value |
Normalization Factor Data Movement Rules |
Name | Type | Rule Text/Value |
Normalization Factor Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Normalization Factor |
NO | ||
SMPL (Oracle) SMPL_IRRAD NORM_FACT |
NO |
Normalization Factor Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Normalization Factor Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Normalization Factor Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Normalization Factor Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Time in Beam |
Base Entity | Sample Irradiation |
Attribute Name | Time in Beam |
Logical Rolename | |
ColumnName | TIME_IN_BEAM |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Time in Beam Logical Attribute Properties |
Logical Attribute Name | Time in Beam |
Datatype | NUMERIC(25, 0) |
Nullable | NO |
Time in Beam Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Time in Beam Security Types |
Name | Current Value |
Time in Beam Bound Attachments |
Name | Current Value |
Time in Beam Data Movement Rules |
Name | Type | Rule Text/Value |
Time in Beam Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Time in Beam |
NO | ||
SMPL (Oracle) SMPL_IRRAD TIME_IN_BEAM |
NO |
Time in Beam Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Time in Beam Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Time in Beam Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Time in Beam Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Time Unit Identifier |
Base Entity | Sample Irradiation |
Attribute Name | Time Unit Identifier |
Logical Rolename | |
ColumnName | TIME_UNIT_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Time Unit Identifier Logical Attribute Properties |
Logical Attribute Name | Time Unit Identifier |
Datatype | VARCHAR(5) |
Nullable | NO |
Time Unit Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Time Unit Identifier Security Types |
Name | Current Value |
Time Unit Identifier Bound Attachments |
Name | Current Value |
Time Unit Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Time Unit Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Time Unit Identifier |
NO | ||
SMPL (Oracle) SMPL_IRRAD TIME_UNIT_ID |
NO |
Time Unit Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Time Unit Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Time Unit Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Time Unit Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Low |
Base Entity | Sample Irradiation |
Attribute Name | Beam Energy Low |
Logical Rolename | |
ColumnName | BEAM_ENERGY_LOW |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Beam Energy Low Logical Attribute Properties |
Logical Attribute Name | Beam Energy Low |
Datatype | DOUBLE PRECISION |
Nullable | NO |
Beam Energy Low Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Beam Energy Low Security Types |
Name | Current Value |
Beam Energy Low Bound Attachments |
Name | Current Value |
Beam Energy Low Data Movement Rules |
Name | Type | Rule Text/Value |
Beam Energy Low Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Beam Energy Low |
NO | ||
SMPL (Oracle) SMPL_IRRAD BEAM_ENERGY_LOW |
NO |
Beam Energy Low Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Low Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Low Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy Low Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy High |
Base Entity | Sample Irradiation |
Attribute Name | Beam Energy High |
Logical Rolename | |
ColumnName | BEAM_ENERGY_HIGH |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Beam Energy High Logical Attribute Properties |
Logical Attribute Name | Beam Energy High |
Datatype | DOUBLE PRECISION |
Nullable | NO |
Beam Energy High Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Beam Energy High Security Types |
Name | Current Value |
Beam Energy High Bound Attachments |
Name | Current Value |
Beam Energy High Data Movement Rules |
Name | Type | Rule Text/Value |
Beam Energy High Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Beam Energy High |
NO | ||
SMPL (Oracle) SMPL_IRRAD BEAM_ENERGY_HIGH |
NO |
Beam Energy High Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy High Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy High Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Beam Energy High Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Special Configuration |
Base Entity | Sample Irradiation |
Attribute Name | Special Configuration |
Logical Rolename | |
ColumnName | SPEC_CONFIG |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Special Configuration Logical Attribute Properties |
Logical Attribute Name | Special Configuration |
Datatype | VARCHAR(1000) |
Nullable | YES |
Special Configuration Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Special Configuration Security Types |
Name | Current Value |
Special Configuration Bound Attachments |
Name | Current Value |
Special Configuration Data Movement Rules |
Name | Type | Rule Text/Value |
Special Configuration Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Special Configuration |
NO | ||
SMPL (Oracle) SMPL_IRRAD SPEC_CONFIG |
NO |
Special Configuration Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Special Configuration Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Special Configuration Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Special Configuration Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |