USER_COMPANY_ID |
ColumnName | USER_COMPANY_ID |
Definition | 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 |
ColumnName | COMPANY_SCHEMA_ID |
Definition | 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 |
ColumnName | DISABLE_LOGIN_FL |
Definition | 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 |
ColumnName | UPGRADE_STATUS_CD |
Definition | 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 |
ColumnName | VERSION_CD |
Definition | 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 |
ColumnName | MODIFIED_BY |
Definition | Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
ColumnName | ROWVERSION |
Definition | Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
ColumnName | TIME_STAMP |
Definition | Name: Time Stamp. Description: Date and time the record was last modified. |
CASE_SENSITIVE_LOGIN_ID_FL |
ColumnName | CASE_SENSITIVE_LOGIN_ID_FL |
Definition | Name: Case Sensitive Login Flag. Description: Logical as to whether domain login id is case sensitive. |