SCHEMA_CONFIG 
Default Table Name  SCHEMA_CONFIG 
Definition 
 Name: Schema Config.     Description: This table contains configuration information for the different companies.
 

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

SCHEMA_CONFIG Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0121  PrimaryKey  USER_COMPANY_ID 

SCHEMA_CONFIG 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  F00093      USER_COMPANY_ID  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable