Proposal Identifier 
Base Entity  Proposal 
Attribute Name  Proposal Identifier 
Logical Rolename   
ColumnName  PRPSL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Proposal Identifier Logical Attribute Properties 
Logical Attribute Name  Proposal Identifier 
Datatype  NUMERIC(10, 0) 
Nullable  NO 

Proposal Identifier Domain Restrictions 

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

Proposal Identifier Bound Attachments 
Name  Current Value 

Proposal Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Identifier 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
PRPSL_ID 		 NO     
EXPRESS (Oracle)
PROPOSAL
PRPSL_ID 		 NO     
IPTSv5 (Oracle)
PROPOSAL
PRPSL_ID 		 NO     
PRPSL (Oracle)
PROPOSAL
PRPSL_ID 		 NO     
PUBL (Oracle)
PROPOSAL
PRPSL_ID 		 NO     
SMPL (Oracle)
PROPOSAL
PRPSL_ID 		 NO     

Proposal Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Date 
Base Entity  Proposal 
Attribute Name  Proposal Date 
Logical Rolename   
ColumnName  PRPSL_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
 
Note 
 

Proposal Date Logical Attribute Properties 
Logical Attribute Name  Proposal Date 
Datatype  DATE 
Nullable  NO 

Proposal Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Proposal Date Security Types 
Name  Current Value 

Proposal Date Bound Attachments 
Name  Current Value 

Proposal Date Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Date 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
PRPSL_DTE 		 NO     
EXPRESS (Oracle)
PROPOSAL
PRPSL_DTE 		 NO     
IPTSv5 (Oracle)
PROPOSAL
PRPSL_DTE 		 NO     
PRPSL (Oracle)
PROPOSAL
PRPSL_DTE 		 NO     
PUBL (Oracle)
PROPOSAL
PRPSL_DTE 		 NO     
SMPL (Oracle)
PROPOSAL
PRPSL_DTE 		 NO     

Proposal Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier 
Base Entity  Proposal 
Attribute Name  Person Identifier 
Logical Rolename   
ColumnName  PERSON_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Note 
 

Person Identifier Logical Attribute Properties 
Logical Attribute Name  Person Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Person Identifier Domain Restrictions 

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

Person Identifier Bound Attachments 
Name  Current Value 

Person Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Person Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Person Identifier 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
PERSON_ID 		 NO     
EXPRESS (Oracle)
PROPOSAL
PERSON_ID 		 NO     
IPTSv5 (Oracle)
PROPOSAL
PERSON_ID 		 NO     
PRPSL (Oracle)
PROPOSAL
PERSON_ID 		 NO     
PUBL (Oracle)
PROPOSAL
PERSON_ID 		 NO     
SMPL (Oracle)
PROPOSAL
PERSON_ID 		 NO     

Person Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Institute Identifier 
Base Entity  Proposal 
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  NO 

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
Proposal
Institute Identifier 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
INST_ID 		 NO     
EXPRESS (Oracle)
PROPOSAL
INST_ID 		 NO     
IPTSv5 (Oracle)
PROPOSAL
INST_ID 		 NO     
PRPSL (Oracle)
PROPOSAL
INST_ID 		 NO     
PUBL (Oracle)
PROPOSAL
INST_ID 		 NO     
SMPL (Oracle)
PROPOSAL
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 

Proposal Type Identifer 
Base Entity  Proposal 
Attribute Name  Proposal Type Identifer 
Logical Rolename   
ColumnName  PRPSL_TYPE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Proposal Type Identifer Logical Attribute Properties 
Logical Attribute Name  Proposal Type Identifer 
Datatype  VARCHAR(20) 
Nullable  NO 

Proposal Type Identifer Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Proposal Type Identifer Security Types 
Name  Current Value 

Proposal Type Identifer Bound Attachments 
Name  Current Value 

