Badge Number |
Base Entity | User Login |
Attribute Name | Badge Number |
Logical Rolename | |
ColumnName | BN |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
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 User Login Badge Number |
NO | ||
Instrument Logbook (Oracle) USER_LOGIN BN |
NO | ||
Logbook (Oracle) USER_LOGIN BN |
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 |
Cnt |
Base Entity | User Login |
Attribute Name | Cnt |
Logical Rolename | |
ColumnName | CNT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Count: The number of times the logbook user has logged into the system. |
Note |
Cnt Logical Attribute Properties |
Logical Attribute Name | Cnt |
Datatype | INTEGER |
Nullable | NO |
Cnt Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Cnt Security Types |
Name | Current Value |
Cnt Bound Attachments |
Name | Current Value |
Cnt Data Movement Rules |
Name | Type | Rule Text/Value |
Cnt Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical User Login Cnt |
NO | ||
Instrument Logbook (Oracle) USER_LOGIN CNT |
NO | ||
Logbook (Oracle) USER_LOGIN CNT |
NO |
Cnt Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Cnt Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Cnt Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Cnt Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Login Dte |
Base Entity | User Login |
Attribute Name | Login Dte |
Logical Rolename | |
ColumnName | LOGIN_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Login Date: The date and time the user logged into the system. |
Note |
Login Dte Logical Attribute Properties |
Logical Attribute Name | Login Dte |
Datatype | DATE |
Nullable | NO |
Login Dte Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Login Dte Security Types |
Name | Current Value |
Login Dte Bound Attachments |
Name | Current Value |
Login Dte Data Movement Rules |
Name | Type | Rule Text/Value |
Login Dte Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical User Login Login Dte |
NO | ||
Instrument Logbook (Oracle) USER_LOGIN LOGIN_DTE |
NO | ||
Logbook (Oracle) USER_LOGIN LOGIN_DTE |
NO |
Login Dte Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Login Dte Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Login Dte Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Login Dte Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |