Publication Identifer 
Base Entity  Publication Stage 
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 Stage
Publication Identifer 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Publication Type Identifer 
Base Entity  Publication Stage 
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 Stage
Publication Type Identifer 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Title 
Base Entity  Publication Stage 
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  YES 

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 Stage
Title 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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 Stage
Status Identifier 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Author 
Base Entity  Publication Stage 
Attribute Name  Author 
Logical Rolename   
ColumnName  AUTH 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Author Logical Attribute Properties 
Logical Attribute Name  Author 
Datatype  VARCHAR(4000) 
Nullable  YES 

Author Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Author Security Types 
Name  Current Value 

Author Bound Attachments 
Name  Current Value 

Author Data Movement Rules 
Name  Type  Rule Text/Value 

Author Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
Author 		 NO     
PUBL (Oracle)
PUBL_STAGE
AUTH 		 NO     

Author Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Author Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Author Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Author Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Publication Volume 
Base Entity  Publication Stage 
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 Stage
Publication Volume 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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 Stage
Publication Page 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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 Stage
Publication Issue 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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  YES 

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 Stage
Publication Year 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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 Stage
Publication Month 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Other Publication Comment 
Base Entity  Publication Stage 
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 Stage
Other Publication Comment 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Other Publication Name 
Base Entity  Publication Stage 
Attribute Name  Other Publication Name 
Logical Rolename   
ColumnName  OTHER_PUBL_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Other Publication Name Logical Attribute Properties 
Logical Attribute Name  Other Publication Name 
Datatype  VARCHAR(256) 
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 Stage
Other Publication Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Digital Object Identifier 
Base Entity  Publication Stage 
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 Stage
Digital Object Identifier 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Conference Identifier 
Base Entity  Publication Stage 
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 Stage
Conference Identifier 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Conference Name 
Base Entity  Publication Stage 
Attribute Name  Conference Name 
Logical Rolename   
ColumnName  CONF_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Conference Name Logical Attribute Properties 
Logical Attribute Name  Conference Name 
Datatype  VARCHAR(120) 
Nullable  YES 

Conference Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Conference Name Security Types 
Name  Current Value 

Conference Name Bound Attachments 
Name  Current Value 

Conference Name Data Movement Rules 
Name  Type  Rule Text/Value 

Conference Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
Conference Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
CONF_NM 		 NO     

Conference Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Conference Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Conference Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Conference Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Conference Proceeding Name 
Base Entity  Publication Stage 
Attribute Name  Conference Proceeding Name 
Logical Rolename   
ColumnName  CONF_PROCED_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Conference Proceeding Name Logical Attribute Properties 
Logical Attribute Name  Conference Proceeding Name 
Datatype  VARCHAR(256) 
Nullable  YES 

Conference Proceeding Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Conference Proceeding Name Security Types 
Name  Current Value 

Conference Proceeding Name Bound Attachments 
Name  Current Value 

Conference Proceeding Name Data Movement Rules 
Name  Type  Rule Text/Value 

Conference Proceeding Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
Conference Proceeding Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
CONF_PROCED_NM 		 NO     

Conference Proceeding Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Conference Proceeding Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Conference Proceeding Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Conference Proceeding Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Book Name 
Base Entity  Publication Stage 
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 Stage
Book Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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 Stage
Book Publisher Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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 Stage
Report Number 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Dissertation Thesis Advisor 
Base Entity  Publication Stage 
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 Stage
Dissertation Thesis Advisor 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Journal Identifier 
Base Entity  Publication Stage 
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 Stage
Journal Identifier 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Journal Name 
Base Entity  Publication Stage 
Attribute Name  Journal Name 
Logical Rolename   
ColumnName  JOURNAL_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition  
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Journal Name Logical Attribute Properties 
Logical Attribute Name  Journal Name 
Datatype  VARCHAR(255) 
Nullable  YES 

Journal Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Journal Name Security Types 
Name  Current Value 

Journal Name Bound Attachments 
Name  Current Value 

Journal Name Data Movement Rules 
Name  Type  Rule Text/Value 

Journal Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
Journal Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
JOURNAL_NM 		 NO     

Journal Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Journal Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Journal Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Journal Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier 
Base Entity  Publication Stage 
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 Stage
Institute Identifier 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 Stage 
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 Stage
Institute Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Comment 
Base Entity  Publication Stage 
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 Stage
Comment 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Other Comment 
Base Entity  Publication Stage 
Attribute Name  Other Comment 
Logical Rolename   
ColumnName  OTHER_CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition  
Comment:  General comments.
 
Note 
 

Other Comment Logical Attribute Properties 
Logical Attribute Name  Other Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