Proposal Type Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Type Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Type Identifer 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
PRPSL_TYPE_ID 		 NO     
EXPRESS (Oracle)
PROPOSAL
PRPSL_TYPE_ID 		 NO     
IPTSv5 (Oracle)
PROPOSAL
PRPSL_TYPE_ID 		 NO     
PRPSL (Oracle)
PROPOSAL
PRPSL_TYPE_ID 		 NO     
PUBL (Oracle)
PROPOSAL
PRPSL_TYPE_ID 		 NO     
SMPL (Oracle)
PROPOSAL
PRPSL_TYPE_ID 		 NO     

Proposal Type Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier 
Base Entity  Proposal 
Attribute Name  Status Identifier 
Logical Rolename   
ColumnName  STAT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Status Identifier Logical Attribute Properties 
Logical Attribute Name  Status Identifier 
Datatype  VARCHAR(20) 
Nullable  NO 

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
Proposal
Status Identifier 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
STAT_ID 		 NO     
EXPRESS (Oracle)
PROPOSAL
STAT_ID 		 NO     
IPTSv5 (Oracle)
PROPOSAL
STAT_ID 		 NO     
PRPSL (Oracle)
PROPOSAL
STAT_ID 		 NO     
PUBL (Oracle)
PROPOSAL
STAT_ID 		 NO     
SMPL (Oracle)
PROPOSAL
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 

Abstract 
Base Entity  Proposal 
Attribute Name  Abstract 
Logical Rolename   
ColumnName  ABSTR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

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

Abstract Domain Restrictions 

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

Abstract Bound Attachments 
Name  Current Value 

Abstract Data Movement Rules 
Name  Type  Rule Text/Value 

Abstract Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Abstract 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
ABSTR 		 NO     
EXPRESS (Oracle)
PROPOSAL
ABSTR 		 NO     
IPTSv5 (Oracle)
PROPOSAL
ABSTR 		 NO     
PRPSL (Oracle)
PROPOSAL
ABSTR 		 NO     
PUBL (Oracle)
PROPOSAL
ABSTR 		 NO     
SMPL (Oracle)
PROPOSAL
ABSTR 		 NO     

Abstract Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Abstract Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Abstract Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Abstract Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

TItle 
Base Entity  Proposal 
Attribute Name  TItle 
Logical Rolename   
ColumnName  TITLE 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

TItle Logical Attribute Properties 
Logical Attribute Name  TItle 
Datatype  VARCHAR(128) 
Nullable  NO 

TItle Domain Restrictions 

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

TItle Bound Attachments 
Name  Current Value 

TItle Data Movement Rules 
Name  Type  Rule Text/Value 

TItle Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
TItle 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
TITLE 		 NO     
EXPRESS (Oracle)
PROPOSAL
TITLE 		 NO     
IPTSv5 (Oracle)
PROPOSAL
TITLE 		 NO     
PRPSL (Oracle)
PROPOSAL
TITLE 		 NO     
PUBL (Oracle)
PROPOSAL
TITLE 		 NO     
SMPL (Oracle)
PROPOSAL
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 

Statement of Research 
Base Entity  Proposal 
Attribute Name  Statement of Research 
Logical Rolename   
ColumnName  STMT_OF_RESCH 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Statement of Research Logical Attribute Properties 
Logical Attribute Name  Statement of Research 
Datatype  VARBINARY/BLOB(1) 
Nullable  YES 

Statement of Research Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Statement of Research Security Types 
Name  Current Value 

Statement of Research Bound Attachments 
Name  Current Value 

Statement of Research Data Movement Rules 
Name  Type  Rule Text/Value 

Statement of Research Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Statement of Research 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
STMT_OF_RESCH 		 NO     
EXPRESS (Oracle)
PROPOSAL
STMT_OF_RESCH 		 NO     
IPTSv5 (Oracle)
PROPOSAL
STMT_OF_RESCH 		 NO     
PRPSL (Oracle)
PROPOSAL
STMT_OF_RESCH 		 NO     
PUBL (Oracle)
PROPOSAL
STMT_OF_RESCH 		 NO     
SMPL (Oracle)
PROPOSAL
STMT_OF_RESCH 		 NO     

