PRPSL_ID 
Base Object  PRPSL_FUND_CNTRY 
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 

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 Funding Country
Proposal Identifier 
NO     
CNMS_PRPSL (Oracle)
PRPSL_FUND_CNTRY
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 


FUND_ID 
Base Object  PRPSL_FUND_CNTRY 
Attribute Name  Funding Identifier 
ColumnName  FUND_ID 
Logical Rolename  Funding Identifier 
RoleName   
Domain   
Physical Only  NO 
Definition 
Funding Identifier: Abbreviated identifier for the agency or company funding the proposed experiment.
 
Note 
 

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

FUND_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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

FUND_ID Security Types 
Name  Current Value 

FUND_ID Bound Attachments 
Name  Current Value 

FUND_ID Data Movement Rules 
Name  Type  Rule Text/Value 

FUND_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Funding Country
Funding Identifier 
NO     
CNMS_PRPSL (Oracle)
PRPSL_FUND_CNTRY
FUND_ID 
NO     

FUND_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

FUND_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

FUND_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

FUND_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CNTRY_ID 
Base Object  PRPSL_FUND_CNTRY 
Attribute Name  Country Identifier 
ColumnName  CNTRY_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Country Identifier: Abbreviated identrifier for a country.
 
Note 
 

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

CNTRY_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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

CNTRY_ID Security Types 
Name  Current Value 

CNTRY_ID Bound Attachments 
Name  Current Value 

CNTRY_ID Data Movement Rules 
Name  Type  Rule Text/Value 

CNTRY_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Funding Country
Country Identifier 
NO     
CNMS_PRPSL (Oracle)
PRPSL_FUND_CNTRY
CNTRY_ID 
NO     

CNTRY_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CNTRY_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CNTRY_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CNTRY_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description