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 

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 

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  Status Identifier 
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 

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  Publication Type Identifer 
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 

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 

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 

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 

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 
Percent Null 

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 
Percent Null 

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 

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  Journal Identifier 
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 

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  Conference Identifier 
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  25 
Percent Null 

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 

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  120 
Percent Null 

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  120 
Percent Null 

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 

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  Institute Identifier 
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 

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 

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 

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 

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 
Percent Null 

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 

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 
Percent Null 

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 

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 

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 

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 
Percent Null 

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 
Yes 
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