Equip Id 
Base Entity  Equipment Location 
Attribute Name  Equip Id 
Logical Rolename   
ColumnName  Equip Id 
RoleName   
Domain  Asset Identifier 
Logical Only  NO 
Definition 
Equipment Identifier:  The unique identifier for the equipment.
 
Note 
 

Equip Id Logical Attribute Properties 
Logical Attribute Name  Equip Id 
Datatype  VARCHAR(30) 
Nullable  NO 

Equip Id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Equip Id Security Types 
Name  Current Value 

Equip Id Bound Attachments 
Name  Current Value 

Equip Id Data Movement Rules 
Name  Type  Rule Text/Value 

Equip Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Location
Equip Id 
NO     

Equip Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Equip Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Bdte 
Base Entity  Equipment Location 
Attribute Name  Bdte 
Logical Rolename   
ColumnName  Bdte 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Begin Date: The date the equipment was originally stored in the building location.
 
Note 
 

Bdte Logical Attribute Properties 
Logical Attribute Name  Bdte 
Datatype  DATE 
Nullable  NO 

Bdte Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Bdte Security Types 
Name  Current Value 

Bdte Bound Attachments 
Name  Current Value 

Bdte Data Movement Rules 
Name  Type  Rule Text/Value 

Bdte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Location
Bdte 
NO     

Bdte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bdte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bdte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bdte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PPS Ind 
Base Entity  Equipment Location 
Attribute Name  PPS Ind 
Logical Rolename   
ColumnName  PPS Ind 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Personal Protection System Indicator: Indicates whether the equipment was purchased for use in the Personal Protection System.
 
Note 
 

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

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

PPS 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 

PPS Ind Security Types 
Name  Current Value 

PPS Ind Bound Attachments 
Name  Current Value 

PPS Ind Data Movement Rules 
Name  Type  Rule Text/Value 

PPS Ind Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Location
PPS Ind 
NO     

PPS Ind Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PPS Ind Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PPS Ind Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PPS Ind Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Edte 
Base Entity  Equipment Location 
Attribute Name  Edte 
Logical Rolename   
ColumnName  Edte 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
End Date: The day the equipment was moved from it's current building location.
 
Note 
 

Edte Logical Attribute Properties 
Logical Attribute Name  Edte 
Datatype  DATE 
Nullable  YES 

Edte Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Edte Security Types 
Name  Current Value 

Edte Bound Attachments 
Name  Current Value 

Edte Data Movement Rules 
Name  Type  Rule Text/Value 

Edte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Location
Edte 
NO     

Edte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Edte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Edte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Edte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Area Id 
Base Entity  Equipment Location 
Attribute Name  Area Id 
Logical Rolename   
ColumnName  Area Id 
RoleName   
Domain  Default Text 
Logical Only  NO 
Definition 
Area Identifier: The unique identifier for the building area.
 
Note 
 

Area Id Logical Attribute Properties 
Logical Attribute Name  Area Id 
Datatype  VARCHAR(50) 
Nullable  NO 

Area Id Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Area Id Security Types 
Name  Current Value 

Area Id Bound Attachments 
Name  Current Value 

Area Id Data Movement Rules 
Name  Type  Rule Text/Value 

Area Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Location
Area Id 
NO     

Area Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Area Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Area Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Area Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Bldg Id 
Base Entity  Equipment Location 
Attribute Name  Bldg Id 
Logical Rolename   
ColumnName  Bldg Id 
RoleName   
Domain   
Logical Only  NO 
Definition 
Building Code: The unique identifier for a building. 
 
Note 
 

Bldg Id Logical Attribute Properties 
Logical Attribute Name  Bldg Id 
Datatype  VARCHAR(10) 
Nullable  NO 

Bldg Id Domain Restrictions 

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

Bldg Id Bound Attachments 
Name  Current Value 

Bldg Id Data Movement Rules 
Name  Type  Rule Text/Value 

Bldg Id Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Location
Bldg Id 
NO     

Bldg Id Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Id Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Id Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Id Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description