Statement of Research Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Related Proposals 
Base Entity  Proposal 
Attribute Name  Related Proposals 
Logical Rolename   
ColumnName  REL_PRPSL 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Related Proposals Logical Attribute Properties 
Logical Attribute Name  Related Proposals 
Datatype  VARCHAR(2000) 
Nullable  YES 

Related Proposals Domain Restrictions 

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

Related Proposals Bound Attachments 
Name  Current Value 

Related Proposals Data Movement Rules 
Name  Type  Rule Text/Value 

Related Proposals Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Related Proposals 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
REL_PRPSL 		 NO     
EXPRESS (Oracle)
PROPOSAL
REL_PRPSL 		 NO     
IPTSv5 (Oracle)
PROPOSAL
REL_PRPSL 		 NO     
PRPSL (Oracle)
PROPOSAL
REL_PRPSL 		 NO     
PUBL (Oracle)
PROPOSAL
REL_PRPSL 		 NO     
SMPL (Oracle)
PROPOSAL
REL_PRPSL 		 NO     

Related Proposals Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Related Proposals Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Related Proposals Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Related Proposals Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proprietary Data Indicator 
Base Entity  Proposal 
Attribute Name  Proprietary Data Indicator 
Logical Rolename   
ColumnName  PROP_DATA_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Proprietary Data Indicator Logical Attribute Properties 
Logical Attribute Name  Proprietary Data Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Proprietary Data Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Proprietary Data Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Proprietary Data Indicator Security Types 
Name  Current Value 

Proprietary Data Indicator Bound Attachments 
Name  Current Value 

Proprietary Data Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Proprietary Data Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proprietary Data Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
PROP_DATA_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
PROP_DATA_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
PROP_DATA_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
PROP_DATA_IND 		 NO     
PUBL (Oracle)
PROPOSAL
PROP_DATA_IND 		 NO     
SMPL (Oracle)
PROPOSAL
PROP_DATA_IND 		 NO     

Proprietary Data Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proprietary Data Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proprietary Data Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proprietary Data Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Classified Data Indicator 
Base Entity  Proposal 
Attribute Name  Classified Data Indicator 
Logical Rolename   
ColumnName  CLASS_DATA_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Classified Data Indicator Logical Attribute Properties 
Logical Attribute Name  Classified Data Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Classified Data Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Classified Data Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Classified Data Indicator Security Types 
Name  Current Value 

Classified Data Indicator Bound Attachments 
Name  Current Value 

Classified Data Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Classified Data Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Classified Data Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
CLASS_DATA_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
CLASS_DATA_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
CLASS_DATA_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
CLASS_DATA_IND 		 NO     
PUBL (Oracle)
PROPOSAL
CLASS_DATA_IND 		 NO     
SMPL (Oracle)
PROPOSAL
CLASS_DATA_IND 		 NO     

Classified Data Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Classified Data Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Classified Data Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Classified Data Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Student Thesis Indicator 
Base Entity  Proposal 
Attribute Name  Student Thesis Indicator 
Logical Rolename   
ColumnName  STUD_THESIS_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Student Thesis Indicator Logical Attribute Properties 
Logical Attribute Name  Student Thesis Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Student Thesis Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Student Thesis Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Student Thesis Indicator Security Types 
Name  Current Value 

Student Thesis Indicator Bound Attachments 
Name  Current Value 

Student Thesis Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Student Thesis Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Student Thesis Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
STUD_THESIS_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
STUD_THESIS_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
STUD_THESIS_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
STUD_THESIS_IND 		 NO     
PUBL (Oracle)
PROPOSAL
STUD_THESIS_IND 		 NO     
SMPL (Oracle)
PROPOSAL
STUD_THESIS_IND 		 NO     

Student Thesis Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Student Thesis Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Student Thesis Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Student Thesis Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name 
Base Entity  Proposal 
Attribute Name  Statement of Research File Name 
Logical Rolename   
ColumnName  SOR_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 
 

Statement of Research File Name Logical Attribute Properties 
Logical Attribute Name  Statement of Research File Name 
Datatype  VARCHAR(255) 
Nullable  YES 

Statement of Research File Name Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Statement of Research File Name Security Types 
Name  Current Value 

