Equip Id 
Base Entity  Equipment Usage 
Attribute Name  Equip Id 
Logical Rolename   
ColumnName  Equip Id 
RoleName   
Domain  Asset Identifier 
Logical Only  NO 
Definition 
Equipment Identifier: The SNS barcode number used to uniquely identify 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 Usage
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 


Usage Strt Dte 
Base Entity  Equipment Usage 
Attribute Name  Usage Strt Dte 
Logical Rolename   
ColumnName  Usage Strt Dte 
RoleName   
Domain  Datetime 
Logical Only  NO 
Definition 
Usage Start Date: The date and time when the equipment was first assigned to an employee for use.
 
Note 
 

Usage Strt Dte Logical Attribute Properties 
Logical Attribute Name  Usage Strt Dte 
Datatype  DATETIME 
Nullable  NO 

Usage Strt Dte Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Usage Strt Dte Security Types 
Name  Current Value 

Usage Strt Dte Bound Attachments 
Name  Current Value 

Usage Strt Dte Data Movement Rules 
Name  Type  Rule Text/Value 

Usage Strt Dte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Usage
Usage Strt Dte 
NO     

Usage Strt Dte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Usage Strt Dte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Usage Strt Dte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Usage Strt Dte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Badge Number 
Base Entity  Equipment Usage 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  Badge Number 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
Employee Badge Number.
 
Note 
 

Badge Number Logical Attribute Properties 
Logical Attribute Name  Badge Number 
Datatype  VARCHAR(10) 
Nullable  NO 

Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Badge Number Security Types 
Name  Current Value 

Badge Number Bound Attachments 
Name  Current Value 

Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Usage
Badge Number 
NO     

Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Usage End Dte 
Base Entity  Equipment Usage 
Attribute Name  Usage End Dte 
Logical Rolename   
ColumnName  Usage End Dte 
RoleName   
Domain  Datetime 
Logical Only  NO 
Definition 
Usage End Date: The date and time when the equipment was no longer used by an employee.
 
Note 
 

Usage End Dte Logical Attribute Properties 
Logical Attribute Name  Usage End Dte 
Datatype  DATETIME 
Nullable  YES 

Usage End Dte Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Usage End Dte Security Types 
Name  Current Value 

Usage End Dte Bound Attachments 
Name  Current Value 

Usage End Dte Data Movement Rules 
Name  Type  Rule Text/Value 

Usage End Dte Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Equipment Usage
Usage End Dte 
NO     

Usage End Dte Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Usage End Dte Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Usage End Dte Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Usage End Dte Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description