PRPSL_ID 
Base Object  PROPOSAL 
Attribute Name  Proposal Identifier 
ColumnName  PRPSL_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

PRPSL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  6 
Percent Null  0 

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

PRPSL_ID Security Types 
Name  Current Value 

PRPSL_ID Bound Attachments 
Name  Current Value 

PRPSL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Identifier 		 NO     
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     

PRPSL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_DTE 
Base Object  PROPOSAL 
Attribute Name  Proposal Date 
ColumnName  PRPSL_DTE 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition 
 
Note 
 

PRPSL_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PRPSL_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

PRPSL_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

PRPSL_DTE Security Types 
Name  Current Value 

PRPSL_DTE Bound Attachments 
Name  Current Value 

PRPSL_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_DTE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Date 		 NO     
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     

PRPSL_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

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

PERSON_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null  0 

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

PERSON_ID Security Types 
Name  Current Value 

PERSON_ID Bound Attachments 
Name  Current Value 

PERSON_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PERSON_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Person Identifier 		 NO     
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_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PERSON_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

INST_ID 
Base Object  PROPOSAL 
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  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

INST_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

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

INST_ID Security Types 
Name  Current Value 

INST_ID Bound Attachments 
Name  Current Value 

INST_ID Data Movement Rules 
Name  Type  Rule Text/Value 

INST_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Institute Identifier 		 NO     
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     

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 

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

PRPSL_TYPE_ID Column Properties 
Datatype  VARCHAR2(20) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PRPSL_TYPE_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

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

PRPSL_TYPE_ID Security Types 
Name  Current Value 

PRPSL_TYPE_ID Bound Attachments 
Name  Current Value 

PRPSL_TYPE_ID Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_TYPE_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Type Identifer 		 NO     
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     

PRPSL_TYPE_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_TYPE_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_TYPE_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_TYPE_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_ID 
Base Object  PROPOSAL 
Attribute Name  Status Identifier 
ColumnName  STAT_ID 
Logical Rolename  Status Identifier 
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

STAT_ID Column Properties 
Datatype  VARCHAR2(20) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

STAT_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null  0 

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

STAT_ID Security Types 
Name  Current Value 

STAT_ID Bound Attachments 
Name  Current Value 

STAT_ID Data Movement Rules 
Name  Type  Rule Text/Value 

STAT_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Status Identifier 		 NO     
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     

STAT_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

STAT_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ABSTR 
Base Object  PROPOSAL 
Attribute Name  Abstract 
ColumnName  ABSTR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

ABSTR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  4000 
Percent Null  0 

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

ABSTR Security Types 
Name  Current Value 

ABSTR Bound Attachments 
Name  Current Value 

ABSTR Data Movement Rules 
Name  Type  Rule Text/Value 

ABSTR Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Abstract 		 NO     
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     

ABSTR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ABSTR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ABSTR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ABSTR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

TITLE 
Base Object  PROPOSAL 
Attribute Name  TItle 
ColumnName  TITLE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

TITLE Column Properties 
Datatype  VARCHAR2(128) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

TITLE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  128 
Percent Null  0 

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

TITLE Security Types 
Name  Current Value 

TITLE Bound Attachments 
Name  Current Value 

TITLE Data Movement Rules 
Name  Type  Rule Text/Value 

TITLE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
TItle 		 NO     
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 

STMT_OF_RESCH 
Base Object  PROPOSAL 
Attribute Name  Statement of Research 
ColumnName  STMT_OF_RESCH 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

STMT_OF_RESCH Column Properties 
Datatype  BLOB 
Nullable  YES 
Not Null Constraint   

STMT_OF_RESCH Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2048 
Percent Null  0 

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

STMT_OF_RESCH Security Types 
Name  Current Value 

STMT_OF_RESCH Bound Attachments 
Name  Current Value 

STMT_OF_RESCH Data Movement Rules 
Name  Type  Rule Text/Value 

STMT_OF_RESCH Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Statement of Research 		 NO     
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     

STMT_OF_RESCH Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

STMT_OF_RESCH Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

STMT_OF_RESCH Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

STMT_OF_RESCH Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

REL_PRPSL 
Base Object  PROPOSAL 
Attribute Name  Related Proposals 
ColumnName  REL_PRPSL 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

REL_PRPSL Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2000 
Percent Null  0 

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

REL_PRPSL Security Types 
Name  Current Value 

REL_PRPSL Bound Attachments 
Name  Current Value 

REL_PRPSL Data Movement Rules 
Name  Type  Rule Text/Value 

REL_PRPSL Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Related Proposals 		 NO     
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     

REL_PRPSL Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

REL_PRPSL Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

REL_PRPSL Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

REL_PRPSL Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

