ColumnName |
Domain |
Datatype |
NULL |
Definition |
USER_COMPANY_ID |
|
VARCHAR2(30) |
NO |
Name: Domain. Description: The external name used to log into Deltek Time and Expense. |
PASSWORD_LEN_NO |
|
NUMBER(10, 0) |
NO |
Name: Minimum Passord Length. Description: Minimum password length. |
PASSWORD_DAYS_NO |
|
NUMBER(10, 0) |
NO |
Name: Password Life (Days). Description: Number of days that a password is valid. |
PASSWORD_CYCLE_NO |
|
NUMBER(10, 0) |
NO |
Name: Password Reuse (Days). Description: Number of days before a password can be reused. |
PASSWORD_ATTEMPTS_NO |
|
NUMBER(10, 0) |
NO |
Name: Maximum Failed Attempts. Description: Number of unsuccessful login attempts before account is disabled. The application restricts the value this column contains. |
PASSWORD_NUMBER_FL |
|
VARCHAR2(1) |
NO |
Name: Number Required in Password Flag. Description: Logical as to whether passwords must contain at least one number. Defaults to "N." |
PASSWORD_SPECIAL_FL |
|
VARCHAR2(1) |
NO |
Name: Special Character Required in Password Flag. Description: Logical as to whether passwords must contain at least one special character. Defaults to "N." |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The login ID of the user who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
MIXED_CASE_PASSWORD_FL |
|
VARCHAR2(1) |
NO |
Name: Mixed Case Password Required Flag. Description: Logical as to whether user password must have mixed case. |
S_AUTHENTICATION_CD |
|
VARCHAR2(10) |
NO |
Authentication Type. Indicates type of authentication the system shall use for this domain. The valid values are as follows: DATABASE. LDAP. SSO |
S_AUTHENTICATION_SOURCE_CD |
|
VARCHAR2(10) |
NO |
Name: SSO Authentication Source. Description: Indicates the source of the users ID for SSO. The valid values are as follows: N/A. LOGIN_ID. CONTEXT_ID case |
PASSWORD_SELF_RESET_FL |
|
VARCHAR2(1) |
NO |
Name: Allow Password Self Reset Flag. Description: Logical as to whether domain allows employee’s to reset forgotten passwords. |
PASSWORD_QUESTION_S |
|
VARCHAR2(120) |
YES |
Name: Password Self Reset Question. Description: This column has been superceeded by LANGUAGE.password_question_s and will no longer be used. |
SAVE_LOGIN_TO_COOKIE_FL |
|
VARCHAR2(1) |
NO |
Name: Login ID Cookie Flag. Description: Logical as to whether a users Login ID is saved to a cookie. |
SAVE_DOMAIN_TO_COOKIE_FL |
|
VARCHAR2(1) |
NO |
Name: Domain Cookie Flag. Description: Logical as to whether a users Domain is saved to a cookie. |
LUMIGENT_ENABLED_FL |
|
VARCHAR2(1) |
NO |
Name: Lumigent Enabled Flag Description: Indicates if Lumigent is enabled for this domain. |
S_STORAGE_METHOD_CD |
|
VARCHAR2(10) |
NO |
|