image


image

Campus Receivables Collector


Release Guide


Release 3.0.0


April 2013


image


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.


image

Contents

INTRODUCTION 4

A SPECIAL NOTE ABOUT THIS RELEASE 4

NEW AND UPDATED FEATURES 4

CAMPUS RECEIVABLES COLLECTOR 4

ENCRYPTION 4

SYSTEM-WIDE ENHANCEMENTS 4

ADMINISTRATION 5

CUSTOMER ACCOUNTS 6

REPORTS 6

IMPORT 6

EXPORT 6

CRC CUSTOMER WEB ACCESS SPECIFIC ENHANCEMENTS 6

A/R SPECIFIC ENHANCEMENTS 7

UPGRADE PATHS 7

MISCELLANEOUS ENHANCEMENTS 7

PROBLEM RESOLUTIONS 13

APPLICATION FILE CHANGES 15

SQL SERVER DATABASE CHANGES 33

FOR ASSISTANCE 49

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


Introduction

image


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.


A Special Note about this Release

image


Re-Brand and Re-Face


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.


New and Updated Features

image


Campus Receivables Collector


Encryption


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.


System-wide Enhancements



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):



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.


Administration



Customer Accounts



CRC Customer Web Access Specific Enhancements



A/R Specific Enhancements



Upgrade Paths

image


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.


Miscellaneous Enhancements

image


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-

image


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:


  • Accelerated

  • balDueInFull

  • deferred


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.

  • enrolled

  • normalLoan

  • onePastDue

  • overThreePastDue

  • postponed

  • threePastDue

  • twoPastDue

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.


image


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.


Problem Resolutions

image


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

MAIL

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

MAIL

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

MAIL

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.


Application File Changes

image


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

image


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


SQL Server Database Changes

image


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.


image


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


image


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


For Assistance

image


Please contact the Ellucian Customer Support Center.


Web: http://connect.ellucian.com/ Email: actionline@ellucian.com Phone: 800.522.4827

Appendix A - Menu Terminology Crosswalk

image


2.7 Menu

3.0 Menu

  • Office Management

  • Administration

  • Customer Accounts


image


2.7 Menu

3.0 Menu

  • Loan Ledger Maintenance

  • Accounting Transaction Details

  • Borrower Maintenance

  • Add/Edit Customer

  • Loan Maintenance

  • Loan/Receivable Details

  • NSLDS Maintenance

  • NSLDS Data

  • Post an Adjustment

  • Post an Adjustment

  • Benefit Reversal

  • Reverse a Benefit/Allowance

  • Payment Reversal/NSF

  • Reverse Payments (NSF)

  • Processes

  • Invoice Cycles

  • Billing Definitions

  • Internal Collection Cost Assessment

  • Internal Collection Cost Assessment

  • Batch Satisfactions

  • Paid in Full

  • Refund Queue Maintenance

  • Pending Processed Refunds

  • Refunds

  • Refund Overpayments

  • Rehabilitations

  • Rehabilitation Update

  • N/A

  • Synchronize CRC with Banner AR

  • School Profile

  • Service Center Address

  • Address - Correspondence

  • Payment Center Address

  • Address - Payments

  • System Tables

  • General Ledger Table Maintenance

  • Accounting Feed Definitions

  • General Ledger Table Replicate

  • Accounting Feed Definitions Replicate

  • Benefit Maintenance

  • Benefit/Allowance Definitions

  • Collection Queue Maintenance

  • Collection Queues

  • Letter Maintenance

  • Letters and Forms

  • Note Maintenance

  • Loan/Receivable Definitions

  • Note Replicate

  • Loan/Receivable Definitions Replicate

  • Bursar/Detail Code Maintenance

  • Loan/Receivable Mappings


  • Security Group Setup

  • Security – Access

  • Staff Member Maintenance

  • Security – Users

  • Coded Data Value Maintenance

  • System Code Definitions

  • System Configuration Parameters

  • System Configuration

  • ACH Parameters

  • ACH Parameters

  • Benefit Mail Parameters

  • Benefit/Allowance Mail Parameters

  • Campus Parameters

  • Campus Parameters

  • Clearinghouse Parameters

  • Clearinghouse Parameters

  • Credit Bureau Parameters

  • Credit Bureau Parameters

  • Borrower Web Access Parameters

  • Customer Web Access Parameters

  • Exit Parameters

  • Exit Parameters

  • Inbound/Outbound Parameters

  • Import/Export Parameters

  • Internal Collection Cost Parameters

  • Internal Collection Cost Parameters

  • IRS 1098-E Parameters

  • IRS 1098-E Parameters

  • Loan Setup

  • Loan/Receivable Setup

  • Mail Margin Setup

  • Mail Margin Setup

  • NetPay Parameters

  • NetPay Parameters

  • Payment Parameters

  • Payment Parameters

  • School Parameters

  • School Parameters

  • Student System Interface