PROP_DATA_IND 
Base Object  PROPOSAL 
Attribute Name  Proprietary Data Indicator 
ColumnName  PROP_DATA_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

PROP_DATA_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

PROP_DATA_IND Security Types 
Name  Current Value 

PROP_DATA_IND Bound Attachments 
Name  Current Value 

PROP_DATA_IND Data Movement Rules 
Name  Type  Rule Text/Value 

PROP_DATA_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proprietary Data Indicator 		 NO     
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     

PROP_DATA_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PROP_DATA_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PROP_DATA_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PROP_DATA_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

CLASS_DATA_IND 
Base Object  PROPOSAL 
Attribute Name  Classified Data Indicator 
ColumnName  CLASS_DATA_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

CLASS_DATA_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

CLASS_DATA_IND Security Types 
Name  Current Value 

CLASS_DATA_IND Bound Attachments 
Name  Current Value 

CLASS_DATA_IND Data Movement Rules 
Name  Type  Rule Text/Value 

CLASS_DATA_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Classified Data Indicator 		 NO     
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     

CLASS_DATA_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CLASS_DATA_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CLASS_DATA_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CLASS_DATA_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

STUD_THESIS_IND 
Base Object  PROPOSAL 
Attribute Name  Student Thesis Indicator 
ColumnName  STUD_THESIS_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

STUD_THESIS_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

STUD_THESIS_IND Security Types 
Name  Current Value 

STUD_THESIS_IND Bound Attachments 
Name  Current Value 

STUD_THESIS_IND Data Movement Rules 
Name  Type  Rule Text/Value 

STUD_THESIS_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Student Thesis Indicator 		 NO     
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     

STUD_THESIS_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

STUD_THESIS_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

STUD_THESIS_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

STUD_THESIS_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_FILE_NM 
Base Object  PROPOSAL 
Attribute Name  Statement of Research File Name 
ColumnName  SOR_FILE_NM 
Logical Rolename   
RoleName   
Domain  File Name 
Physical 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 
 

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

SOR_FILE_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

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

SOR_FILE_NM Security Types 
Name  Current Value 

SOR_FILE_NM Bound Attachments 
Name  Current Value 

SOR_FILE_NM Data Movement Rules 
Name  Type  Rule Text/Value 

SOR_FILE_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Statement of Research File Name 		 NO     
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     

SOR_FILE_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_FILE_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_FILE_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_FILE_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_MIMETYPE 
Base Object  PROPOSAL 
Attribute Name  Statement of Research MIME Type 
ColumnName  SOR_MIMETYPE 
Logical Rolename   
RoleName   
Domain  MIME Type 
Physical 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 
 

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

SOR_MIMETYPE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null  0 

SOR_MIMETYPE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'application/pdf' 
Bound Default   

SOR_MIMETYPE Security Types 
Name  Current Value 

SOR_MIMETYPE Bound Attachments 
Name  Current Value 

SOR_MIMETYPE Data Movement Rules 
Name  Type  Rule Text/Value 

SOR_MIMETYPE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Statement of Research MIME Type 		 NO     
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     

SOR_MIMETYPE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_MIMETYPE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_MIMETYPE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SOR_MIMETYPE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXPT_CMPLT_IND 
Base Object  PROPOSAL 
Attribute Name  Experiment Complete Indicator 
ColumnName  EXPT_CMPLT_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

EXPT_CMPLT_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

EXPT_CMPLT_IND Security Types 
Name  Current Value 

EXPT_CMPLT_IND Bound Attachments 
Name  Current Value 

EXPT_CMPLT_IND Data Movement Rules 
Name  Type  Rule Text/Value 

EXPT_CMPLT_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Experiment Complete Indicator 		 NO     
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     

EXPT_CMPLT_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXPT_CMPLT_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXPT_CMPLT_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXPT_CMPLT_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

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

EXPT_CMPLT_CMNT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2000 
Percent Null  0 

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

EXPT_CMPLT_CMNT Security Types 
Name  Current Value 

EXPT_CMPLT_CMNT Bound Attachments 
Name  Current Value 

EXPT_CMPLT_CMNT Data Movement Rules 
Name  Type  Rule Text/Value 

EXPT_CMPLT_CMNT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Experiment Complete Comment 		 NO     
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     

EXPT_CMPLT_CMNT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXPT_CMPLT_CMNT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXPT_CMPLT_CMNT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXPT_CMPLT_CMNT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_IND 
Base Object  PROPOSAL 
Attribute Name  Export Control Indicator 
ColumnName  EXP_CONTR_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

EXP_CONTR_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

EXP_CONTR_IND Security Types 
Name  Current Value 

