| ID |
| Base Object | STUDY |
| 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) STUDY 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 |
| NAME |
| Base Object | STUDY |
| Attribute Name | NAME |
| ColumnName | NAME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| NAME Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NAME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| NAME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NAME Security Types |
| Name | Current Value |
| NAME Bound Attachments |
| Name | Current Value |
| NAME Data Movement Rules |
| Name | Type | Rule Text/Value |
| NAME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY NAME |
NO |
| NAME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NAME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NAME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NAME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FUNDING_INFO |
| Base Object | STUDY |
| Attribute Name | FUNDING_INFO |
| ColumnName | FUNDING_INFO |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| FUNDING_INFO Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| FUNDING_INFO Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| FUNDING_INFO Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FUNDING_INFO Security Types |
| Name | Current Value |
| FUNDING_INFO Bound Attachments |
| Name | Current Value |
| FUNDING_INFO Data Movement Rules |
| Name | Type | Rule Text/Value |
| FUNDING_INFO Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY FUNDING_INFO |
NO |
| FUNDING_INFO Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FUNDING_INFO Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FUNDING_INFO Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FUNDING_INFO Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| START_DATE |
| Base Object | STUDY |
| Attribute Name | START_DATE |
| ColumnName | START_DATE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| START_DATE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| START_DATE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| START_DATE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| START_DATE Security Types |
| Name | Current Value |
| START_DATE Bound Attachments |
| Name | Current Value |
| START_DATE Data Movement Rules |
| Name | Type | Rule Text/Value |
| START_DATE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY START_DATE |
NO |
| START_DATE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| START_DATE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| START_DATE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| START_DATE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_DATE |
| Base Object | STUDY |
| Attribute Name | END_DATE |
| ColumnName | END_DATE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| END_DATE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| END_DATE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| END_DATE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| END_DATE Security Types |
| Name | Current Value |
| END_DATE Bound Attachments |
| Name | Current Value |
| END_DATE Data Movement Rules |
| Name | Type | Rule Text/Value |
| END_DATE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY END_DATE |
NO |
| END_DATE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_DATE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_DATE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| END_DATE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PURPOSE |
| Base Object | STUDY |
| Attribute Name | PURPOSE |
| ColumnName | PURPOSE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PURPOSE Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PURPOSE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| PURPOSE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PURPOSE Security Types |
| Name | Current Value |
| PURPOSE Bound Attachments |
| Name | Current Value |
| PURPOSE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PURPOSE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY PURPOSE |
NO |
| PURPOSE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PURPOSE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PURPOSE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PURPOSE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS |
| Base Object | STUDY |
| Attribute Name | STATUS |
| ColumnName | STATUS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| STATUS Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STATUS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| STATUS Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| STATUS Security Types |
| Name | Current Value |
| STATUS Bound Attachments |
| Name | Current Value |
| STATUS Data Movement Rules |
| Name | Type | Rule Text/Value |
| STATUS Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY STATUS |
NO |
| STATUS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES |
| Base Object | STUDY |
| Attribute Name | NOTES |
| ColumnName | NOTES |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| NOTES Column Properties |
| Datatype | VARCHAR2(500) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| NOTES Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 500 |
| Percent Null | 0 |
| NOTES Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NOTES Security Types |
| Name | Current Value |
| NOTES Bound Attachments |
| Name | Current Value |
| NOTES Data Movement Rules |
| Name | Type | Rule Text/Value |
| NOTES Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY NOTES |
NO |
| NOTES Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTES Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RELATED_MATERIAL |
| Base Object | STUDY |
| Attribute Name | RELATED_MATERIAL |
| ColumnName | RELATED_MATERIAL |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| RELATED_MATERIAL Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RELATED_MATERIAL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| RELATED_MATERIAL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RELATED_MATERIAL Security Types |
| Name | Current Value |
| RELATED_MATERIAL Bound Attachments |
| Name | Current Value |
| RELATED_MATERIAL Data Movement Rules |
| Name | Type | Rule Text/Value |
| RELATED_MATERIAL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| SICAT (Oracle) STUDY RELATED_MATERIAL |
NO |
| RELATED_MATERIAL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RELATED_MATERIAL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RELATED_MATERIAL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RELATED_MATERIAL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_MODIFY_TIME |
| Base Object | STUDY |
| 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) STUDY 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 | STUDY |
| 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) STUDY 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 | STUDY |
| 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) STUDY 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 |