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 |