Configuration

  • Student System Interface Configuration

  • Term Table Maintenance

  • Term Code Definitions

  • Borrower Services

  • Customer Accounts

Select a Borrower Services Function

Select a Customer Account Function

  • Accounts

  • Collection Status

  • Collection Status

  • Call Log

  • Comments Log

  • N/A

  • Exit


  • Flags

  • Flags

  • History

  • History

  • Loans

  • Loans/Receivables Grid

  • Notepad

  • Notepad

  • Correspondence

  • Coupons

  • Coupons

  • Disbursement Notices

  • Disbursement Notices

  • Invoices

  • Invoices

  • Mail

  • Mail

  • N/A

  • Method

  • Personal

  • ACH Accounts

  • ACH Accounts

  • Addresses

  • Addresses

  • Comakers

  • Comakers

  • Employment

  • Employment

  • Family/Personal

  • Family/Personal

  • Financial Profile

  • Financial Calculator

  • Exit Interview Online Data

  • Online Personal Data Form

  • References

  • References

  • Processes

  • Add a Loan

  • Add New Loan/Receivable

  • Benefits

  • Benefit/Allowance

  • Loan Verification Certificate

  • Loan Verification Certificate

  • Tmp. Repayment Arrangements (TRA)

  • Payment Plan Calculator (TRA)

  • Student System Hold

  • Student System Hold

  • Select a Loan Function

  • Select a Loan/Receivable Function

  • Data

  • Comaker

  • Comaker


  • Credit Report Detail

  • Credit Report Detail

  • Loan Detail

  • Details

  • Exit Detail

  • Exit Details

  • Flags

  • Flags

  • Loan History

  • History

  • Payment Method

  • Payment Method

  • Payment Plan

  • Payment Plan

  • Transaction History

  • Transaction History

  • Correspondence

  • Call Log

  • Comments Log

  • Processes

  • Amortization Schedule

  • Amortization Schedule

  • Assignment Form

  • Assignment Form

  • Exit a Loan

  • Exit

  • Adjust Loan +/-

  • Increase/Decrease

  • Post a Payment

  • Post a Payment

  • Re-enroll Loans

  • Re-Enroll

  • Refer to Collections Queue

  • Refer to Collection Queue

  • Rehabilitate

  • Rehabilitate

  • N/A

  • Remove from Collection Queue

  • TRA Calculator

  • Payment Plan Calculator

  • Reports

  • Reports

  • Banner Reports

  • Banner Accounts Receivable

  • Banner A/R Outstanding Debt

  • N/A

  • Banner A/R Payment Transfers

  • Banner A/R Credits

  • Banner A/R Transfer Offset (Write-off)

  • N/A

  • CRC to Banner A/R Reconciliation

  • Collection Reports


  • Collection Referrals

  • Collections Outflow

  • Collection Queue History

  • Collection Queue List

  • Collection Queue List

  • N/A

  • Collection Status

  • Collector Productivity

  • Collector Productivity

  • Customer Reports

  • ACH Borrowers

  • ACH Customers

  • Borrower Addresses

  • Addresses

  • Co maker Listing

  • Comaker List

  • Borrower Loan and History Detail

  • Customer and Account History Detail

  • Borrower Web Updates

  • Customer Web Updates

  • Borrowers Entering Default

  • Customers Entering Default

  • Borrowers Entering Repayment

  • Customers Entering Repayment

  • Borrower and Loan Exit Batch Contents

  • Exit Batch Contents

  • Exit Status

  • Exit Status

  • Flags Report

  • Flags

  • Student System Hold

  • Student System Holds

  • Temporary Repayment Arrangements

  • Temporary Repayment Arrangements

  • Federal Reports

  • AOR Reporting

  • AOR Federal Loan Reporting

  • Cohort Default Rate

  • Cohort Default Rate-Federal

  • Federal Loan Payment

  • Federal Loan Payment

  • FISAP Reporting

  • FISAP Reporting

  • NSLDS Error Analysis

  • NSLDS Error Analysis

  • Financial

  • Accounting Feed by Trans Date

  • Accounting Feed by Trans Date


  • Accounting Feed Detail by GL Posted Date


  • Accounting Feed Detail by GL Posted Date

  • Daily Adjustments

  • Daily Adjustments

image


  • Daily Activity Balancing

  • Daily Transactions

  • Internal Collection Cost Assessment Records

  • Internal Collection Cost Assessments

  • Inbound Borrower and Loan Records

  • Loans/Receivables - Imported Batch

