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 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
TABLE_NAME    VARCHAR(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    VARCHAR(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    VARCHAR(254)  NO 
Name: . Description: COMMENTS provide a user-friendly view of the entry and explanations for certain entries.
 
CONV_CP_VERS_ID    VARCHAR(10)  NO 
Name: . Description: Conversion version identification. Not used by Deltek Time and Expense but retained for compatibility.
 
MODIFIED_BY    VARCHAR(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    NUMERIC(10, 0)  NO 
Name: Time Stamp. Description: The number of times this record has been updated.
 

TC_TABLE_VERS Keys 
Key Name  Key Type  Keys 

TC_TABLE_VERS Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype