Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
USER_COMPANY_ID |
|
VARCHAR(30) |
NO |
Name: Domain. Description: The logical name given to the schema. For internal system use. Do not modify unless instructed to do so by Deltek. |
COMPANY_SCHEMA_ID |
|
VARCHAR(30) |
NO |
Name: DB Schema ID. Description: The actual database login user ID for the named USER_COMPANY_ID. The convention is to start COMPANY_SCHEMA_ID with "TC_" and use numeric codes for schema assignment. TC_0000 is the master schema for Deltek Time and Expense. TC_9999 is reserved for training and contains the sample data for Deltek Time and Expense. |
DISABLE_LOGIN_FL |
|
VARCHAR(1) |
NO |
Name: Login Disabled Flag. Description: This establishes whether the login to the COMPANY_SCHEMA_ID is allowed. A value of "N" allows a user login. A value of "Y" blocks all users from logging in for the named USER_COMPANY_ID. The flag is checked only once at the beginning of a user connection. The connection is either allowed or disallowed and is not checked again for that user session. |
UPGRADE_STATUS_CD |
|
VARCHAR(1) |
NO |
Name: Upgrade Status. Description: This is used to indicate that a schema upgrade is in process and that users are not allowed to log into the named USER_COMPANY_ID. A value of "Y" enables the login and indicates that the named COMPANY_SCHEMA_ID has been upgraded to the current version. A value of "N" disables the login. A value of "F" means the named COMPANY_SCHEMA_ID failed the upgrade. |
VERSION_CD |
|
VARCHAR(15) |
NO |
Name: Version. Description: The product version of the named USER_COMPANY_ID. For internal system use. Do not modify unless instructed to do so by Deltek. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(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. |
CASE_SENSITIVE_LOGIN_ID_FL |
|
VARCHAR(1) |
NO |
Name: Case Sensitive Login Flag. Description: Logical as to whether domain login id is case sensitive. |