Badge Number 
Base Entity  Organization Matrix 
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
Organization Matrix
Badge Number 
NO     
OPER (Oracle)
ORG_MATRIX
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 


Organization Identifier 
Base Entity  Organization Matrix 
Attribute Name  Organization Identifier 
Logical Rolename   
ColumnName  ORG_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Organization Identifier Logical Attribute Properties 
Logical Attribute Name  Organization Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

Organization Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Organization Identifier Security Types 
Name  Current Value 

Organization Identifier Bound Attachments 
Name  Current Value 

Organization Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Organization Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Organization Matrix
Organization Identifier 
NO     
OPER (Oracle)
ORG_MATRIX
ORG_ID 
NO     

Organization Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Organization Level 1 Identifier 
Base Entity  Organization Matrix 
Attribute Name  Organization Level 1 Identifier 
Logical Rolename   
ColumnName  ORG_LVL1_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Organization Level 1 Identifier Logical Attribute Properties 
Logical Attribute Name  Organization Level 1 Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

Organization Level 1 Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Organization Level 1 Identifier Security Types 
Name  Current Value 

Organization Level 1 Identifier Bound Attachments 
Name  Current Value 

Organization Level 1 Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Organization Level 1 Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Organization Matrix
Organization Level 1 Identifier 
NO     
OPER (Oracle)
ORG_MATRIX
ORG_LVL1_ID 
NO     

Organization Level 1 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 1 Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 1 Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 1 Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Organization Level 2 Identifier 
Base Entity  Organization Matrix 
Attribute Name  Organization Level 2 Identifier 
Logical Rolename   
ColumnName  ORG_LVL2_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Organization Level 2 Identifier Logical Attribute Properties 
Logical Attribute Name  Organization Level 2 Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

Organization Level 2 Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Organization Level 2 Identifier Security Types 
Name  Current Value 

Organization Level 2 Identifier Bound Attachments 
Name  Current Value 

Organization Level 2 Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Organization Level 2 Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Organization Matrix
Organization Level 2 Identifier 
NO     
OPER (Oracle)
ORG_MATRIX
ORG_LVL2_ID 
NO     

Organization Level 2 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 2 Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 2 Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 2 Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Organization Level 3 Identifier 
Base Entity  Organization Matrix 
Attribute Name  Organization Level 3 Identifier 
Logical Rolename   
ColumnName  ORG_LVL3_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Organization Level 3 Identifier Logical Attribute Properties 
Logical Attribute Name  Organization Level 3 Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

Organization Level 3 Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Organization Level 3 Identifier Security Types 
Name  Current Value 

Organization Level 3 Identifier Bound Attachments 
Name  Current Value 

Organization Level 3 Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Organization Level 3 Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Organization Matrix
Organization Level 3 Identifier 
NO     
OPER (Oracle)
ORG_MATRIX
ORG_LVL3_ID 
NO     

Organization Level 3 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 3 Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 3 Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 3 Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Organization Level 4 Identifier 
Base Entity  Organization Matrix 
Attribute Name  Organization Level 4 Identifier 
Logical Rolename   
ColumnName  ORG_LVL4_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Organization Level 4 Identifier Logical Attribute Properties 
Logical Attribute Name  Organization Level 4 Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

Organization Level 4 Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Organization Level 4 Identifier Security Types 
Name  Current Value 

Organization Level 4 Identifier Bound Attachments 
Name  Current Value 

Organization Level 4 Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Organization Level 4 Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Organization Matrix
Organization Level 4 Identifier 
NO     
OPER (Oracle)
ORG_MATRIX
ORG_LVL4_ID 
NO     

Organization Level 4 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 4 Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 4 Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Organization Level 4 Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description