Badge Number 
Base Entity  Personnel Role 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  BN 
RoleName   
Domain  Badge Number 
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
Personnel Role
Badge Number 
NO     
OPER (Oracle)
PERS_ROLES
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 


Pers Role Desc 
Base Entity  Personnel Role 
Attribute Name  Pers Role Desc 
Logical Rolename   
ColumnName  Pers Role Desc 
RoleName   
Domain  Description 
Logical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Pers Role Desc Logical Attribute Properties 
Logical Attribute Name  Pers Role Desc 
Datatype  VARCHAR(255) 
Nullable  YES 

Pers Role Desc Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Pers Role Desc Security Types 
Name  Current Value 

Pers Role Desc Bound Attachments 
Name  Current Value 

Pers Role Desc Data Movement Rules 
Name  Type  Rule Text/Value 

Pers Role Desc Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Personnel Role
Pers Role Desc 
NO     
OPER (Oracle)
PERS_ROLES
Pers Role Desc 
NO     

Pers Role Desc Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pers Role Desc Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pers Role Desc Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pers Role Desc Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Opr Ind 
Base Entity  Personnel Role 
Attribute Name  Opr Ind 
Logical Rolename   
ColumnName  Opr Ind 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Operator Indicator: Indicates accelerator operator.
 
Note 
 

Opr Ind Logical Attribute Properties 
Logical Attribute Name  Opr Ind 
Datatype  CHAR(1) 
Nullable  NO 

Opr Ind Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Opr Ind Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Opr Ind Security Types 
Name  Current Value 

Opr Ind Bound Attachments 
Name  Current Value 

Opr Ind Data Movement Rules 
Name  Type  Rule Text/Value 

Opr Ind Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Personnel Role
Opr Ind 
NO     
OPER (Oracle)
PERS_ROLES
Opr Ind 
NO     

Opr Ind Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Opr Ind Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Opr Ind Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Opr Ind Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Opr Mgr 
Base Entity  Personnel Role 
Attribute Name  Opr Mgr 
Logical Rolename   
ColumnName  Opr Mgr 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Operations Manager: Indicates Operations Manager role.
 
Note 
 

Opr Mgr Logical Attribute Properties 
Logical Attribute Name  Opr Mgr 
Datatype  CHAR(1) 
Nullable  NO 

Opr Mgr Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Opr Mgr Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Opr Mgr Security Types 
Name  Current Value 

Opr Mgr Bound Attachments 
Name  Current Value 

Opr Mgr Data Movement Rules 
Name  Type  Rule Text/Value 

Opr Mgr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Personnel Role
Opr Mgr 
NO     
OPER (Oracle)
PERS_ROLES
Opr Mgr 
NO     

Opr Mgr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Opr Mgr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Opr Mgr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Opr Mgr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Area Mgr Ind 
Base Entity  Personnel Role 
Attribute Name  Area Mgr Ind 
Logical Rolename   
ColumnName  AREA_MGR_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Area Manager Indicator: 
 
Note 
 

Area Mgr Ind Logical Attribute Properties 
Logical Attribute Name  Area Mgr Ind 
Datatype  CHAR(1) 
Nullable  NO 

Area Mgr Ind Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Area Mgr Ind Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Area Mgr Ind Security Types 
Name  Current Value 

Area Mgr Ind Bound Attachments 
Name  Current Value 

Area Mgr Ind Data Movement Rules 
Name  Type  Rule Text/Value 

Area Mgr Ind Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Personnel Role
Area Mgr Ind 
NO     
OPER (Oracle)
PERS_ROLES
AREA_MGR_IND 
NO     

Area Mgr Ind Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Area Mgr Ind Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Area Mgr Ind Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Area Mgr Ind Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Area Engr Ind 
Base Entity  Personnel Role 
Attribute Name  Area Engr Ind 
Logical Rolename   
ColumnName  AREA_ENGR_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Area Engr Ind Logical Attribute Properties 
Logical Attribute Name  Area Engr Ind 
Datatype  CHAR(1) 
Nullable  NO 

Area Engr Ind Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Area Engr Ind Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Area Engr Ind Security Types 
Name  Current Value 

Area Engr Ind Bound Attachments 
Name  Current Value 

Area Engr Ind Data Movement Rules 
Name  Type  Rule Text/Value 

Area Engr Ind Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Personnel Role
Area Engr Ind 
NO     
OPER (Oracle)
PERS_ROLES
AREA_ENGR_IND 
NO     

Area Engr Ind Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Area Engr Ind Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Area Engr Ind Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Area Engr Ind Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Logbook Read Only Ind 
Base Entity  Personnel Role 
Attribute Name  Logbook Read Only Ind 
Logical Rolename   
ColumnName  LOG_READ_ONLY_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Technical Contact Indicator: Owner or technical contact of equipment.
 
Note 
 

Logbook Read Only Ind Logical Attribute Properties 
Logical Attribute Name  Logbook Read Only Ind 
Datatype  CHAR(1) 
Nullable  NO 

Logbook Read Only Ind Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Logbook Read Only Ind Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Logbook Read Only Ind Security Types 
Name  Current Value 

Logbook Read Only Ind Bound Attachments 
Name  Current Value 

Logbook Read Only Ind Data Movement Rules 
Name  Type  Rule Text/Value 

Logbook Read Only Ind Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Personnel Role
Logbook Read Only Ind 
NO     
OPER (Oracle)
PERS_ROLES
LOG_READ_ONLY_IND 
NO     

Logbook Read Only Ind Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Logbook Read Only Ind Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Logbook Read Only Ind Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Logbook Read Only Ind Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Photograph 
Base Entity  Personnel Role 
Attribute Name  Photograph 
Logical Rolename   
ColumnName  PHOTO 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Photograph Logical Attribute Properties 
Logical Attribute Name  Photograph 
Datatype  VARBINARY/BLOB(50) 
Nullable  YES 

Photograph Domain Restrictions 

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

Photograph Bound Attachments 
Name  Current Value 

Photograph Data Movement Rules 
Name  Type  Rule Text/Value 

Photograph Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Personnel Role
Photograph 
NO     
OPER (Oracle)
PERS_ROLES
PHOTO 
NO     

Photograph Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Photograph Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Photograph Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Photograph Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description