Proposal Identifier 
Base Entity  Proposal Funding Status 
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 Funding Status
Proposal Identifier 
NO     
CNMS_PRPSL (Oracle)
PRPSL_FUND_STAT
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 


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

Funding Status Identifier Logical Attribute Properties 
Logical Attribute Name  Funding Status Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Funding Status Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Funding Status Identifier Security Types 
Name  Current Value 

Funding Status Identifier Bound Attachments 
Name  Current Value 

Funding Status Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Funding Status Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Funding Status
Funding Status Identifier 
NO     
CNMS_PRPSL (Oracle)
PRPSL_FUND_STAT
FUND_STAT_ID 
NO     

Funding Status Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Funding Status Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Funding Status Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Funding Status Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description