BN 
Base Object  ORG_MATRIX 
Attribute Name  Badge Number 
ColumnName  BN 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

BN Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

BN Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

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

BN Security Types 
Name  Current Value 

BN Bound Attachments 
Name  Current Value 

BN Data Movement Rules 
Name  Type  Rule Text/Value 

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

BN Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BN Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BN Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BN Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ORG_ID 
Base Object  ORG_MATRIX 
Attribute Name  Organization Identifier 
ColumnName  ORG_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

ORG_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ORG_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

ORG_ID Security Types 
Name  Current Value 

ORG_ID Bound Attachments 
Name  Current Value 

ORG_ID Data Movement Rules 
Name  Type  Rule Text/Value 

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

ORG_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ORG_LVL1_ID 
Base Object  ORG_MATRIX 
Attribute Name  Organization Level 1 Identifier 
ColumnName  ORG_LVL1_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

ORG_LVL1_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ORG_LVL1_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

ORG_LVL1_ID Security Types 
Name  Current Value 

ORG_LVL1_ID Bound Attachments 
Name  Current Value 

ORG_LVL1_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ORG_LVL1_ID 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     

ORG_LVL1_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL1_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL1_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL1_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ORG_LVL2_ID 
Base Object  ORG_MATRIX 
Attribute Name  Organization Level 2 Identifier 
ColumnName  ORG_LVL2_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

ORG_LVL2_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ORG_LVL2_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

ORG_LVL2_ID Security Types 
Name  Current Value 

ORG_LVL2_ID Bound Attachments 
Name  Current Value 

ORG_LVL2_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ORG_LVL2_ID 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     

ORG_LVL2_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL2_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL2_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL2_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ORG_LVL3_ID 
Base Object  ORG_MATRIX 
Attribute Name  Organization Level 3 Identifier 
ColumnName  ORG_LVL3_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

ORG_LVL3_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ORG_LVL3_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

ORG_LVL3_ID Security Types 
Name  Current Value 

ORG_LVL3_ID Bound Attachments 
Name  Current Value 

ORG_LVL3_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ORG_LVL3_ID 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     

ORG_LVL3_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL3_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL3_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL3_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ORG_LVL4_ID 
Base Object  ORG_MATRIX 
Attribute Name  Organization Level 4 Identifier 
ColumnName  ORG_LVL4_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

ORG_LVL4_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

ORG_LVL4_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

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

ORG_LVL4_ID Security Types 
Name  Current Value 

ORG_LVL4_ID Bound Attachments 
Name  Current Value 

ORG_LVL4_ID Data Movement Rules 
Name  Type  Rule Text/Value 

ORG_LVL4_ID 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     

ORG_LVL4_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL4_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL4_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORG_LVL4_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description