Statement of Research File Name Bound Attachments 
Name  Current Value 

Statement of Research File Name Data Movement Rules 
Name  Type  Rule Text/Value 

Statement of Research File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Statement of Research File Name 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
SOR_FILE_NM 		 NO     
EXPRESS (Oracle)
PROPOSAL
SOR_FILE_NM 		 NO     
IPTSv5 (Oracle)
PROPOSAL
SOR_FILE_NM 		 NO     
PRPSL (Oracle)
PROPOSAL
SOR_FILE_NM 		 NO     
PUBL (Oracle)
PROPOSAL
SOR_FILE_NM 		 NO     
SMPL (Oracle)
PROPOSAL
SOR_FILE_NM 		 NO     

Statement of Research File Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type 
Base Entity  Proposal 
Attribute Name  Statement of Research MIME Type 
Logical Rolename   
ColumnName  SOR_MIMETYPE 
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 
 

Statement of Research MIME Type Logical Attribute Properties 
Logical Attribute Name  Statement of Research MIME Type 
Datatype  VARCHAR(255) 
Nullable  YES 

Statement of Research MIME Type Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'application/pdf' 
Bound Default   

Statement of Research MIME Type Security Types 
Name  Current Value 

Statement of Research MIME Type Bound Attachments 
Name  Current Value 

Statement of Research MIME Type Data Movement Rules 
Name  Type  Rule Text/Value 

Statement of Research MIME Type Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Statement of Research MIME Type 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
SOR_MIMETYPE 		 NO     
EXPRESS (Oracle)
PROPOSAL
SOR_MIMETYPE 		 NO     
IPTSv5 (Oracle)
PROPOSAL
SOR_MIMETYPE 		 NO     
PRPSL (Oracle)
PROPOSAL
SOR_MIMETYPE 		 NO     
PUBL (Oracle)
PROPOSAL
SOR_MIMETYPE 		 NO     
SMPL (Oracle)
PROPOSAL
SOR_MIMETYPE 		 NO     

Statement of Research MIME Type Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Statement of Research MIME Type Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Indicator 
Base Entity  Proposal 
Attribute Name  Experiment Complete Indicator 
Logical Rolename   
ColumnName  EXPT_CMPLT_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Experiment Complete Indicator Logical Attribute Properties 
Logical Attribute Name  Experiment Complete Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Experiment Complete Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Experiment Complete Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Experiment Complete Indicator Security Types 
Name  Current Value 

Experiment Complete Indicator Bound Attachments 
Name  Current Value 

Experiment Complete Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Experiment Complete Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Experiment Complete Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
EXPT_CMPLT_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
EXPT_CMPLT_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
EXPT_CMPLT_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
EXPT_CMPLT_IND 		 NO     
PUBL (Oracle)
PROPOSAL
EXPT_CMPLT_IND 		 NO     
SMPL (Oracle)
PROPOSAL
EXPT_CMPLT_IND 		 NO     

Experiment Complete Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Comment 
Base Entity  Proposal 
Attribute Name  Experiment Complete Comment 
Logical Rolename   
ColumnName  EXPT_CMPLT_CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition  
Comment:  General comments.
 
Note 
 

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

Experiment Complete Comment Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Experiment Complete Comment Security Types 
Name  Current Value 

Experiment Complete Comment Bound Attachments 
Name  Current Value 

Experiment Complete Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Experiment Complete Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Experiment Complete Comment 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
EXPT_CMPLT_CMNT 		 NO     
EXPRESS (Oracle)
PROPOSAL
EXPT_CMPLT_CMNT 		 NO     
IPTSv5 (Oracle)
PROPOSAL
EXPT_CMPLT_CMNT 		 NO     
PRPSL (Oracle)
PROPOSAL
EXPT_CMPLT_CMNT 		 NO     
PUBL (Oracle)
PROPOSAL
EXPT_CMPLT_CMNT 		 NO     
SMPL (Oracle)
PROPOSAL
EXPT_CMPLT_CMNT 		 NO     

