| ID |
| Base Object | INVESTIGATION |
| Attribute Name | ID |
| ColumnName | ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ID Column Properties |
| Datatype | NUMBER(38, 0) |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ID Security Types |
| Name | Current Value |
| ID Bound Attachments |
| Name | Current Value |
| ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION ID |
NO |
| ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPERIMENT_NUMBER |
| Base Object | INVESTIGATION |
| Attribute Name | EXPERIMENT_NUMBER |
| ColumnName | EXPERIMENT_NUMBER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EXPERIMENT_NUMBER Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EXPERIMENT_NUMBER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| EXPERIMENT_NUMBER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EXPERIMENT_NUMBER Security Types |
| Name | Current Value |
| EXPERIMENT_NUMBER Bound Attachments |
| Name | Current Value |
| EXPERIMENT_NUMBER Data Movement Rules |
| Name | Type | Rule Text/Value |
| EXPERIMENT_NUMBER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION EXPERIMENT_NUMBER |
NO |
| EXPERIMENT_NUMBER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPERIMENT_NUMBER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPERIMENT_NUMBER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPERIMENT_NUMBER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE |
| Base Object | INVESTIGATION |
| Attribute Name | TITLE |
| ColumnName | TITLE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TITLE Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TITLE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| TITLE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TITLE Security Types |
| Name | Current Value |
| TITLE Bound Attachments |
| Name | Current Value |
| TITLE Data Movement Rules |
| Name | Type | Rule Text/Value |
| TITLE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION TITLE |
NO |
| TITLE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TITLE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVESTIGATION_TYPE |
| Base Object | INVESTIGATION |
| Attribute Name | INVESTIGATION_TYPE |
| ColumnName | INVESTIGATION_TYPE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| INVESTIGATION_TYPE Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INVESTIGATION_TYPE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| INVESTIGATION_TYPE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INVESTIGATION_TYPE Security Types |
| Name | Current Value |
| INVESTIGATION_TYPE Bound Attachments |
| Name | Current Value |
| INVESTIGATION_TYPE Data Movement Rules |
| Name | Type | Rule Text/Value |
| INVESTIGATION_TYPE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION INVESTIGATION_TYPE |
NO |
| INVESTIGATION_TYPE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVESTIGATION_TYPE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVESTIGATION_TYPE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INVESTIGATION_TYPE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTRUMENT |
| Base Object | INVESTIGATION |
| Attribute Name | INSTRUMENT |
| ColumnName | INSTRUMENT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| INSTRUMENT Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INSTRUMENT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| INSTRUMENT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INSTRUMENT Security Types |
| Name | Current Value |
| INSTRUMENT Bound Attachments |
| Name | Current Value |
| INSTRUMENT Data Movement Rules |
| Name | Type | Rule Text/Value |
| INSTRUMENT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION INSTRUMENT |
NO |
| INSTRUMENT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTRUMENT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTRUMENT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INSTRUMENT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INV_ABSTRACT |
| Base Object | INVESTIGATION |
| Attribute Name | INV_ABSTRACT |
| ColumnName | INV_ABSTRACT |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| INV_ABSTRACT Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| INV_ABSTRACT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| INV_ABSTRACT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| INV_ABSTRACT Security Types |
| Name | Current Value |
| INV_ABSTRACT Bound Attachments |
| Name | Current Value |
| INV_ABSTRACT Data Movement Rules |
| Name | Type | Rule Text/Value |
| INV_ABSTRACT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION INV_ABSTRACT |
NO |
| INV_ABSTRACT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INV_ABSTRACT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| INV_ABSTRACT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| INV_ABSTRACT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_EXPERIMENT_NUMBER |
| Base Object | INVESTIGATION |
| Attribute Name | PREV_EXPERIMENT_NUMBER |
| ColumnName | PREV_EXPERIMENT_NUMBER |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PREV_EXPERIMENT_NUMBER Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PREV_EXPERIMENT_NUMBER Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| PREV_EXPERIMENT_NUMBER Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PREV_EXPERIMENT_NUMBER Security Types |
| Name | Current Value |
| PREV_EXPERIMENT_NUMBER Bound Attachments |
| Name | Current Value |
| PREV_EXPERIMENT_NUMBER Data Movement Rules |
| Name | Type | Rule Text/Value |
| PREV_EXPERIMENT_NUMBER Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION PREV_EXPERIMENT_NUMBER |
NO |
| PREV_EXPERIMENT_NUMBER Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_EXPERIMENT_NUMBER Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_EXPERIMENT_NUMBER Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PREV_EXPERIMENT_NUMBER Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BCAT_INV_STR |
| Base Object | INVESTIGATION |
| Attribute Name | BCAT_INV_STR |
| ColumnName | BCAT_INV_STR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| BCAT_INV_STR Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BCAT_INV_STR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| BCAT_INV_STR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BCAT_INV_STR Security Types |
| Name | Current Value |
| BCAT_INV_STR Bound Attachments |
| Name | Current Value |
| BCAT_INV_STR Data Movement Rules |
| Name | Type | Rule Text/Value |
| BCAT_INV_STR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION BCAT_INV_STR |
NO |
| BCAT_INV_STR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BCAT_INV_STR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BCAT_INV_STR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BCAT_INV_STR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFY_TIME |
| Base Object | INVESTIGATION |
| Attribute Name | LAST_MODIFY_TIME |
| ColumnName | LAST_MODIFY_TIME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| LAST_MODIFY_TIME Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LAST_MODIFY_TIME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| LAST_MODIFY_TIME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LAST_MODIFY_TIME Security Types |
| Name | Current Value |
| LAST_MODIFY_TIME Bound Attachments |
| Name | Current Value |
| LAST_MODIFY_TIME Data Movement Rules |
| Name | Type | Rule Text/Value |
| LAST_MODIFY_TIME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION LAST_MODIFY_TIME |
NO |
| LAST_MODIFY_TIME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFY_TIME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFY_TIME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFY_TIME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFIER_ID |
| Base Object | INVESTIGATION |
| Attribute Name | LAST_MODIFIER_ID |
| ColumnName | LAST_MODIFIER_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| LAST_MODIFIER_ID Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LAST_MODIFIER_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| LAST_MODIFIER_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LAST_MODIFIER_ID Security Types |
| Name | Current Value |
| LAST_MODIFIER_ID Bound Attachments |
| Name | Current Value |
| LAST_MODIFIER_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| LAST_MODIFIER_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION LAST_MODIFIER_ID |
NO |
| LAST_MODIFIER_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFIER_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFIER_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFIER_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMMENTS |
| Base Object | INVESTIGATION |
| Attribute Name | COMMENTS |
| ColumnName | COMMENTS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| COMMENTS Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| COMMENTS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| COMMENTS Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| COMMENTS Security Types |
| Name | Current Value |
| COMMENTS Bound Attachments |
| Name | Current Value |
| COMMENTS Data Movement Rules |
| Name | Type | Rule Text/Value |
| COMMENTS Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION COMMENTS |
NO |
| COMMENTS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMMENTS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMMENTS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMMENTS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACILITY |
| Base Object | INVESTIGATION |
| Attribute Name | FACILITY |
| ColumnName | FACILITY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| FACILITY Column Properties |
| Datatype | VARCHAR2(256) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FACILITY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 256 |
| Percent Null | 0 |
| FACILITY Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FACILITY Security Types |
| Name | Current Value |
| FACILITY Bound Attachments |
| Name | Current Value |
| FACILITY Data Movement Rules |
| Name | Type | Rule Text/Value |
| FACILITY Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) INVESTIGATION FACILITY |
NO |
| FACILITY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACILITY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACILITY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FACILITY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |