Validating Tables

Individual Only: Select to process only individual accounts. If you select this option, all options are available in the ID Options group box,

Individual and Organization: Select to process all accounts in the system. If you select this option, the ID Option is limited to All IDs.

Organization Only: Select to process only external organization accounts. If you select this option, all options are available in the ID Options group box.

Select to correct data errors when they are detected. Clear this check box to produce reports only. If you select this check box, the process still produces reports.

Select to run the process against all accounts in the system. If Individual and Organization is selected as the Select Option, All IDs is the required ID Option.

Select to run the process against a single individual or corporate account. When you select this option, the ID field becomes available.

Select to process a range of either individual or corporate accounts. When you select this option, the From ID and to ID fields become available.

Select to compare the account balance from the ACCOUNT_SF table with the sum of the item amounts from the ITEM_SF table. If the amounts are different, the system uses the sum of the item amounts to update the account balance.

Select to compare the account balance from the ACCOUNT_ORG_SF table with the sum of the item amounts from the ITEM_SF table. If the amounts are different, the system uses the sum of the item amounts to update the account balance.

Select to compare the item amount from the ITEM_SF table with the sum of the line amounts from the ITEM_LINE_SF table. If the amounts are different, the system uses the sum of the line amounts to update the item amount.

Select to compare the payment amounts from the PAYMENT_TBL table with the sum of the item amounts for each payment from the ITEM_SF table. If the amounts are different, the system uses the sum of the item amounts to update the payment amount.

Select to compare the refund amount from the REFUND_HDR table with the item amount from the ITEM_SF table. If the amounts are different, the system uses the item amount to update the refund amount.

Select to compare the sum of the cross reference amounts from the ITEM_XREF table with the applied amount from the ITEM_SF table. If the amounts are different, the system uses the cross-reference amount to update the applied amount.

Select to compare the sum of the cross-reference amount from the ITEM_XREF table with the net value of the item amount, minus the item balance from the ITEM_SF table. If the amounts are different, the system subtracts the sum of the cross-reference amount from the item amount and uses the result to update the item balance.

Select the Cross Reference CommonID Table check box and run the process.

The report performs the following cross checks:

• For every student with an account that is defined in ACCOUNT_SF and for every organization with an account that is defined in ACCOUNT_ORG_SF, the report verifies that a row exists in the SF_COMMON_ID table. If a row does not exist in the SF_COMMON_ID table and you run the report in update mode, the system inserts a row for the student or organization ID into SF_COMMON_ID.

• For every person or organization, the report verifies for each COMMON_ID that the maximum item number that is recorded in the ITEM_SF table matches the field ITEM_NBR_LAST stored in the SF_COMMON_ID table. When you run the report in update mode, if the ITEM_NBR_LAST in the SF_COMMON_ID table does not match the highest ITEM_NBR for a given student or organization in ITEM_SF, the program updates the field ITEM_NBR_LAST to match the highest ITEM_NBR in ITEM_SF for that student or organization.

• For every person or organization, the report verifies for each COMMON_ID that the maximum payment ID number recorded in the PAYMENT_TBL matches the field PAYMENT_ID_LAST stored in the SF_COMMON_ID table. When you run the report in update mode, if the PAYMENT_ID_LAST in the SF_COMMON_ID table does not match the highest PAYMENT_ID_NBR for a given student or organization in PAYMENT_TBL, the program updates the field PAYMENT_ID_LAST to match the highest PAYMENT_ID_NBR in PAYMENT_TBL for that student or organization.

The report lists any discrepancies found.

Select the Cross Reference CommonID Field check box and run the process.

The report cross checks COMMON_ID and SA_ID_TYPE against the fields EMPLID and EXT_ORG_ID in the following tables:

• ITEM_SF

• ITEM_LINE_SF

• PAYMENT_TBL

• ITEM_DUE_SF

For each table, the system reports errors when the following conditions occur:

• Both EMPLID and EXT_ORG_ID are populated.

• Neither EMPLID nor EXT_ORG_ID is populated.

• The SF_COMMON_ID.SA_ID_TYPE = P (person) and the EMPLID has a value that is not the same value in COMMON_ID.

• The SF_COMMON_ID.SA_ID_TYPE = O (organization) and the EXT_ORG_ID have values that are not the same value in COMMON_ID.

Select to compare the sum of the cross-reference amounts from the ITEM_XREF table with the item amount from the ITEM_SF table. If the item amount is less than this sum, the values in the ITEM_XREF table are set to zero and the errors are reported. To correct the errors, the payments must be backed out and then reapplied. Each payment can be backed out manually or by running the Applied Amount and Balance Amount reports after running this report. Exception: If the item is linked to a contract, the system does not set the values in the ITEM_XREF table to zero. To correct the errors, the contracts must be cancelled, the update process must be run again to zero the ITEM_XREF values, and the contracts must be reapplied.

Select to find any missing effective dates in the ITEM_XREF table to the item effective date in the ITEM_SF table. If dates are missing, the system uses the item effective date from ITEM_SF to update the effective date.

Select to find any missing payment ID numbers from the ITEM_XREF table with the payment ID number from the ITEM_SF table. If the numbers are different, the system uses the payment ID number from ITEM_SF to update the payment ID number in ITEM_XREF.

Select to validate the contract number in the ITEM_XREF table. If the item number contract is populated but the contract number is blank, the system uses the contract number from the TP_STUDENT table to update the ITEM_XREF table.

Select to find due date discrepancies in the ITEM_DUE_SF table. The program compares this due date with the due date from the ITEM_LINE_SF table. If the dates are different, the system uses the due date from ITEM_LINE_SF to calculate the appropriate value and update the ITEM_DUE_SF due date.

To correct any discrepancies, this option should be run in update mode.

Select in conjunction with the Item Due Date option to delete all due date values from the ITEM_DUE_SF table before recalculating them. This option only has an effect if the report is run in update mode.

Select to commit changes only at the end of processing.

This option applies only to the Item Due Date option.

Select to specify a commit level. When you select this option, you are required to specify a value in the box that appears to the right. The program commits changes to the table after each 100 IDs have been processed.