Experiment Complete Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Complete Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Indicator 
Base Entity  Proposal 
Attribute Name  Export Control Indicator 
Logical Rolename   
ColumnName  EXP_CONTR_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Export Control Indicator Logical Attribute Properties 
Logical Attribute Name  Export Control Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Export Control Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Export Control Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Export Control Indicator Security Types 
Name  Current Value 

Export Control Indicator Bound Attachments 
Name  Current Value 

Export Control Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Export Control Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Export Control Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
EXP_CONTR_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
EXP_CONTR_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
EXP_CONTR_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
EXP_CONTR_IND 		 NO     
PUBL (Oracle)
PROPOSAL
EXP_CONTR_IND 		 NO     
SMPL (Oracle)
PROPOSAL
EXP_CONTR_IND 		 NO     

Export Control Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Prohibited Indicator 
Base Entity  Proposal 
Attribute Name  Export Control Prohibited Indicator 
Logical Rolename   
ColumnName  EXP_CONTR_PROHIB_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Export Control Prohibited Indicator Logical Attribute Properties 
Logical Attribute Name  Export Control Prohibited Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Export Control Prohibited Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Export Control Prohibited Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Export Control Prohibited Indicator Security Types 
Name  Current Value 

Export Control Prohibited Indicator Bound Attachments 
Name  Current Value 

Export Control Prohibited Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Export Control Prohibited Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Export Control Prohibited Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
EXP_CONTR_PROHIB_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
EXP_CONTR_PROHIB_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
EXP_CONTR_PROHIB_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
EXP_CONTR_PROHIB_IND 		 NO     
PUBL (Oracle)
PROPOSAL
EXP_CONTR_PROHIB_IND 		 NO     
SMPL (Oracle)
PROPOSAL
EXP_CONTR_PROHIB_IND 		 NO     

Export Control Prohibited Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Prohibited Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Prohibited Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Export Control Prohibited Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Staff Technical Assistance Indicator 
Base Entity  Proposal 
Attribute Name  Staff Technical Assistance Indicator 
Logical Rolename   
ColumnName  STAFF_TECH_ASST_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Staff Technical Assistance Indicator Logical Attribute Properties 
Logical Attribute Name  Staff Technical Assistance Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Staff Technical Assistance Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Staff Technical Assistance Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Staff Technical Assistance Indicator Security Types 
Name  Current Value 

Staff Technical Assistance Indicator Bound Attachments 
Name  Current Value 

Staff Technical Assistance Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Staff Technical Assistance Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Staff Technical Assistance Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
STAFF_TECH_ASST_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
STAFF_TECH_ASST_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
STAFF_TECH_ASST_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
STAFF_TECH_ASST_IND 		 NO     
PUBL (Oracle)
PROPOSAL
STAFF_TECH_ASST_IND 		 NO     
SMPL (Oracle)
PROPOSAL
STAFF_TECH_ASST_IND 		 NO     

Staff Technical Assistance Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Staff Technical Assistance Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Staff Technical Assistance Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Staff Technical Assistance Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Scientist Contacted Indicator 
Base Entity  Proposal 
Attribute Name  Instrument Scientist Contacted Indicator 
Logical Rolename   
ColumnName  INSTR_SCI_CONT_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Instrument Scientist Contacted Indicator Logical Attribute Properties 
Logical Attribute Name  Instrument Scientist Contacted Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Instrument Scientist Contacted Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Instrument Scientist Contacted Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Instrument Scientist Contacted Indicator Security Types 
Name  Current Value 

Instrument Scientist Contacted Indicator Bound Attachments 
Name  Current Value 

Instrument Scientist Contacted Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Instrument Scientist Contacted Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Instrument Scientist Contacted Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
INSTR_SCI_CONT_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
INSTR_SCI_CONT_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
INSTR_SCI_CONT_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
INSTR_SCI_CONT_IND 		 NO     
PUBL (Oracle)
PROPOSAL
INSTR_SCI_CONT_IND 		 NO     
SMPL (Oracle)
PROPOSAL
INSTR_SCI_CONT_IND 		 NO     

