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.