USER_INFO 
Default Table Name  USER_INFO 
Definition 
 Name: User Information.     Description: This table identifies valid users of the system.
 

USER_INFO Columns 
ColumnName  Domain  Datatype  NULL  Definition 
LOGIN_ID(PK)    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(PK)(FK)    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
 

USER_INFO Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0112  PrimaryKey  LOGIN_ID, USER_COMPANY_ID 

USER_INFO Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
SCHEMA_TRANSLATION  Identifying  One To Zero or More  F00081      USER_COMPANY_ID  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
USER_PASSWORD  Identifying  One To Zero or More  F00082        NO  NO