Instrument Scientist Contacted Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Scientist Contacted Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Scientist Contacted Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Scientist Contacted Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Resubmit Indicator 
Base Entity  Proposal 
Attribute Name  Resubmit Indicator 
Logical Rolename   
ColumnName  RESUB_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Resubmit Indicator Logical Attribute Properties 
Logical Attribute Name  Resubmit Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Resubmit Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Resubmit Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Resubmit Indicator Security Types 
Name  Current Value 

Resubmit Indicator Bound Attachments 
Name  Current Value 

Resubmit Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Resubmit Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Resubmit Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
RESUB_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
RESUB_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
RESUB_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
RESUB_IND 		 NO     
PUBL (Oracle)
PROPOSAL
RESUB_IND 		 NO     
SMPL (Oracle)
PROPOSAL
RESUB_IND 		 NO     

Resubmit Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Resubmit Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Resubmit Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Resubmit Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Continuation Indicator 
Base Entity  Proposal 
Attribute Name  Proposal Continuation Indicator 
Logical Rolename   
ColumnName  PRPSL_CONT_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Proposal Continuation Indicator Logical Attribute Properties 
Logical Attribute Name  Proposal Continuation Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Proposal Continuation Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Proposal Continuation Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Proposal Continuation Indicator Security Types 
Name  Current Value 

Proposal Continuation Indicator Bound Attachments 
Name  Current Value 

Proposal Continuation Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Continuation Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Continuation Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
PRPSL_CONT_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
PRPSL_CONT_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
PRPSL_CONT_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
PRPSL_CONT_IND 		 NO     
PUBL (Oracle)
PROPOSAL
PRPSL_CONT_IND 		 NO     
SMPL (Oracle)
PROPOSAL
PRPSL_CONT_IND 		 NO     

Proposal Continuation Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Continuation Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Continuation Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Continuation Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

NScD Publication 
Base Entity  Proposal 
Attribute Name  NScD Publication 
Logical Rolename   
ColumnName  NSCD_PUBL 
RoleName   
Domain  Text 
Logical Only  NO 
Definition  
NScD Publication: When the pulbication for consideration is not in the PSUH system then the proposal creator will enter the publication(s) here.
 
Note 
 

NScD Publication Logical Attribute Properties 
Logical Attribute Name  NScD Publication 
Datatype  VARCHAR(4000) 
Nullable  YES 

NScD Publication Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NScD Publication Security Types 
Name  Current Value 

NScD Publication Bound Attachments 
Name  Current Value 

NScD Publication Data Movement Rules 
Name  Type  Rule Text/Value 

NScD Publication Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
NScD Publication 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
NSCD_PUBL 		 NO     
EXPRESS (Oracle)
PROPOSAL
NSCD_PUBL 		 NO     
IPTSv5 (Oracle)
PROPOSAL
NSCD_PUBL 		 NO     
PRPSL (Oracle)
PROPOSAL
NSCD_PUBL 		 NO     
PUBL (Oracle)
PROPOSAL
NSCD_PUBL 		 NO     
SMPL (Oracle)
PROPOSAL
NSCD_PUBL 		 NO     

NScD Publication Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NScD Publication Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NScD Publication Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NScD Publication Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date 
Base Entity  Proposal 
Attribute Name  Modify Date 
Logical Rolename   
ColumnName  MOD_DATE 
RoleName   
Domain  Modify Date 
Logical Only  NO 
Definition 
 
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
Proposal
Modify Date 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
MOD_DATE 		 NO     
EXPRESS (Oracle)
PROPOSAL
MOD_DATE 		 NO     
IPTSv5 (Oracle)
PROPOSAL
MOD_DATE 		 NO     
PRPSL (Oracle)
PROPOSAL
MOD_DATE 		 NO     
PUBL (Oracle)
PROPOSAL
MOD_DATE 		 NO     
SMPL (Oracle)
PROPOSAL
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 

Relevant Publication Indicator 
Base Entity  Proposal 
Attribute Name  Relevant Publication Indicator 
Logical Rolename   
ColumnName  RELV_PUBL_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition  
Relevant Publication Indicator: If No then the PI had no relevant publications to be considered for the proposal review.
 