Content

  • Loan Advances

  • Loans/Receivables - Manual and Imported

  • Payments, Applied/Reversed

  • Payments, by User, Applied/Reversed

  • Payments, Daily ACH

  • Payments, Inbound

  • Payments, Inbound Applied

  • Payments, Not Applied

  • Payments – All

  • N/A

  • Payments by Batch

  • Online Gateway Payments

  • Payments - Online Gateway

  • Paid Ahead Listing

  • Payments - Paid Ahead

  • Partial Payments Listing

  • Payments – Partial

  • Payments by Check Number or Amount

  • Payments - Search by Amt. or Ck #

  • Trial Balance

  • Trial Balance

  • Loan/Receivable Reports

  • Admin Fee Acct Balance

  • Admin Account Balance

  • Aged Accounts Receivables

  • Aged Accounts Receivables

  • Loans in Collections - Aged

  • Aged Collections Accounts

  • Benefits - Currently Active

  • Benefits/Allowances Active

  • Benefits Given

  • Benefits/Allowances History

  • Loan Listing - By Benefit Type

  • Benefits/Allowances Search by Code

  • Loan Listing - By Status

  • Loan Summary By Status

  • By Status

  • Campus Loan Totals

  • Campus Loan Totals – Detail

  • Campus Account Totals

  • Cancellation History

  • Cancellation/Write-Off History

  • Loan Listing - Paid in Fulls

  • Batch Satisfactions

  • Ready To Close Loans

  • Closed/Paid in Full

  • Missed Payment Aging & Default Rate

  • Default - Missed Payment Aging


  • External Collections

  • External Collector

  • Negative Balance Closed Loans

  • Negative Balance Closed Loan/Receivables

  • Loan Listing - Federal PIF During Grace

  • Paid in Full During Grace

  • Loan Listing - By Payment Frequency

  • Payment Frequency

  • Small Balance

  • Small Balance

  • Mail Functions

  • Campaign Mail

  • Generate Campaign Mail

  • Queued Mail Printing

  • Print Queued Mail

  • System Reports

  • General Ledger Records

  • Accounting Feed Definitions

  • Batch Jobs History

  • Batch Jobs History

  • Benefits – List of Valid Types

  • Benefits/Allowances Definitions

  • Note Types Information

  • Loan/Receivable Definitions

  • Coded Data Values

  • System Code Definitions

  • Inbound

  • Import

  • Import

  • Inbound Borrower & Loan Records

  • Customer Accounts

  • Inbound Payment Records

  • Payments

  • Inbound Exit Records

  • Exits

  • Inbound Clearinghouse

  • Clearinghouse - Federal

  • Inbound Banner Accounts Receivable

  • Banner Accounts Receivable

  • Apply

  • Apply Borrower & Loan Records

  • Customer Accounts

  • Apply Payment Records

  • Payments

  • Apply Exit Records

  • Exits

  • Apply Clearinghouse

  • Clearinghouse - Federal

  • Apply Banner Accounts Receivable

  • Banner Accounts Receivable

  • Outbound

  • Export


  • Banner A/R Feeds

  • Banner AR Credits

  • Credits

  • N/A

  • Payments

  • Correspondence

  • Benefit Mail

  • Benefit Mail

  • Coupon Outbound

  • Coupons

  • Loan Inbound Disbursement Notices

  • Disbursement Notices - Inbound

Accounts

  • Invoices – Bills

  • Invoices - Bills

  • Invoices – Due Diligence

  • Invoices - Due Diligence

  • Federal Reporting

  • ClearingHouse

  • ClearingHouse

  • IRS 1098-E Reporting

  • IRS 1098-E Reporting

  • IRS 1098-E Statements

  • IRS 1098-E Statements

  • NSLDS Reporting

  • NSLDS Reporting

  • Financials

  • Accounting Feed Extract

  • Accounting Feed Extract

  • ACH Outbound File

  • ACH Outbound File

  • Miscellaneous

  • Collections Referral File

  • Collections Referral File

  • Credit Report Extract

  • Credit Report Extract


Appendix B - Crosswalk from 2.7.0 Reports to Consolidated 3.0 Reports

image


Primary sort for consolidated reports are by Campus where previous reports may have been either combined or option provided.


Closed/Paid in Full Report Crosswalk … 2.7.0 to 3.0


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.


image


image


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.


image


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.


image


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.


image


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.


image


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).


image


Consolidation of Payment Reports Crosswalk… 2.7.0 to 3.0


2.7.0 Payments, Applied and Reversed: Produced detailed list of payments and reversals within selected date range. Sort was by Date/Fund/Customer


image


image


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


image


image


image


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.


image


3.0 Equiv… Consolidated Payments: Provides options for sort by campus, selection of user, and selection of payment and posting methods. See parameters


image


2.7.0 Payments, Daily ACH: Provided report of Payments applied with method of ACH. (Report did not reflect any Unapplied payments).


image


image


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.


image


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.


image


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.


image


2.7.0 Payments, Inbound Applied


image


image


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.

image

ellucian..


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 &)mnts

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 image image

I


image


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


image

image

image

image

image

image

image

image


Page 67 of 69 I

Campus Receivables Collector 3.0.0 Release Guide 1

© 2013 Ellucian. All Rights Reserved- Confidential & Proprietary 1


Additionally RUN Inbound Manual Batch


image


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.


image


Equiv 3.0 Consolidated Payments OR Payments in Batch (New Report)


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.


image


OR


image