Database tables

The samples that are provided with Business Rules include the database tables that are used to populate the tables that are needed by the context validation node. The context validation node uses many of the same tables that the content validation node does.

For the tables that are used by the content validation node, see Sample database tables for content validation. The following table describes the sample tables that contain data for context validation.
Table 1. Sample database tables for context validation
Database table name Description

X9_VAL_CONTEXT_XXX

NACHA_VAL_CONTEXT_XXX

 Context record field validation where XXX is, for example, GLOBAL, FORWARD, or ORIGINATOR. Refer to Table 2 for an example of the X9 global context table.

X9 context tables

The X9 global context rules table defines the valid current record type and previous record types for global level validation. Its table definition is shown in the following table.
Table 2. X9_VAL_CONTEXT_GLOBAL table definition
Field name Data type Length Description
DATA_TYPE smallint   The data type, which makes content validation specific to a transmission type. For more information, see 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.
PRECEDED_BY smallint   Valid preceding record type from X9_VAL_RECORDS.
LAST_UPDATED_USERID char 32 ID of the user that last updated the record.
LAST_UPDATED_TIMESTAMP timestamp   Date and time of the last update.

The other stackable tables are not described here. They are laid out in a similar fashion as the tables for the content node, which are shown in Database tables.

The database fields that are in the records table are shown in the following table.
Table 3. X9_VAL_RECORDS table definition
Field name Data type Length Description
DATA_TYPE smallint   The data type, which makes content validation specific to a transmission type. For more information, see 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.
CONTEXT_ERROR char 24 Context error generated when the record is found out of context.
DESCRIPTION varchar 50 Record description.
LAST_UPDATED_USERID char 32 ID of the user that last updated the record.
LAST_UPDATED_TIMESTAMP timestamp   Date and time of the last update.