Error Table Structure

1. Columns of the Checked Table

• Description: The error table contains all the attributes (columns) of the checked datastore. These columns store the actual data from the datastore being checked, providing context for any errors.

2. ERR_TYPE

• Description: Specifies the type of error based on the type of check performed.
• Values:
• 'F': When the datastore is checked during flow control.
• 'S': When the datastore is checked using static control.

3. ERR_MESS

• Description: Contains the error message related to the violated constraint. This message provides information about why the record was rejected.

4. CHECK_DATE

• Description: The date and time when the datastore was checked. This helps in tracking when the validation occurred.

5. ORIGIN

• Description: Identifies the origin of the check operation. It specifies where the check was performed.
• Values:
• Set to either the datastore name or a mapping name and ID, depending on how the check was executed.

6. CONS_NAME

• Description: The name of the violated constraint. This column identifies which specific constraint was violated by the record (e.g., primary key, foreign key, etc.).

7. CONS_TYPE

• Description: Specifies the type of constraint that was violated.
• Values:
• 'PK': Primary Key
• 'AK': Alternate Key
• 'FK': Foreign Key
• 'CK': Check Condition
• 'NN': Mandatory Attribute (i.e., non-null)