Instrument Identifier 
Base Entity  Proposal Type Schedule 
Attribute Name  Instrument Identifier 
Logical Rolename   
ColumnName  INSTR_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Instrument Identifier: Abbreviated identier for the instrument.
 
Note 
 

Instrument Identifier Logical Attribute Properties 
Logical Attribute Name  Instrument Identifier 
Datatype  VARCHAR(20) 
Nullable  NO 

Instrument Identifier Domain Restrictions 

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

Instrument Identifier Bound Attachments 
Name  Current Value 

Instrument Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Instrument Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Type Schedule
Instrument Identifier 
NO     
EXPRESS (Oracle)
PRPSL_TYPE_SCHED
INSTR_ID 
NO     

Instrument Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Proposal Type Identifer 
Base Entity  Proposal Type Schedule 
Attribute Name  Proposal Type Identifer 
Logical Rolename   
ColumnName  PRPSL_TYPE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Category Identifier: Abbreviated identifier for the user category.
 
Note 
 

Proposal Type Identifer Logical Attribute Properties 
Logical Attribute Name  Proposal Type Identifer 
Datatype  VARCHAR(20) 
Nullable  NO 

Proposal Type Identifer Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Proposal Type Identifer Security Types 
Name  Current Value 

Proposal Type Identifer Bound Attachments 
Name  Current Value 

Proposal Type Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Type Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Type Schedule
Proposal Type Identifer 
NO     
EXPRESS (Oracle)
PRPSL_TYPE_SCHED
PRPSL_TYPE_ID 
NO     

Proposal Type Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Type Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Start Date 
Base Entity  Proposal Type Schedule 
Attribute Name  Start Date 
Logical Rolename   
ColumnName  START_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Scheduled Start Date: The scheduled start date for the resource.
 
Note 
 

Start Date Logical Attribute Properties 
Logical Attribute Name  Start Date 
Datatype  DATE 
Nullable  NO 

Start Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Start Date Security Types 
Name  Current Value 

Start Date Bound Attachments 
Name  Current Value 

Start Date Data Movement Rules 
Name  Type  Rule Text/Value 

Start Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Type Schedule
Start Date 
NO     
EXPRESS (Oracle)
PRPSL_TYPE_SCHED
START_DTE 
NO     

Start Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Start Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Start Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Start Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


End Date 
Base Entity  Proposal Type Schedule 
Attribute Name  End Date 
Logical Rolename   
ColumnName  END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Scheduled End Date: The scheduled ending date for the resource.
 
Note 
 

End Date Logical Attribute Properties 
Logical Attribute Name  End Date 
Datatype  DATE 
Nullable  NO 

End Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

End Date Security Types 
Name  Current Value 

End Date Bound Attachments 
Name  Current Value 

End Date Data Movement Rules 
Name  Type  Rule Text/Value 

End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Proposal Type Schedule
End Date 
NO     
EXPRESS (Oracle)
PRPSL_TYPE_SCHED
END_DTE 
NO     

End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description