ERROR_ID 
ColumnName  ERROR_ID 
Definition 
Name: Error Identifier. Description: UUID - Unique Identifier in hex format.  This is the primary key for the record.
 

S_SOURCE_CD 
ColumnName  S_SOURCE_CD 
Definition 
Name: Import Source. Description: The import source. The valid values are: ASCII, XML, QUEUE, TABLE.
 

FILE_NAME 
ColumnName  FILE_NAME 
Definition 
Name: File Name. Description: ASCII or XML filename.
 

MESSAGE_GROUP_NAME 
ColumnName  MESSAGE_GROUP_NAME 
Definition 
Name: Import Unit. Description: Import unit name. E.g: UDT01, UDT02.. For unexpected errors, we set it to ‘GENERAL’
 

FIELD_NAME 
ColumnName  FIELD_NAME 
Definition 
Name: Field . Description: Name of the database field that caused the error.
 

S_IMPORT_CD 
ColumnName  S_IMPORT_CD 
Definition 
Name: Field . Description: Indicates the type of transaction. The valid values are:. A - Add. C - Change. D - Delete. B - Batch
 

S_ADJUSTED_IMPORT_CD 
ColumnName  S_ADJUSTED_IMPORT_CD 
Definition 
Name: . Description: Indicates if a batch transaction was adjusted to Add, Change or Delete.. The valid values are: . A - Add. C - Change. D - Delete
 

SOURCE_LOCATION 
ColumnName  SOURCE_LOCATION 
Definition 
Name: Source Location. Description: The source location for ASCII and XML imports. Depending on where the error occurred it may include file name, batch id, row count, message id, and xPath.
 

BATCH_DTT 
ColumnName  BATCH_DTT 
Definition 
Name: Batch Date/Time. Description: Date and time the import batch was started.
 

UNIT_KEY 
ColumnName  UNIT_KEY 
Definition 
Name: Import Key. Description: A concatenated string of primary key values for the transaction.
 

SOURCE_VERSION_S 
ColumnName  SOURCE_VERSION_S 
Definition 
Name: Import Source Version. Description: The source version is the backwardly compatible data format version level as defined in the Deltek Time and Expense with ESS Technical Guide. Generally each new version of Time and Expense with ESS accepts all prior data format versions. Data in a prior format version undergoes a transformation to make it compatible with the target version.
 

TARGET_VERSION_S 
ColumnName  TARGET_VERSION_S 
Definition 
Name: Import Target Version. Description: The target version is the data format of the currently executing code base. Data in all prior format versions is transformed to conform to the target data format version supported by the current version of the software.
 

MESSAGE_NAME 
ColumnName  MESSAGE_NAME 
Definition 
Name: Message Name. Description: The message name is the name of one of the sub-types of a message group. A message group is a set of closely related messages. Member messages of the group can be packaged together in a single data file. Each sub-type is identified by a unique s_import_type_cd.  E.g if the message_group_name is "CHARGE", then the message_name could be CHARGE, CHARGE_BRANCH_CHARGE, CHARGE_EMPL_GROUP etc. depending on the s_import_type_cd
 

IMPORT_TEXT 
ColumnName  IMPORT_TEXT 
Definition 
Name: Import Text. Description: XML string containing the import data.
 

ERROR_CD 
ColumnName  ERROR_CD 
Definition 
Name: Error Code. Description: E.g E0245. 
 

ERROR_STATUS_CD 
ColumnName  ERROR_STATUS_CD 
Definition 
Name: Error Status. Description: The valid values are:  ERROR, INFO.
 

ERROR_TEXT 
ColumnName  ERROR_TEXT 
Definition 
Name: Error Text. Description: For unexpected exception this contains a stack trace of the error.
 

EXTERNAL_USER 
ColumnName  EXTERNAL_USER 
Definition 
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. 
 

ERROR_DTT 
ColumnName  ERROR_DTT 
Definition 
Name: Error Date/Time. Description: The date and time when the error occurred. 
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.