Validation of Records
The SPED Fiscal - Block 9 Control & Join program validates some of the values in the F76B0511 table against values in the F76B0780 table to determine the rules to apply to records. If rules are not found in the F76B0780 table for a register, but the records exist in the F76B0511 table, the system includes the records from F76B0511 in the flat file, but does not validate them against rules set up in the F76B0780 table. The system prints a message in the report that states that a rule was not found, and that the record is included without validation.
If the record is found in the F76B0780 table, the SPED Fiscal - Block 9 Control & Join program retrieves the input rule, output rule, and other rule from the F76B0780 table and compares them to the value for the Cotepe Register Type (data item B76CRTY) in the F76B0512 table. The system applies the rules according to this logic:
If the value of the Cotepe Register Type field is I, then the system uses the rule set up for input transactions (F76B0780.B76CIR).
If the value of the Cotepe Register Type field is O, then the system uses the rule set up for output transactions (F76B0780.B76COR).
If the value of the Cotepe Register Type field is B, then the system uses the rule set up for other transactions (F76B0780.B76CAR).
If the value of the Cotepe Register Type field is U, the system accesses the values for F76B0780.B76CIR and F76B0780.B76COR for the record in F76B0512. If either of the values is O, then the system uses the rule set up in F76B0780.B76COR.
If the value in F76B0780.B76CIR or F76B0780.B76COR is other than O, the system does not include the record in the flat file.
After the system determines which rule to apply to records, it takes one of the actions listed in this table to determine whether to include the data in the flat file:
F76B0512.B76CRTY |
F76B0512.B76CRDT |
Cotepe Rule Value |
Action |
|---|---|---|---|
I (input) |
I (information available) |
O (obligatory) |
Include |
I |
I |
OC (report if information exists) |
Include |
I |
I |
C (conditional) |
Include |
I |
I |
N (no not include) |
Omit |
I |
D (no data) |
O |
Omit and write warning to report. |
I |
D |
OC |
Omit |
I |
D |
C |
Include |
I |
D |
N |
Omit |
O (output) |
I |
O |
Include |
O |
I |
OC |
Include |
O |
I |
C |
Include |
O |
I |
N |
Omit |
O |
D |
O |
Omit and write warning to report. |
O |
D |
OC |
Omit |
O |
D |
C |
Include |
O |
D |
N |
Omit |
B |
I |
O |
Include |
B |
I |
OC |
Include |
B |
I |
C |
Include |
B |
I |
N |
Omit |
B |
D |
O |
Omit and write warning to report. |
B |
D |
OC |
Omit |
B |
D |
C |
Include |
B |
D |
N |
Omit |
U |
na |
O |
Omit and write warning to report. |
U |
na |
Blank |
Omit |
When a required record is omitted because the data is not available, the system writes a warning message to the report stating that the required record is not included in the flat file. If a record exists in the F76B0511 table, but does not exist in the F76B0512 table, the system prints a message on the report that information required to evaluate the Cotepe rules is not available, and the system stops processing records. The system includes in the report information about the F76B0511 record that is missing F76B0512 information so that you can locate the record.