Badge Number 
Base Entity  Person Location 
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
Person Location
Badge Number 		 NO     
OPER (Oracle)
PERS_LOC
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  Person Location 
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
Person Location
Start Date 		 NO     
OPER (Oracle)
PERS_LOC
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  Person Location 
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
Person Location
End Date 		 NO     
OPER (Oracle)
PERS_LOC
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 

Location 
Base Entity  Person Location 
Attribute Name  Location 
Logical Rolename   
ColumnName  LOC 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Location Logical Attribute Properties 
Logical Attribute Name  Location 
Datatype  VARCHAR(200) 
Nullable  YES 

Location Domain Restrictions 

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

Location Bound Attachments 
Name  Current Value 

Location Data Movement Rules 
Name  Type  Rule Text/Value 

Location Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person Location
Location 		 NO     
OPER (Oracle)
PERS_LOC
LOC 		 NO     

Location Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Location Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Location Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Location Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment 
Base Entity  Person Location 
Attribute Name  Comment 
Logical Rolename   
ColumnName  CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition  
Comment:  General comments.
 
Note 
 

Comment Logical Attribute Properties 
Logical Attribute Name  Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

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

Comment Security Types 
Name  Current Value 

Comment Bound Attachments 
Name  Current Value 

Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Person Location
Comment 		 NO     
OPER (Oracle)
PERS_LOC
CMNT 		 NO     

Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description