Campus Receivables Collector
Release Guide
Release 3.0.0
April 2013
Banner®, Colleague®, Luminis® and Datatel® are trademarks of Ellucian or its affiliates and are registered in the U.S. and other countries. Ellucian ™, PowerCampus™, Advance™, Degree Works™, fsaATLAS™, Course Signals™, SmartCall™, Recruiter™, and ILP™ are trademarks of Ellucian Company L.P. or its affiliates. Other names may be trademarks of their respective owners.
© 2012-2013 Ellucian Company L.P. and its affiliates. The unauthorized possession, use, reproduction, distribution, display or disclosure of this material or the information contained herein is prohibited.
Contains confidential and proprietary information of Ellucian and its subsidiaries. Use of these materials is limited to Ellucian licensees, and is subject to the terms and conditions of one or more written license agreements between Ellucian and the licensee in question.
In preparing and providing this publication, Ellucian is not rendering legal, accounting, or other similar professional services. Ellucian makes no claims that an institution's use of this publication or the software for which it is provided will guarantee compliance with applicable federal or state laws, rules, or regulations. Each organization should seek legal, accounting and other similar professional services from competent providers of the organization's own choosing.
Prepared by: Ellucian 4375 Fair Lakes Court Fairfax, Virginia 22033 United States of America
Revision History
Publication Date Summary
April 2013 New version that supports Campus Receivables Collector 3.0.0 software.
A SPECIAL NOTE ABOUT THIS RELEASE 4
CAMPUS RECEIVABLES COLLECTOR 4
CRC CUSTOMER WEB ACCESS SPECIFIC ENHANCEMENTS 6
SQL SERVER DATABASE CHANGES 33
APPENDIX A - MENU TERMINOLOGY CROSSWALK 49
APPENDIX B - CROSSWALK FROM 2.7.0 REPORTS TO CONSOLIDATED 3.0 REPORTS 57
CLOSED/PAID IN FULL REPORT CROSSWALK … 2.7.0 TO 3.0 57
CONSOLIDATION OF PAYMENT REPORTS CROSSWALK… 2.7.0 TO 3.0 61
ADDITIONALLY RUN INBOUND MANUAL BATCH 68
EQUIV 3.0 CONSOLIDATED PAYMENTS OR PAYMENTS IN BATCH (NEW REPORT) 69
This Release Guide documents the Release 3.0.0 of the Campus Receivables Collector (CRC) system. The release 3.0.0 includes enhancements and problem resolutions.
As of Release 3.0, the product formerly known as Campus Loan Manager (CLM) has been renamed and is now known as Campus Receivables Collector (CRC). Over the past couple of years, CLM has been enhanced evolving to a more robust all campus debt collection software. To more correctly reflect the full functionality of the product, both the administrative application (CLM) and the borrower web application (BWA) have been re-named to Campus Receivables Collector (CRC) and Customer Web Access (CWA) respectively. Included in this release, you will notice a re-face of the products which include: changes in terminology which supports the enhanced functionality of collections for Accounts Receivable (student and non-student) and changes in the organization of the menu driven system which has been formatted in functional groups rather than alpha.
At the same time, we have kept some of the internal naming constructs in place, such as folder names and other items that are not visible to the typical user. This allows us to continue to provide upgrades to our customer base without requiring time-consuming and potentially mistake-prone changes to the product infrastructure.
For installation purposes, be aware that CLM = CRC when encountering references to those names in the internal structure of the product.
Encryption of SSN and Password data stored in the CRC Database
The purpose of this enhancement is to prevent the exposure of sensitive information in the database to any one viewing the database outside of the CRC application interface. This enhancement will protect the sensitive nature of the SSN and Password columns throughout the CRC database by using Microsoft SQL Server Transact-SQL Cryptographic Functions to encrypt and decrypt the data. The encryption method employed will be Symmetric Key with AES_256 Algorithm Encrypted by a Certificate.
Re-Brand/Re-Face
Tab Function Label Change
Office Management -> Administration
Borrower Services -> Customer Accounts
Inbound -> Import
Outbound -> Export
SSN Encryption
Menu selections by function
Added middle name and date of birth to „customer find? result lists
Screen headers remain constant when scrolling is necessary
Account Grid Color Schema – client options based on status and number payments past due.
To edit, the file is in the “css” folder and is named LoanGrid.css. Within that file (which is a style sheet) the following classes can be modified to the institution?s liking.
The classes are (alphabetically):
accelerated
balDueInFull
deferred
enrolled
normalLoan
onePastDue
overThreePastDue
postponed
threePastDue
twoPastDue
They are linked to the loan/receivable status and the number of payments past due, if applicable. The color of the font and/or the background may be set for any of these
circumstances. The font, font-size and bold setting can also be set BUT changing the font-size is likely to affect the alignment and page sizing of the loan grid and so it is not recommended.
Menu terminology crosswalk provided (see Appendix A)
Prohibit access to Customer Web Access (CWA) for customers whose accounts are placed with an external collection agency. This script will be provided upon request through the Ellucian Customer Support Center
System Configuration-Customer Web Access Parameters - Reconfigured and enhanced to better organize the information and to support some new and updated parameters for ease of data entry.
System Configuration-Loan/Receivable Set-up: Added parameter „Default New Customers? Correspondence Method to?. Established all new customers? correspondence option to your preferred choice. Contact Ellucian Customer Support Center to obtain script to set all existing customers if desired.
System Configuration-Customer Web Access Parameters –Payment Parameters: controls the interface between CWA and a third party payment gateway provider.
Automatically apply payments received through the payment gateway?: When set to Yes the payment will be automatically applied to the Customer?s CRC/CWA account when the payment was successfully processed by the payment gateway provider. When set to No payments successfully processed by the payment gateway provider will be placed in an Import Payment Batch for application by a CRC user in Import>Apply Payment Records.
CRC URL for auto-application of payments: Must contain the URL for CRC when
“Automatically apply payments received through the payment gateway?” is set to Yes. CWA needs to know the location of the payment posting page (IB_LBProcessPostPaymentUnattended.asp). Do NOT include trailing forward slash (/).
Successful Payment Message: message displayed to the Customer when the payment
gateway provider indicates a payment was successful.
Unsuccessful Payment Message: message displayed to the Customer when the payment
gateway provider indicates a payment was NOT successful.
System Configuration-Customer Web Access Parameters- Email Options:
Billing Email Message: contains the text of the email to be sent to the Customer whenever invoices or due diligence mail is generated and released to the Customer. You may use the following replaceable tags with the text:
#SCHOOLNAME – the name of your school as set in OM>System
Configuration>School Parameters
#AMOUNT – total amount due on bill
#DUEDATE – date bill is due
#BWAURLLINK – hyperlink that will take the Customer to CWA as set in OM>System Configuration>Customer Web Access Parameters>System Settings
Incomplete Exit Email Message: contains the text of the email to be sent to the Customer while there is an online exit pending. An online exit is pending until the Customer logs into CWA and completes an online exit. At that time the exit will flagged as completed and they will cease to receive this email. You may use the following replaceable tags with the text:
#SCHOOLNAME – the name of your school as set in OM>System
Configuration>School Parameters
#BWAURLLINK – hyperlink that will take the Customer to CWA as set in OM>System Configuration>Customer Web Access Parameters>System Settings
Menu terminology crosswalk provided (see Appendix A)
Added functionality to process Exits at Customer level allowing to exit multiple loans simultaneously
ACH process
Added routing number verification
Added „effective from/through? dates
Added „Remove account from Collection? at Loan/Receivable level
Option to decelerate
Aging and placement in appropriate system queue takes place upon removal
Menu terminology crosswalk provided (see Appendix A)
Consolidated reports for paid in full processing (see Appendix B) o Consolidated reports for processed payments (see Appendix B) o Added option to exclude zero balance accounts from reports
Added fund selections to many reports (i.e. all, groups, specific)
Menu terminology crosswalk provided (see Appendix A)
Menu terminology crosswalk provided (see Appendix A)
ACH – added email notification upon creation of extract file (Queued Mail)
Benefit Mail – option to Include/Exclude statement with correspondence
Re-Brand/Re-Face
Enabled Customers to select communication method to Paperless, Paper, or Both
ACH: Customer has option to specify effective start/end dates for withdrawal.
Added option to auto-apply Gateway payments real-time (See Administration/System Configuration-CWA Parameters-Payment Parameters)
Added Email options – (See Administration/System Configuration-CWA Parameters-Email Options)
Select the email release control option for each of 3 correspondence groups
Specify the text of email notification for each of 3 correspondence groups
Import
Add correspondence upon import
Assign to a Collection Queue upon import
Place Banner hold immediately
Option to post payments real-time or batch from CRC/CWA
Enhanced selection criteria for import of Banner debt.
Include 100% debt if customer meets any of selected criteria
Exclude customer if meets selected criteria yet enrolled in recent term
Export
CRC Payments to Banner A/R (Auto/Batch)
Reports
CRC to Banner A/R Reconciliation
Banner A/R Payment Transfers
Administration
Process - Synchronize CRC to Banner (used for Replicated scenario only)
Banner adjustments to debts previously recorded to CRC, will subsequently be adjusted to CRC with the synchronization process.
System Configuration-Student System Access: Added parameter to establish method for handling of
Banner A/R debt
Import Method - Transfer or Replicate
Posting Method – None, Auto, Batch
In Transfer scenario – The posting is the credit to write off debt in Banner A/R
In Replicate scenario – The posting are the payment/adjustment transactions processed in CRC transferred to Banner A/R
A/R Posting Code – Detail code for use in Banner A/R
Customer Accounts
Payment Plan Calculator: Establishes the payment terms of account to the TRA calculated amounts. (not for use with federal loans without re-negotiated repayment schedule)
This information is for people who have been using a previous version of Campus Receivables Collector. If Campus Receivables Collector 2.7.0 is currently installed on your system, you can upgrade to 3.0.0
If a version other than Campus Receivables Collector 2.7.0 is currently installed on your system, you must first upgrade to 2.7.0 before you can upgrade to 3.0.0.
This section describes RPEs delivered in this release. The following Campus Receivables Collector processes and forms have been enhanced.
RPE# | Requested Functionality | Resolution | |
1-83HEI7 | Reports > Defaults – Missed Payment | Added option to select by loan sub- |
RPE# | Requested Functionality | Resolution | |
Aging Add option to run by loan sub-name. Eliminates need to run individual aging reports. | name. Added option to exclude House Accounts (Admin Fees). | ||
1-15J5HHY | Customer Accounts > Personal > Family/Personal Make enrollment begin date optional. Date is not always known. | Enrollment begin date is now optional. | |
CMS-RPE40012 | Export > Correspondence > Benefit Mail | Added the checkbox “Include an | |
Account Statement Page” that, when | |||
CMS-RPE46352 | Need option to limit printing of bill to only | checked, will print a bill for everyone | |
CMS-RPE46969 | those who truly have an amount due and not everyone receiving a benefit notice. | receiving a notice in the selected batch. | |
1-3X8XN1 | Reduces mail volume. | Default is unchecked which will print a | |
bill for only those customers who have | |||
an amount due. | |||
CMS-RPE46327 CMS-RPE48915 | Fix the headers of the scrolling grids so that the header remains stationary while scrolling the detail. Difficult to know for sure what you are looking at when the header scrolls from view. | Modified scrolling grids throughout the system so that header remains fixed. | |
CMS-RPE46328 | Allow more reports to be selected by loan fund. Different staff members need to work with only a portion of the Reports on CRC for a specific loan fund. They must run the report as is, which in most cases includes all funds. We have many funds and this is a waste of time and paper, etc to sort what you need out. | Modified multiple reports to allow for selection by loan fund. | |
CMS-RPE48903 | Color coding outstanding loans It is sometimes difficult to differentiate between outstanding and paid in full loans in Customer Accounts because neither of them are highlighted like the past due loans. Add colors for all outstanding loans (any loan that is not in A, T, Z or X status) …. 1 color for loans that are not due yet (E, P, D or G status) 1 color for loans that are current in repayment (R status with no past due installments) 1 color for loans that are 1 | The color of the lines within the Loan Grid is now controlled by classes in a cascading style sheet (CSS). This file is in the “CSS” folder and the file is named LoanGrid.css. The following classes can be modified to change the color. The classes are:
| |
RPE# | Requested Functionality | Resolution | |
installment past due (R status with 1 past due installment) 1 color for loans that are in Q, S or Y status (preferably the red) It is sometimes difficult to differentiate between outstanding and paid in full loans in Customer Accounts because neither of them are highlighted like the past due loans. |
| ||
1-5S9RK | House accounts not used but included in reports. Most reports include house accounts which we do not use. This wastes a lot of paper when is prints page after page of zero amounts. Reports would be much more useful if you could pick which loan types to include. This is needed for all reports. Make optional which loans to include in reports; House accts with balance >0.00. | Most reports have had options added to exclude zero-balance loan/receivalbes and exclude house accounts (where the total of all fields is zero). | |
1-C3HVQ | If someone is in the collector queue, I cannot just remove it. I have to reassign it to another queue which causes the account to go to "Q" or "S" status and many times late charges get put out during this process. It is a very manual process to change these accounts back to Z just to get the collector removed. | Collector referral and recall has been enhanced in Customer Accounts. | |
CMS-RPE48912 | Collection Queue & Repayment Enhancement Requested and Impact. Add the ability to move a Customer in collections directly to repayment after the loan is brought current. Impact – potential for a Customer to get stuck in a collection queue and be assessed collections costs and/or negative reporting to credit bureau agency. | Collector referral and recall has been enhanced in Customer Accounts. | |
1-6ZA0W | Remove loan from collection. Add a new option to the collection queue maintenance View of a specific queue to allow users to simply REMOVE a loan from collections. This is needed when a Customer assigned to an external collector pays in full; the user satisfies the loan then tries to remove from the queue. The loan is set back into “Q” status because you must move the loan | Loans may now be removed without having to refer to a different queue. | |
RPE# | Requested Functionality | Resolution | |
to another Q to close it. | |||
1-2AUVJT | Rehab and partial payment field When a Customer successfully completes rehab it does not remove the partial payment amount. | Rehab partial payment field is zeroed out upon completion of rehab. | |
1-E8UTAS | Collector Productivity Report Suggestions to enhance the "Collector Productivity Report" to give more information. The Collector Productivity would be even more improved if on the Call Log, you could add the User, along with the name, ID, date/ time and Call Text. With that, we can determine WHO actually did the activity, An account may be in a Collection Queue, but the activity may have been by a different Collector. I could then sort the CALL activity based upon the USER, not just the Queue. On the Collector Productivity Report, Can I see more than CALL, Could we see instead a certain number of characters from the Call text from the first line of the actual action that took place? Obviously CALL doesn?t tell us much. The sooner, the better. | Multiple enhancements have been made to this report; please see report options for this report in the Reports menu. | |
1-EHQA4R | Moving accounts from one Queue to another When at Customer Accounts I am limited as to which Collection Queues I can move a loan to. At Collection Queue Maintenance, I have the option of moving to a system queue. It would be helpful to have these same options at the Borrower Service screen It would be helpful to also have the choice to simply "remove" a loan from a Collector Code without placing to a new Collector. | Collector referral and recall has been enhanced in Customer Accounts. | |
1-IQPN1X | Invoices/Bills - 2 page bills With the Federal reg. changes, we now create a new Perkins loan every year (i.e. Perk10, Perk 11 which will be followed by Perk12 etc) A four year student could end up with 4 Perk lines on his/her invoice/bill. More if they have other loans or continue on to Grad school here. The | Loans are now grouped by name and status. |
RPE# | Requested Functionality | Resolution |
more loan lines listed...the more likely that a second invoice/bill page will print since there is no relationship between the number of loan lines and the number of Letter Body lines available for Boiler- Plate with Invoice Statement. Keep printing of invoice to 1 page with multiple loan lines | ||
1-MCKG0X | Aged Accounts Receivable - I?d like to be able to select ALL, period to get ALL loans. I?d like to be able to select ALL, period to get ALL loans. Presently I have to select All Federal, All Institutional, All Health Professional and export three times, and then consolidate the reports. I?d rather be able to select ALL, export once, and not need to consolidate. | Option was added. |
1-MCKG5V | Collector Productivity Report Presently, this report lists all CALLs, All Payments, and All MAIL per Collector Queue. I would like to be able to select ALL, Calls, Payments, and Mail, if I want that, but I would like to more importantly be able to select ONLY what I want, I may want to select ONLY Calls, ONLY Payments…. I would also like to be able to see the actual Collector (the actual Staff member) who did the action that created a “CALL” to appear. For example I am in a specific Collection Queue, if the Queue is assigned to a staff member, it may not necessarily be that staff member who did the action. I?d like to be able to select Productivity reports based upon Collection Queues; I?d like to be able to select a new report of productivity of a staff member. For example, a staff member may be working on. | Report was completely rewritten. |
1-MCKG61 | Outbound Collection Referral File I would like to be able to select other Collection Queues, such as Custom, or Internal Queues, not only External Queues. | Outbound Collection Referral File format is dictated by collection agency; therefore, the process cannot be modified. However, the Collection Reports have been modified to offer selection by queue, include additional fields and export in an Excel-friendly format. |
RPE# | Requested Functionality | Resolution |
1-12FVSJW | Customer Accounts/Loan Grid Make the “Exclude Closed Loans” checkbox and system configuration setting that controls when the box is checked by default. | Option now exists in Administration > System Configuration > Loan/Receivable Setup to control when this box is checked by default. |
1-1181UHX | Banner AR Import We would like to see an additional option of "Map AR Category Code to Bursar/Category Code Lookup Table". | Category option has been added. |
1-YA3ZHF | Provide Customer selection for Paper/Paperless/Both Version 2.7.0 released paperless capabilities. Add the option in CWA for Customer to make selection. | Customer now has expanded choices through CWA. |
1-YBYMVA | Invoice Cycles - option to DISABLE Due Diligence cycle Version 2.7.0 provides option to include all Due Diligence age categories in the Billing cycle. This allows the user to run a single all-inclusive invoice cycle per month. The current parameters currently do not allow for the DD cycle to not run on a specified date. Therefore, user must always delete the DD job. Need to provide the option to enable/disable each cycle. | Bills can be scheduled to include the due diligence negating the need to run a separate due diligence cycle. DD Messages must be attached and age categories „Enabled?. |
1-YBYMVE | Enhance ACH processes Establish effective start dates Include option to exclude G, D, and P statuses from the ACH file. | Customer can establish ACH start date in CWA. User can opt to include/exclude G, D, P status loans when exporting ACH file. |
1-YBYMVG | Create detailed version of FISAP AB report. Provide reports to back up the numbers and counts reflected on FISAP Part III Sec A and B. Re-label headings in sync with Fed report. | Detail version of FISAP AB report now exists to support the summary report. |
1-1195CHR | CWA website vulnerabilities | General CWA vulnerabilities reported by client were addressed. |
1-11I4QCO | When we process benefits, we get 2 or 3 flashing screens as we are processing. | Tweaked the javascript. |
RPE# | Requested Functionality | Resolution |
1-YGJH1D | Need the ability to add a Customer into the system without a SSN. | SSN is no longer required. |
1-1866UF5 | Need a report that shows which students have signed up for ACH, but have no payment method attached. | Modified ACH Customers report to identify such Customers. |
This section describes Defect resolutions delivered in this release. The following Campus Receivables Collector problem resolutions are delivered with this release.
Defect# | Module | Process | Problem | Resolution | |
1-4XSD4S 1-1BKFBZQ | ADMINISTRATI ON | INVOICE CYCLES | Customers on TRA not being billed when all notices not selected for billing. | Resolved. | |
1-4SH1MT | EXPORT | BENEFIT | Standard message must print on ALL Benefit Mail. | Resolved. | |
1-13KYQUS | SECURITY | ENCRYPTI ON | Password and SSN encryption required. | SSN, passwords and string containing passwords have been encrypted. | |
1-4GR2SJ | MULTIPLE | Inconsistent Use of Payment Center (lockbox address) vs. Service Center (university address). | Resolved. | ||
1-4OYB49 | CUSTOMER ACCOUNTS | BENEFITS | CRC granting initial grace after expiration when deferment is processed effective with repayment begin date. Initial grace expired, then deferment processed effective with repayment begin date - awards another 9-mo when should be 6-mo. | Grant 9 month extension when deferment begins before repayment is scheduled to being. Grant 6 month extension when deferment begins on or after when repayment is scheduled to begin. | |
1-F76FI7 | IMPORT | APPLY PAYMENT | Unable to advance to the next page when manually applying payments and the 4 payments on the current page are all | Resolved. |
Defect# | Module | Process | Problem | Resolution | |
being skipped. | |||||
1-5R0X5H | CUSTOMER ACCOUNTS | ACH ACCOUNT S | Validate ACH routing numbers. | ACH routing numbers are now validated against the FedACHDir table. | |
1-165LD42 | CUSTOMER ACCOUNTS | ADD A LOAN | Default bank/ledger account not displaying. | Display default bank/ledger account as set in Loan/Receivable Setup in System Configuration. | |
1-109WQ4S | REPORTS | QUEUED | Count of mail does not update from the "show Mail requested by" dropdown. The "show mail requested" does not go back to zero when the mail is updated. The count just keeps going up. | Correct count displayed. | |
1-2SDID3 | CUSTOMER ACCOUNTS | POST A PAYMENT | Payment type default is not displayed forcing you to select payment type. | Payment type now defaults to coded data value order. | |
1-6DYFY6 | CUSTOMER ACCOUNTS | ACH | Automatic updates to ACH table containing the bank routing numbers. | Update to FedACHDir table will be delivered with upgrades and patches. | |
1-BQC1WG | MULTIPLE | SCREEN DISPLAY | "Save" icon does not show on page. | Adjusted displays as percentage of desktop resolution. | |
1-11TEA6X | CUSTOMER ACCOUNTS | POST A PAYMENT | Collection agency fees not calculating correctly. | Resolved. | |
1-75JCSE | REPORTS | FISAP | FISAP AB Report - sum of lines 27.1 and 27.2 are not showing up on line 27.3. | Modified FISAP AB report to display line 27.3 as the sum of 27.1 and 27.2 | |
1-3D9P9E | EXPORT | MULTIPLE | Date formatting issues in exported file names. | Format the date in exported file names as MMDDYYYYHHMMSS. | |
1-4U5YCX | CUSTOMER ACCOUNTS | EXITS | Loan re-payment amounts are incorrect when they have more than 1 loan. Now that we have to create a new loan type each year, for | Added Exit function to Customer Accounts that will exit all loans ready for exit and amortize correctly. |
Defect# | Module | Process | Problem | Resolution |
students who have more than 1 loan, the repayment amount is getting calculated way too high. It works OK if they only have 1 loan; those with 2 or 3 are getting a repayment amount that is not right. |
This section includes a list of the Campus Receivables Collector 3.0.0 files which have changed since Campus Receivables Collector 2.7.0. This list does NOT include any Help related files.
Location | File |
Admin | ADMIN_ChangePassword.asp |
Billing | invoice_addtojob.asp |
Billing | invoice_browse.asp |
Billing | invoice_cyclebrowse.asp |
Billing | invoice_cycleedit.asp |
Billing | invoice_jobedit.asp |
Billing | trialinvoice_cycleedit.asp |
Billing/Report | PrintInvoiceForecast.asp |
BorrowerServices | borrServMain.asp |
BorrowerServices | BS_FunctionBar.asp |
BorrowerServices | bs_loanverification.asp |
BorrowerServices | BSA_AddEdit.asp |
BorrowerServices | BSA_Browse.asp |
BorrowerServices | BSACH_AddEdit.asp |
BorrowerServices | BSACH_Browse.asp |
BorrowerServices | bsaddDisburse_addedit.asp |
BorrowerServices | BSAddLoan_AddEdit.asp |
BorrowerServices | BSAddLoan_Browse.asp |
Location | File | |
BorrowerServices | BSBannerAR_Detail.asp | |
BorrowerServices | BSBNFT_Benefits.asp | |
BorrowerServices | BSBNFT_IntAdj.asp | |
BorrowerServices | BSBNFT_Loans.asp | |
BorrowerServices | BSBNFT_Main.asp | |
BorrowerServices | BSBNFT_Opeid.asp | |
BorrowerServices | BSBWAExitData_addedit.asp | |
BorrowerServices | BSBWAExitData_Browse.asp | |
BorrowerServices | BSCC_Browse.asp | |
BorrowerServices | BSCL_Call.asp | |
BorrowerServices | BSCL_CallLogAdd.asp | |
BorrowerServices | BSCL_CallLogBorrower.asp | |
BorrowerServices | BSCL_CallLogDate.asp | |
BorrowerServices | BSCL_CallLogLoan.asp | |
BorrowerServices | bscl_calllogloan_main.asp | |
BorrowerServices | BSCL_CallLogUser.asp | |
BorrowerServices | BSCN_CustNote.asp | |
BorrowerServices | BSCOLL_AddEdit.asp | |
BorrowerServices | BSCOLL_Control.asp | |
BorrowerServices | BSCOLL_LoanMaint.asp | |
BorrowerServices | BSCOLL_Loans.asp | |
BorrowerServices | BSCOM_AddEdit.asp | |
BorrowerServices | BSCOM_Browse.asp | |
BorrowerServices | BSCPN_AddEdit.asp | |
BorrowerServices | BSCPN_Browse.asp | |
BorrowerServices | BSCPN_Main.asp | |
BorrowerServices | BSCU_Browse.asp | |
BorrowerServices | BSCU_Main.asp | |
Location | File | |
BorrowerServices | bscu_recent.asp | |
BorrowerServices | BSCU_Select.asp | |
BorrowerServices | bscu_select.htm | |
BorrowerServices | bsdisbnotice_browse.asp | |
BorrowerServices | BSE_Browse.asp | |
BorrowerServices | BSEX_Detail.asp | |
BorrowerServices | BSExit_FunctionBar.asp | |
BorrowerServices | BSExit_Letter.asp | |
BorrowerServices | BSExit_Loans.asp | |
BorrowerServices | BSExit_Main.asp | |
BorrowerServices | BSExit_Top.asp | |
BorrowerServices | BSExitLoan2.asp | |
BorrowerServices | BSF_AddEdit.asp | |
BorrowerServices | BSFL_List.asp | |
BorrowerServices | BSFL_Main.asp | |
BorrowerServices | BSFLAG_Edit.asp | |
BorrowerServices | BSH_Display.asp | |
BorrowerServices | BSH_GroupFrameset.asp | |
BorrowerServices | BSH_Header.asp | |
BorrowerServices | BSH_Main.asp | |
BorrowerServices | BSH_PopUp.asp | |
BorrowerServices | BSLO_AddLoanRepayment.asp | |
BorrowerServices | bslo_amortschedule.asp | |
BorrowerServices | BSLO_Control.asp | |
BorrowerServices | BSLO_Detail.asp | |
BorrowerServices | bslo_exitloan.asp | |
BorrowerServices | bslo_exitloan_main.asp | |
BorrowerServices | BSLO_LoanDisplay.asp | |
Location | File | |
BorrowerServices | BSLO_PayMethod.asp | |
BorrowerServices | BSLO_PostPayment.asp | |
BorrowerServices | BSLO_PostPaymentMain.asp | |
BorrowerServices | BSLO_PostPaymentMthdPop.asp | |
BorrowerServices | BSLO_ReEnroll.asp | |
BorrowerServices | BSLO_ReEnrollMain.asp | |
BorrowerServices | BSLO_SetACH.asp | |
BorrowerServices | BSLO_SetCC.asp | |
BorrowerServices | BSLO_SetComaker.asp | |
BorrowerServices | bslo_transhistory.asp | |
BorrowerServices | bslo_transhistoryheader.asp | |
BorrowerServices | bslo_transhistorymain.asp | |
BorrowerServices | bslocreditrpt_main.asp | |
BorrowerServices | BSM_AltParams.asp | |
BorrowerServices | BSM_Browse.asp | |
BorrowerServices | BSM_BrowseHeader.asp | |
BorrowerServices | BSM_Delete.asp | |
BorrowerServices | BSM_Editor.asp | |
BorrowerServices | BSM_Frameset.asp | |
BorrowerServices | BSM_LetterText.asp | |
BorrowerServices | BSM_List.asp | |
BorrowerServices | BSM_Main.asp | |
BorrowerServices | BSP_AddEdit_Nav.htm | |
BorrowerServices | BSPP_AddEdit.asp | |
BorrowerServices | BSR_RefEdit.asp | |
BorrowerServices | BSR_RefList.asp | |
BorrowerServices | bsrehab_addedit.asp | |
BorrowerServices | BSStudentHoldAddEdit.asp | |
Location | File | |
BorrowerServices | BSStudentHoldAddEditYes.asp | |
BorrowerServices | BSStudentHoldBrowse.asp | |
BorrowerServices | BSStudentHoldBrowseYes.asp | |
BorrowerServices | BSTRA_AddEdit.asp | |
BorrowerServices | BSTRA_Browse.asp | |
BorrowerServices | BSTRA_Calculate.asp | |
BorrowerServices | BSTRA_Frameset.asp | |
BorrowerServices | calendar.htm | |
BorrowerServices | navBarBSrv.asp | |
BorrowerServices | OMN_Header.asp | |
BorrowerServices/Reports | RehabBatch.rpt | |
BorrowerServices/Reports | RehabBatch.ttx | |
Collections | COLL_AddEdit.asp | |
Collections | COLL_Browse.asp | |
Collections | COLL_Control.asp | |
Collections | COLL_Loans.asp | |
Collections | COLL_Main.asp | |
Collections | coll_referloan.asp | |
Collections | coll_referralfile.asp | |
Collections | coll_removeloan.asp | |
Collections | coll_select.asp | |
Collections | collfee_keyboard.asp | |
Collections | collfee_main.asp | |
Collections | collfee_run.asp | |
css | bodytext.css | |
css | calendar.css | |
css | LoanGrid.css | |
Inbound | calendar.htm | |
Location | File | |
Inbound | CHIBBatchActivity.ttx | |
Inbound | IB_AccountsReceivable.asp | |
Inbound | IB_AccountsReceivableContents.asp | |
Inbound | IB_AccountsReceivableContents.htm | |
Inbound | IB_AccountsReceivableProcess.asp | |
Inbound | IB_AROrigFile.asp | |
Inbound | IB_AROrigFileContents.asp | |
Inbound | ib_clearinghousebatchedit.asp | |
Inbound | ib_clearinghousecontents.htm | |
Inbound | ib_exit.asp | |
Inbound | ib_exitcontents.htm | |
Inbound | ib_exitorigcreaterecord.asp | |
Inbound | ib_exitorigfileauto.asp | |
Inbound | ib_exitorigfilecontents.htm | |
Inbound | ib_exitorigfilemanual.asp | |
Inbound | ib_exitorigfilemanualloans.asp | |
Inbound | ib_exitorigfilemanualmain.asp | |
Inbound | ib_exitorigfilepopup.asp | |
Inbound | IB_FunctionBar.asp | |
Inbound | IB_LBAllocateManualPayment.asp | |
Inbound | IB_LBProcessPostPayment.asp | |
Inbound | IB_LBProcessPostPaymentUnattended.asp | |
Inbound | ib_loanorigcreatebatch.asp | |
Inbound | ib_loanorigcreaterecord.asp | |
Inbound | IB_LoanOrigFile.asp | |
Inbound | IB_LoanOrigFileAuto.asp | |
Inbound | IB_LoanOrigFileContents.htm | |
Inbound | IB_LoanOrigFileManual.asp | |
Location | File | |
Inbound | IB_LoanOrigFilePopup.asp | |
Inbound | IB_LoanRecordsContents.htm | |
Inbound | IB_LockBox.asp | |
Inbound | IB_LockBoxContents.htm | |
Inbound | ib_lockboxorigbrowseborrower.asp | |
Inbound | IB_LockboxOrigCreateBatch.asp | |
Inbound | IB_LockboxOrigCreateRecord.asp | |
Inbound | IB_LockBoxOrigFileAuto.asp | |
Inbound | IB_LockBoxOrigFileManual.asp | |
Inbound | IB_LockBoxOrigFilePopup.asp | |
Inbound | IB_LockBoxOrigFilePreview.asp | |
Inbound | ib_lockboxorigselectborrower.htm | |
Inbound | inboundmain.asp | |
Inbound | navbarinbound.asp | |
Inbound | New.asp | |
Inbound | OM_CLMConfigClearingHouseAddEdit.asp | |
Inbound | test2.asp | |
inc | AllocatePayment.asp | |
inc | BannerDataRetrieval.asp | |
inc | Coupon_logic.asp | |
inc | debugPopup.asp | |
inc | LoanExit_amortizeloan.asp | |
inc | tabBarUtils.asp | |
lib | clmcalendar.js | |
lib | clmdates.js | |
lib | clmFunctionBar.inc | |
lib | Exit_FormFunctions.js | |
lib | rptCampusAccountSelect.asp | |
Location | File | |
OfficeManagement | navBarOMgmt.asp | |
OfficeManagement | offmgmtmain.asp | |
OfficeManagement | OM_BannerARAdjustmentsBrowse.asp | |
OfficeManagement | OM_BannerARAdjustmentsContents.asp | |
OfficeManagement | OM_BannerARAdjustmentsCreate.asp | |
OfficeManagement | OM_BannerARAdjustmentsEdit.asp | |
OfficeManagement | OM_BorrowerSearch.asp | |
OfficeManagement | OM_BorrowerSearch_HELP.html | |
OfficeManagement | OM_BorrowerSearchRecent.asp | |
OfficeManagement | OM_BorrowerSearchResults.asp | |
OfficeManagement | OM_BSKeyboard.asp | |
OfficeManagement | OM_BSMain.asp | |
OfficeManagement | OM_BSTurbo.asp | |
OfficeManagement | OM_BursarCode.asp | |
OfficeManagement | OM_BursarCodeAddEdit.asp | |
OfficeManagement | OM_BursarCodeContents.asp | |
OfficeManagement | OM_CLMConfigBenefitMail.asp | |
OfficeManagement | OM_CLMConfigBorrowerWebAccessAddEdit.asp | |
OfficeManagement | OM_CLMConfigClearingHouseAddEdit.asp | |
OfficeManagement | OM_CLMConfigExit.asp | |
OfficeManagement | OM_CLMConfigGeneral.asp | |
OfficeManagement | OM_CLMConfigIO.asp | |
OfficeManagement | OM_CLMConfigLoan.asp | |
OfficeManagement | OM_CLMConfigPayment.asp | |
OfficeManagement | OM_CLMConfigSelect.asp | |
OfficeManagement | OM_CLMConfigSelectBackup.asp | |
OfficeManagement | OM_CLMConfigStudentSystemAccess.asp | |
OfficeManagement | OM_FunctionBar.asp | |
Location | File | |
OfficeManagement | OM_FunctionBarPopup.asp | |
OfficeManagement | OM_LetterMargin.asp | |
OfficeManagement | OM_LetterPreview.asp | |
OfficeManagement | OM_REFUNDBrowse.asp | |
OfficeManagement | OM_REFUNDContents.asp | |
OfficeManagement | OM_REFUNDQueue.asp | |
OfficeManagement | OM_REFUNDQueueContents.asp | |
OfficeManagement | OM_REFUNDQueueMain.asp | |
OfficeManagement | OMBEN_AddEdit.asp | |
OfficeManagement | OMBEN_Browse.asp | |
OfficeManagement | OMBEN_Header.asp | |
OfficeManagement | OMBenefitReversal_Browse.asp | |
OfficeManagement | OMBenefitReversal_Main.asp | |
OfficeManagement | OMCU_AddEdit.asp | |
OfficeManagement | OMGLTable_AddEdit.asp | |
OfficeManagement | OMGLTable_Browse.asp | |
OfficeManagement | omgltable_header.asp | |
OfficeManagement | OMGLTable_Replicate.asp | |
OfficeManagement | OML_AddEdit.asp | |
OfficeManagement | OML_Header.asp | |
OfficeManagement | OMLedger_AddEdit.asp | |
OfficeManagement | OMLedger_Browse.asp | |
OfficeManagement | omledger_frameset.asp | |
OfficeManagement | OMLedgerLoans_Browse.asp | |
OfficeManagement | OMLoanNameSelection.asp | |
OfficeManagement | OMLOEXIT_AddEdit.asp | |
OfficeManagement | OMLOEXIT_Browse.asp | |
OfficeManagement | OMLOFINC_AddEdit.asp | |
Location | File | |
OfficeManagement | OMLOMAIN_AddEdit.asp | |
OfficeManagement | OMLOMAIN_Browse.asp | |
OfficeManagement | OMLOORIG_AddEdit.asp | |
OfficeManagement | OMLOORIG_Browse.asp | |
OfficeManagement | OMLOYLD_AddEdit.asp | |
OfficeManagement | OMLOYLD_Browse.asp | |
OfficeManagement | OMN_AddEdit.asp | |
OfficeManagement | OMN_Browse.asp | |
OfficeManagement | OMN_Header.asp | |
OfficeManagement | OMNote_Replicate.asp | |
OfficeManagement | OMNote_ReplicatePrime.asp | |
OfficeManagement | OMNoteTerm_Browse.asp | |
OfficeManagement | OMNSLDS_AddEdit.asp | |
OfficeManagement | OMNSLDS_Browse.asp | |
OfficeManagement | OMNSLDS_Header.asp | |
OfficeManagement | OMPaymentRev_Browse.asp | |
OfficeManagement | OMPaymentRev_Main.asp | |
OfficeManagement | OMPaymentRevCU_Browse.asp | |
OfficeManagement | OMPaymentRevCU_Select.asp | |
OfficeManagement | omrehab_rapidfire.asp | |
OfficeManagement | omrehab_setup.asp | |
OfficeManagement | omrehab_turbo.asp | |
OfficeManagement | OMReversal_Header.asp | |
OfficeManagement | OMTERM_AddEdit.asp | |
OfficeManagement | OMTERM_Browse.asp | |
OfficeManagement | OMTerm_Header.asp | |
OfficeManagement | SEC_GroupMain.asp | |
OfficeManagement | SEC_Header.asp | |
Location | File | |
OfficeManagement | TabTest.asp | |
Origination | navBarOrig.html | |
Origination | origMain.html | |
Outbound | navBarOBound.asp | |
Outbound | OB_1098ESetup.asp | |
Outbound | OB_AcctFeedExtract.asp | |
Outbound | OB_ACHOutbound.asp | |
Outbound | OB_ACHOutboundContents.htm | |
Outbound | OB_BannerARCredits.asp | |
Outbound | OB_BannerARCreditsContents.asp | |
Outbound | OB_BannerARCreditsPopup.asp | |
Outbound | OB_BannerARCreditsPost.asp | |
Outbound | OB_BannerARPayments.asp | |
Outbound | OB_BannerARPaymentsContents.asp | |
Outbound | OB_BannerARPaymentsPopup.asp | |
Outbound | OB_BannerARPaymentsPost.asp | |
Outbound | OB_CouponOutbound.asp | |
Outbound | OB_CreditOutbound.asp | |
Outbound | OB_FunctionBar.asp | |
Outbound | ob_inbounddisbnotice.asp | |
Outbound | ob_inbounddisbnoticeContents.htm | |
Outbound | OB_NSLDS.asp | |
Outbound | OB_NSLDSPrep.asp | |
Outbound | obch_jobedit.asp | |
Outbound | outboundmain.asp | |
Outbound/ACH | AchOutbound.rpt | |
Outbound/ACH | AchOutbound.ttx | |
Outbound/ACH | PrintACHOutbound.aspx | |
Location | File | |
Outbound/ACH | run_report.asp | |
Outbound/BenefitMail | OBBM_config.asp | |
Outbound/BenefitMail | obbm_forecast.asp | |
Outbound/BenefitMail | obbm_jobheader.asp | |
Outbound/BenefitMail | obbm_jobs.asp | |
Outbound/BenefitMail/Report | BenefitMailContent.rpt | |
Outbound/BenefitMail/Report | BenefitsMail.rpt | |
Outbound/BenefitMail/Report | PrintBenefitsMail.asp | |
Outbound/BenefitMail/Report | RunReport.asp | |
Outbound/Clearinghouse | obch_jobedit.asp | |
Outbound/Clearinghouse/Report | CHOBJobActual.rpt | |
Outbound/Clearinghouse/Report | CHOBJobcontent.rpt | |
Outbound/Clearinghouse/Report | CHOBJobDownLoadFile.rpt | |
Outbound/Clearinghouse/Report | PrintCHOBReports.asp | |
Outbound/Clearinghouse/Report | RunReport.asp | |
Outbound/Coupons | Coupons.ttx | |
Outbound/CreditReport | ob_creditoutboundRun.asp | |
Outbound/CreditReport | obch_jobedit.asp | |
Outbound/IRS1098E | IRS_1098EBrowse.asp | |
Outbound/IRS1098E | IRS_1098EControl.asp | |
Outbound/IRS1098E | IRS_1098EReport.asp | |
Security | SEC_FunctionTokenIndex.asp | |
Security | sec_update.asp | |
Servicing | AcctFeedDetailParam.asp | |
Servicing | AcctFeedDetailParamgl.asp | |
Servicing | AchBorrowersParam.asp | |
Servicing | addrParam.asp | |
Servicing | agedLoanListParam.asp | |
Location | File | |
Servicing | AORParams.asp | |
Servicing | BannerARCreditsParams.asp | |
Servicing | BannerARParams.asp | |
Servicing | BannerARPaymentsParams.asp | |
Servicing | BannerARReconciliationParams.asp | |
Servicing | BatchSatisfactionParams.asp | |
Servicing | BenefitsGivenparam.asp | |
Servicing | BorrowerAddressParam.asp | |
Servicing | BorrowerLoanHistDetailParam.asp | |
Servicing | BorrowerWebUpdatesParam.asp | |
Servicing | calendar.htm | |
Servicing | CampMailParam.asp | |
Servicing | CampMailReport.asp | |
Servicing | CampMailReportRun.asp | |
Servicing | CampusLoanTotalDetailParam.asp | |
Servicing | cancelHistParam.asp | |
Servicing | checkParams.asp | |
Servicing | CodedDataValueParam.asp | |
Servicing | CohortDefaultParam.asp | |
Servicing | CohortListParam.asp | |
Servicing | CollectionHistoryParam.asp | |
Servicing | CollectionsOutflowParam.asp | |
Servicing | CollectionStatusParam.asp | |
Servicing | CollectorProductivityParams.asp | |
Servicing | collQueListParam.asp | |
Servicing | CollReferralParam.asp | |
Servicing | collrfrlparam.asp | |
Servicing | CoMakerParam.asp | |
Location | File | |
Servicing | CustomerSummaryParam.asp | |
Servicing | dailyACHpymtparam.asp | |
Servicing | dailyACHpymtparamBackup.asp | |
Servicing | DailyAdjustmentsParam.asp | |
Servicing | DailyBalancingParam.asp | |
Servicing | Dailypymtbyuserparam.asp | |
Servicing | dailypymtparam.asp | |
Servicing | dailyPymts1Param.asp | |
Servicing | dailyPymts2Param.asp | |
Servicing | DailySummaryParam.asp | |
Servicing | ExitStatusParam.asp | |
Servicing | FederalPayParam.asp | |
Servicing | FISAPParams.asp | |
Servicing | FlagsParam.asp | |
Servicing | FundConsolidationParam.asp | |
Servicing | FundConsTest.asp | |
Servicing | GatewayPaymentsParam.asp | |
Servicing | HouseBalParam.asp | |
Servicing | housepaymentsparam.asp | |
Servicing | instloansparam.asp | |
Servicing | IntCollCostParam.asp | |
Servicing | JobHistoryList.asp | |
Servicing | ledgerloanadvparam.asp | |
Servicing | LetterParam.asp | |
Servicing | LettersParam.asp | |
Servicing | loanadvancesparam.asp | |
Servicing | LoanBalancingParam.asp | |
Servicing | LoanExitBatchParam.asp | |
Location | File | |
Servicing | LoanInboundBatchParam.asp | |
Servicing | LoanListAgedParam.asp | |
Servicing | LoansByPayFreqParam.asp | |
Servicing | loansbypif.asp | |
Servicing | LoansByStatusParam.asp | |
Servicing | LoansInRepayParam.asp | |
Servicing | LoansPerBenefitTypeParam.asp | |
Servicing | LoansPIFandClosedParam.asp | |
Servicing | navBarBSrv3.asp | |
Servicing | navBarRept.asp | |
Servicing | NsldsAnalysisParam.asp | |
Servicing | OpenReceivablesParam.asp | |
Servicing | PaymentsConsolidatedParam.asp | |
Servicing | PaymentsOneBatchParam.asp | |
Servicing | PDGStatusLoansParam.asp | |
Servicing | PlaceHolderAddeditSecA.asp | |
Servicing | PlaceHolderAddEditSecC.asp | |
Servicing | PlaceHolderHeader.asp | |
Servicing | QueuedMailList.asp | |
Servicing | QueuedMailParam.asp | |
Servicing | ReportParam_DoubleDate.asp | |
Servicing | ReportParam_SingleDate.asp | |
Servicing | servmain.asp | |
Servicing | TRAsParam.asp | |
Servicing | TrialBalanceParam.asp | |
Servicing | TrialBalanceParam2.asp | |
Servicing/reports | 240D_Transactions.rpt | |
Servicing/reports | Acctfeeddetail.rpt | |
Location | File | |
Servicing/reports | AcctfeeddetailByAccount.rpt | |
Servicing/reports | AcctfeeddetailGL.rpt | |
Servicing/reports | AcctFeedDetailParam.asp | |
Servicing/reports | AcctFeedDetailParamgl.asp | |
Servicing/reports | AchBorrowers.rpt | |
Servicing/reports | AchBorrowers.ttx | |
Servicing/reports | Address.rpt | |
Servicing/reports | AOR_Detail.rpt | |
Servicing/reports | AOR_Summary.rpt | |
Servicing/reports | BannerAR.rpt | |
Servicing/reports | BannerAR.ttx | |
Servicing/reports | BannerARPayments.ttx | |
Servicing/reports | BannerARReconciliation.ttx | |
Servicing/reports | BatchSatisfactions.rpt | |
Servicing/reports | benefit.rpt | |
Servicing/reports | BenefitsGiven.rpt | |
Servicing/reports | BorrAddress.rpt | |
Servicing/reports | BorrowerLoanHistDetail.rpt | |
Servicing/reports | borrowerwebupdates.rpt | |
Servicing/reports | borrowerwebupdates.ttx | |
Servicing/reports | CampaignMailPreview.rpt | |
Servicing/reports | CampusLoanTotalDetail.rpt | |
Servicing/reports | CampusLoanTotals.rpt | |
Servicing/reports | CancellationHistory.rpt | |
Servicing/reports | cdv.rpt | |
Servicing/reports | CheckNum.rpt | |
Servicing/reports | closeacct.rpt | |
Servicing/reports | CohortDefaultRate.rpt | |
Location | File | |
Servicing/reports | CollectionHistory.rpt | |
Servicing/reports | CollectionHistory.ttx | |
Servicing/reports | CollectionQueueList.rpt | |
Servicing/reports | CollectionsOutflow.rpt | |
Servicing/reports | CollectionStatus.rpt | |
Servicing/reports | CollectionStatus.ttx | |
Servicing/reports | CollectionStatusExport.rpt | |
Servicing/reports | CollectorProductivity.rpt | |
Servicing/reports | collectorproductivity.ttx | |
Servicing/reports | CollectorProductivityExport.rpt | |
Servicing/reports | CollectorReferral.rpt | |
Servicing/reports | CoMaker.rpt | |
Servicing/reports | CurrentBenefitListing.rpt | |
Servicing/reports | CustomerSummary.rpt | |
Servicing/reports | dailyACHPayments.rpt | |
Servicing/reports | dailyACHPayments.ttx | |
Servicing/reports | DailyAdjustments.rpt | |
Servicing/reports | DailyAdjustments.ttx | |
Servicing/reports | dailypymts.rpt | |
Servicing/reports | dailypymtsbyuser.rpt | |
Servicing/reports | DailySummary.rpt | |
Servicing/reports | exitflag.rpt | |
Servicing/reports | exitstatus.rpt | |
Servicing/reports | ExternalCollections.rpt | |
Servicing/reports | FederalPay.rpt | |
Servicing/reports | FISAP_ABDetail.ttx | |
Servicing/reports | Flags.rpt | |
Servicing/reports | Flags_Summary.rpt | |
Location | File | |
Servicing/reports | FundConsolidation.rpt | |
Servicing/reports | FundConsolidationDetail.rpt | |
Servicing/reports | gatewaypayments.rpt | |
Servicing/reports | gltable.rpt | |
Servicing/reports | housebal.rpt | |
Servicing/reports | HouseBal.ttx | |
Servicing/reports | intcollcost.rpt | |
Servicing/reports | LoanAdvances.rpt | |
Servicing/reports | LoanBalancing.rpt | |
Servicing/reports | LoanExitBatch.rpt | |
Servicing/reports | LoanInboundBatch.rpt | |
Servicing/reports | LoanListingAged.rpt | |
Servicing/reports | LoanListingAged.ttx | |
Servicing/reports | LoansByPayFreq.rpt | |
Servicing/reports | LoansByPayFreq.ttx | |
Servicing/reports | LoansByPIF.rpt | |
Servicing/reports | LoansByStatus.rpt | |
Servicing/reports | LoansByStatus.ttx | |
Servicing/reports | LoansInDefault.rpt | |
Servicing/reports | LoansInRepay.rpt | |
Servicing/reports | LoansPerBenefitType.rpt | |
Servicing/reports | LoansPIFandClosed.rpt | |
Servicing/reports | LoansPIFandClosed.ttx | |
Servicing/reports | LoansPIFDuringGrace.rpt | |
Servicing/reports | LoanVerification.ttx | |
Servicing/reports | NegBalClosedLoans.rpt | |
Servicing/reports | Notes.rpt | |
Servicing/reports | NSLDSAnalysis_Detail.rpt | |
Location | File |
Servicing/reports | NSLDSAnalysis_Summary.rpt |
Servicing/reports | OpenReceivables.rpt |
Servicing/reports | PaidAhead.rpt |
Servicing/reports | PartialPayment.rpt |
Servicing/reports | PaymentsConsolidated.rpt |
Servicing/reports | PaymentsConsolidated.ttx |
Servicing/reports | PaymentsConsolidatedExport.rpt |
Servicing/reports | PaymentsOneBatch.rpt |
Servicing/reports | PaymentsOneBatchExport.rpt |
Servicing/reports | RegistrarFlag.rpt |
Servicing/reports | RPCollRfrl.asp |
Servicing/reports | RptAddr_Header.asp |
Servicing/reports | run_report.asp |
Servicing/reports | smallbal.rpt |
Servicing/reports | StudentSystemHold.rpt |
Servicing/reports | StudentSystemHold.ttx |
Servicing/reports | Subreport_Header_Landscape.rpt |
Servicing/reports | Subreport_Header_Portrait.rpt |
Servicing/reports | SumBysta.rpt |
Servicing/reports | SumBysta.ttx |
Servicing/reports | TRAs.rpt |
Servicing/reports | TrialBalance.rpt |
Servicing/reports | TrialBalance2.rpt |
Servicing/reports | TrialBalanceDetail.rpt |
This section includes a list of the Campus Receivables Collector 3.0.0 SQL Server Database objects which have changed since Campus Receivables Collector 2.7.0.
Type | Name | Update | |
Table | ACH | Columns, Constraints, Triggers | |
Table | ADDRESS | Constraints, Triggers, Indexes | |
Table | ASPNET_APPLICATIONS | Constraints, Indexes | |
Table | ASPNET_MEMBERSHIP | Constraints | |
Table | ASPNET_PATHS | Constraints | |
Table | ASPNET_PERSONALIZATIONALLUSERS | Constraints | |
Table | ASPNET_PERSONALIZATIONPERUSER | Constraints | |
Table | ASPNET_PROFILE | Constraints | |
Table | ASPNET_ROLES | Constraints | |
Table | ASPNET_SCHEMAVERSIONS | Constraints | |
Table | ASPNET_USERS | Constraints | |
Table | ASPNET_USERSINROLES | Constraints | |
Table | ASPNET_WEBEVENT_EVENTS | Constraints | |
Table | BANNERAROBPAYMENTS | New | |
Table | BANNERAROUTBOUND | Indexes | |
Table | BATCHBANNERAROBPAYMENTS | New | |
Table | BATCHCLEARINGHOUSE | Constraints | |
Table | BATCHEXIT | Triggers | |
Table | BATCHLOAN | Columns, Constraints | |
Table | BATCHPYMT | Constraints, Triggers | |
Table | BATCHREHAB | Constraints, Triggers | |
Table | BENEFIT_MAIL | Constraints | |
Table | BENEFIT_MAIL_ERROR | Constraints | |
Table | BENEFIT_MAIL_JOB | Triggers | |
Table | BENEFIT_MAIL_LETTER | Constraints | |
Table | BENEFIT_MAIL_LOAN | Constraints | |
Table | BENEFITS | Constraints, Triggers | |
Table | BORROWER_FLAGS | Constraints |
Type | Name | Update | |
Table | BORROWER_WEB_ACCESS_CONFIG | Columns, Constraints | |
Table | BURSARCODE_LOOKUP | Constraints | |
Table | BWA_ENTRANCE_DATA | Extended Properties, Constraints | |
Table | BWA_EXIT_DATA | Extended Properties, Constraints, Triggers | |
Table | CALLINFO | Constraints, Triggers | |
Table | CAMPUS | Triggers | |
Table | CHRONHISTORY | Constraints, Triggers, Indexes | |
Table | CLEARINGHOUSE_CONFIG | Constraints | |
Table | CLEARINGHOUSE_OUTBOUND_HISTORY | Columns, Constraints | |
Table | CLEARINGHOUSE_OUTBOUND_JOB | Constraints | |
Table | CLEARINGHOUSEINBD | Columns, Constraints | |
Table | CLMCONFIG | Columns, Constraints, Triggers | |
Table | COLLECTION_QUEUE | Constraints, Triggers | |
Table | COMAKER | Columns, Constraints, Triggers | |
Table | COUPONS | Indexes | |
Table | COUPONS_OUTBOUND | Constraints, Indexes | |
Table | CREDITBUREAU | Constraints | |
Table | CREDITREPORT | Constraints | |
Table | CUSTEMP | Constraints, Triggers | |
Table | CUSTFAM | Columns, Constraints, Triggers | |
Table | CUSTMAIL | Constraints, Triggers | |
Table | CUSTMAIN | Columns, Constraints, Triggers, Indexes | |
Table | CUSTNOTE | Constraints, Triggers | |
Table | CUSTTRA | Constraints, Triggers | |
Table | CUSTTRA_LOANS | Constraints | |
Table | ENDORSE | Constraints | |
Table | EXITINBD | Columns |
Type | Name | Update |
Table | FRIDAY27 | Deleted |
Table | FUNDCONFIG | Constraints |
Table | GATEWAY_PAYMENTS | Columns, Constraints, Triggers |
Table | GLTABLE | Constraints, Triggers |
Table | HISTORY_ADDR | Constraints |
Table | HISTORY_COLL | Constraints, Indexes |
Table | HISTORY_COLLFEE | Constraints |
Table | HISTORY_COUP | Constraints |
Table | HISTORY_CUSTOMER | Columns, Constraints |
Table | HISTORY_CUSTTRA | Constraints |
Table | HISTORY_EXIT | Constraints |
Table | HISTORY_LOANPYMT | Constraints, Triggers, Indexes |
Table | HISTORY_OVERPAY | Constraints, Triggers |
Table | HISTORY_PYMT | Constraints, Triggers, Indexes |
Table | HISTORY_SATISFACTION | Constraints |
Table | INVOICE | Constraints |
Table | INVOICE_CYCLE | Constraints |
Table | INVOICE_DETAIL | Constraints |
Table | INVOICE_ERROR | Constraints |
Table | INVOICE_JOB | Constraints, Triggers |
Table | INVOICE_SCHEDULE | Constraints |
Table | LEDGER | Constraints, Triggers, Indexes |
Table | LEDGER_AFE | Constraints |
Table | LETTER | Constraints, Triggers |
Table | LOANEXIT | Triggers, Indexes |
Table | LOANFINC | Constraints, Triggers, Indexes |
Table | LOANINBD | Columns, Constraints, Triggers, Indexes |
Type | Name | Update |
Table | LOANMAIN | Columns, Constraints, Triggers, Indexes |
Table | LOANORIG | Constraints |
Table | LOANYLD | Constraints |
Table | LOCKBOXINBD | Columns, Constraints, Triggers |
Table | NOTE_CAMPUS | Constraints |
Table | NOTEMAIN | Constraints, Triggers |
Table | NOTETERM | Constraints |
Table | NSLDS | Columns, Indexes |
Table | PLACEHOLDERS_FISAP | Extended Properties, Constraints |
Table | QUEUE_FILTER_SETUP | Constraints |
Table | QUEUE_LOAD_SETUP | Constraints |
Table | REFERENCE | Columns, Constraints, Triggers |
Table | REFUND_DETAIL | Constraints |
Table | REFUNDS | Constraints |
Table | REHAB_DETAIL | Constraints |
Table | SHEET1$ | Deleted |
Table | STAFF | Columns |
Table | STUDENTSYSTEMHOLD | Indexes |
Table | SYSTEM_ACCOUNT | Constraints |
Table | TERM | Constraints |
Table | TESTG | Deleted |
View | _HYPMV_2_3047 | New |
View | BANNERARDEBITCOPIED_VIEW | New |
View | BS_LOAN_COLLECTION_VIEW | Modified |
View | BS_LOAN_VIEW | Modified |
View | CLEARINGHOUSE_OUTBOUND_HISTORY_VIEW | New |
View | CLEARINGHOUSEINBD_VIEW | New |
Type | Name | Update | |
View | CLMCONFIG_VIEW | New | |
View | COMAKER_VIEW | New | |
View | CUSTFAM_VIEW | New | |
View | CUSTMAIN_VIEW | New | |
View | EXIT_FLAG_VIEW_REPORT | Modified | |
View | EXITINBD_VIEW | New | |
View | HISTORY_CUSTOMER_VIEW | New | |
View | INVOICE_LOAN_VIEW | New | |
View | LETTER_DATA_VIEW | Modified | |
View | LOANINBD_VIEW | New | |
View | LOCKBOXINBD_VIEW | New | |
View | NSLDS_VIEW | New | |
View | REFERENCE_VIEW | New | |
View | STAFF LIST | Deleted | |
View | STAFF_VIEW | New | |
Procedure | ASPNET_MEMBERSHIP_GETUSERBYNAME | Modified | |
Procedure | PROC_GENSCRIPT | Deleted | |
Procedure | SP_FIND_CUSTOMER | Modified | |
Procedure | SP_QUEUE_FETCH_LOCKS | Modified | |
Procedure | SP1098EADDLETTER | Modified | |
Procedure | SP1098EEXTRACTDATA | Modified | |
Procedure | SP1098EQUEUEDMAIL | Modified | |
Procedure | SPADMINCHANGEPASSWORD | Modified | |
Procedure | SPADMINFETCHPROVIDERSTRING | Modified | |
Procedure | SPADMINFETCHUSERSTAFFID | Modified | |
Procedure | SPAMORITIZEACTUAL | Modified | |
Procedure | SPBANNERFETCHADDRESSTYPES | New | |
Procedure | SPBANNERFETCHDETAILCODES | Modified |
Type | Name | Update | |
Procedure | SPBANNERFETCHSTUDENT | Modified | |
Procedure | SPBANNERFETCHSTVHLDDCODES | New | |
Procedure | SPBANNERFETCHSTVORIGCODES | New | |
Procedure | SPBANNERFETCHTERMS | Modified | |
Procedure | SPBATCHADJUSTINTEREST | Modified | |
Procedure | SPBERMUDAADDRESSTOADDRESS | Modified | |
Procedure | SPBERMUDACALLINFOTOCLM | Modified | |
Procedure | SPBERMUDACOLLINFOTOCUSTTRA | Modified | |
Procedure | SPBERMUDACOMAKERTOCOMAKER | Modified | |
Procedure | SPBERMUDACUSTOMERTOCLM | Modified | |
Procedure | SPBERMUDAENDORSETOCLM | Modified | |
Procedure | SPBERMUDAHISTORYLOANTOCLM | Modified | |
Procedure | SPBERMUDAHISTORYPYMTTOCLM | Modified | |
Procedure | SPBERMUDAHISTORYRFNDTOCLM | Modified | |
Procedure | SPBERMUDALEDGERTOCLM | Modified | |
Procedure | SPBERMUDALOANSTOCLM | Modified | |
Procedure | SPBERMUDANSLDSTOCLM | Modified | |
Procedure | SPBILLFETCHREPORTDATA | Modified | |
Procedure | SPBSACHFETCHACCOUNT | Modified | |
Procedure | SPBSACHFETCHACCOUNTS | Modified | |
Procedure | SPBSACHUPDATEACCOUNT | Modified | |
Procedure | SPBSADDDISBURSEUPDATE | Modified | |
Procedure | SPBSADDLOANUPDATE | Modified | |
Procedure | SPBSASSIGNFORM553 | Modified | |
Procedure | SPBSBANNERARDETAIL | Modified | |
Procedure | SPBSBENSAVELOAN | Modified | |
Procedure | SPBSCBSTATEMENT | Modified | |
Procedure | SPBSCFETCHCUSTOMER | Modified |
Type | Name | Update | |
Procedure | SPBSCFETCHCUSTOMERS | Modified | |
Procedure | SPBSCOMFETCHCOMAKER | Modified | |
Procedure | SPBSCOMFETCHCOMAKERS | Modified | |
Procedure | SPBSCOMUPDATECOMAKER | Modified | |
Procedure | SPBSCUFETCHRECENTBORROWER | Modified | |
Procedure | SPBSCUPDATECUSTOMER | Modified | |
Procedure | SPBSFFETCHFAMILY | Modified | |
Procedure | SPBSFUPDATEFAMILY | Modified | |
Procedure | SPBSGETLOANHISTORY | Modified | |
Procedure | SPBSHGETCLEARINGHOUSE_OUTBOUND_HISTORY | Modified | |
Procedure | SPBSHGETCLEARINGHOUSEINBD | Modified | |
Procedure | SPBSHGETHISTORY_CUSTOMER | Modified | |
Procedure | SPBSHGETHISTORY_EXIT | Modified | |
Procedure | SPBSHGETLEDGER | Modified | |
Procedure | SPBSHGETLOANINBD | Modified | |
Procedure | SPBSLETTERBORROWERDATA | Modified | |
Procedure | SPBSLETTERFETCHTAGVALUES | Modified | |
Procedure | SPBSLOADDLOANREPAYMENTFETCHDATA | Modified | |
Procedure | SPBSLOANEXITFETCH | Modified | |
Procedure | SPBSLOANVERF | Modified | |
Procedure | SPBSLOFETCHAGEDLOANS | Modified | |
Procedure | SPBSLOFETCHLOANGRIDDATE | Modified | |
Procedure | SPBSLOPOSTPAYMENTLOAN | Modified | |
Procedure | SPBSNINSERTNOTEPAD | Modified | |
Procedure | SPBSREHABATTEMPTREHAB | Modified | |
Procedure | SPBSRGETREFERENCES | Modified | |
Procedure | SPBSRUPDATEREFERENCE | Modified | |
Procedure | SPBSSARCHIVEACHRECORDS | New |
Type | Name | Update | |
Procedure | SPBSSBNFTSENDEMAIL | Modified | |
Procedure | SPBSSFETCHACHACCOUNTS | New | |
Procedure | SPBSSFETCHAMOUNTDUEBYBORROWER | Modified | |
Procedure | SPBSSFETCHAMOUNTDUEBYLOANTYPE | Modified | |
Procedure | SPBSSFETCHLOANEXITDATA | Modified | |
Procedure | SPBSSFETCHONLINEPAYMENTRECORD | Modified | |
Procedure | SPBSSFETCHSCHOOLIDSFROMSTUDENTID | Modified | |
Procedure | SPBSSGENERATEPASSWORD | Modified | |
Procedure | SPBSSGETACTIVEACHACCTFORBORROWER | Modified | |
Procedure | SPBSSGETACTIVEACHCOUNT | New | |
Procedure | SPBSSGETBANKFROMROUTINGNUMBER | Modified | |
Procedure | SPBSSGETCOMAKERDETAILS | Modified | |
Procedure | SPBSSGETCOMAKERFROMLOANID | Modified | |
Procedure | SPBSSGETREFERENCES | Modified | |
Procedure | SPBSSGETSTUDENTIDS | Modified | |
Procedure | SPBSSINSERTONLINEPAYMENTRECORD | Modified | |
Procedure | SPBSSLOANEXITSENDEMAIL | Modified | |
Procedure | SPBSSMAILFETCHLOAN | Modified | |
Procedure | SPBSSMAILINSERT | Modified | |
Procedure | SPBSSMAILUPDATERECORDS | Modified | |
Procedure | SPBSSMANUALLYFORCEPAYMENT | New | |
Procedure | SPBSSVERIFYBORROWER | New | |
Procedure | SPBSTRAUPDATELOAN | Modified | |
Procedure | SPCOLLDECELERATELOAN | New | |
Procedure | SPCOLLFEEFETCHBORROWERS | Modified | |
Procedure | SPCOLLFEEPCTAGEFETCHBORROWERS | Modified | |
Procedure | SPCOLLFETCHCOLLECTORSFROMHISTORY | New | |
Procedure | SPCOLLFETCHREFERRALFILEDATA | Modified |
Type | Name | Update | |
Procedure | SPCOLLFETCHSTAFFLOANS | Modified | |
Procedure | SPCOREFETCHBORROWER | Modified | |
Procedure | SPCREATEBILL | Modified | |
Procedure | SPIBCLEARINGHOUSEAPPLYBATCH | Modified | |
Procedure | SPIBCLEARINGHOUSEFETCHJOBCONTENT | Modified | |
Procedure | SPIBCREATEBATCHLOAN | Modified | |
Procedure | SPIBCREATEBATCHPAYMENT | Modified | |
Procedure | SPIBLOADBANNERAR | Modified | |
Procedure | SPIBLOADBANNERAR_NEW | New | |
Procedure | SPIBLOADCLEARINGHOUSE | Modified | |
Procedure | SPIBLOADEXIT | Modified | |
Procedure | SPIBLOADLOAN | Modified | |
Procedure | SPIBLOADLOCKBOX | Modified | |
Procedure | SPIBREVERSELOANBATCH | Modified | |
Procedure | SPINVOICECREATEINVOICE | Modified | |
Procedure | SPINVOICECURSORBILL | Modified | |
Procedure | SPINVOICEEXECUTEJOB | Modified | |
Procedure | SPINVOICEFETCHJOBERRORS | Modified | |
Procedure | SPINVOICEREPORTDATAMAIN | Modified | |
Procedure | SPINVOICESENDEMAIL | Modified | |
Procedure | SPINVOICEUPDATETOTALS | Modified | |
Procedure | SPLEDGERLINKTOGLTABLE | Modified | |
Procedure | SPLOANCHECKFORDEFAULTCURE | Modified | |
Procedure | SPMAILFETCHLOAN | Modified | |
Procedure | SPMAILUPDATERECORDS | Modified | |
Procedure | SPMIGRATEBORROWER | Modified | |
Procedure | SPMIGRATENSLDS_LOAD | Modified | |
Procedure | SPMIGRATESTAFF | Modified |
Type | Name | Update | |
Procedure | SPNPBILLFETCHSTUDENTBILLRECORD | Modified | |
Procedure | SPNPBNFETCHSTUDENTBILLRECORD | Modified | |
Procedure | SPNPDDFETCHSTUDENTBILLRECORD | Deleted | |
Procedure | SPNPDDFETCHSTUDENTBILLRECORD_NOTUSED | New | |
Procedure | SPNSLDSFETCHEXTRACT | Modified | |
Procedure | SPNSLDSPREPLOAN | Modified | |
Procedure | SPNSLDSPREPLOANSTATUS | Modified | |
Procedure | SPOBACHBUILDFILE | Modified | |
Procedure | SPOBAORFETCHLOANS | Modified | |
Procedure | SPOBAORFETCHREPORTDATA | Modified | |
Procedure | SPOBBANNERARCREATEPAYMENTSBATCH | New | |
Procedure | SPOBBANNERARDELETEPAYMENTSBATCH | New | |
Procedure | SPOBBANNERARFETCHPAYMENTSBATCH | New | |
Procedure | SPOBBANNERARFETCHPAYMENTSBATCHES | New | |
Procedure | SPOBBANNERARFETCHPENDINGCREDITSDETAIL | Modified | |
Procedure | SPOBBANNERARLOADPAYMENTS | New | |
Procedure | SPOBBANNERARPAYMENTSSTATUS | New | |
Procedure | SPOBBANNERARPOSTCREDITS | Modified | |
Procedure | SPOBBANNERARPOSTPAYMENTS | New | |
Procedure | SPOBBMFETCHBENEFITMAILERRORS | Modified | |
Procedure | SPOBBMFETCHJOBMAIL | Modified | |
Procedure | SPOBBMUPDATEMAILTOTALS | Modified | |
Procedure | SPOBCHDOWNLOAD | Modified | |
Procedure | SPOBCHDOWNLOADVIEW | Modified | |
Procedure | SPOBCHGENERATE | Modified | |
Procedure | SPOBCPNCREATEYEARLYCOUPONS | Modified | |
Procedure | SPOBCPNGETCOUPONINFO | Modified | |
Procedure | SPOBCPNGETCOUPONS | Modified |
Type | Name | Update | |
Procedure | SPOBCRFETCHEXTRACTDATA | Modified | |
Procedure | SPOBDDBORROWERCURSOR | Deleted | |
Procedure | SPOBDDBORROWERCURSOR_NOTUSED | New | |
Procedure | SPOBDDCREATEBORROWERSTATEMENT | Deleted | |
Procedure | SPOBDDCREATEBORROWERSTATEMENT_NOTUSED | New | |
Procedure | SPOBDDCREATEMAILING | Deleted | |
Procedure | SPOBDDCREATEMAILING_NOTUSED | New | |
Procedure | SPOBDDDUEDILIGENCEUPDATE | Deleted | |
Procedure | SPOBDDDUEDILIGENCEUPDATE_NOTUSED | New | |
Procedure | SPOBDDFETCHBORROWERS | Deleted | |
Procedure | SPOBDDFETCHBORROWERS_NOTUSED | New | |
Procedure | SPOBDDFETCHDUEDILIGENCE | Deleted | |
Procedure | SPOBDDFETCHDUEDILIGENCE_NOTUSED | New | |
Procedure | SPOBDDFETCHMAILING | Deleted | |
Procedure | SPOBDDFETCHMAILING_NOTUSED | New | |
Procedure | SPOBDDJOBUPDATE | Deleted | |
Procedure | SPOBDDJOBUPDATE_NOTUSED | New | |
Procedure | SPOBDDRUNJOBS | Deleted | |
Procedure | SPOBDDRUNJOBS_NOTUSED | New | |
Procedure | SPOBEXTRACTBANNERAR | Deleted | |
Procedure | SPOBFISAPABFETCHREPORTDATA | Modified | |
Procedure | SPOBFISAPCDFETCHREPORTDATA | Modified | |
Procedure | SPOBFISAPGETOLDPLACEHOLDERS | Deleted | |
Procedure | SPOMBANNERARADJUSTMENTSDETAIL | New | |
Procedure | SPOMBANNERARADJUSTMENTSSUMMARY | New | |
Procedure | SPOMBSSCONFIGFETCHBORROWERWEBACCESS | Modified | |
Procedure | SPOMBSSCONFIGUPDATEBORROWERWEBACCESS | Modified | |
Procedure | SPOMBURSARCODEFETCH | Modified |
Type | Name | Update | |
Procedure | SPOMCLMCONFIGFETCHLOAN | Modified | |
Procedure | SPOMCLMCONFIGFETCHSTUDENTACCESS | Modified | |
Procedure | SPOMCLMCONFIGFETCHSTUDENTACCESSRS | Modified | |
Procedure | SPOMCLMCONFIGUPDATELOAN | Modified | |
Procedure | SPOMCLMCONFIGUPDATESTUDENTACCESS | Modified | |
Procedure | SPOMCREATEHOUSEACCT | Modified | |
Procedure | SPOMCUSTFETCH | Modified | |
Procedure | SPOMCUSTUPDATE | Modified | |
Procedure | SPOMCUSTUPDATENOTIFY | New | |
Procedure | SPOMLOMAINFETCH | Modified | |
Procedure | SPOMLOMAINFETCHALL | Modified | |
Procedure | SPOMLOMAINUPDATE | Modified | |
Procedure | SPOMNFETCHSUBNAMES | New | |
Procedure | SPOMNSLDSFETCH | Modified | |
Procedure | SPOMNSLDSFETCHALL | Modified | |
Procedure | SPOMNSLDSUPDATE | Modified | |
Procedure | SPOMREFUNDFETCHQUEUE | Modified | |
Procedure | SPOMREHABGETNEXTLOAN | Modified | |
Procedure | SPOMSFETCHSTAFFMEMBER | Modified | |
Procedure | SPOMSFETCHSTAFFMEMBERS | Modified | |
Procedure | SPOMSUPDATESTAFFMEMBER | Modified | |
Procedure | SPOMTEMPLOANCREATE | Modified | |
Procedure | SPOREXITLETTERS | Modified | |
Procedure | SPORGETCUSTOMERID | Modified | |
Procedure | SPORGETEXITFILE | Modified | |
Procedure | SPORGETEXITFILETOP1 | Modified | |
Procedure | SPORGETEXITLOANS | Modified | |
Procedure | SPORGETFILE | Modified |
Type | Name | Update | |
Procedure | SPORGETLOANIDSFROMSSN | Modified | |
Procedure | SPORGETLOCKBOXFILE | Modified | |
Procedure | SPORGETLOCKBOXFILESINGLEREC | Modified | |
Procedure | SPORGETRECSBYFILE | Modified | |
Procedure | SPORINSERTADDRESS | Modified | |
Procedure | SPORLOAN_GETCUSTOMERID | Modified | |
Procedure | SPORLOCKBOXCHECKFORADJ | Modified | |
Procedure | SPORLOCKBOXINBDFETCH | Modified | |
Procedure | SPORLOCKBOXINBDFETCHALL | Modified | |
Procedure | SPORMODIFYEXITREC | Modified | |
Procedure | SPORMODIFYLOANINBDREC | Modified | |
Procedure | SPORMODIFYLOCKBOXREC | Modified | |
Procedure | SPORORIGINATEBANNERARCREDIT | Modified | |
Procedure | SPORORIGINATELOANFILEAUTO | Modified | |
Procedure | SPORORIGINATELOANFILEREC | Modified | |
Procedure | SPPERKINS3TOCLM | Deleted | |
Procedure | SPREENROLL_CHKIFREQD | Modified | |
Procedure | SPREPORT_EXITFLAG | Modified | |
Procedure | SPRPTACCTFEEDDETAIL | Modified | |
Procedure | SPRPTACCTFEEDDETAILGL | Modified | |
Procedure | SPRPTACHBORROWERS | Modified | |
Procedure | SPRPTACHPAY | Modified | |
Procedure | SPRPTACHPAYOFFS | Modified | |
Procedure | SPRPTACTBNFT2 | Modified | |
Procedure | SPRPTACTTOTALS | Modified | |
Procedure | SPRPTBANNERAR | Modified | |
Procedure | SPRPTBANNERARCREDITS | Modified | |
Procedure | SPRPTBANNERARPAYMENTS | New |
Type | Name | Update | |
Procedure | SPRPTBANNERARPAYMENTSPARAMS | New | |
Procedure | SPRPTBANNERARRECONCILIATION | New | |
Procedure | SPRPTBATCHSATISFACTIONS | Modified | |
Procedure | SPRPTBENEFITSGIVEN | Modified | |
Procedure | SPRPTBORRADDRESS | Modified | |
Procedure | SPRPTBORROWERLOANHISTDETAIL | Modified | |
Procedure | SPRPTBORROWERLOANHISTDETAIL_TRANSACTIONS | Modified | |
Procedure | SPRPTBORROWERMAILDATA | Modified | |
Procedure | SPRPTBORROWERWEBUPDATES | Modified | |
Procedure | SPRPTCAMPUSLOANTOTALSDETAIL | Modified | |
Procedure | SPRPTCHOUTBOUND | Modified | |
Procedure | SPRPTCOHORTDEFAULTRATE | Modified | |
Procedure | SPRPTCOHORTLISTING | Modified | |
Procedure | SPRPTCOLLECTIONHISTORY | New | |
Procedure | SPRPTCOLLECTIONSTATUS | New | |
Procedure | SPRPTCOLLECTORPRODUCTIVITY | Modified | |
Procedure | SPRPTCOLLRFRL | Modified | |
Procedure | SPRPTCOMAKER | Modified | |
Procedure | SPRPTCOUPNOT | Modified | |
Procedure | SPRPTCUSTOMERINFO | Modified | |
Procedure | SPRPTCUSTOMERLOANINFO | Modified | |
Procedure | SPRPTCUSTOMERSUMMARY | Modified | |
Procedure | SPRPTDAILYACHPAYMENTS | Modified | |
Procedure | SPRPTDAILYADJUSTMENTS | Modified | |
Procedure | SPRPTDAILYBALANCING | Modified | |
Procedure | SPRPTDAILYPAYMENTS1 | Modified | |
Procedure | SPRPTDAILYPAYMENTS2 | Modified | |
Procedure | SPRPTDAILYSUMMARY | Modified |
Type | Name | Update | |
Procedure | SPRPTDEFAULTFLAGTRANS | Modified | |
Procedure | SPRPTDFLTLOAN | Modified | |
Procedure | SPRPTFEDERALPAY | Modified | |
Procedure | SPRPTFLAGS | New | |
Procedure | SPRPTFUNDCONSOLIDATION | Modified | |
Procedure | SPRPTGATEWAYPAYMENTS | Modified | |
Procedure | SPRPTHOUSEACCTPYMT | Modified | |
Procedure | SPRPTHOUSEBAL | Modified | |
Procedure | SPRPTINSTITUTIONALLOANS | Modified | |
Procedure | SPRPTINTERESTONLYLOANS | Modified | |
Procedure | SPRPTLEDGERLOANADVANCES | Modified | |
Procedure | SPRPTLETTERDATA | Modified | |
Procedure | SPRPTLOANADVANCES | Modified | |
Procedure | SPRPTLOANBALANCING | Modfied | |
Procedure | SPRPTLOANEXITBATCH | Modified | |
Procedure | SPRPTLOANLISTINGAGED | Modified | |
Procedure | SPRPTLOANSBYPAYFREQ | Modified | |
Procedure | SPRPTLOANSBYSTATUS | Modified | |
Procedure | SPRPTLOANSPIFANDCLOSED | New | |
Procedure | SPRPTNEGBALCLOSEDLOANS | Modified | |
Procedure | SPRPTNSLDSANALYSIS | Modified | |
Procedure | SPRPTOPENRECEIVABLES | Modified | |
Procedure | SPRPTPAYMENTSCONSOLIDATED | New | |
Procedure | SPRPTPDGSTATUSLOANS | Modified | |
Procedure | SPRPTPERKLOANS | Modified | |
Procedure | SPRPTQUEUEDMAIL | Modified | |
Procedure | SPRPTQUEUEDMAILSTAFFID | Modified | |
Procedure | SPRPTREGISTRARFLAG | Modified |
Type | Name | Update |
Procedure | SPRPTREHABBATCH | Modified |
Procedure | SPRPTSELECTPAYMENTBATCHES | New |
Procedure | SPRPTSMALLBAL | Modified |
Procedure | SPRPTSTUDENTSYSTEMHOLD | Modified |
Procedure | SPRPTSUMBYSTA | Modified |
Procedure | SPRPTTRADITIONALDEFAULTRATE | Modified |
Procedure | SPRPTUNAPPLIEDPAYMENTS | Modified |
Procedure | SPTEST_PURGE_BORROWER | Modified |
Procedure | SPTESTBERMUDAHISTORYPYMTTOCLM | Deleted |
Procedure | SPTESTBERMUDAHISTORYPYMTTOCLM_NOTUSED | New |
Procedure | SPUTILGETCAMPUSPARTNERDATA | Modified |
Procedure | SPUTILJASSTATEDEBTOFFSET | Modified |
Procedure | SPUTILMOSTATEDEBTOFFSET | Modified |
Procedure | SPUTILOPENCLOSESYMMETRICKEY | New |
Function | F_CLMDECRYPTBYKEY | New |
Function | F_CLMDECRYPTBYKEYAUTOCERT | New |
Function | F_CLMENCRYPTBYKEY | New |
Please contact the Ellucian Customer Support Center.
Web: http://connect.ellucian.com/ Email: actionline@ellucian.com Phone: 800.522.4827
2.7 Menu | 3.0 Menu |
|
|
|
2.7 Menu | 3.0 Menu |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Configuration |
|
|
|
|
|
Select a Borrower Services Function | Select a Customer Account Function |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| ||
|
| |
| ||
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| ||
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
| |
|
Content | |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| ||
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| ||
|
| |
|
| |
| ||
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| ||
|
| |
|
| |
|
| |
|
| |
|
| |
| ||
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
|
|
Accounts |
|
|
|
|
| |
|
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
Primary sort for consolidated reports are by Campus where previous reports may have been either combined or option provided.
2.7.0 Ready to Close: Includes G D P Q R status with =/<$0.00 Balance. Combined report does not include these. Tested all statuses, verified that activity bringing acct </=$0.00 results in status of T, X or Y. Does not provide option of date selection – renders comprehensive list only.
Equiv 3.0 Closed/Paid in Full: To render accounts which are pending to be processed as „Paid in Full?, select dates for which the account would have entered Closed status (</= $0.00 +/- PIF parameter). Enter a „From? date of 01/01/1900 to retrieve a comprehensive list of all pending Ln/Recvs.
2.7.0 Batch Satisfactions: (Paid in full Processed) Included ALL pending accts to be closed regardless of date entering T status in addition to the Accts which were processed to Z status within the date parameters requested. Excluded the X, Y Status.
Equiv 3.0 Closed/Paid in Full: To render ONLY accounts which were processed as „Paid in Full?, select the Loan/Recv Status for Cancelled/Paid in Full for selected dates. To render ONLY accounts which are still pending to be processed as „Paid in Full?, select Closed (Pending PIF) for selected dates or enter 01/01/1900 to retrieve a comprehensive list of all pending.
2.7.0 Loan Listing – Paid in Fulls (Paid In Full Accounts): This report checks for all loans and receivables that are in X, Y, or Z status. If there is an amount in the principal balance you may want to check the customer?s account. The item was closed with a balance.
Equiv. 3.0 Closed/Paid in Full: Accounts which were processed as Paid in Full (Status Z), Cancelled through Write-Off (Status Y) or Assigned to Dept. of Ed. (Status X).
2.7.0 Payments, Applied and Reversed: Produced detailed list of payments and reversals within selected date range. Sort was by Date/Fund/Customer
3.0 Equv Consolidated Payments: Provides options for sort by campus, selection of user, and selection of Payment and Posting methods and Status . See parameters for 2.7.0 Equivalent
2.7.0 Payments by User, Applied and Reversed: Selection of User or ALL, provides detailed list of payments and reversals within selected date range. Sort was by Date/Fund/Customer.
3.0 Equiv… Consolidated Payments: Provides options for sort by campus, selection of user, and selection of payment and posting methods. See parameters
2.7.0 Payments, Daily ACH: Provided report of Payments applied with method of ACH. (Report did not reflect any Unapplied payments).
3.0 Equiv Consolidated Payments: Provides options for sort by campus, selection of user, and selection of payment and posting methods. See parameters topull ACH payment records.. May select select status for ALL to review any un-applied.
2.7.0 Payments, Inbound: Produced a list of all records contained in a payment file which was imported or manually created batch. Status indicated if the Customer ID was successfully applied.
3.0 Equiv Consolidated Payments………….. : Provides options for sort by campus, selection of user, and selection of payment and posting methods. See parameters to pull Imported payments.
2.7.0 Payments, Inbound Applied
3.0 Equiv Consolidated Payments………….. Provides options for sort by campus, selection of user, and selection of payment and posting methods. See parameters to pull Imported payments. To obtain ALL imports regardless of method, user would process using each method of Import separately.
This report will retrieve all Payments and Reversals within the spedfied effective or entry date range for the selected user(s ). Choosea Format @ Report 0 Export (111GroupbyCampus The output is grouped by user, date,Account name and then Customer. Campus: All Campuses ? Loan/Receivable Type: All loans/Rec eivables ? Age Date: @ ERective 0 Entered From: 01/01/2013 0 Through: 01/20/2013 0Sort by: Date / loan Rec v. User. All ? Payment Method: All ? osted Method: Imported File ) ? (status: Appled ) ? ISubmrt I I 6 B 1 .. J Preview J | |
DATE 01f3012013 CLMDEV 3.0 .0 (SOL2005) (DB V ersion: 3.0.0) State Un ers y PAGE 1 T II.IE 12:41. 0 Ellucian Campus Receiv ables Collector Con solidatid P &)m•nts Payments by Effective Date from 01/01/2013 throug h 01/20/20 13 LoantR ecv .:A llloans/Receivab les U ser: All Sort by : D ate / Loan Recv . Payment Method:All Posted Method : Imported File Statu s:App lied Name Customer 10 loan/Recv. Status Entered Dt Pd.Ahead Principal Interest Late F ee Coli Fee Amount I C ampus: KtlI 1/ 20/2013 123 George ,A manda 77888 9999 A ppled 1120/ 13 $0.00 $0.00 $17.39 $0.00 $0.00 $17.39 George, A manda 778889999 A ppled 1120/ 13 SO.OO $159.15 SO.OO $0.00 SO.OO $159.15 Totals for 123 $0.00 $159.15 $17.39 $0.00 $0.00 $176.54 |
.. .. ' ·
I
I
RH ltlST R
Scales, Theresa KN0000007502
Appled 1/20/ 13 $0.00 $0.00 $45.45 $0.00 so.oo $45.45
Totals ror 1/20/ 2013 $0.00 $1,348.16 $0.00
$0.00 $115.07 $1,463.23
Totals rorJcampu s: TC I $0.00 $1,348.16 $0.00
$0.00 $115.07 $1,463.23
... I
I G rand Totals I Imported FILE only $0.00 $7,663.97 $385. 54 Run Imported Manual Batch($440) separately lor $1,905.04 $1,619.74 $11,574.29 I equivalent 2.7 .0 canbined Inbound Report
Page 67 of 69 I
Campus Receivables Collector 3.0.0 Release Guide 1
© 2013 Ellucian. All Rights Reserved- Confidential & Proprietary 1
2.7.0 Payments, Not Applied: Provided lists of Batches in alpha order which contained Un-applied payments.
3.0 'Consolidated Pmt' report lists by dates/customer OR 3.0 new report 'Payments in Batch' lists all payments within slected Batch and indicates status.
Provides options of ALL Payments in system or selected parameters. Additionally, the new report, Payments in Batch, has been added to retrieve data contained in any batch with an indicator of the status as applied or unapplied.
OR