Campus Receivables Collector Release Guide Release 3.3.0 July 2016
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-2016 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
July 2016
New version that supports Campus Receivables Collector 3.3.0 software.
Contents
CRC Customer Web Access
Specific Enhancements
Enhancements and Defect
Resolutions..
This Release Guide documents the Release 3.3.0 of the Campus Receivables Collector (CRC) system. The release 3.3.0 includes enhancements and problem resolutions.
o You can now search for customers by prior last name and email address.
o Loan/Receivable Details
o Main section: option to Lock the Review Date (new). Allows collector to lock the review date to prevent it from moving upon referral to subsequent queues.
o Billing Definitions
o Account List Format option (new): Group by loan name and status so as to reduce the number of lines printed on the bill.
o Message Setup: Display the full description of the form letter.
o Paid in Full Process
o This process has been totally rewritten to present all loans ready to close in a table format with options to selectively process one, some or all and options to sort by customer, ID or balance.
o Collections Icon
o Option to Lock the Review Date (new). Allows collector to lock the review date to prevent it from moving upon referral to subsequent queues.
o Assignment form version update
o Payment Plan Calculator – the temporary repayment arrangement (TRA) function has been expanded to provide for establishing permanent payment plans.
o
o
o NSLDS – implement loan status VA - Disabled Veteran Discharged. Requires benefit code of CXVA be used when cancelling a loan due to Disabled Veteran Discharged.
o NSLDS – new option exists to run the process for all campuses at one time.
o Collection Referral Batches – you can now save for future reference and reporting the collector referral files
· Include actual mail date in correspondence
· Mask ACH bank account number
· Omit due date for closed and enrolled loans
· Suppress contact information on accounts in CWA for queues that are not external
· Format phone, zip and SSN correctly
·
This information is for people who have been using a previous version of Campus Receivables Collector. If Campus Receivables Collector 3.2.0 is currently installed on your system, you can upgrade to 3.3.0
If a version other than Campus Receivables Collector 3.2.0 is currently installed on your system, you must first upgrade to 3.2.0 before you can upgrade to 3.3.0.
This section describes Enhancements and Defect resolutions delivered in this release. The following Campus Receivables Collector processes and forms have been enhanced.
|
CR/Idea
# |
Issue/Functionality
Addressed |
|
CR-000114607 |
The net agency fee amount is
skewing the collection fee column by including the gross agency fee
amount. Should only display the gross
agency fee amount in the collection fee column and omit net agency fee
altogether since it nets to zero anyway. |
|
1-18ZWMOM |
Reversing a benefit does not
reinstate the prior active benefit.
This causes the loan to remain in its current status because there’s
no benefit expiration to trigger the status change. This will also cause coupons not to
generate at benefit expiration time. |
|
CR-000104145 |
Maximum allowable space for a path
parameter was 50 characters. The
Windows limit is 260 characters so the path fields were altered to be 260. |
|
CR-000120132
|
Date
Range on Payment Search. Request
for future versions to add a "date range" to add to the payment
amount search. See Case # 01184506. Added date type option, entered vs
effective. |
|
CR-000104541 |
Name search. Add Prior name and e-mail address to
search. See Case #00759743. |
|
CR-000132682 |
Nightly student hold batch job was
not generating new holds and was producing the following error: The cause and solution were: The previous view must not have had references to
the function that reference the G$_DATE_PKG as it had worked prior to the
upgrade. As it turns out the NLS_DATE_FORMAT for the session created by the
Oracle Provider for OLE DB was setting the NLS_DATE_FORMAT to 'YYYY-MM-DD
HH24:MI:SS' which is too long for the variable in G$_DATE_PKG. CLMCONFIG_VIEW and \application\OfficeManagement\OM_CLMConfigStudentSystemAccess.asp were
modified to append “UseSessionFormat=True” to the end of the connection
string. |
|
CR-000108644 |
Add
Email to Collection Agency file |
|
CR-000108657 |
Export Collection Agency - add Cell
Phone |
|
CR-000119412 |
Collector Referral File Export– add
past due installments to report |
|
CR-000133024 |
Fisap report is out of balance. It appears that the debit and credit totals
are not matching in Fisap report. Not all lines are included when totals are
calculated on line 58. It only uses lines 1.1 through 43 and excludes lines
44-57. Also, the debit columns for lines 1.1 - 43 are summed they do not
match what is shown in the report. |
|
CR-000132997 |
Trial Balance report needs an
option to print for all/select campuses. |
|
1-1537KN5 |
Paid-in-full process (Batch
Satisfaction) creating multiple letters for closed accounts instead of just
one per customer. |
|
1-2J9J34 |
Batch satisfaction using incorrect
date for satisfaction date. |
|
CR-000118847 |
Paid-in-full (BATCHSAT) process
needs sort and restart options. |
|
CR-000133148 |
Msg 8152, Level 16, State 14,
Procedure spCOLLFetchReferralFileData, Line 344 |
|
1-2UZIRE |
Selecting multiple refunds to
reverse results in only the first refund in the list being reversed. |
|
N/A |
|
|
CR-000119412 |
Collector Referral File Export. Save
details of the Referral each loan/receivable record; Generate details in
History for Referral to Collection Agency adding the amounts submitted (P, I,
LF, CF) at time of export. Provide means to generate the details of Referral to
Collection file extract to save to history record. Provide a batch-like capability to store
list of exports. Generate report of exported files if export file has been
created else report on what the file would contain when export is done. |
|
N/A |
When
displaying a loan make last
paid date N/A when IntMethod is N. |
|
CR-000111829 |
Queue Mail Printing. This page was
rewritten to solve the page count reverting to 5 and the “from” date
reverting to 1/1/1900 problems. Option
to show 100, 500, or 1000 mail items at a time was added. The upper limit is
1000 so that the page doesn’t overflow the maximum page size in the browser. |
|
N/A |
Customer Web Access parameters were
not displaying according to the tab structure. They were all scrolling down one page. |
|
1-1342S4S |
Benefit expiration coupons were generated
for those customers with a bill hold or in a queue that prohibits billing. |
|
CR-000132543 |
CR-000132543
Enrolled borrowers are showing accrued interest even though they have never
left school and should not have accrued interest. |
|
CR-000131296 |
Amount past due incorrect. Date of 1st delinquency is
futuristic. |
|
CR-000129203 |
Phone numbers and email aren't
populating when new addresses are created since these values aren't obtained
during the exit. Pull the values from
the prior address records. |
|
CR-1-15HJ3RE |
Unable to print coupons for
borrower |
|
N/A |
Billing Definitions – Display letter
description and type; sort by type, letter code. |
|
CR-000118279 |
Invoice format question. Desire to be able to group accounts by name
and status or to use the standard CRC style of presenting them like the loan
grid does. |
|
N/A |
Mask bank account number on ACH
page in CWA. |
|
CR-000132544 |
Add
option to run NSLDS processes for all campuses combined. |
|
N/A |
Added LDAP authentication. |
|
CR-000121985 |
Updating
Exit Interview Completed Process Date.
Allow updating of exit completion date from within the Customer
Account Loan Grid menu. |
|
N/A |
Import
> Import > Banner Accounts Receivable:
Headers not displayed with blue background. |
|
N/A |
Allow user the option to select Loan/Receivable Type in the
Loan/Receivables Paid in Full Report. |
|
CR-000133940 |
FISAP AB and CD were including
placeholder data even when the option to exclude them was chosen |
|
CR-000136602 |
Loan grid displaying loans with 1
installment past due with the color for current. |
|
N/A |
Increased the size of the
collection queue add/edit window to eliminate need to scroll. |
|
CR-000124139 |
Address changes are being recorded
under an incorrect userid |
|
N/A |
Importing
Banner AR batches where multiple schools exist in CRC database results in
“Invalid SSN Error” resulting from not using school_link_id along with SSN to
find customer. |
|
N/A |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
This section includes a list of the Campus Receivables Collector 3.3.0 files which have changed since Campus Receivables Collector 3.2.0. This list does NOT include any Help related files.
|
Location |
File |
Comments |
|
Application\Servicing\Reports |
PaymentsConsolidate.rpt |
CR-000114607 The net agency fee
amount is skewing the collection fee column by including the gross agency fee
amount. Should only display the gross
agency fee amount in the collection fee column and omit net agency fee
altogether since it nets to zero anyway. |
|
Application\lib |
CLM_DownloadFile.asp |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Application\OfficeMangement |
OM_CLMConfigIO.asp |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Application\Outbound |
OB_NSLDSDownload.asp |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Application\Outbound\Clearinghouse\Report |
PrintCHOBReports.asp |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The filename field was altered to be 260. |
|
Application\NetPay |
NP_Configuration.asp |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Application\NetPay |
NP_Procedures.asp |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Application\Servicing |
checkParams.asp |
CR-000120132
Date Range on Payment Search; Added date type option, entered vs
effective. |
|
Application\Servicing\Reports |
run_report.asp |
CR-000120132
Date Range on Payment Search; Added date type option, entered vs
effective. |
|
Application\BorrowerServices |
BSCU_Browse.asp |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Application\BorrowerServices |
BSCU_Recent.asp |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Application\BorrowerServices |
BSCU_Select.htm |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Application\BorrowerServices |
BSCU_Select.asp |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Application\OfficeManagement |
OMReversal_header.asp |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Application\OfficeManagement |
OM_BorrowerSearch.asp |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Application\OfficeManagement |
OM_BorrowerSearchRecent.asp |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Application\OfficeManagement |
OM_BorrowerSearchResults.asp |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
application\OfficeManagement |
\OM_CLMConfigStudentSystemAccess.asp |
CR-000132682 Student Hold Batch job
is ending in error and not generating new holds. |
|
Application\Collections |
Coll_referralfile_run.asp |
CR-000108644
Add Email to Collection Agency file |
|
Application\Collections |
Coll_referralfile_run.asp |
CR-000108657 Export Collection
Agency - add Cell Phone |
|
Application\Collections |
Coll_referralfile_run.asp |
CR-000119412 Collector Referral
File Export – add past due installments to report |
|
Application\Help |
Outbound_File_Formats.html |
CR-000108644
Add Email to Collection Agency file. Alter file layout in help. |
|
Application\Help |
Outbound_File_Formats.html |
CR-000108657 Export Collection
Agency - add Cell Phone. Alter
file layout in help. |
|
Application\Help |
Outbound_File_Formats.html |
CR-000119412 Collector Referral
File Export – add past due installments to report. Alter file layout in help. |
|
Application\Servicing\Reports |
FISAP_AB.rpt |
CR-000133024 Fisap report is out of
balance. It appears that the debit and
credit totals are not matching in Fisap report. Not all lines are included
when totals are calculated on line 58. It only uses lines 1.1 through 43 and
excludes lines 44-57. Also, the debit columns for lines 1.1 - 43 are summed
they do not match what is shown in the report. |
|
Application\Servicing |
TrialBalanceParam.asp |
CR-000132997 Trial Balance report
needs an option to print for all/select campuses. |
|
Application\servicing\reports |
run_report.asp |
CR-000132997 Trial Balance report
needs an option to print for all/select campuses. |
|
Application\Servicing\reports |
TrialBalanceDetail.ttx |
CR-000132997 Trial Balance report
needs an option to print for all/select campuses. |
|
Application\Servicing\reports |
TrialBalanceDetail.rpt |
CR-000132997 Trial Balance report
needs an option to print for all/select campuses. |
|
Application\OfficeManagement |
OM_PaidInFullBrowse.asp (NEW) |
CR-000118847 Paid-in-full
(BATCHSAT) process needs sort and restart options. |
|
Application\OfficeManagement |
OfficeManagement\OM_PaidInFullContents.asp
(NEW) |
CR-000118847 Paid-in-full
(BATCHSAT) process needs sort and restart options. |
|
Application\OfficeManagement |
OfficeManagement\OM_PaidInFullProcess.asp
(NEW) |
CR-000118847 Paid-in-full
(BATCHSAT) process needs sort and restart options. |
|
Application\OfficeManagement |
OfficeManagement\OM_PaidInFullViewLoan.asp
(NEW) |
CR-000118847 Paid-in-full
(BATCHSAT) process needs sort and restart options. |
|
Application\OfficeManagement |
OM_REFUNDReverseRefund.asp |
1-2UZIRE selecting multiple refunds
to reverse results in only the first refund in the list being reversed. |
|
Application\Collections |
Coll_referral_batchedit.asp (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Collections |
Coll_referral_batchyears.asp (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Collections |
Coll_referral_batchmakefile.asp (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Collections |
Coll_referral_batchlist.asp (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Collections |
Reports (NEW folder) |
CR-000119412
Collector Referral File Export |
|
Application\Collections\Reports |
Run_report.asp (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Collections\Reports |
Reports.asp (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Collections\Reports |
Preview.rpt and .ttx (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Collections\Reports |
Export.rpt and .ttx (NEW) |
CR-000119412
Collector Referral File Export |
|
Application\Security |
SEC_FunctionTokenIndex.asp |
CR-000119412
Collector Referral File Export, for new menu item under Export |
|
Application\BorrowerServices |
BSLO_LoanDisplay.asp |
When
displaying a loan make last
paid date N/A when IntMethod is N. |
|
Application\BorrowerServices |
BSExitLoan2.asp |
CR-000103990 exit detail – Edit check to be sure
incomplete date is earlier than completed date. |
|
Application\OfficeManagement |
OMLOEXIT_AddEdit.asp |
CR-000103990 exit detail – Edit check to be sure
incomplete date is earlier than completed date. |
|
Application\Servicing |
QueuedMailDisplay.asp (NEW) |
CR-000111829 Queue Mail Printing. A
replacement script was written to solve paging and date reverting to
1/1/1900. Option to show 100, 500, or
1000 mail items at a time was added. |
|
Application\Servicing |
QueuedMailParam.asp (REMOVED) |
CR-000111829 Queue Mail Printing.
This script removed from CRC. |
|
Application\Servicing |
QueuedMailList.asp (REMOVED) |
CR-000111829 Queue Mail Printing. This script removed from CRC. |
|
Application\OfficeManagement |
OM_CLMConfigBorrowerWebAccessAddEdit.asp |
Customer Web Access parameters were
not displaying according to the tab structure. They were all scrolling down one page. |
|
Application\Outbound\Creditreport |
OB_CreditOutboundExtract.asp |
CR-000131296 - Amount past due
incorrect. Date of 1st
delinquency is futuristic. |
|
WebComponents |
clmCreditReport.dll |
CR-000131296 - Amount past due
incorrect. Date of 1st
delinquency is futuristic. |
|
Application\Billing |
BSCPN_AddEdit.asp |
CR-1-15HJ3RE Unable to print
coupons for borrower |
|
Application/Billing |
Invoice_cycleedit.asp |
CR-000118279 Invoice format
question |
|
Application/Billing/Report |
Bill.rpt |
CR-000118279 Invoice format
question |
|
Application/Billing/Report |
LoanData.ttx |
CR-000118279 Invoice format
question |
|
Application/Outbound |
OB_NSLDS.asp |
CR-000132544 Add option to run
NSLDS processes for all campuses combined. |
|
Application/Admin |
ADMIN_ChangePassword.asp |
|
|
Application |
login.asp |
Added LDAP authentication |
|
Application |
session.asp |
Added LDAP authentication |
|
settings.xml |
Added
LDAP authentication |
|
|
WebComponents |
clmAdminFunctions.dll |
Added LDAP authentication |
|
Application\OfficeManagement |
OM_BannerARAdjustmentsBrowse.asp |
Added in-progress message while
page builds. |
|
Application\BorrowerServices |
BSEX_Detail.asp |
CR-000121985 Updating Exit Interview Completed Process
Date |
|
Application\BorrowerServices |
BSEX_ExitCompleteDateEdit.asp (NEW) |
CR-000121985 Updating Exit Interview Completed Process
Date. |
|
Application\Inbound |
IB_AccountsReceivable.asp |
Import > Import > Banner
Accounts Receivable: Headers not
displayed with blue background. |
|
Application\Servicing |
LoansPIFandClosedParam.asp |
Allow user the option to select Loan/Receivable Type in the
Loan/Receivables Paid in Full Report. |
|
Application\Servicing\Reports |
LoansPIFandClosed.rpt |
Allow user the option to select Loan/Receivable Type in the
Loan/Receivables Paid in Full Report. |
|
Application\Servicing\Reports |
Run_report.asp |
Allow user the option to select Loan/Receivable Type in the
Loan/Receivables Paid in Full Report. |
|
Application\BorrowerServices |
BSLO_LoanDisplay.asp |
CR-000136602 Loans with 1
installment past due were being displayed with the color for current. |
|
Application\Collections |
COLL_AddEdit.asp |
Increase size of collection queue
add/edit window to eliminate need to scroll. |
|
Application\Collections |
COLL_Browse.asp |
Increase size of collection queue
add/edit window to eliminate need to scroll. |
|
Application\BorrowerServices |
BSCOLL_LoanMaint.asp |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Application\Collections |
COLL_Loans.asp |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Application\Collections |
COLL_Main.asp |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Application\Collections |
coll_referloan.asp |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Application\OfficeManagement |
OMLOMAIN_AddEdit.asp |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Webcomponents |
clmCollections.dll |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Webcomponents |
clmOMLOMAINEdit.dll |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Application\Servicing\Reports |
AssignForm553.rpt |
Revised expiration date 12/31/2018. |
|
Application\BorrowerServices |
BSA_Browse.asp |
Added display of email to address
list. |
This section includes a list of the Customer Web Access 3.3.0 files which have changed since Customer Web Access 3.2.0. This list does NOT include any Help related files.
|
Location |
File |
Comments |
|
independent |
Loansummary.aspx |
CR-000105032 Do not show due date
for loans in status E, T, X, Y or Z. |
|
independent |
Loansummary.aspx |
Suppress contact information on
accounts in CWA for queues that are not external |
|
independent |
Loandetails.aspx |
Suppress contact information on
accounts in CWA for queues that are not external |
|
independent |
Viewachaccounts.aspx |
Mask bank account number on CWA ACH
page. |
|
App_code |
Editor.vb |
Format phone, zip and SSN
correctly. |
This section includes a list of the Campus Receivables Collector 3.3.0 SQL Server Database objects which have changed since Campus Receivables Collector 3.2.0.
|
Type |
Name |
Update |
|
Stored Procedure |
spOMBenReverseBenefit |
1-18ZWMOM Reversing a benefit does
not reinstate the prior active benefit.
This causes the loan to remain in its current status because there’s
no benefit expiration to trigger the status change. This will also cause coupons not to
generate at benefit expiration time. |
|
Stored Procedure |
spIBGetInboundPath |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Stored Procedure |
spOBGetOutboundPath |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Stored Procedure |
spOBCHGenerate |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. The filename parameter was
similarly changed from 100 to 260. |
|
Stored Procedure |
spOMClmConfigFetchIO |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Stored Procedure |
spOMClmCONFIGUpdate |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Stored Procedure |
spOMCLMCONFIGUpdateIO |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Stored Procedure |
spOMConfigNetPayFetch |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Stored Procedure |
spOMConfigNetPayUpdate |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the path fields were altered
to be 260. |
|
Table |
CLMCONFIG |
CR-000104145 Maximum allowable
space for a path parameter was 50 characters.
The Windows limit is 260 characters, so the 4 path columns were
altered to be varchar(260). |
|
Stored Procedure |
spRptCheckNum |
CR-000120132
Date Range on Payment Search; Added date type option, entered vs
effective. |
|
Stored Procedure |
spBSCFetchCustomers |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
Stored Procedure |
spBSCUFetchRecentBorrower |
CR-000104541 Name search. Add Prior name and e-mail address to
search. |
|
View |
CLMCONFIG_VIEW |
CR-000132682 Student Hold Batch job
is ending in error and not generating new holds. |
|
Stored Procedure |
spCOLLFetchReferralFileData |
CR-000108644
Add Email to Collection Agency file |
|
Stored Procedure |
spCOLLFetchReferralFileData |
CR-000108657 Export Collection
Agency - add Cell Phone |
|
Stored Procedure |
spCOLLFetchReferralFileData |
CR-000119412 Collector Referral
File Export – add past due installments to report |
|
Stored Procedure |
spRptTrialBalance |
CR-000132997 Trial Balance report
needs an option to print for all/select campuses. |
|
Stored Procedure |
spRptTrialBalanceDetail |
CR-000132997 Trial Balance report
needs an option to print for all/select campuses. |
|
Stored Procedure |
spOMBatchSatSatisfyLoan |
1-1537KN5 Paid-in-full process
(Batch Satisfaction) creating multiple letters for closed accounts instead of
just one per customer. |
|
Stored Procedure |
spOMBatchSatSatisfyLoan |
1-2J9J34 Paid-infull
process (Batch satisfaction) using incorrect date for satisfaction date. |
|
Stored Procedure |
spOMBatchSatFetchAll |
CR-000118847 Paid-in-full
(BATCHSAT) process needs sort and restart options. |
|
Data |
UPDATE [FUNCTION] SET
MENU_JS = 'HelpFileName = HelpFolder + "OM_BSMain_help.html";
top.main.location.href="../Servicing/blank.htm";top.contents.location
= "OM_PaidInFullContents.asp"; top.main.location.href="OM_PaidInFullBrowse.asp";'
WHERE INC_CONSTANT = 'SEC_OMBatchSat' |
CR-000118847 Paid-in-full
(BATCHSAT) process needs sort and restart options. |
|
Stored Procedure |
spCOLLFetchReferralFileData |
CR-000133148 Msg 8152, Level 16,
State 14, Procedure spCOLLFetchReferralFileData, Line 344 |
|
Stored Procedure |
spOMRefundReverse |
1-2UZIRE selecting multiple refunds
to reverse results in only the first refund in the list being reversed. |
|
Stored Procedure |
spBannerFetchSTVRSTSCodes |
In Banner
AR Outstanding Report and Import Banner AR, registration status drop-down was
not ordered by withdrawal indicator. |
|
Stored Procedure |
spBannerFetchSTVESTSCodes |
In Banner
AR Outstanding Report and Import Banner AR, student status drop-down was not
ordered by withdrawal indicator. |
|
Stored Procedure |
spCOLLInsertCollectionsHistory.sql |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spCOLLFetchReferralFileData.sql |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spBSHGetHistory_Coll.sql |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spRptCollectionBatchReferral.sql
(NEW) |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spRptCollectionBatchExport.sql(NEW) |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spCOLLUpdateHistExportFields.sql
(NEW) |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spCOLLUpdateBatch.sql (NEW) |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spCOLLFetchBatchYears.sql
(NEW) |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spCOLLFetchBatches.sql
(NEW) |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spCOLLFetchBatch.sql
(NEW) |
CR-000119412
Collector Referral File Export |
|
Stored Procedure |
spRptQueuedMail |
CR-000111829 Queue Mail
Printing. |
|
Stored Procedure |
spOBCPNCreateGDPExpirationsCoupons |
1-1342S4S - Benefit
expiration coupons were generated for those customers with a bill hold or in
a queue that prohibits billing |
|
Stored Procedure |
spLoanAmountDue |
CR-000132543
Enrolled borrowers are showing accrued interest even though they have never
left school and should not have accrued interest. |
|
Stored Procedure |
spLoanAmountDueExcludePartial |
CR-000132543 Enrolled
borrowers are showing accrued interest even though they have never left
school and should not have accrued interest. |
|
Stored Procedure |
spOBCRFetchExtractData |
CR-000131296 - Amount past due
incorrect. Date of 1st
delinquency is futuristic. |
|
Stored Procedure |
spORInsertExitAddress |
CR-000129203 Phone
numbers and email aren't populating when new addresses are created since
these values aren't obtained during the exit.
Pull the values from the prior address records. |
|
Stored Procedure |
spBSSLOAgedLoan |
Suppress contact information on
accounts in CWA for queues that are not external |
|
Stored Procedure |
spINVOICELettersFetch |
Billing Definitions – Display letter
description and type; sort by type, letter code. |
|
Stored Procedure |
spINVOICECycleUpdate |
CR-000118279 Invoice
format question |
|
spINVOICEReportDataDetail |
CR-000118279 Invoice
format question |
|
|
Stored Procedure |
spNSLDSFetchExtract |
CR-000132544 Add option to run
NSLDS processes for all campuses combined. |
|
Stored Procedure |
spNSLDSPrepLoan |
CR-000132544 Add option to run
NSLDS processes for all campuses combined. |
|
Stored Procedure |
spNSLDSPrepLoansForCampus_Run |
CR-000132544
Add option to run NSLDS processes for all campuses combined. |
|
spNSLDSWrapupLoansForCampus |
CR-000132544 Add option to run
NSLDS processes for all campuses combined. |
|
|
Stored Procedure |
spADMINFetchUserStaffID |
Added LDAP authentication |
|
Stored Procedure |
spBSSGeneratePassword |
Added LDAP authentication |
|
Stored Procedure |
spOMSUpdateStaffMember |
Added LDAP authentication |
|
Stored Procedure |
spBSLOEXITUpdate (NEW) |
CR-000121985
Updating Exit Interview Completed Process Date. |
|
Stored Procedure |
spOBFISAPABFetchReportData |
CR-000133940 The section where it
pulls the amounts from the ledger is not excluding placeholders when
requested. |
|
Stored Procedure |
spOBFISAPCDFetchReportData |
CR-000133940 The section where it
pulls the amounts from the ledger is not excluding placeholders when
requested. |
|
Stored Procedure |
spRptLoansPIFandClosed |
Allow user the option to select Loan/Receivable Type in the
Loan/Receivables Paid in Full Report. |
|
Stored Procedure |
spBSAUpdateAddress |
CR-000124139 Address
changes are being recorded under an incorrect userid |
|
Stored Procedure |
spORORiginateLoanFileRec |
Importing
Banner AR batches where multiple schools exist in CRC database results in
“Invalid SSN Error” resulting from not using school_link_id along with SSN to
find customer. Use
to_date function when looking for existence of hold record in order to
respect Banner default date format and mitigate error: ORA-01861: literal does not match format
string |
|
Stored Procedure |
spCOLLFetchLoanInfo |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spCOLLFetchStaffLoans |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spCOLLPutLoanInCollections |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spCOLLRemoveLoanFromCollections |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spOMLoanMainFetch |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spOMLoanMainUpdate |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spOMLOMAINFetch |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spOMLOMAINFetchAll |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spOMLOMAINUpdate |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Table |
LOANMAIN |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
View |
BS_LOAN_COLLECTION_VIEW |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
View |
BS_LOAN_VIEW |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
View |
INVOICE_LOAN_VIEW |
Need a flag/switch on LOANMAIN that
controls whether or not the collector review date advances automatically or
must be manually overridden. |
|
Stored Procedure |
spIBLoadBannerAR |
Added
push_pred to oracle sub-select; instructs the optimizer to use
VIEW PUSH PREDICATE optimization if possible, which basically rewrites the
query internally to be more efficient. |
|
Stored Procedure |
spNSLDSPrepLoanStatus |
Implement
loan status VA - Disabled Veteran Discharged |
Please contact the Ellucian Customer Support Center.
Web: http://www.ellucian.com/Support-and-Training/Ellucian-Client-Support/
Email: actionline@ellucian.com
Phone: 800.522.4827