SCHEMA_TRANSLATION 
Default Table Name  SCHEMA_TRANSLATION 
Definition 
 

SCHEMA_TRANSLATION Columns 
ColumnName  Domain  Datatype  NULL  Definition 
USER_COMPANY_ID(PK)    VARCHAR2(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    VARCHAR2(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    VARCHAR2(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    VARCHAR2(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    VARCHAR2(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    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person 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.
 
CASE_SENSITIVE_LOGIN_ID_FL    VARCHAR2(1)  NO 
Name: Case Sensitive Login Flag. Description: Logical as to whether domain login id is case sensitive.
 

SCHEMA_TRANSLATION Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0000  PrimaryKey  USER_COMPANY_ID 

SCHEMA_TRANSLATION Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
USER_INFO  Identifying  One To Zero or More  F00081        NO  NO 
SCHEMA_CONFIG  Identifying  One To Zero or More  F00093        NO  NO