IMPORT_ERROR 
Default Table Name  IMPORT_ERROR 
Definition 
 Name: Employee Leave Import  .     Description: This table contains errors found while processing imports.
 

IMPORT_ERROR Columns 
ColumnName  Domain  Datatype  NULL  Definition 
ERROR_ID(PK)    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.
 

IMPORT_ERROR Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0270  PrimaryKey  ERROR_ID 

IMPORT_ERROR 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