Current Date 
Base Entity  Beam Allocation Committee Allocation History 
Attribute Name  Current Date 
Logical Rolename   
ColumnName  CUR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Current Date Security Types 
Name  Current Value 

Current Date Bound Attachments 
Name  Current Value 

Current Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Beam Allocation Committee Allocation History
Current Date 
NO     
IPTSv5 (Oracle)
BAC_ALLOC_HIST
CUR_DTE 
NO     
PRPSL (Oracle)
BAC_ALLOC_HIST
CUR_DTE 
NO     

Current Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Instrument Identifier 
Base Entity  Beam Allocation Committee Allocation History 
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
Beam Allocation Committee Allocation History
Instrument Identifier 
NO     
IPTSv5 (Oracle)
BAC_ALLOC_HIST
INSTR_ID 
NO     
PRPSL (Oracle)
BAC_ALLOC_HIST
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 Identifier 
Base Entity  Beam Allocation Committee Allocation History 
Attribute Name  Proposal Identifier 
Logical Rolename   
ColumnName  PRPSL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Proposal Identifier Logical Attribute Properties 
Logical Attribute Name  Proposal Identifier 
Datatype  NUMERIC(10, 0) 
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
Beam Allocation Committee Allocation History
Proposal Identifier 
NO     
IPTSv5 (Oracle)
BAC_ALLOC_HIST
PRPSL_ID 
NO     
PRPSL (Oracle)
BAC_ALLOC_HIST
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 


Submission Number 
Base Entity  Beam Allocation Committee Allocation History 
Attribute Name  Submission Number 
Logical Rolename   
ColumnName  SUBMISS_NBR 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Submission Number Logical Attribute Properties 
Logical Attribute Name  Submission Number 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Submission Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Submission Number Security Types 
Name  Current Value 

Submission Number Bound Attachments 
Name  Current Value 

Submission Number Data Movement Rules 
Name  Type  Rule Text/Value 

Submission Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Beam Allocation Committee Allocation History
Submission Number 
NO     
IPTSv5 (Oracle)
BAC_ALLOC_HIST
SUBMISS_NBR 
NO     
PRPSL (Oracle)
BAC_ALLOC_HIST
SUBMISS_NBR 
NO     

Submission Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Beam Allocation Committee Days Allocated Number 
Base Entity  Beam Allocation Committee Allocation History 
Attribute Name  Beam Allocation Committee Days Allocated Number 
Logical Rolename   
ColumnName  BAC_DAY_ALLOC_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Beam Allocation Committee Days Allocated Number Logical Attribute Properties 
Logical Attribute Name  Beam Allocation Committee Days Allocated Number 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Beam Allocation Committee Days Allocated Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Beam Allocation Committee Days Allocated Number Security Types 
Name  Current Value 

Beam Allocation Committee Days Allocated Number Bound Attachments 
Name  Current Value 

Beam Allocation Committee Days Allocated Number Data Movement Rules 
Name  Type  Rule Text/Value 

Beam Allocation Committee Days Allocated Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Beam Allocation Committee Allocation History
Beam Allocation Committee Days Allocated Number 
NO     
IPTSv5 (Oracle)
BAC_ALLOC_HIST
BAC_DAY_ALLOC_NBR 
NO     
PRPSL (Oracle)
BAC_ALLOC_HIST
BAC_DAY_ALLOC_NBR 
NO     

Beam Allocation Committee Days Allocated Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Allocation Committee Days Allocated Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Allocation Committee Days Allocated Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Allocation Committee Days Allocated Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description