BLDG_ID 
Base Object  BLDG 
Attribute Name  Bldg Id 
ColumnName  BLDG_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Building Code: The unique identifier for a building. 
 
Note 
 

BLDG_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

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

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 Object  BLDG 
Attribute Name  Bldg Nm 
ColumnName  BLDG_NM 
Logical Rolename   
RoleName   
Domain  Name 
Physical Only  NO 
Definition 
Building Name:  The name of the building within the SNS Facility
 
Note 
 

BLDG_NM Column Properties 
Datatype  VARCHAR2(120) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

BLDG_NM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  120 
Percent Null 

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 Object  BLDG 
Attribute Name  Bldg Abbrv Code 
ColumnName  BLDG_ABBRV_CODE 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Building Abbreviation Code:  A two character abbreviation for the building.
 
Note 
 

BLDG_ABBRV_CODE Column Properties 
Datatype  CHAR(2) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

BLDG_ABBRV_CODE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

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