Proposal Identifier 
Base Entity  Proposal PDF 
Attribute Name  Proposal Identifier 
Logical Rolename   
ColumnName  PRPSL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Proposal Identifier: Unique identifer assigned to the proposal.
 
Note 
 

Proposal Identifier Logical Attribute Properties 
Logical Attribute Name  Proposal Identifier 
Datatype  VARCHAR(10) 
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 PDF
Proposal Identifier 		 NO     
CNMS_PRPSL (Oracle)
PRPSL_PDF
PRPSL_ID 		 NO     
IPTSv5 (Oracle)
PRPSL_PDF
PRPSL_ID 		 NO     
PRPSL (Oracle)
PRPSL_PDF
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 

Content Identifier 
Base Entity  Proposal PDF 
Attribute Name  Content Identifier 
Logical Rolename   
ColumnName  CONTENT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

Content Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Content Identifier Security Types 
Name  Current Value 

Content Identifier Bound Attachments 
Name  Current Value 

Content Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Content Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal PDF
Content Identifier 		 NO     
CNMS_PRPSL (Oracle)
PRPSL_PDF
CONTENT_ID 		 NO     
IPTSv5 (Oracle)
PRPSL_PDF
CONTENT_ID 		 NO     
PRPSL (Oracle)
PRPSL_PDF
CONTENT_ID 		 NO     

Content Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Content Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Content Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Content Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Content 
Base Entity  Proposal PDF 
Attribute Name  Content 
Logical Rolename   
ColumnName  CONTENT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Content Logical Attribute Properties 
Logical Attribute Name  Content 
Datatype  VARBINARY/BLOB(50) 
Nullable  YES 

Content Domain Restrictions 

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

Content Bound Attachments 
Name  Current Value 

Content Data Movement Rules 
Name  Type  Rule Text/Value 

Content Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal PDF
Content 		 NO     
CNMS_PRPSL (Oracle)
PRPSL_PDF
CONTENT 		 NO     
IPTSv5 (Oracle)
PRPSL_PDF
CONTENT 		 NO     
PRPSL (Oracle)
PRPSL_PDF
CONTENT 		 NO     

Content Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Content Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Content Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Content Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

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

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

File Name Security Types 
Name  Current Value 

File Name Bound Attachments 
Name  Current Value 

File Name Data Movement Rules 
Name  Type  Rule Text/Value 

File Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal PDF
File Name 		 NO     
CNMS_PRPSL (Oracle)
PRPSL_PDF
FILE_NM 		 NO     
IPTSv5 (Oracle)
PRPSL_PDF
FILE_NM 		 NO     
PRPSL (Oracle)
PRPSL_PDF
FILE_NM 		 NO     

File Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

File Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIMETYPE 
Base Entity  Proposal PDF 
Attribute Name  MIMETYPE 
Logical Rolename   
ColumnName  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 
 

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

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

MIMETYPE Security Types 
Name  Current Value 

MIMETYPE Bound Attachments 
Name  Current Value 

MIMETYPE Data Movement Rules 
Name  Type  Rule Text/Value 

MIMETYPE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal PDF
MIMETYPE 		 NO     
CNMS_PRPSL (Oracle)
PRPSL_PDF
MIMETYPE 		 NO     
IPTSv5 (Oracle)
PRPSL_PDF
MIMETYPE 		 NO     
PRPSL (Oracle)
PRPSL_PDF
MIMETYPE 		 NO     

MIMETYPE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIMETYPE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

MIMETYPE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIMETYPE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description