PUBL_ID |
Base Object | PUBL |
Attribute Name | Publication Identifer |
ColumnName | PUBL_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
PUBL_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
PUBL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_ID Security Types |
Name | Current Value |
PUBL_ID Bound Attachments |
Name | Current Value |
PUBL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_ID 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 |
PUBL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TITLE |
Base Object | PUBL |
Attribute Name | Title |
ColumnName | TITLE |
Logical Rolename | |
RoleName | |
Domain | Title |
Physical Only | NO |
Definition | |
Note |
TITLE Column Properties |
Datatype | VARCHAR2(1000) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TITLE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1000 |
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 |
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 |
STAT_ID |
Base Object | PUBL |
Attribute Name | Status Identifier |
ColumnName | STAT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Status Identifer: Abbreviated idenfifer for the given status. |
Note |
STAT_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
STAT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
STAT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
STAT_ID Security Types |
Name | Current Value |
STAT_ID Bound Attachments |
Name | Current Value |
STAT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
STAT_ID 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 |
STAT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
STAT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_TYPE_ID |
Base Object | PUBL |
Attribute Name | Publication Type Identifer |
ColumnName | PUBL_TYPE_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Category Identifier: Abbreviated identifier for the user category. |
Note |
PUBL_TYPE_ID Column Properties |
Datatype | VARCHAR2(20) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_TYPE_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
PUBL_TYPE_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_TYPE_ID Security Types |
Name | Current Value |
PUBL_TYPE_ID Bound Attachments |
Name | Current Value |
PUBL_TYPE_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_TYPE_ID 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 |
PUBL_TYPE_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_TYPE_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_TYPE_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_TYPE_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_VOLUME |
Base Object | PUBL |
Attribute Name | Publication Volume |
ColumnName | PUBL_VOLUME |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUBL_VOLUME Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_VOLUME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
PUBL_VOLUME Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_VOLUME Security Types |
Name | Current Value |
PUBL_VOLUME Bound Attachments |
Name | Current Value |
PUBL_VOLUME Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_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 |
PUBL_VOLUME Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_VOLUME Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_VOLUME Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_VOLUME Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_PAGE |
Base Object | PUBL |
Attribute Name | Publication Page |
ColumnName | PUBL_PAGE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUBL_PAGE Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_PAGE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
PUBL_PAGE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_PAGE Security Types |
Name | Current Value |
PUBL_PAGE Bound Attachments |
Name | Current Value |
PUBL_PAGE Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_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 |
PUBL_PAGE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_PAGE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_PAGE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_PAGE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_ISSUE |
Base Object | PUBL |
Attribute Name | Publication Issue |
ColumnName | PUBL_ISSUE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUBL_ISSUE Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_ISSUE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
PUBL_ISSUE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_ISSUE Security Types |
Name | Current Value |
PUBL_ISSUE Bound Attachments |
Name | Current Value |
PUBL_ISSUE Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_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 |
PUBL_ISSUE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_ISSUE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_ISSUE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_ISSUE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_YEAR |
Base Object | PUBL |
Attribute Name | Publication Year |
ColumnName | PUBL_YEAR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUBL_YEAR Column Properties |
Datatype | CHAR(4) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_YEAR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 4 |
Percent Null | 0 |
PUBL_YEAR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_YEAR Security Types |
Name | Current Value |
PUBL_YEAR Bound Attachments |
Name | Current Value |
PUBL_YEAR Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_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 |
PUBL_YEAR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_YEAR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_YEAR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_YEAR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_MONTH |
Base Object | PUBL |
Attribute Name | Publication Month |
ColumnName | PUBL_MONTH |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
PUBL_MONTH Column Properties |
Datatype | VARCHAR2(3) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PUBL_MONTH Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 3 |
Percent Null | 0 |
PUBL_MONTH Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PUBL_MONTH Security Types |
Name | Current Value |
PUBL_MONTH Bound Attachments |
Name | Current Value |
PUBL_MONTH Data Movement Rules |
Name | Type | Rule Text/Value |
PUBL_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 |
PUBL_MONTH Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_MONTH Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_MONTH Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PUBL_MONTH Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DOI |
Base Object | PUBL |
Attribute Name | Digital Object Identifier |
ColumnName | DOI |
Logical Rolename | |
RoleName | |
Domain | URL |
Physical Only | NO |
Definition | Universal Resource Locator: The global address of documents and other resources on the web. |
Note |
DOI Column Properties |
Datatype | VARCHAR2(2048) |
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 |
Logical Publication Digital Object Identifier |
NO | ||
IPTSv5 (Oracle) PUBL DIG_OBJ_ID |
NO | ||
PRPSL (Oracle) PUBL DOI |
NO | ||
PUBL (Oracle) PUBL 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 |
JOURNAL_ID |
Base Object | PUBL |
Attribute Name | Journal Identifier |
ColumnName | JOURNAL_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
JOURNAL_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
JOURNAL_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
JOURNAL_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
JOURNAL_ID Security Types |
Name | Current Value |
JOURNAL_ID Bound Attachments |
Name | Current Value |
JOURNAL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
JOURNAL_ID 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_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
JOURNAL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
JOURNAL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
JOURNAL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CONF_ID |
Base Object | PUBL |
Attribute Name | Conference Identifier |
ColumnName | CONF_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
CONF_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CONF_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
CONF_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CONF_ID Security Types |
Name | Current Value |
CONF_ID Bound Attachments |
Name | Current Value |
CONF_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CONF_ID 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 |
CONF_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CONF_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CONF_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CONF_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROCEED_ID |
Base Object | PUBL |
Attribute Name | Proceeding Identifier |
ColumnName | PROCEED_ID |
Logical Rolename | |
RoleName | |
Domain | Identifier |
Physical Only | NO |
Definition | |
Note |
PROCEED_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PROCEED_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
PROCEED_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PROCEED_ID Security Types |
Name | Current Value |
PROCEED_ID Bound Attachments |
Name | Current Value |
PROCEED_ID Data Movement Rules |
Name | Type | Rule Text/Value |
PROCEED_ID 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 |
PROCEED_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROCEED_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PROCEED_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PROCEED_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BOOK_NAME |
Base Object | PUBL |
Attribute Name | Book Name |
ColumnName | BOOK_NAME |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
BOOK_NAME Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BOOK_NAME Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
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_PUB_NM |
Base Object | PUBL |
Attribute Name | Book Publisher Name |
ColumnName | BOOK_PUB_NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
BOOK_PUB_NM Column Properties |
Datatype | VARCHAR2(256) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BOOK_PUB_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 256 |
Percent Null | 0 |
BOOK_PUB_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BOOK_PUB_NM Security Types |
Name | Current Value |
BOOK_PUB_NM Bound Attachments |
Name | Current Value |
BOOK_PUB_NM Data Movement Rules |
Name | Type | Rule Text/Value |
BOOK_PUB_NM 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_PUB_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BOOK_PUB_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BOOK_PUB_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BOOK_PUB_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
REPT_NBR |
Base Object | PUBL |
Attribute Name | Report Number |
ColumnName | REPT_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
REPT_NBR Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
REPT_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
REPT_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
REPT_NBR Security Types |
Name | Current Value |
REPT_NBR Bound Attachments |
Name | Current Value |
REPT_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
REPT_NBR 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 |
REPT_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
REPT_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
REPT_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
REPT_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID |
Base Object | PUBL |
Attribute Name | Institute Identifier |
ColumnName | INST_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Institute Identifer: Abbreviated identifier for a institute. |
Note |
INST_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INST_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
INST_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INST_ID Security Types |
Name | Current Value |
INST_ID Bound Attachments |
Name | Current Value |
INST_ID Data Movement Rules |
Name | Type | Rule Text/Value |
INST_ID 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 |
INST_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INST_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
INST_NM |
Base Object | PUBL |
Attribute Name | Institute Name |
ColumnName | INST_NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
INST_NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
INST_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
INST_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
INST_NM Security Types |
Name | Current Value |
INST_NM Bound Attachments |
Name | Current Value |
INST_NM Data Movement Rules |
Name | Type | Rule Text/Value |
INST_NM 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 |
INST_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
INST_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
INST_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
INST_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIST_THES_ADVISOR |
Base Object | PUBL |
Attribute Name | Dissertation Thesis Advisor |
ColumnName | DIST_THES_ADVISOR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
DIST_THES_ADVISOR Column Properties |
Datatype | VARCHAR2(120) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DIST_THES_ADVISOR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
DIST_THES_ADVISOR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DIST_THES_ADVISOR Security Types |
Name | Current Value |
DIST_THES_ADVISOR Bound Attachments |
Name | Current Value |
DIST_THES_ADVISOR Data Movement Rules |
Name | Type | Rule Text/Value |
DIST_THES_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 |
DIST_THES_ADVISOR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIST_THES_ADVISOR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
DIST_THES_ADVISOR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
DIST_THES_ADVISOR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT |
Base Object | PUBL |
Attribute Name | Comment |
ColumnName | CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Comment: General comments. |
Note |
CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1024 |
Percent Null | 0 |
CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CMNT Security Types |
Name | Current Value |
CMNT Bound Attachments |
Name | Current Value |
CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
CMNT 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 |
CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE |
Base Object | PUBL |
Attribute Name | Create Date |
ColumnName | CREATE_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
CREATE_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CREATE_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
CREATE_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
CREATE_DTE Security Types |
Name | Current Value |
CREATE_DTE Bound Attachments |
Name | Current Value |
CREATE_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
CREATE_DTE 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_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CREATE_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID |
Base Object | PUBL |
Attribute Name | Modified By Userid |
ColumnName | MOD_BY_UID |
Logical Rolename | |
RoleName | |
Domain | Mod By Uid |
Physical Only | NO |
Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
Note |
MOD_BY_UID Column Properties |
Datatype | VARCHAR2(64) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MOD_BY_UID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
MOD_BY_UID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MOD_BY_UID Security Types |
Name | Current Value |
MOD_BY_UID Bound Attachments |
Name | Current Value |
MOD_BY_UID Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_BY_UID 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 |
MOD_BY_UID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_BY_UID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DATE |
Base Object | PUBL |
Attribute Name | Modify Date |
ColumnName | MOD_DATE |
Logical Rolename | |
RoleName | |
Domain | Modify Date |
Physical Only | NO |
Definition | Modify Date: The date the entity values were were created or modified. |
Note |
MOD_DATE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
MOD_DATE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
MOD_DATE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MOD_DATE Security Types |
Name | Current Value |
MOD_DATE Bound Attachments |
Name | Current Value |
MOD_DATE Data Movement Rules |
Name | Type | Rule Text/Value |
MOD_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 |
MOD_DATE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DATE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DATE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MOD_DATE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUB_BY_EMAIL_ADDR |
Base Object | PUBL |
Attribute Name | Submitted By Email Address |
ColumnName | SUB_BY_EMAIL_ADDR |
Logical Rolename | |
RoleName | |
Domain | Email Addr |
Physical Only | NO |
Definition | Email Address: |
Note |
SUB_BY_EMAIL_ADDR Column Properties |
Datatype | VARCHAR2(75) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SUB_BY_EMAIL_ADDR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 64 |
Percent Null | 0 |
SUB_BY_EMAIL_ADDR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SUB_BY_EMAIL_ADDR Security Types |
Name | Current Value |
SUB_BY_EMAIL_ADDR Bound Attachments |
Name | Current Value |
SUB_BY_EMAIL_ADDR Data Movement Rules |
Name | Type | Rule Text/Value |
SUB_BY_EMAIL_ADDR 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 |
SUB_BY_EMAIL_ADDR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUB_BY_EMAIL_ADDR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUB_BY_EMAIL_ADDR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUB_BY_EMAIL_ADDR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_NM |
Base Object | PUBL |
Attribute Name | Other Publication Name |
ColumnName | OTHER_PUBL_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
OTHER_PUBL_NM Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OTHER_PUBL_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 25 |
Percent Null | 0 |
OTHER_PUBL_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OTHER_PUBL_NM Security Types |
Name | Current Value |
OTHER_PUBL_NM Bound Attachments |
Name | Current Value |
OTHER_PUBL_NM Data Movement Rules |
Name | Type | Rule Text/Value |
OTHER_PUBL_NM 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_PUBL_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_CMNT |
Base Object | PUBL |
Attribute Name | Other Publication Comment |
ColumnName | OTHER_PUBL_CMNT |
Logical Rolename | |
RoleName | |
Domain | Comment |
Physical Only | NO |
Definition | Comment: General comments. |
Note |
OTHER_PUBL_CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OTHER_PUBL_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
OTHER_PUBL_CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OTHER_PUBL_CMNT Security Types |
Name | Current Value |
OTHER_PUBL_CMNT Bound Attachments |
Name | Current Value |
OTHER_PUBL_CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
OTHER_PUBL_CMNT 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_PUBL_CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OTHER_PUBL_CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
TBC_IND |
Base Object | PUBL |
Attribute Name | To Be Confimred Indicator |
ColumnName | TBC_IND |
Logical Rolename | |
RoleName | |
Domain | Indicator |
Physical 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 |
TBC_IND Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
TBC_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
TBC_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
TBC_IND 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 |
TBC_IND Security Types |
Name | Current Value |
TBC_IND Bound Attachments |
Name | Current Value |
TBC_IND Data Movement Rules |
Name | Type | Rule Text/Value |
TBC_IND 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 |
TBC_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
TBC_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
TBC_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
TBC_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |