Data flow logic for Finance |
| |
| Receipts are collected at multiple stations throughout the district |
| These receipts are written to 3 locations: Local computer, court database and District database in Tyler |
| Finance needs to retrieve the receipts from the District database that apply to Victim restitution |
| "Get receipts from District" |
| The data is retrieved by a stored procedured called "GetDistrictReceipts" |
| To see it in this list, CopiedToFinance is blank |
| After retrieving the relevent receipts from District, each receipt must be matched to a valid case |
| "Match receipts to a case" |
| The data is retrieved by a stored procedured called "GetFinanceReceipts" |
| To see it in this list, ConfirmedCaseNo is blank |
| The receipts can now be allocated to the victims |
| "Select Case to process" |
| The data is retrieved by a stored procedured called "GetFinanceReceiptsSummary" |
| To see it in this list, BatchID is blank |
| **This is were payments are applied in the order as specified on Sheet 6 of the judgment** |
| The receipts are now ready to be sent to FAST for payment |
| "Select Items to send to FAST" |
| The data is retrieved by 2 stored procedured called "spFASTsummary" and "spFASTdetails" |
| To see it in this list, ToBePaid is blank |
| The items need to be marked as paid when FAST is done |
| "Items waiting to receive from FAST" |
| The data is retrieved by a stored procedured called "GetListOfVouchersWaitingPayment" |
| To see it in this list, CheckNo must be blank |