Bldg Id 
Base Entity  Building 
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
Building
Bldg Id 
NO     
EQUIP (Oracle)
BLDG
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 


Bldg Nm 
Base Entity  Building 
Attribute Name  Bldg Nm 
Logical Rolename   
ColumnName  Bldg Nm 
RoleName   
Domain  Name 
Logical Only  NO 
Definition 
Building Name:  The name of the building within the SNS Facility
 
Note 
 

Bldg Nm Logical Attribute Properties 
Logical Attribute Name  Bldg Nm 
Datatype  VARCHAR(120) 
Nullable  NO 

Bldg Nm Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Bldg Nm Security Types 
Name  Current Value 

Bldg Nm Bound Attachments 
Name  Current Value 

Bldg Nm Data Movement Rules 
Name  Type  Rule Text/Value 

Bldg Nm Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Building
Bldg Nm 
NO     
EQUIP (Oracle)
BLDG
BLDG_NM 
NO     

Bldg Nm Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Nm Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Nm Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Nm Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Bldg Abbrv Code 
Base Entity  Building 
Attribute Name  Bldg Abbrv Code 
Logical Rolename   
ColumnName  Bldg Abbrv Code 
RoleName   
Domain   
Logical Only  NO 
Definition 
Building Abbreviation Code:  A two character abbreviation for the building.
 
Note 
 

Bldg Abbrv Code Logical Attribute Properties 
Logical Attribute Name  Bldg Abbrv Code 
Datatype  CHAR(2) 
Nullable  YES 

Bldg Abbrv Code Domain Restrictions 

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

Bldg Abbrv Code Bound Attachments 
Name  Current Value 

Bldg Abbrv Code Data Movement Rules 
Name  Type  Rule Text/Value 

Bldg Abbrv Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Building
Bldg Abbrv Code 
NO     
EQUIP (Oracle)
BLDG
BLDG_ABBRV_CODE 
NO     

Bldg Abbrv Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Abbrv Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Abbrv Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bldg Abbrv Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description