Other Comment Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Other Comment Security Types 
Name  Current Value 

Other Comment Bound Attachments 
Name  Current Value 

Other Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Other Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
Other Comment 		 NO     
PUBL (Oracle)
PUBL_STAGE
OTHER_CMNT 		 NO     

Other Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Other Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Other Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Other Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Comment 
Base Entity  Publication Stage 
Attribute Name  Proposal Identifier Comment 
Logical Rolename   
ColumnName  PRPSL_ID_CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition  
Comment:  General comments.
 
Note 
 

Proposal Identifier Comment Logical Attribute Properties 
Logical Attribute Name  Proposal Identifier Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

Proposal Identifier Comment Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Proposal Identifier Comment Security Types 
Name  Current Value 

Proposal Identifier Comment Bound Attachments 
Name  Current Value 

Proposal Identifier Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Identifier Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
Proposal Identifier Comment 		 NO     
PUBL (Oracle)
PUBL_STAGE
PRPSL_ID_CMNT 		 NO     

Proposal Identifier Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name 
Base Entity  Publication Stage 
Attribute Name  File Name 
Logical Rolename   
ColumnName  FILE_NM 
RoleName   
Domain  File Name 
Logical Only  NO 
Definition  
File Name: An external file system file name.  Often the external file name of data imported into the Rdb, such as EPICS .db files.
 
Note 
 

File Name Logical Attribute Properties 
Logical Attribute Name  File Name 
Datatype  VARCHAR(255) 
Nullable  NO 

File Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

File Name Security Types 
Name  Current Value 

File Name Bound Attachments 
Name  Current Value 

File Name Data Movement Rules 
Name  Type  Rule Text/Value 

File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
File Name 		 NO     
PUBL (Oracle)
PUBL_STAGE
FILE_NM 		 NO     

File Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIME Type 
Base Entity  Publication Stage 
Attribute Name  MIME Type 
Logical Rolename   
ColumnName  MIME_TYPE 
RoleName   
Domain  MIME Type 
Logical Only  NO 
Definition  
MIME Type: Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of e-mail to support:



    * text in character sets other than US-ASCII;

    * non-text attachments;

    * message bodies with multiple parts; and

    * header information in non-ASCII character sets.



MIME's use, however, has grown beyond describing the content of e-mail to describing content type in general.
 
Note 
 

MIME Type Logical Attribute Properties 
Logical Attribute Name  MIME Type 
Datatype  VARCHAR(255) 
Nullable  NO 

MIME Type Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

MIME Type Security Types 
Name  Current Value 

MIME Type Bound Attachments 
Name  Current Value 

MIME Type Data Movement Rules 
Name  Type  Rule Text/Value 

MIME Type Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
MIME Type 		 NO     
PUBL (Oracle)
PUBL_STAGE
MIME_TYPE 		 NO     

MIME Type Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIME Type Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIME Type Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIME Type Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

RSI File Contents 
Base Entity  Publication Stage 
Attribute Name  RSI File Contents 
Logical Rolename   
ColumnName  RSI_FILE_CONTENT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

RSI File Contents Logical Attribute Properties 
Logical Attribute Name  RSI File Contents 
Datatype  VARBINARY/BLOB(50) 
Nullable  NO 

RSI File Contents Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
RSI File Contents Security Types 
Name  Current Value 

RSI File Contents Bound Attachments 
Name  Current Value 

RSI File Contents Data Movement Rules 
Name  Type  Rule Text/Value 

RSI File Contents Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
RSI File Contents 		 NO     
PUBL (Oracle)
PUBL_STAGE
RSI_FILE_CONTENT 		 NO     

RSI File Contents Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RSI File Contents Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RSI File Contents Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RSI File Contents Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Submitted By Email Address 
Base Entity  Publication Stage 
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 Stage
Submitted By Email Address 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Modify Date 
Base Entity  Publication Stage 
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 Stage
Modify Date 		 NO     
PUBL (Oracle)
PUBL_STAGE
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 

Process Code 
Base Entity  Publication Stage 
Attribute Name  Process Code 
Logical Rolename   
ColumnName  PROC_CD 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Process Code Logical Attribute Properties 
Logical Attribute Name  Process Code 
Datatype  CHAR(1) 
Nullable  NO 

Process Code Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   
Process Code Security Types 
Name  Current Value 

Process Code Bound Attachments 
Name  Current Value 

Process Code Data Movement Rules 
Name  Type  Rule Text/Value 

Process Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Stage
Process Code 		 NO     
PUBL (Oracle)
PUBL_STAGE
PROC_CD 		 NO     

Process Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Process Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Process Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Process Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description