| ID |
| Base Object | PUBLICATION |
| Attribute Name | ID |
| ColumnName | ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ID Column Properties |
| Datatype | NUMBER |
| 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 |
| PUBL_V1 (Oracle) PUBLICATION ID |
NO | ||
| SICAT (Oracle) PUBLICATION 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 |
| TITLE |
| Base Object | PUBLICATION |
| Attribute Name | TITLE |
| ColumnName | TITLE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| TITLE Column Properties |
| Datatype | VARCHAR2(1024) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| TITLE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1024 |
| 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 |
| PUBL_V1 (Oracle) PUBLICATION TITLE |
NO | ||
| SICAT (Oracle) PUBLICATION 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 |
| PROPOSAL_ID |
| Base Object | PUBLICATION |
| Attribute Name | PROPOSAL_ID |
| ColumnName | PROPOSAL_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PROPOSAL_ID Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PROPOSAL_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| PROPOSAL_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PROPOSAL_ID Security Types |
| Name | Current Value |
| PROPOSAL_ID Bound Attachments |
| Name | Current Value |
| PROPOSAL_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PROPOSAL_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PROPOSAL_ID |
NO | ||
| SICAT (Oracle) PUBLICATION PROPOSAL_ID |
NO |
| PROPOSAL_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROPOSAL_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROPOSAL_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PROPOSAL_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCI_DISCIP |
| Base Object | PUBLICATION |
| Attribute Name | SCI_DISCIP |
| ColumnName | SCI_DISCIP |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SCI_DISCIP Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SCI_DISCIP Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| SCI_DISCIP Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SCI_DISCIP Security Types |
| Name | Current Value |
| SCI_DISCIP Bound Attachments |
| Name | Current Value |
| SCI_DISCIP Data Movement Rules |
| Name | Type | Rule Text/Value |
| SCI_DISCIP Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION SCI_DISCIP |
NO | ||
| SICAT (Oracle) PUBLICATION SCI_DISCIP |
NO |
| SCI_DISCIP Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCI_DISCIP Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCI_DISCIP Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SCI_DISCIP Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_NAME |
| Base Object | PUBLICATION |
| Attribute Name | PUB_NAME |
| ColumnName | PUB_NAME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_NAME Column Properties |
| Datatype | VARCHAR2(512) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_NAME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 512 |
| Percent Null | 0 |
| PUB_NAME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_NAME Security Types |
| Name | Current Value |
| PUB_NAME Bound Attachments |
| Name | Current Value |
| PUB_NAME Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_NAME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_NAME |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_NAME |
NO |
| PUB_NAME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_NAME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_NAME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_NAME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ADD_NAME |
| Base Object | PUBLICATION |
| Attribute Name | PUB_ADD_NAME |
| ColumnName | PUB_ADD_NAME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_ADD_NAME Column Properties |
| Datatype | VARCHAR2(512) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_ADD_NAME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 512 |
| Percent Null | 0 |
| PUB_ADD_NAME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_ADD_NAME Security Types |
| Name | Current Value |
| PUB_ADD_NAME Bound Attachments |
| Name | Current Value |
| PUB_ADD_NAME Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_ADD_NAME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_ADD_NAME |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_ADD_NAME |
NO |
| PUB_ADD_NAME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ADD_NAME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ADD_NAME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ADD_NAME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_TYPE |
| Base Object | PUBLICATION |
| Attribute Name | PUB_TYPE |
| ColumnName | PUB_TYPE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_TYPE Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_TYPE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| PUB_TYPE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_TYPE Security Types |
| Name | Current Value |
| PUB_TYPE Bound Attachments |
| Name | Current Value |
| PUB_TYPE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_TYPE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_TYPE |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_TYPE |
NO |
| PUB_TYPE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_TYPE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_TYPE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_TYPE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_VOLUME |
| Base Object | PUBLICATION |
| Attribute Name | PUB_VOLUME |
| ColumnName | PUB_VOLUME |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_VOLUME Column Properties |
| Datatype | VARCHAR2(256) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_VOLUME Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 256 |
| Percent Null | 0 |
| PUB_VOLUME Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_VOLUME Security Types |
| Name | Current Value |
| PUB_VOLUME Bound Attachments |
| Name | Current Value |
| PUB_VOLUME Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_VOLUME Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_VOLUME |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_VOLUME |
NO |
| PUB_VOLUME Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_VOLUME Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_VOLUME Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_VOLUME Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_PAGE |
| Base Object | PUBLICATION |
| Attribute Name | PUB_PAGE |
| ColumnName | PUB_PAGE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_PAGE Column Properties |
| Datatype | VARCHAR2(256) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_PAGE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 256 |
| Percent Null | 0 |
| PUB_PAGE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_PAGE Security Types |
| Name | Current Value |
| PUB_PAGE Bound Attachments |
| Name | Current Value |
| PUB_PAGE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_PAGE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_PAGE |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_PAGE |
NO |
| PUB_PAGE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_PAGE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_PAGE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_PAGE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ISSUE |
| Base Object | PUBLICATION |
| Attribute Name | PUB_ISSUE |
| ColumnName | PUB_ISSUE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_ISSUE Column Properties |
| Datatype | VARCHAR2(256) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_ISSUE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 256 |
| Percent Null | 0 |
| PUB_ISSUE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_ISSUE Security Types |
| Name | Current Value |
| PUB_ISSUE Bound Attachments |
| Name | Current Value |
| PUB_ISSUE Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_ISSUE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_ISSUE |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_ISSUE |
NO |
| PUB_ISSUE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ISSUE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ISSUE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_ISSUE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_YEAR |
| Base Object | PUBLICATION |
| Attribute Name | PUB_YEAR |
| ColumnName | PUB_YEAR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_YEAR Column Properties |
| Datatype | VARCHAR2(4) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_YEAR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 0 |
| PUB_YEAR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_YEAR Security Types |
| Name | Current Value |
| PUB_YEAR Bound Attachments |
| Name | Current Value |
| PUB_YEAR Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_YEAR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_YEAR |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_YEAR |
NO |
| PUB_YEAR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_YEAR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_YEAR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_YEAR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_MONTH |
| Base Object | PUBLICATION |
| Attribute Name | PUB_MONTH |
| ColumnName | PUB_MONTH |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| PUB_MONTH Column Properties |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PUB_MONTH Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| PUB_MONTH Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PUB_MONTH Security Types |
| Name | Current Value |
| PUB_MONTH Bound Attachments |
| Name | Current Value |
| PUB_MONTH Data Movement Rules |
| Name | Type | Rule Text/Value |
| PUB_MONTH Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION PUB_MONTH |
NO | ||
| SICAT (Oracle) PUBLICATION PUB_MONTH |
NO |
| PUB_MONTH Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_MONTH Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_MONTH Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PUB_MONTH Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOI |
| Base Object | PUBLICATION |
| Attribute Name | DOI |
| ColumnName | DOI |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DOI Column Properties |
| Datatype | VARCHAR2(256) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DOI Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 256 |
| Percent Null | 0 |
| DOI Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DOI Security Types |
| Name | Current Value |
| DOI Bound Attachments |
| Name | Current Value |
| DOI Data Movement Rules |
| Name | Type | Rule Text/Value |
| DOI Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION DOI |
NO | ||
| SICAT (Oracle) PUBLICATION DOI |
NO |
| DOI Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOI Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOI Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DOI Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_DIV |
| Base Object | PUBLICATION |
| Attribute Name | ORNL_DIV |
| ColumnName | ORNL_DIV |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ORNL_DIV Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ORNL_DIV Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| ORNL_DIV Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ORNL_DIV Security Types |
| Name | Current Value |
| ORNL_DIV Bound Attachments |
| Name | Current Value |
| ORNL_DIV Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL_DIV Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION ORNL_DIV |
NO | ||
| SICAT (Oracle) PUBLICATION ORNL_DIV |
NO |
| ORNL_DIV Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_DIV Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_DIV Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_DIV Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PTS |
| Base Object | PUBLICATION |
| Attribute Name | ORNL_PTS |
| ColumnName | ORNL_PTS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ORNL_PTS Column Properties |
| Datatype | VARCHAR2(128) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ORNL_PTS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 128 |
| Percent Null | 0 |
| ORNL_PTS Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ORNL_PTS Security Types |
| Name | Current Value |
| ORNL_PTS Bound Attachments |
| Name | Current Value |
| ORNL_PTS Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL_PTS Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION ORNL_PTS |
NO | ||
| SICAT (Oracle) PUBLICATION ORNL_PTS |
NO |
| ORNL_PTS Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PTS Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PTS Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PTS Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBMITTED_BY |
| Base Object | PUBLICATION |
| Attribute Name | SUBMITTED_BY |
| ColumnName | SUBMITTED_BY |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| SUBMITTED_BY Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| SUBMITTED_BY Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| SUBMITTED_BY Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SUBMITTED_BY Security Types |
| Name | Current Value |
| SUBMITTED_BY Bound Attachments |
| Name | Current Value |
| SUBMITTED_BY Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBMITTED_BY Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION SUBMITTED_BY |
NO | ||
| SICAT (Oracle) PUBLICATION SUBMITTED_BY |
NO |
| SUBMITTED_BY Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBMITTED_BY Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBMITTED_BY Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBMITTED_BY Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Base Object | PUBLICATION |
| Attribute Name | |
| ColumnName | |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| EMAIL Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EMAIL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| EMAIL Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EMAIL Security Types |
| Name | Current Value |
| EMAIL Bound Attachments |
| Name | Current Value |
| EMAIL Data Movement Rules |
| Name | Type | Rule Text/Value |
| EMAIL Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION |
NO | ||
| SICAT (Oracle) PUBLICATION |
NO |
| EMAIL Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EMAIL Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| COMMENTS |
| Base Object | PUBLICATION |
| Attribute Name | COMMENTS |
| ColumnName | COMMENTS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| COMMENTS Column Properties |
| Datatype | VARCHAR2(1024) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| COMMENTS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1024 |
| 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 |
| PUBL_V1 (Oracle) PUBLICATION COMMENTS |
NO | ||
| SICAT (Oracle) PUBLICATION 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 |
| LAST_UPDATE |
| Base Object | PUBLICATION |
| Attribute Name | LAST_UPDATE |
| ColumnName | LAST_UPDATE |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| LAST_UPDATE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| LAST_UPDATE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| LAST_UPDATE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LAST_UPDATE Security Types |
| Name | Current Value |
| LAST_UPDATE Bound Attachments |
| Name | Current Value |
| LAST_UPDATE Data Movement Rules |
| Name | Type | Rule Text/Value |
| LAST_UPDATE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| PUBL_V1 (Oracle) PUBLICATION LAST_UPDATE |
NO | ||
| SICAT (Oracle) PUBLICATION LAST_UPDATE |
NO |
| LAST_UPDATE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_UPDATE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_UPDATE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LAST_UPDATE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| STATUS |
| Base Object | PUBLICATION |
| Attribute Name | STATUS |
| ColumnName | STATUS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| STATUS Column Properties |
| Datatype | VARCHAR2(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| STATUS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| 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 |
| PUBL_V1 (Oracle) PUBLICATION STATUS |
NO | ||
| SICAT (Oracle) PUBLICATION 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 |