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

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

PRPSL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
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 PDF
Proposal Identifier 		 NO     
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     

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 

CONTENT_ID 
Base Object  PRPSL_PDF 
Attribute Name  Content Identifier 
ColumnName  CONTENT_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

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

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

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

CONTENT_ID Security Types 
Name  Current Value 

CONTENT_ID Bound Attachments 
Name  Current Value 

CONTENT_ID Data Movement Rules 
Name  Type  Rule Text/Value 

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

CONTENT_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CONTENT_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CONTENT_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

CONTENT 
Base Object  PRPSL_PDF 
Attribute Name  Content 
ColumnName  CONTENT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

CONTENT Column Properties 
Datatype  BLOB 
Nullable  YES 
Not Null Constraint   

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

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     
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_NM 
Base Object  PRPSL_PDF 
Attribute Name  File Name 
ColumnName  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 
 

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

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

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

FILE_NM Security Types 
Name  Current Value 

FILE_NM Bound Attachments 
Name  Current Value 

FILE_NM Data Movement Rules 
Name  Type  Rule Text/Value 

FILE_NM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal PDF
File Name 		 NO     
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_NM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FILE_NM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

MIMETYPE 
Base Object  PRPSL_PDF 
Attribute Name  MIMETYPE 
ColumnName  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 
 

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

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

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     
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