Facility Identifier 
Base Entity  ESH Administrator 
Attribute Name  Facility Identifier 
Logical Rolename   
ColumnName  FACIL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place.
 
Note 
 

Facility Identifier Logical Attribute Properties 
Logical Attribute Name  Facility Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Facility Identifier Domain Restrictions 

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

Facility Identifier Bound Attachments 
Name  Current Value 

Facility Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Facility Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
ESH Administrator
Facility Identifier 
NO     
XF_ADMIN (Oracle)
ESH_ADMIN
FACIL_ID 
NO     

Facility Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Person Identifier 
Base Entity  ESH Administrator 
Attribute Name  Person Identifier 
Logical Rolename   
ColumnName  PERSON_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Note 
 

Person Identifier Logical Attribute Properties 
Logical Attribute Name  Person Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Person Identifier Domain Restrictions 

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

Person Identifier Bound Attachments 
Name  Current Value 

Person Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Person Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
ESH Administrator
Person Identifier 
NO     
XF_ADMIN (Oracle)
ESH_ADMIN
PERSON_ID 
NO     

Person Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Person Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description