ColumnName |
Domain |
Datatype |
NULL |
Definition |
LOGIN_ID |
|
VARCHAR2(20) |
NO |
Name: Login ID. Description: Login ID identifier for the user.Corresponds to EMPL. login_empl_id in the schema associated with the USER_COMPANY_ID in SCHEMA_TRANSLATION.. |
USER_COMPANY_ID |
|
VARCHAR2(30) |
NO |
Domain. Description: The external name a person uses to access the Deltek Time and Expense System. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Modified By. Description: The Login ID that last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Time Stamp. Description: Date and time the record was last modified. |
LOGIN_ATTEMPTS_NO |
|
NUMBER(5, 0) |
NO |
Current Unsucessful Login Attempts. Description: Number of times the user logged in or attempted to log into the system |
LDAP_CONTEXT_S |
|
VARCHAR2(120) |
YES |
LDAP Context. Description: The context where the login ID can be found in LDAP directory. |
RESET_ATTEMPTS_NO |
|
NUMBER(5, 0) |
NO |
Reset Password Attempts. Description: Number of times the user logged in or attempted to reset password |
PASSWORD_ANSWER_S |
|
VARCHAR2(40) |
YES |
Password Reset Answer. Description: The employee’s answer to the security question for the password self reset. This field is encrypted |