PUBL_ID 
Base Object  PUB_AUTHOR_ASSC 
Attribute Name  Publication Identifer 
ColumnName  PUBL_ID 
Logical Rolename  Publication Identifer 
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 Author Association
Publication Identifer 
NO     
PUBL (Oracle)
PUB_AUTHOR_ASSC
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 


AUTHOR_ID 
Base Object  PUB_AUTHOR_ASSC 
Attribute Name  Author Identifier 
ColumnName  AUTHOR_ID 
Logical Rolename  Author Identifier 
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Note 
 

AUTHOR_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

AUTHOR_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

AUTHOR_ID Security Types 
Name  Current Value 

AUTHOR_ID Bound Attachments 
Name  Current Value 

AUTHOR_ID Data Movement Rules 
Name  Type  Rule Text/Value 

AUTHOR_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Author Association
Author Identifier 
NO     
PUBL (Oracle)
PUB_AUTHOR_ASSC
AUTHOR_ID 
NO     

AUTHOR_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AUTHOR_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AUTHOR_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AUTHOR_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RANK 
Base Object  PUB_AUTHOR_ASSC 
Attribute Name  Rank 
ColumnName  RANK 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

RANK Column Properties 
Datatype  NUMBER(4, 2) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

RANK Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

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

RANK Security Types 
Name  Current Value 

RANK Bound Attachments 
Name  Current Value 

RANK Data Movement Rules 
Name  Type  Rule Text/Value 

RANK Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Author Association
Rank 
NO     
PUBL (Oracle)
PUB_AUTHOR_ASSC
RANK 
NO     

RANK Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RANK Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RANK Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RANK Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


HFIR_IND 
Base Object  PUB_AUTHOR_ASSC 
Attribute Name  HFIR Indicator 
ColumnName  HFIR_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

HFIR_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

HFIR_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

HFIR_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

HFIR_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 

HFIR_IND Security Types 
Name  Current Value 

HFIR_IND Bound Attachments 
Name  Current Value 

HFIR_IND Data Movement Rules 
Name  Type  Rule Text/Value 

HFIR_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Author Association
HFIR Indicator 
NO     
PUBL (Oracle)
PUB_AUTHOR_ASSC
HFIR_IND 
NO     

HFIR_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

HFIR_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SNS_IND 
Base Object  PUB_AUTHOR_ASSC 
Attribute Name  SNS Indicator 
ColumnName  SNS_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

SNS_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SNS_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

SNS_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

SNS_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 

SNS_IND Security Types 
Name  Current Value 

SNS_IND Bound Attachments 
Name  Current Value 

SNS_IND Data Movement Rules 
Name  Type  Rule Text/Value 

SNS_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Author Association
SNS Indicator 
NO     
PUBL (Oracle)
PUB_AUTHOR_ASSC
SNS_IND 
NO     

SNS_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SNS_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SNS_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INST_ID 
Base Object  PUB_AUTHOR_ASSC 
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 

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 Author Association
Institute Identifier 
NO     
PUBL (Oracle)
PUB_AUTHOR_ASSC
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 


NSCD_DIV_ID 
Base Object  PUB_AUTHOR_ASSC 
Attribute Name  NSCD Division Identifier 
ColumnName  NSCD_DIV_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

NSCD_DIV_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

NSCD_DIV_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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

NSCD_DIV_ID Security Types 
Name  Current Value 

NSCD_DIV_ID Bound Attachments 
Name  Current Value 

NSCD_DIV_ID Data Movement Rules 
Name  Type  Rule Text/Value 

NSCD_DIV_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Publication Author Association
NSCD Division Identifier 
NO     
PUBL (Oracle)
PUB_AUTHOR_ASSC
NSCD_DIV_ID 
NO     

NSCD_DIV_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD_DIV_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD_DIV_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD_DIV_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description