ColumnName |
Domain |
Datatype |
NULL |
Definition |
ERROR_ID |
|
VARCHAR2(32) |
NO |
Name: Error Identifier. Description: UUID - Unique Identifier in hex format. This is the primary key for the record. |
S_SOURCE_CD |
|
VARCHAR2(10) |
NO |
Name: Import Source. Description: The import source. The valid values are: ASCII, XML, QUEUE, TABLE. |
FILE_NAME |
|
VARCHAR2(254) |
YES |
Name: File Name. Description: ASCII or XML filename. |
MESSAGE_GROUP_NAME |
|
VARCHAR2(50) |
NO |
Name: Import Unit. Description: Import unit name. E.g: UDT01, UDT02.. For unexpected errors, we set it to ‘GENERAL’ |
FIELD_NAME |
|
VARCHAR2(30) |
YES |
Name: Field . Description: Name of the database field that caused the error. |
S_IMPORT_CD |
|
VARCHAR2(1) |
YES |
Name: Field . Description: Indicates the type of transaction. The valid values are:. A - Add. C - Change. D - Delete. B - Batch |
S_ADJUSTED_IMPORT_CD |
|
VARCHAR2(1) |
YES |
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 |
|
VARCHAR2(254) |
YES |
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 |
|
DATE |
NO |
Name: Batch Date/Time. Description: Date and time the import batch was started. |
UNIT_KEY |
|
VARCHAR2(254) |
YES |
Name: Import Key. Description: A concatenated string of primary key values for the transaction. |
SOURCE_VERSION_S |
|
VARCHAR2(10) |
YES |
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 |
|
VARCHAR2(10) |
YES |
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 |
|
VARCHAR2(50) |
YES |
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 |
|
CLOB |
YES |
Name: Import Text. Description: XML string containing the import data. |
ERROR_CD |
|
VARCHAR2(10) |
NO |
Name: Error Code. Description: E.g E0245. |
ERROR_STATUS_CD |
|
VARCHAR2(10) |
NO |
Name: Error Status. Description: The valid values are: ERROR, INFO. |
ERROR_TEXT |
|
CLOB |
YES |
Name: Error Text. Description: For unexpected exception this contains a stack trace of the error. |
EXTERNAL_USER |
|
VARCHAR2(20) |
YES |
Name: External User. Description: User ID of the non-TC user initiating the insert into the Import table. |
ERROR_DTT |
|
DATE |
NO |
Name: Error Date/Time. Description: The date and time when the error occurred. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |