CUR_DTE 
Base Object  BAC_ALLOC_HIST 
Attribute Name  Current Date 
ColumnName  CUR_DTE 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition 
 
Note 
 

CUR_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

CUR_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

CUR_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

CUR_DTE Security Types 
Name  Current Value 

CUR_DTE Bound Attachments 
Name  Current Value 

CUR_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

CUR_DTE 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     

CUR_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CUR_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


INSTR_ID 
Base Object  BAC_ALLOC_HIST 
Attribute Name  Instrument Identifier 
ColumnName  INSTR_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Instrument Identifier: Abbreviated identier for the instrument.
 
Note 
 

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

INSTR_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

INSTR_ID Security Types 
Name  Current Value 

INSTR_ID Bound Attachments 
Name  Current Value 

INSTR_ID Data Movement Rules 
Name  Type  Rule Text/Value 

INSTR_ID 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     

INSTR_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PRPSL_ID 
Base Object  BAC_ALLOC_HIST 
Attribute Name  Proposal Identifier 
ColumnName  PRPSL_ID 
Logical Rolename  Proposal Identifier 
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

PRPSL_ID Column Properties 
Datatype  NUMBER(10, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

PRPSL_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
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
Beam Allocation Committee Allocation History
Proposal Identifier 
NO     
IPTSv5 (Oracle)
BAC_ALLOC_HIST
PRPSL_ID 
NO     
PRPSL (Oracle)
BAC_ALLOC_HIST
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 


SUBMISS_NBR 
Base Object  BAC_ALLOC_HIST 
Attribute Name  Submission Number 
ColumnName  SUBMISS_NBR 
Logical Rolename  Submission Number 
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

SUBMISS_NBR Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

SUBMISS_NBR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

SUBMISS_NBR Security Types 
Name  Current Value 

SUBMISS_NBR Bound Attachments 
Name  Current Value 

SUBMISS_NBR Data Movement Rules 
Name  Type  Rule Text/Value 

SUBMISS_NBR 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     

SUBMISS_NBR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBMISS_NBR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SUBMISS_NBR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SUBMISS_NBR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BAC_DAY_ALLOC_NBR 
Base Object  BAC_ALLOC_HIST 
Attribute Name  Beam Allocation Committee Days Allocated Number 
ColumnName  BAC_DAY_ALLOC_NBR 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

BAC_DAY_ALLOC_NBR Column Properties 
Datatype  NUMBER(3, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

BAC_DAY_ALLOC_NBR Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

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

BAC_DAY_ALLOC_NBR Security Types 
Name  Current Value 

BAC_DAY_ALLOC_NBR Bound Attachments 
Name  Current Value 

BAC_DAY_ALLOC_NBR Data Movement Rules 
Name  Type  Rule Text/Value 

BAC_DAY_ALLOC_NBR 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     

BAC_DAY_ALLOC_NBR Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BAC_DAY_ALLOC_NBR Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BAC_DAY_ALLOC_NBR Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BAC_DAY_ALLOC_NBR Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description