Note 
 

Relevant Publication Indicator Logical Attribute Properties 
Logical Attribute Name  Relevant Publication Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Relevant Publication Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Relevant Publication Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Relevant Publication Indicator Security Types 
Name  Current Value 

Relevant Publication Indicator Bound Attachments 
Name  Current Value 

Relevant Publication Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Relevant Publication Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Relevant Publication Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
RELV_PUBL_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
RELV_PUBL_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
RELV_PUBL_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
RELV_PUBL_IND 		 NO     
PUBL (Oracle)
PROPOSAL
RELV_PUBL_IND 		 NO     
SMPL (Oracle)
PROPOSAL
RELV_PUBL_IND 		 NO     

Relevant Publication Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Relevant Publication Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Relevant Publication Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Relevant Publication Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Indicator 
Base Entity  Proposal 
Attribute Name  Neutron School Indicator 
Logical Rolename   
ColumnName  NX_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition  
Neutron School Indicator:Indicates this proposal was used for the Neutron School training.
 
Note 
 

Neutron School Indicator Logical Attribute Properties 
Logical Attribute Name  Neutron School Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Neutron School Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Neutron School Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Neutron School Indicator Security Types 
Name  Current Value 

Neutron School Indicator Bound Attachments 
Name  Current Value 

Neutron School Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Neutron School Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Neutron School Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
NX_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
NX_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
NX_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
NX_IND 		 NO     
PUBL (Oracle)
PROPOSAL
NX_IND 		 NO     
SMPL (Oracle)
PROPOSAL
NX_IND 		 NO     

Neutron School Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron School Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Discretionary Time Category Identifier 
Base Entity  Proposal 
Attribute Name  Discretionary Time Category Identifier 
Logical Rolename   
ColumnName  DISCRET_TIME_CAT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Discretionary Time Category Identifier Logical Attribute Properties 
Logical Attribute Name  Discretionary Time Category Identifier 
Datatype  VARCHAR(10) 
Nullable  YES 

Discretionary Time Category Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Discretionary Time Category Identifier Security Types 
Name  Current Value 

Discretionary Time Category Identifier Bound Attachments 
Name  Current Value 

Discretionary Time Category Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Discretionary Time Category Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Discretionary Time Category Identifier 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
DISCRET_TIME_CAT_ID 		 NO     
EXPRESS (Oracle)
PROPOSAL
DISCRET_TIME_CAT_ID 		 NO     
IPTSv5 (Oracle)
PROPOSAL
DISCRET_TIME_CAT_ID 		 NO     
PRPSL (Oracle)
PROPOSAL
DISCRET_TIME_CAT_ID 		 NO     
PUBL (Oracle)
PROPOSAL
DISCRET_TIME_CAT_ID 		 NO     
SMPL (Oracle)
PROPOSAL
DISCRET_TIME_CAT_ID 		 NO     

Discretionary Time Category Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Discretionary Time Category Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Discretionary Time Category Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Discretionary Time Category Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator 
Base Entity  Proposal 
Attribute Name  Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator 
Logical Rolename   
ColumnName  CRADA_SPP_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Logical Attribute Properties 
Logical Attribute Name  Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator 
Datatype  CHAR(1) 
Nullable  YES 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Y  Yes 
N  No 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Security Types 
Name  Current Value 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Bound Attachments 
Name  Current Value 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator 		 NO     
CNMS_PRPSL (Oracle)
PROPOSAL
CRADA_SPP_IND 		 NO     
EXPRESS (Oracle)
PROPOSAL
CRADA_SPP_IND 		 NO     
IPTSv5 (Oracle)
PROPOSAL
CRADA_SPP_IND 		 NO     
PRPSL (Oracle)
PROPOSAL
CRADA_SPP_IND 		 NO     
PUBL (Oracle)
PROPOSAL
CRADA_SPP_IND 		 NO     
SMPL (Oracle)
PROPOSAL
CRADA_SPP_IND 		 NO     

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cooperative Research and Development Agreement or Security and Prosperity Partnership Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description