EXP_CONTR_IND Bound Attachments 
Name  Current Value 

EXP_CONTR_IND Data Movement Rules 
Name  Type  Rule Text/Value 

EXP_CONTR_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Export Control Indicator 		 NO     
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     

EXP_CONTR_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_PROHIB_IND 
Base Object  PROPOSAL 
Attribute Name  Export Control Prohibited Indicator 
ColumnName  EXP_CONTR_PROHIB_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

EXP_CONTR_PROHIB_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

EXP_CONTR_PROHIB_IND Security Types 
Name  Current Value 

EXP_CONTR_PROHIB_IND Bound Attachments 
Name  Current Value 

EXP_CONTR_PROHIB_IND Data Movement Rules 
Name  Type  Rule Text/Value 

EXP_CONTR_PROHIB_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Export Control Prohibited Indicator 		 NO     
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     

EXP_CONTR_PROHIB_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_PROHIB_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_PROHIB_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EXP_CONTR_PROHIB_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

STAFF_TECH_ASST_IND 
Base Object  PROPOSAL 
Attribute Name  Staff Technical Assistance Indicator 
ColumnName  STAFF_TECH_ASST_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

STAFF_TECH_ASST_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

STAFF_TECH_ASST_IND Security Types 
Name  Current Value 

STAFF_TECH_ASST_IND Bound Attachments 
Name  Current Value 

STAFF_TECH_ASST_IND Data Movement Rules 
Name  Type  Rule Text/Value 

STAFF_TECH_ASST_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Staff Technical Assistance Indicator 		 NO     
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_TECH_ASST_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAFF_TECH_ASST_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

STAFF_TECH_ASST_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

STAFF_TECH_ASST_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_SCI_CONT_IND 
Base Object  PROPOSAL 
Attribute Name  Instrument Scientist Contacted Indicator 
ColumnName  INSTR_SCI_CONT_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

INSTR_SCI_CONT_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

INSTR_SCI_CONT_IND Security Types 
Name  Current Value 

INSTR_SCI_CONT_IND Bound Attachments 
Name  Current Value 

INSTR_SCI_CONT_IND Data Movement Rules 
Name  Type  Rule Text/Value 

INSTR_SCI_CONT_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Instrument Scientist Contacted Indicator 		 NO     
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     

INSTR_SCI_CONT_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_SCI_CONT_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_SCI_CONT_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_SCI_CONT_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

RESUB_IND 
Base Object  PROPOSAL 
Attribute Name  Resubmit Indicator 
ColumnName  RESUB_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
 
Note 
 

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

RESUB_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

RESUB_IND Security Types 
Name  Current Value 

RESUB_IND Bound Attachments 
Name  Current Value 

RESUB_IND Data Movement Rules 
Name  Type  Rule Text/Value 

RESUB_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Resubmit Indicator 		 NO     
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     

RESUB_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RESUB_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RESUB_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RESUB_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

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

PRPSL_CONT_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1 
Percent Null  0 

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

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

PRPSL_CONT_IND Security Types 
Name  Current Value 

PRPSL_CONT_IND Bound Attachments 
Name  Current Value 

PRPSL_CONT_IND Data Movement Rules 
Name  Type  Rule Text/Value 

PRPSL_CONT_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Proposal Continuation Indicator 		 NO     
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     

PRPSL_CONT_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_CONT_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_CONT_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PRPSL_CONT_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD_PUBL 
Base Object  PROPOSAL 
Attribute Name  NScD Publication 
ColumnName  NSCD_PUBL 
Logical Rolename   
RoleName   
Domain  Text 
Physical Only  NO 
Definition 
 
Note 
 

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

NSCD_PUBL Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  4000 
Percent Null  0 

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

NSCD_PUBL Security Types 
Name  Current Value 

NSCD_PUBL Bound Attachments 
Name  Current Value 

NSCD_PUBL Data Movement Rules 
Name  Type  Rule Text/Value 

NSCD_PUBL Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
NScD Publication 		 NO     
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_PUBL Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD_PUBL Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD_PUBL Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NSCD_PUBL Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DATE 
Base Object  PROPOSAL 
Attribute Name  Modify Date 
ColumnName  MOD_DATE 
Logical Rolename   
RoleName   
Domain  Modify Date 
Physical Only  NO 
Definition 
 
Note 
 

MOD_DATE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

MOD_DATE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  7 
Percent Null  0 

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

MOD_DATE Security Types 
Name  Current Value 

MOD_DATE Bound Attachments 
Name  Current Value 

MOD_DATE Data Movement Rules 
Name  Type  Rule Text/Value 

MOD_DATE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal
Modify Date 		 NO     
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     

MOD_DATE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DATE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DATE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MOD_DATE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description