Experiment Resource Identifier 
Base Entity  Experiment Resource Personnel Resource 
Attribute Name  Experiment Resource Identifier 
Logical Rolename   
ColumnName  EXPT_RSRC_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Experiment Resource Identifier Logical Attribute Properties 
Logical Attribute Name  Experiment Resource Identifier 
Datatype  VARCHAR(50) 
Nullable  NO 

Experiment Resource Identifier Domain Restrictions 

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

Experiment Resource Identifier Bound Attachments 
Name  Current Value 

Experiment Resource Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Experiment Resource Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Personnel Resource
Experiment Resource Identifier 
NO     
EXPRESS (Oracle)
EXPT_RSRC_PERS_RSRC
EXPT_RSRC_ID 
NO     

Experiment Resource Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Badge Number 
Base Entity  Experiment Resource Personnel Resource 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  BN 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Badge Number Logical Attribute Properties 
Logical Attribute Name  Badge Number 
Datatype  VARCHAR(10) 
Nullable  NO 

Badge Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Badge Number Security Types 
Name  Current Value 

Badge Number Bound Attachments 
Name  Current Value 

Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource Personnel Resource
Badge Number 
NO     
EXPRESS (Oracle)
EXPT_RSRC_PERS_RSRC
BN 
NO     

Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Start Date 
Base Entity  Experiment Resource Personnel Resource 
Attribute Name  Start Date 
Logical Rolename   
ColumnName  START_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
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
Experiment Resource Personnel Resource
Start Date 
NO     
EXPRESS (Oracle)
EXPT_RSRC_PERS_RSRC
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  Experiment Resource Personnel Resource 
Attribute Name  End Date 
Logical Rolename   
ColumnName  END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
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
Experiment Resource Personnel Resource
End Date 
NO     
EXPRESS (Oracle)
EXPT_RSRC_PERS_RSRC
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