Cab Id 
Base Entity  Part Cab Dr Bin 
Attribute Name  Cab Id 
Logical Rolename   
ColumnName  CAB_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Cabinet Identifer: A unique identiefer for the cabinet made up of the equipment category and a number.
 
Note 
 

Cab Id Logical Attribute Properties 
Logical Attribute Name  Cab Id 
Datatype  VARCHAR(12) 
Nullable  NO 

Cab Id Domain Restrictions 

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

Cab Id Bound Attachments 
Name  Current Value 

Cab Id Data Movement Rules 
Name  Type  Rule Text/Value 

Cab Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Part Cab Dr Bin
Cab Id 
NO     
PART (Oracle)
PART_CAB_DR_BIN
CAB_ID 
NO     

Cab Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cab Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cab Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cab Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Dr Id 
Base Entity  Part Cab Dr Bin 
Attribute Name  Dr Id 
Logical Rolename   
ColumnName  DR_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Drawer Identifier: A unique identifier for a drawer or tray in a cabinet.
 
Note 
 

Dr Id Logical Attribute Properties 
Logical Attribute Name  Dr Id 
Datatype  VARCHAR(5) 
Nullable  NO 

Dr Id Domain Restrictions 

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

Dr Id Bound Attachments 
Name  Current Value 

Dr Id Data Movement Rules 
Name  Type  Rule Text/Value 

Dr Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Part Cab Dr Bin
Dr Id 
NO     
PART (Oracle)
PART_CAB_DR_BIN
DR_ID 
NO     

Dr Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dr Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Dr Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Dr Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Bin Id 
Base Entity  Part Cab Dr Bin 
Attribute Name  Bin Id 
Logical Rolename   
ColumnName  BIN_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Bin Identifer: Identifer for a unique bin within a drawer.
 
Note 
 

Bin Id Logical Attribute Properties 
Logical Attribute Name  Bin Id 
Datatype  VARCHAR(5) 
Nullable  NO 

Bin Id Domain Restrictions 

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

Bin Id Bound Attachments 
Name  Current Value 

Bin Id Data Movement Rules 
Name  Type  Rule Text/Value 

Bin Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Part Cab Dr Bin
Bin Id 
NO     
PART (Oracle)
PART_CAB_DR_BIN
BIN_ID 
NO     

Bin Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bin Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bin Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bin Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Part Id 
Base Entity  Part Cab Dr Bin 
Attribute Name  Part Id 
Logical Rolename   
ColumnName  PART_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Part Identifier:  Abbreviated identifer for a part.
 
Note 
 

Part Id Logical Attribute Properties 
Logical Attribute Name  Part Id 
Datatype  VARCHAR(25) 
Nullable  YES 

Part Id Domain Restrictions 

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

Part Id Bound Attachments 
Name  Current Value 

Part Id Data Movement Rules 
Name  Type  Rule Text/Value 

Part Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Part Cab Dr Bin
Part Id 
NO     
PART (Oracle)
PART_CAB_DR_BIN
PART_ID 
NO     

Part Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Part Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Part Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Part Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description