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. |