Database views

To transform the sample tables to the format required by Business Rules, (for more details, see Table Record Layout) a set of database views are required. The binary tables cannot be edited directly. The views provide a way to combine the database tables that can be edited using the Business Rules user interface and the binary tables used by Business Rules at run time.

The X9 collectors table database view (Table 1) joins the X9 collectors table with the X9 fields and error codes tables to create the list of collectors. The resulting data corresponds with the definitions in Table 2 and Table 3.
Table 1. X9_VAL_COLLECTORS_V view definition
View column Source table Source column
ibmFileFormat X9_VAL_COLLECTORS DATA_TYPE
ibmValCollectSourceRecType X9_VAL_COLLECTORS SOURCE_RECORD_TYPE
ibmValCollectIndex Generated by the view  
ibmValCollectName X9_VAL_COLLECTORS NAME
ibmValCollectorType X9_VAL_COLLECTORS TYPE
ibmValCollectTargetRecType X9_VAL_COLLECTORS TARGET_RECORD_TYPE
ibmValCollectTargetFieldNum X9_VAL_COLLECTORS TARGET_FIELD_NUMBER
ibmValCollectTargetFixedPos X9_VAL_FIELDS FIXED_FIELD_POS
ibmValCollectTargetFixedLen X9_VAL_FIELDS FIXED_FIELD_LEN
ibmValCollectTargetVarPos X9_VAL_FIELDS FIXED_FIELD_POS
ibmValCollectTargetVarLen X9_VAL_FIELDS FIXED_FIELD_LEN
ibmValCollectTargetValue X9_VAL_COLLECTORS TARGET_VALUE
ibmValCollectComparison X9_VAL_COLLECTORS COMPARISON
ibmValCollectCompareFactor X9_VAL_COLLECTORS COMPARE_FACTOR
ibmvalCollectCompareCondition X9_VAL_COLLECTORS COMPARE_CONDITIONAL
ibmValCollectConditional X9_VAL_COLLECTORS CONDITIONAL
ibmValCollectErrorCode X9_VAL_COLLECTORS ERROR_CODE
ibmValCollectReject ERROR_CODES REJECT
ibmValCollectOverride ERROR_CODES OVERRIDE
The X9 count collector table database view (Table 2) joins the X9 count collector table with itself to create the list of records. The data corresponds to the definitions in Table 3.
Table 2. X9_VAL_COLLECTOR_COUNT_V view definition
View column Source table Source column
ibmFileFormat X9_VAL_COLLECTOR_COUNT DATA_TYPE
ibmValCollectName X9_VAL_COLLECTOR_COUNT NAME
ibmValCollectIndex Generated by the view  
ibmValCollectRecType X9_VAL_COLLECTOR_COUNT RECORD_TYPE
ibmValCollectConditional X9_VAL_COLLECTOR_COUNT CONDITIONAL
The X9 sum collector table database view (Table 3) joins the X9 sum collector table with the X9 fields table to create the list of fields in the sum collectors. The resulting data corresponds to the definitions in Table 4.
Table 3. X9_VAL_COLLECTOR_SUM_V view definition
View column Source table Source column
ibmFileFormat X9_VAL_COLLECTOR_SUM DATA_TYPE
ibmValCollectName X9_VAL_COLLECTOR_SUM NAME
ibmValCollectIndex Generated by the view  
ibmValCollectRecType X9_VAL_COLLECTOR_SUM RECORD_TYPE
ibmValCollectFieldNum X9_VAL_COLLECTOR_SUM FIELD_NUMBER
ibmValCollectFixedPos X9_VAL_FIELDS FIXED_FIELD_POS
ibmValCollectFixedLen X9_VAL_FIELDS FIXED_FIELD_LEN
ibmValCollectVarPos X9_VAL_FIELDS FIXED_FIELD_POS
ibmValCollectVarLen X9_VAL_FIELDS FIXED_FIELD_LEN
ibmValCollectAddConstant X9_VAL_COLLECTOR_SUM ADDITIONAL_CONSTANT
ibmValCollectConditional X9_VAL_COLLECTOR_SUM CONDITIONAL
The X9 unique collector table database view (Table 4) joins the X9 unique collector table with the X9 fields table to create the list of fields included in the unique collectors. The resulting data corresponds to the definitions in Table 5.
Table 4. X9_VAL_COLLECTOR_UNIQUE_V view definition
View column Source table Source column
ibmFileFormat X9_VAL_COLLECTOR_UNIQUE DATA_TYPE
ibmValCollectName X9_VAL_COLLECTOR_UNIQUE NAME
ibmValCollectIndex Generated by the view  
ibmValCollectRecType X9_VAL_COLLECTOR_UNIQUE RECORD_TYPE
ibmValCollectFieldNum X9_VAL_COLLECTOR_UNIQUE FIELD_NUMBER
ibmValCollectFixedPos X9_VAL_FIELDS FIXED_FIELD_POS
ibmValCollectFixedLen X9_VAL_FIELDS FIXED_FIELD_LEN
ibmValCollectVarPos X9_VAL_FIELDS FIXED_FIELD_POS
ibmValCollectVarLen X9_VAL_FIELDS FIXED_FIELD_LEN
ibmValCollectOrdering X9_VAL_COLLECTOR_UNIQUE ORDERING
ibmValCollectConditional X9_VAL_COLLECTOR_UNIQUE CONDITIONAL
ibmValType X9_VAL_FIELDS TYPE
The NACHA collectors general table database view (Table 5) joins the NACHA collectors table with the error codes table to create the list of collectors. The resulting data corresponds with the definitions in Table 6 and Table 3.
Table 5. NACHA_VAL_COLLECTORS_GENERAL_SPEC_V view definition
View column Source table Source column
ibmFileFormat NACHA_VAL_COLLECTORS_GENERAL_SPEC DATA_TYPE
ibmValCollectSourceRecType NACHA_VAL_COLLECTORS_GENERAL_SPEC SOURCE_RECORD_TYPE
ibmValCollectIndex Generated by the view  
ibmValCollectName NACHA_VAL_COLLECTORS_GENERAL_SPEC NAME
ibmValCollectorType NACHA_VAL_COLLECTORS_GENERAL_SPEC TYPE
ibmValCollectTargetRecType NACHA_VAL_COLLECTORS_GENERAL_SPEC TARGET_RECORD_TYPE
ibmValCollectTargetFieldDesc NACHA_VAL_COLLECTORS_GENERAL_SPEC TARGET_FIELD_DESCRIPTION
ibmValCollectTargetValue NACHA_VAL_COLLECTORS_GENERAL_SPEC TARGET_VALUE
ibmValCollectComparison NACHA_VAL_COLLECTORS_GENERAL_SPEC COMPARISON
ibmValCollectCompareFactor NACHA_VAL_COLLECTORS_GENERAL_SPEC COMPARE_FACTOR
ibmvalCollectCompareCondition NACHA_VAL_COLLECTORS_GENERAL_SPEC COMPARE_CONDITIONAL
ibmValCollectConditional NACHA_VAL_COLLECTORS_GENERAL_SPEC CONDITIONAL
ibmValCollectErrorCode NACHA_VAL_COLLECTORS_GENERAL_SPEC ERROR_CODE
ibmValCollectReject ERROR_CODES REJECT
ibmValCollectOverride ERROR_CODES OVERRIDE
The NACHA collectors specific table database view (Table 6) joins the NACHA collectors table with the error codes table to create the list of collectors. The resulting data corresponds with the definitions in Table 6 and Table 3.
Table 6. NACHA_VAL_COLLECTORS_SPECIFIC_SPEC_V view definition
View column Source table Source column
ibmFileFormat NACHA_VAL_COLLECTORS_SPECIFIC_SPEC DATA_TYPE
ibmValCollectSourceRecType NACHA_VAL_COLLECTORS_SPECIFIC_SPEC SOURCE_RECORD_TYPE
ibmValCollectSourceSecCode NACHA_VAL_COLLECTORS_SPECIFIC_SPEC SOURCE_SEC_TYPE
ibmValCollectSourceAddenda NACHA_VAL_COLLECTORS_SPECIFIC_SPEC SOURCE_ADDENDA
ibmValCollectIndex Generated by the view  
ibmValCollectName NACHA_VAL_COLLECTORS_SPECIFIC_SPEC NAME
ibmValCollectorType NACHA_VAL_COLLECTORS_SPECIFIC_SPEC TYPE
ibmValCollectTargetRecType NACHA_VAL_COLLECTORS_SPECIFIC_SPEC TARGET_RECORD_TYPE
ibmValCollectTargetFieldDesc NACHA_VAL_COLLECTORS_SPECIFIC_SPEC TARGET_FIELD_DESCRIPTION
ibmValCollectTargetValue NACHA_VAL_COLLECTORS_SPECIFIC_SPEC TARGET_VALUE
ibmValCollectComparison NACHA_VAL_COLLECTORS_SPECIFIC_SPEC COMPARISON
ibmValCollectCompareFactor NACHA_VAL_COLLECTORS_SPECIFIC_SPEC COMPARE_FACTOR
ibmvalCollectCompareCondition NACHA_VAL_COLLECTORS_SPECIFIC_SPEC COMPARE_CONDITIONAL
ibmValCollectConditional NACHA_VAL_COLLECTORS_SPECIFIC_SPEC CONDITIONAL
ibmValCollectErrorCode NACHA_VAL_COLLECTORS_SPECIFIC_SPEC ERROR_CODE
ibmValCollectReject ERROR_CODES REJECT
ibmValCollectOverride ERROR_CODES OVERRIDE
The NACHA count collector table database view (Table 7) joins the NACHA count collector table with itself to create the list of records. The data corresponds to the definitions in Table 7.
Table 7. NACHA_VAL_COLLECTOR_COUNT_SPEC_V view definition
View column Source table Source column
ibmFileFormat NACHA_VAL_COLLECTOR_COUNT_SPEC DATA_TYPE
ibmValCollectName NACHA_VAL_COLLECTOR_COUNT_SPEC NAME
ibmValCollectIndex Generated by the view  
ibmValCollectRecType NACHA_VAL_COLLECTOR_COUNT_SPEC RECORD_TYPE
ibmValCollectConditional NACHA_VAL_COLLECTOR_COUNT_SPEC CONDITIONAL
The NACHA sum collector table database view (Table 8) joins the NACHA sum collector table with itself to create the list of fields in the sum collectors. The resulting data corresponds to the definitions in Table 8.
Table 8. NACHA_VAL_COLLECTOR_SUM_SPEC_V view definition
View column Source table Source column
ibmFileFormat NACHA_VAL_COLLECTOR_SUM_SPEC DATA_TYPE
ibmValCollectName NACHA_VAL_COLLECTOR_SUM_SPEC NAME
ibmValCollectIndex Generated by the view  
ibmValCollectRecType NACHA_VAL_COLLECTOR_SUM_SPEC RECORD_TYPE
ibmValCollectFieldDesc NACHA_VAL_COLLECTOR_SUM_SPEC FIELD_DESCRIPTION
ibmValCollectAddConstant NACHA_VAL_COLLECTOR_SUM_SPEC ADDITIONAL_CONSTANT
ibmValCollectConditional NACHA_VAL_COLLECTOR_SUM_SPEC CONDITIONAL
The NACHA unique collector table database view (Table 9) joins the NACHA unique collector table with itself to create the list of fields included in the unique collectors. The resulting data corresponds to the definitions in Table 9.
Table 9. NACHA_VAL_COLLECTOR_UNIQUE_SPEC_V view definition
View column Source table Source column
ibmFileFormat NACHA_VAL_COLLECTOR_UNIQUE_SPEC DATA_TYPE
ibmValCollectName NACHA_VAL_COLLECTOR_UNIQUE_SPEC NAME
ibmValCollectIndex Generated by the view  
ibmValCollectRecType NACHA_VAL_COLLECTOR_UNIQUE_SPEC RECORD_TYPE
ibmValCollectFieldDesc NACHA_VAL_COLLECTOR_UNIQUE_SPEC FIELD_DESCRIPTION
ibmValCollectOrdering NACHA_VAL_COLLECTOR_UNIQUE_SPEC ORDERING
ibmValType NACHA_VAL_FIELDS_SPEC TYPE
ibmValCollectConditional NACHA_VAL_COLLECTOR_UNIQUE_SPEC CONDITIONAL