| Publication Identifer |
| Base Entity | Publication |
| Attribute Name | Publication Identifer |
| Logical Rolename | |
| ColumnName | PUBL_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Identifer Logical Attribute Properties |
| Logical Attribute Name | Publication Identifer |
| Datatype | NUMERIC(38, 0) |
| Nullable | NO |
| Publication Identifer Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Publication Identifer Security Types |
| Name | Current Value |
| Publication Identifer Bound Attachments |
| Name | Current Value |
| Publication Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Publication Identifer |
NO | ||
| IPTSv5 (Oracle) PUBL PUBL_ID |
NO | ||
| PRPSL (Oracle) PUBL PUBL_ID |
NO | ||
| PUBL (Oracle) PUBL PUBL_ID |
NO |
| Publication Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Title |
| Base Entity | Publication |
| Attribute Name | Title |
| Logical Rolename | |
| ColumnName | TITLE |
| RoleName | |
| Domain | Title |
| Logical Only | NO |
| Definition | |
| Note |
| Title Logical Attribute Properties |
| Logical Attribute Name | Title |
| Datatype | VARCHAR(1000) |
| Nullable | NO |
| 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 |
| Logical Publication Title |
NO | ||
| IPTSv5 (Oracle) PUBL TITLE |
NO | ||
| PRPSL (Oracle) PUBL TITLE |
NO | ||
| PUBL (Oracle) PUBL 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 |
| Status Identifier |
| Base Entity | Publication |
| Attribute Name | Status Identifier |
| Logical Rolename | |
| ColumnName | STAT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Status Identifer: Abbreviated idenfifer for the given status. |
| Note |
| Status Identifier Logical Attribute Properties |
| Logical Attribute Name | Status Identifier |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Status Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Status Identifier Security Types |
| Name | Current Value |
| Status Identifier Bound Attachments |
| Name | Current Value |
| Status Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Status Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Status Identifier |
NO | ||
| IPTSv5 (Oracle) PUBL STAT_ID |
NO | ||
| PRPSL (Oracle) PUBL STAT_ID |
NO | ||
| PUBL (Oracle) PUBL STAT_ID |
NO |
| Status Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Type Identifer |
| Base Entity | Publication |
| Attribute Name | Publication Type Identifer |
| Logical Rolename | |
| ColumnName | PUBL_TYPE_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Category Identifier: Abbreviated identifier for the user category. |
| Note |
| Publication Type Identifer Logical Attribute Properties |
| Logical Attribute Name | Publication Type Identifer |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Publication Type Identifer Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Publication Type Identifer Security Types |
| Name | Current Value |
| Publication Type Identifer Bound Attachments |
| Name | Current Value |
| Publication Type Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Type Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Publication Type Identifer |
NO | ||
| IPTSv5 (Oracle) PUBL PUBL_TYPE_ID |
NO | ||
| PRPSL (Oracle) PUBL PUBL_TYPE_ID |
NO | ||
| PUBL (Oracle) PUBL PUBL_TYPE_ID |
NO |
| Publication Type Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Type Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Type Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Type Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Volume |
| Base Entity | Publication |
| Attribute Name | Publication Volume |
| Logical Rolename | |
| ColumnName | PUBL_VOLUME |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Volume Logical Attribute Properties |
| Logical Attribute Name | Publication Volume |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Publication Volume Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Publication Volume Security Types |
| Name | Current Value |
| Publication Volume Bound Attachments |
| Name | Current Value |
| Publication Volume Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Volume Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Publication Volume |
NO | ||
| IPTSv5 (Oracle) PUBL PUBL_VOLUME |
NO | ||
| PRPSL (Oracle) PUBL PUBL_VOLUME |
NO | ||
| PUBL (Oracle) PUBL PUBL_VOLUME |
NO |
| Publication Volume Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Volume Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Volume Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Volume Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Page |
| Base Entity | Publication |
| Attribute Name | Publication Page |
| Logical Rolename | |
| ColumnName | PUBL_PAGE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Page Logical Attribute Properties |
| Logical Attribute Name | Publication Page |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Publication Page Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Publication Page Security Types |
| Name | Current Value |
| Publication Page Bound Attachments |
| Name | Current Value |
| Publication Page Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Page Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Publication Page |
NO | ||
| IPTSv5 (Oracle) PUBL PUBL_PAGE |
NO | ||
| PRPSL (Oracle) PUBL PUBL_PAGE |
NO | ||
| PUBL (Oracle) PUBL PUBL_PAGE |
NO |
| Publication Page Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Page Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Page Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Page Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Issue |
| Base Entity | Publication |
| Attribute Name | Publication Issue |
| Logical Rolename | |
| ColumnName | PUBL_ISSUE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Issue Logical Attribute Properties |
| Logical Attribute Name | Publication Issue |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Publication Issue Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Publication Issue Security Types |
| Name | Current Value |
| Publication Issue Bound Attachments |
| Name | Current Value |
| Publication Issue Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Issue Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Publication Issue |
NO | ||
| IPTSv5 (Oracle) PUBL PUBL_ISSUE |
NO | ||
| PRPSL (Oracle) PUBL PUBL_ISSUE |
NO | ||
| PUBL (Oracle) PUBL PUBL_ISSUE |
NO |
| Publication Issue Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Issue Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Issue Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Issue Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Year |
| Base Entity | Publication |
| Attribute Name | Publication Year |
| Logical Rolename | |
| ColumnName | PUBL_YEAR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Year Logical Attribute Properties |
| Logical Attribute Name | Publication Year |
| Datatype | CHAR(4) |
| Nullable | NO |
| Publication Year Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Publication Year Security Types |
| Name | Current Value |
| Publication Year Bound Attachments |
| Name | Current Value |
| Publication Year Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Year Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Publication Year |
NO | ||
| IPTSv5 (Oracle) PUBL PUB_YEAR |
NO | ||
| PRPSL (Oracle) PUBL PUBL_YEAR |
NO | ||
| PUBL (Oracle) PUBL PUBL_YEAR |
NO |
| Publication Year Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Year Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Year Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Year Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month |
| Base Entity | Publication |
| Attribute Name | Publication Month |
| Logical Rolename | |
| ColumnName | PUBL_MONTH |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Publication Month Logical Attribute Properties |
| Logical Attribute Name | Publication Month |
| Datatype | VARCHAR(3) |
| Nullable | YES |
| Publication Month Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Publication Month Security Types |
| Name | Current Value |
| Publication Month Bound Attachments |
| Name | Current Value |
| Publication Month Data Movement Rules |
| Name | Type | Rule Text/Value |
| Publication Month Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Publication Month |
NO | ||
| IPTSv5 (Oracle) PUBL PUBL_MONTH |
NO | ||
| PRPSL (Oracle) PUBL PUBL_MONTH |
NO | ||
| PUBL (Oracle) PUBL PUBL_MONTH |
NO |
| Publication Month Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Publication Month Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier |
| Base Entity | Publication |
| Attribute Name | Digital Object Identifier |
| Logical Rolename | |
| ColumnName | DOI |
| RoleName | |
| Domain | URL |
| Logical Only | NO |
| Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
| Note |
| Digital Object Identifier Logical Attribute Properties |
| Logical Attribute Name | Digital Object Identifier |
| Datatype | VARCHAR(2048) |
| Nullable | YES |
| Digital Object Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Digital Object Identifier Security Types |
| Name | Current Value |
| Digital Object Identifier Bound Attachments |
| Name | Current Value |
| Digital Object Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Digital Object Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Digital Object Identifier |
NO | ||
| IPTSv5 (Oracle) PUBL DIG_OBJ_ID |
NO | ||
| PRPSL (Oracle) PUBL DOI |
NO | ||
| PUBL (Oracle) PUBL DOI |
NO |
| Digital Object Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Digital Object Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Journal Identifier |
| Base Entity | Publication |
| Attribute Name | Journal Identifier |
| Logical Rolename | |
| ColumnName | JOURNAL_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Journal Identifier Logical Attribute Properties |
| Logical Attribute Name | Journal Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | YES |
| Journal Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Journal Identifier Security Types |
| Name | Current Value |
| Journal Identifier Bound Attachments |
| Name | Current Value |
| Journal Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Journal Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Journal Identifier |
NO | ||
| IPTSv5 (Oracle) PUBL JOURNAL_ID |
NO | ||
| PRPSL (Oracle) PUBL JOURNAL_ID |
NO | ||
| PUBL (Oracle) PUBL JOURNAL_ID |
NO |
| Journal Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Journal Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Journal Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Journal Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Conference Identifier |
| Base Entity | Publication |
| Attribute Name | Conference Identifier |
| Logical Rolename | |
| ColumnName | CONF_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Conference Identifier Logical Attribute Properties |
| Logical Attribute Name | Conference Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | YES |
| Conference Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Conference Identifier Security Types |
| Name | Current Value |
| Conference Identifier Bound Attachments |
| Name | Current Value |
| Conference Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Conference Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Conference Identifier |
NO | ||
| IPTSv5 (Oracle) PUBL CONF_ID |
NO | ||
| PRPSL (Oracle) PUBL CONF_ID |
NO | ||
| PUBL (Oracle) PUBL CONF_ID |
NO |
| Conference Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Conference Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Conference Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Conference Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proceeding Identifier |
| Base Entity | Publication |
| Attribute Name | Proceeding Identifier |
| Logical Rolename | |
| ColumnName | PROCEED_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Proceeding Identifier Logical Attribute Properties |
| Logical Attribute Name | Proceeding Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | YES |
| Proceeding Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Proceeding Identifier Security Types |
| Name | Current Value |
| Proceeding Identifier Bound Attachments |
| Name | Current Value |
| Proceeding Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proceeding Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Proceeding Identifier |
NO | ||
| IPTSv5 (Oracle) PUBL PROCEED_ID |
NO | ||
| PRPSL (Oracle) PUBL PROCEED_ID |
NO | ||
| PUBL (Oracle) PUBL PROCEED_ID |
NO |
| Proceeding Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proceeding Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proceeding Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proceeding Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Name |
| Base Entity | Publication |
| Attribute Name | Book Name |
| Logical Rolename | |
| ColumnName | BOOK_NAME |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Book Name Logical Attribute Properties |
| Logical Attribute Name | Book Name |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Book Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Book Name Security Types |
| Name | Current Value |
| Book Name Bound Attachments |
| Name | Current Value |
| Book Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Book Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Book Name |
NO | ||
| IPTSv5 (Oracle) PUBL BOOK_NAME |
NO | ||
| PRPSL (Oracle) PUBL BOOK_NAME |
NO | ||
| PUBL (Oracle) PUBL BOOK_NAME |
NO |
| Book Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Publisher Name |
| Base Entity | Publication |
| Attribute Name | Book Publisher Name |
| Logical Rolename | |
| ColumnName | BOOK_PUB_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Book Publisher Name Logical Attribute Properties |
| Logical Attribute Name | Book Publisher Name |
| Datatype | VARCHAR(256) |
| Nullable | YES |
| Book Publisher Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Book Publisher Name Security Types |
| Name | Current Value |
| Book Publisher Name Bound Attachments |
| Name | Current Value |
| Book Publisher Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Book Publisher Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Book Publisher Name |
NO | ||
| IPTSv5 (Oracle) PUBL BOOK_PUB_NM |
NO | ||
| PRPSL (Oracle) PUBL BOOK_PUB_NM |
NO | ||
| PUBL (Oracle) PUBL BOOK_PUB_NM |
NO |
| Book Publisher Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Publisher Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Publisher Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Book Publisher Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Report Number |
| Base Entity | Publication |
| Attribute Name | Report Number |
| Logical Rolename | |
| ColumnName | REPT_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Report Number Logical Attribute Properties |
| Logical Attribute Name | Report Number |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Report Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Report Number Security Types |
| Name | Current Value |
| Report Number Bound Attachments |
| Name | Current Value |
| Report Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Report Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Report Number |
NO | ||
| IPTSv5 (Oracle) PUBL REPT_NBR |
NO | ||
| PRPSL (Oracle) PUBL REPT_NBR |
NO | ||
| PUBL (Oracle) PUBL REPT_NBR |
NO |
| Report Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Report Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Report Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Report Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier |
| Base Entity | Publication |
| Attribute Name | Institute Identifier |
| Logical Rolename | |
| ColumnName | INST_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Institute Identifer: Abbreviated identifier for a institute. |
| Note |
| Institute Identifier Logical Attribute Properties |
| Logical Attribute Name | Institute Identifier |
| Datatype | INTEGER |
| Nullable | YES |
| Institute Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Institute Identifier Security Types |
| Name | Current Value |
| Institute Identifier Bound Attachments |
| Name | Current Value |
| Institute Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Institute Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Institute Identifier |
NO | ||
| IPTSv5 (Oracle) PUBL INST_ID |
NO | ||
| PRPSL (Oracle) PUBL INST_ID |
NO | ||
| PUBL (Oracle) PUBL INST_ID |
NO |
| Institute Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name |
| Base Entity | Publication |
| Attribute Name | Institute Name |
| Logical Rolename | |
| ColumnName | INST_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Institute Name Logical Attribute Properties |
| Logical Attribute Name | Institute Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Institute Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Institute Name Security Types |
| Name | Current Value |
| Institute Name Bound Attachments |
| Name | Current Value |
| Institute Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Institute Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Institute Name |
NO | ||
| IPTSv5 (Oracle) PUBL INST_NM |
NO | ||
| PRPSL (Oracle) PUBL INST_NM |
NO | ||
| PUBL (Oracle) PUBL INST_NM |
NO |
| Institute Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dissertation Thesis Advisor |
| Base Entity | Publication |
| Attribute Name | Dissertation Thesis Advisor |
| Logical Rolename | |
| ColumnName | DIST_THES_ADVISOR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Dissertation Thesis Advisor Logical Attribute Properties |
| Logical Attribute Name | Dissertation Thesis Advisor |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Dissertation Thesis Advisor Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Dissertation Thesis Advisor Security Types |
| Name | Current Value |
| Dissertation Thesis Advisor Bound Attachments |
| Name | Current Value |
| Dissertation Thesis Advisor Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dissertation Thesis Advisor Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Dissertation Thesis Advisor |
NO | ||
| IPTSv5 (Oracle) PUBL DIST_THES_ADVISOR |
NO | ||
| PRPSL (Oracle) PUBL DIST_THES_ADVISOR |
NO | ||
| PUBL (Oracle) PUBL DIST_THES_ADVISOR |
NO |
| Dissertation Thesis Advisor Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dissertation Thesis Advisor Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dissertation Thesis Advisor Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dissertation Thesis Advisor Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment |
| Base Entity | Publication |
| Attribute Name | Comment |
| Logical Rolename | |
| ColumnName | CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Comment: General comments. |
| Note |
| Comment Logical Attribute Properties |
| Logical Attribute Name | Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Comment Security Types |
| Name | Current Value |
| Comment Bound Attachments |
| Name | Current Value |
| Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Comment |
NO | ||
| IPTSv5 (Oracle) PUBL CMNT |
NO | ||
| PRPSL (Oracle) PUBL CMNT |
NO | ||
| PUBL (Oracle) PUBL CMNT |
NO |
| Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Create Date |
| Base Entity | Publication |
| Attribute Name | Create Date |
| Logical Rolename | |
| ColumnName | CREATE_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Create Date Logical Attribute Properties |
| Logical Attribute Name | Create Date |
| Datatype | DATE |
| Nullable | NO |
| Create Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Create Date Security Types |
| Name | Current Value |
| Create Date Bound Attachments |
| Name | Current Value |
| Create Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Create Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Create Date |
NO | ||
| IPTSv5 (Oracle) PUBL CREATE_DTE |
NO | ||
| PRPSL (Oracle) PUBL CREATE_DTE |
NO | ||
| PUBL (Oracle) PUBL CREATE_DTE |
NO |
| Create Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Create Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Create Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Create Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Userid |
| Base Entity | Publication |
| Attribute Name | Modified By Userid |
| Logical Rolename | |
| ColumnName | MOD_BY_UID |
| RoleName | |
| Domain | Mod By Uid |
| Logical Only | NO |
| Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
| Note |
| Modified By Userid Logical Attribute Properties |
| Logical Attribute Name | Modified By Userid |
| Datatype | VARCHAR(64) |
| Nullable | NO |
| Modified By Userid Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modified By Userid Security Types |
| Name | Current Value |
| Modified By Userid Bound Attachments |
| Name | Current Value |
| Modified By Userid Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modified By Userid Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Modified By Userid |
NO | ||
| IPTSv5 (Oracle) PUBL MOD_BY_UID |
NO | ||
| PRPSL (Oracle) PUBL MOD_BY_UID |
NO | ||
| PUBL (Oracle) PUBL MOD_BY_UID |
NO |
| Modified By Userid Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Userid Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Userid Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Userid Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date |
| Base Entity | Publication |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DATE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Modify Date: The date the entity values were were created or modified. |
| Note |
| Modify Date Logical Attribute Properties |
| Logical Attribute Name | Modify Date |
| Datatype | DATE |
| Nullable | NO |
| Modify Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modify Date Security Types |
| Name | Current Value |
| Modify Date Bound Attachments |
| Name | Current Value |
| Modify Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modify Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Modify Date |
NO | ||
| IPTSv5 (Oracle) PUBL MOD_DATE |
NO | ||
| PRPSL (Oracle) PUBL MOD_DATE |
NO | ||
| PUBL (Oracle) PUBL MOD_DATE |
NO |
| Modify Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submitted By Email Address |
| Base Entity | Publication |
| Attribute Name | Submitted By Email Address |
| Logical Rolename | |
| ColumnName | SUB_BY_EMAIL_ADDR |
| RoleName | |
| Domain | Email Addr |
| Logical Only | NO |
| Definition | Email Address: |
| Note |
| Submitted By Email Address Logical Attribute Properties |
| Logical Attribute Name | Submitted By Email Address |
| Datatype | VARCHAR(75) |
| Nullable | NO |
| Submitted By Email Address Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Submitted By Email Address Security Types |
| Name | Current Value |
| Submitted By Email Address Bound Attachments |
| Name | Current Value |
| Submitted By Email Address Data Movement Rules |
| Name | Type | Rule Text/Value |
| Submitted By Email Address Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Submitted By Email Address |
NO | ||
| IPTSv5 (Oracle) PUBL SUB_BY_EMAIL_ADDR |
NO | ||
| PRPSL (Oracle) PUBL SUB_BY_EMAIL_ADDR |
NO | ||
| PUBL (Oracle) PUBL SUB_BY_EMAIL_ADDR |
NO |
| Submitted By Email Address Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submitted By Email Address Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submitted By Email Address Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Submitted By Email Address Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Name |
| Base Entity | Publication |
| Attribute Name | Other Publication Name |
| Logical Rolename | |
| ColumnName | OTHER_PUBL_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Other Publication Name Logical Attribute Properties |
| Logical Attribute Name | Other Publication Name |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Other Publication Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Other Publication Name Security Types |
| Name | Current Value |
| Other Publication Name Bound Attachments |
| Name | Current Value |
| Other Publication Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Other Publication Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Other Publication Name |
NO | ||
| IPTSv5 (Oracle) PUBL OTHER_PUBL_NM |
NO | ||
| PRPSL (Oracle) PUBL OTHER_PUBL_NM |
NO | ||
| PUBL (Oracle) PUBL OTHER_PUBL_NM |
NO |
| Other Publication Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Comment |
| Base Entity | Publication |
| Attribute Name | Other Publication Comment |
| Logical Rolename | |
| ColumnName | OTHER_PUBL_CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Comment: General comments. |
| Note |
| Other Publication Comment Logical Attribute Properties |
| Logical Attribute Name | Other Publication Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Other Publication Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Other Publication Comment Security Types |
| Name | Current Value |
| Other Publication Comment Bound Attachments |
| Name | Current Value |
| Other Publication Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Other Publication Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication Other Publication Comment |
NO | ||
| IPTSv5 (Oracle) PUBL OTHER_PUBL_CMNT |
NO | ||
| PRPSL (Oracle) PUBL OTHER_PUBL_CMNT |
NO | ||
| PUBL (Oracle) PUBL OTHER_PUBL_CMNT |
NO |
| Other Publication Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Other Publication Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| To Be Confimred Indicator |
| Base Entity | Publication |
| Attribute Name | To Be Confimred Indicator |
| Logical Rolename | |
| ColumnName | TBC_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | To Be Confimred Indicator: Used for some publications which are almost published, but the publisher does not allow citations or any reference before the paper is published officially ( like "Nature") |
| Note |
| To Be Confimred Indicator Logical Attribute Properties |
| Logical Attribute Name | To Be Confimred Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| To Be Confimred Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| To Be Confimred Indicator Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| To Be Confimred Indicator Security Types |
| Name | Current Value |
| To Be Confimred Indicator Bound Attachments |
| Name | Current Value |
| To Be Confimred Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| To Be Confimred Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Publication To Be Confimred Indicator |
NO | ||
| IPTSv5 (Oracle) PUBL TBC_IND |
NO | ||
| PRPSL (Oracle) PUBL TBC_IND |
NO | ||
| PUBL (Oracle) PUBL TBC_IND |
NO |
| To Be Confimred Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| To Be Confimred Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| To Be Confimred Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| To Be Confimred Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |