STUDY_ID |
Base Object | INVESTIGATION_LIST |
Attribute Name | ID |
ColumnName | STUDY_ID |
Logical Rolename | |
RoleName | STUDY_ID |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
STUDY_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
STUDY_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
STUDY_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
STUDY_ID Security Types |
Name | Current Value |
STUDY_ID Bound Attachments |
Name | Current Value |
STUDY_ID Data Movement Rules |
Name | Type | Rule Text/Value |
STUDY_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) INVESTIGATION_LIST STUDY_ID |
NO |
STUDY_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
STUDY_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
STUDY_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
STUDY_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INVESTIGATION_ID |
Base Object | INVESTIGATION_LIST |
Attribute Name | ID |
ColumnName | INVESTIGATION_ID |
Logical Rolename | |
RoleName | INVESTIGATION_ID |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
INVESTIGATION_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INVESTIGATION_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
INVESTIGATION_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INVESTIGATION_ID Security Types |
Name | Current Value |
INVESTIGATION_ID Bound Attachments |
Name | Current Value |
INVESTIGATION_ID Data Movement Rules |
Name | Type | Rule Text/Value |
INVESTIGATION_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
SICAT (Oracle) INVESTIGATION_LIST INVESTIGATION_ID |
NO |
INVESTIGATION_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INVESTIGATION_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INVESTIGATION_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INVESTIGATION_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAST_MODIFY_TIME |
Base Object | INVESTIGATION_LIST |
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_LIST 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_LIST |
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_LIST 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_LIST |
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_LIST 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 |