Strt Dte |
Base Entity | Instr Usage |
Attribute Name | Strt Dte |
Logical Rolename | |
ColumnName | Strt Dte |
RoleName | |
Domain | Datetime |
Logical Only | NO |
Definition | Instrument Usage Start Date: The date and time the instrument was assigned to an instrument user. |
Note |
Strt Dte Logical Attribute Properties |
Logical Attribute Name | Strt Dte |
Datatype | DATETIME |
Nullable | NO |
Strt Dte Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Strt Dte Security Types |
Name | Current Value |
Strt Dte Bound Attachments |
Name | Current Value |
Strt Dte Data Movement Rules |
Name | Type | Rule Text/Value |
Strt Dte Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instr Usage Strt Dte |
NO |
Strt Dte Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Strt Dte Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Strt Dte Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Strt Dte Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Equip Id |
Base Entity | Instr 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 Instr 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 |
End Dt |
Base Entity | Instr Usage |
Attribute Name | End Dt |
Logical Rolename | |
ColumnName | End Dt |
RoleName | |
Domain | Datetime |
Logical Only | NO |
Definition | Instrument Usage End Date: The date and time the instrument was last used by the instrument user. |
Note |
End Dt Logical Attribute Properties |
Logical Attribute Name | End Dt |
Datatype | DATETIME |
Nullable | YES |
End Dt Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
End Dt Security Types |
Name | Current Value |
End Dt Bound Attachments |
Name | Current Value |
End Dt Data Movement Rules |
Name | Type | Rule Text/Value |
End Dt Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instr Usage End Dt |
NO |
End Dt Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
End Dt Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
End Dt Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
End Dt Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instr User BN |
Base Entity | Instr Usage |
Attribute Name | Instr User BN |
Logical Rolename | |
ColumnName | Instr User BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | Instrument User Badge Number |
Note |
Instr User BN Logical Attribute Properties |
Logical Attribute Name | Instr User BN |
Datatype | VARCHAR(10) |
Nullable | NO |
Instr User BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Instr User BN Security Types |
Name | Current Value |
Instr User BN Bound Attachments |
Name | Current Value |
Instr User BN Data Movement Rules |
Name | Type | Rule Text/Value |
Instr User BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Instr Usage Instr User BN |
NO |
Instr User BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instr User BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Instr User BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Instr User BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |