SMPL_ID |
Base Object | SMPL_IRRAD |
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 Irradiation Sample Identifier |
NO | ||
SMPL (Oracle) SMPL_IRRAD 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 |
INSTR_ID |
Base Object | SMPL_IRRAD |
Attribute Name | Instrument Identifier |
ColumnName | INSTR_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Instrument Identifier: Abbreviated identier for the instrument. |
Note |
INSTR_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INSTR_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
INSTR_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INSTR_ID Security Types |
Name | Current Value |
INSTR_ID Bound Attachments |
Name | Current Value |
INSTR_ID Data Movement Rules |
Name | Type | Rule Text/Value |
INSTR_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Instrument Identifier |
NO | ||
SMPL (Oracle) SMPL_IRRAD INSTR_ID |
NO |
INSTR_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INSTR_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BEAM_DTE |
Base Object | SMPL_IRRAD |
Attribute Name | Remove From Beam Date |
ColumnName | RMV_BEAM_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
RMV_BEAM_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RMV_BEAM_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
RMV_BEAM_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
RMV_BEAM_DTE Security Types |
Name | Current Value |
RMV_BEAM_DTE Bound Attachments |
Name | Current Value |
RMV_BEAM_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
RMV_BEAM_DTE 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 |
RMV_BEAM_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BEAM_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BEAM_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BEAM_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY |
Base Object | SMPL_IRRAD |
Attribute Name | Beam Energy |
ColumnName | BEAM_ENGY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BEAM_ENGY Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | NO |
Not Null Constraint |
BEAM_ENGY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
BEAM_ENGY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BEAM_ENGY Security Types |
Name | Current Value |
BEAM_ENGY Bound Attachments |
Name | Current Value |
BEAM_ENGY Data Movement Rules |
Name | Type | Rule Text/Value |
BEAM_ENGY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Beam Energy |
NO | ||
SMPL (Oracle) SMPL_IRRAD BEAM_ENGY |
NO |
BEAM_ENGY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY_UOM_ID |
Base Object | SMPL_IRRAD |
Attribute Name | Beam Energy Unit of Measure Identifier |
ColumnName | BEAM_ENGY_UOM_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
BEAM_ENGY_UOM_ID Column Properties |
Datatype | VARCHAR2(3) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BEAM_ENGY_UOM_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
BEAM_ENGY_UOM_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BEAM_ENGY_UOM_ID Security Types |
Name | Current Value |
BEAM_ENGY_UOM_ID Bound Attachments |
Name | Current Value |
BEAM_ENGY_UOM_ID Data Movement Rules |
Name | Type | Rule Text/Value |
BEAM_ENGY_UOM_ID 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_ENGY_UOM_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY_UOM_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY_UOM_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENGY_UOM_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
NORM_FACT |
Base Object | SMPL_IRRAD |
Attribute Name | Normalization Factor |
ColumnName | NORM_FACT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
NORM_FACT Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | NO |
Not Null Constraint |
NORM_FACT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
NORM_FACT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
NORM_FACT Security Types |
Name | Current Value |
NORM_FACT Bound Attachments |
Name | Current Value |
NORM_FACT Data Movement Rules |
Name | Type | Rule Text/Value |
NORM_FACT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Normalization Factor |
NO | ||
SMPL (Oracle) SMPL_IRRAD NORM_FACT |
NO |
NORM_FACT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
NORM_FACT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
NORM_FACT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
NORM_FACT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TIME_IN_BEAM |
Base Object | SMPL_IRRAD |
Attribute Name | Time in Beam |
ColumnName | TIME_IN_BEAM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
TIME_IN_BEAM Column Properties |
Datatype | NUMBER(25, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TIME_IN_BEAM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 13 |
Percent Null | 0 |
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_ID |
Base Object | SMPL_IRRAD |
Attribute Name | Time Unit Identifier |
ColumnName | TIME_UNIT_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
TIME_UNIT_ID Column Properties |
Datatype | VARCHAR2(5) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TIME_UNIT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
TIME_UNIT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
TIME_UNIT_ID Security Types |
Name | Current Value |
TIME_UNIT_ID Bound Attachments |
Name | Current Value |
TIME_UNIT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
TIME_UNIT_ID 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_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TIME_UNIT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TIME_UNIT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TIME_UNIT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BEAM_ENERGY_LOW |
Base Object | SMPL_IRRAD |
Attribute Name | Beam Energy Low |
ColumnName | BEAM_ENERGY_LOW |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BEAM_ENERGY_LOW Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | NO |
Not Null Constraint |
BEAM_ENERGY_LOW Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
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 Object | SMPL_IRRAD |
Attribute Name | Beam Energy High |
ColumnName | BEAM_ENERGY_HIGH |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BEAM_ENERGY_HIGH Column Properties |
Datatype | BINARY_DOUBLE |
Nullable | NO |
Not Null Constraint |
BEAM_ENERGY_HIGH Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 0 |
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 |
SPEC_CONFIG |
Base Object | SMPL_IRRAD |
Attribute Name | Special Configuration |
ColumnName | SPEC_CONFIG |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
SPEC_CONFIG Column Properties |
Datatype | VARCHAR2(1000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SPEC_CONFIG Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1000 |
Percent Null | 0 |
SPEC_CONFIG Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SPEC_CONFIG Security Types |
Name | Current Value |
SPEC_CONFIG Bound Attachments |
Name | Current Value |
SPEC_CONFIG Data Movement Rules |
Name | Type | Rule Text/Value |
SPEC_CONFIG Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Sample Irradiation Special Configuration |
NO | ||
SMPL (Oracle) SMPL_IRRAD SPEC_CONFIG |
NO |
SPEC_CONFIG Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SPEC_CONFIG Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SPEC_CONFIG Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SPEC_CONFIG Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |