Database Tables

The samples shipped with Business Rules include the database tables that are used to populate the tables required by the content validation node. Table 1 describes the sample tables that contain data for content validation.
Table 1. Sample database tables for content validation
Database Table Name Description
ERROR_CATEGORIES List of error categories. Table 1 contains the definition for this table.
REJECT_LEVELS List of validation rejection levels. Table 2 contains the definition for this table.
ERROR_CODES List of valid error codes with their associated rejection level, override flag, notification flag, and description. Table 3 contains the definition for this table.
DATA_TYPES List of transmission formats

X9_VAL_RECORDS

NACHA_VAL_RECORDS_SPEC

 Record types with the context error that should be returned when the record is found to be out of order. Table 4 contains the definition for this table.

X9_VAL_FIELDS

NACHA_VAL_FIELDS_SPEC

 List of fields for each record type. Table 5 contains the definition for this table.
X9_VAL_FORWARD_RULES_MAP List of the collection types associated with the forward rules. Table 6 contains the definition for this table.
X9_VAL_RETURN_RULES_MAP List of the collection types associated with the return rules. Table 7 contains the definition for this table.

X9_VAL_CONTENT_XXX

NACHA_VAL_CONTENT_XXX

 Content record field validation where XXX is for example GLOBAL, FORWARD, ORIGINATOR, etc. Refer to Table 2 for an example of the X9 Global Content table. Refer to the tables just below it for examples of additional configurations.
The X9 global content rules table is used with the X9 fields table to define validation rules for each field in a record. The X9 global content rules fields are defined in Table 2.
Table 2. X9_VAL_CONTENT_GLOBAL Table Definition
Field Name Data Type Length Description
DATA_TYPE smallint   Data Type. Makes content validation specific to a transmission type. Refer to Table 1
RECORD_TYPE smallint   Type of record. For example,
  • 1 is transmission
  • 10 is X9 batch
  • 20 is X9 bundle
  • 25 is X9 transaction
FIELD_NUMBER smallint   Field number
EDIT_REQUIRED char 1 Options are:
  • Y - Field is validated
  • N - Field is not validated
MANDATORY varchar 100 Flag to determine if the field is mandatory. Options are:
  • Y - Field is mandatory
  • N - Field is not mandatory

If the mandatory flag of the field depends on the value of another field, it is expressed as a conditional statement. For more information, see Mandatory Check.
JUSTIFICATION char 100 Justification flag or conditional. For more information, see Justification Check.
JUSTIFICATION2 char 100 Same as the justification field, except that there is no default justification. It is valid only if the justification field is a conditional justification rule.
VALUES1 varchar 100 List of valid values for the field. For more information, see Value Check.
VALUES2 varchar 100 List of valid values for the field
VALUES3 varchar 100 List of valid values for the field
VALUES4 varchar 100 List of valid values for the field
VALUES5 varchar 100 List of valid values for the field
LAST_UPDATED_USERID char 32 ID of the user that last updated the data
LAST_UPDATED_TIMESTAMP timestamp   Date and time of the last update

The X9 forward and return content rules tables have the same layout as the X9 global content rules table shown in Table 2.

The X9 product content rules table uses the layout of the global content rules table (Table 2) as a base, and then adds the fields shown in Table 3.
Table 3. X9_VAL_CONTENT_PRODUCT Table Definition
Field Name Data Type Length Description
PRODUCT_CODE char 4 ID from the deposit products table
The X9 depositor content rules table uses the layout of the global content rules table (Table 2) as a base, and then adds the fields shown in Table 4.
Table 4. X9_VAL_CONTENT_DEPOSITOR Table Definition
Field Name Data Type Length Description
DEPOSITOR char 9 Depositor ID from the ECE institution routing number
The X9 originator content rules table uses the layout of the global content rules table (Table 2) as a base, and then adds the fields shown in Table 5.
Table 5. X9_VAL_CONTENT_ORIGINATOR Table Definition
Field Name Data Type Length Description
ORIGINATOR char 9 Originator ID from the immediate origin routing number