TC_TABLE_VERS 
Default Table Name  TC_TABLE_VERS 
Definition 
 Name: Version and patch level versification table..     Description: This table contains information about the status of the database. One row stores the current version (for example, "5.0"). Other rows track all patches and Emergency Bug Fixes (EBFs) that have been applied against the database. Other rows record customized table structures (if any). The Deltek Time and Expense screen checks this table to make sure that the database and the software are at the same version.
 

TC_TABLE_VERS Columns 
ColumnName  Domain  Datatype  NULL  Definition 
TABLE_NAME    VARCHAR2(18)  NO 
Name: . Description: TABLE_NAME is an alias that stores the name of files as well as the database version and Customer Service Pack (CSP) level. It also stores the file name/reference of patches, custom work, and other information designated by the product group. Other information can include status of initialization, special forms, or currencies. Standard coding uses:
 
CUR_VERS_ID    VARCHAR2(10)  NO 
Name: . Description: This column is used to associate the version code with the object named in TABLE_NAME. Although there are exceptions, the version code of each line entry should be the same for a given database.
 
CONV_DT    DATE  YES 
Name: . Description: Conversion date. Not used by Deltek Time and Expense but retained for compatibility.
 
COMMENTS    VARCHAR2(254)  NO 
Name: . Description: COMMENTS provide a user-friendly view of the entry and explanations for certain entries.
 
CONV_CP_VERS_ID    VARCHAR2(10)  NO 
Name: . Description: Conversion version identification. Not used by Deltek Time and Expense but retained for compatibility.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: MODIFIED_BY shows the User ID of the person who last changed or inserted the row.
 
TIME_STAMP    DATE  NO 
Name: Row Version. Description: Date and time the record was last modified.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Time Stamp. Description: The number of times this record has been updated.
 

TC_TABLE_VERS Primary and Unique Keys 
Key Name  Key Type  Keys 

TC_TABLE_VERS 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