Code_Changes_to_EVARS_in_2012.docx

Attachment 4 Code Changes to EVARS

10-09-2012

In C:\inetpub\evars\view\vextension\dsp_extensionSearch.cfm, line 61 was commented out to prevent HECM extensions from being requested. Jane Anderson requested this. HECM loans are now being handled by HERMIT.

10-15-2012

Code change was reversed from 10-09-2012. However, FHA Case #’s in table, HECM_REF where set to status, ‘C’ from ‘O’ if no previous requests were made, since HERMIT can only handle new requests. A backup of HECM_REF was made in table, HECM_TEMP.

02-01-2013

Line 32 of evars\view\vextension\dsp_extensionSearchResult.cfm “Other(SSCRA/Moratorium/Title Issues/Drug Seizure/Natural Disaster)” changed to “Other”

Added record to table EVARS.dbo.other_extension_type_ref: “Submitted Due to ML 2012-22”

03-15-2013

Line 79 of evars\view\vVariance\dsp_varianceHome.cfm removed, requested by Anh:

<option value="varianceHAMP" <cfif comparenocase(variables.fhaSearch.getFhaSearchInfo().getSelVarianceType(),"varianceHAMP") eq 0>selected="selected"</cfif>>FHA-HAMP</option>

05-13-2013

Mcladrey database changes for test system:

alter table extension_req add [mitigation_status] [bit] NOT NULL DEFAULT 1

Added Variance_Ratio_Sets table

Added columns to Variance_Req table: front_end_ratio, back_end_ratio, need_extension_appraisal, appraisal_completed_dt, need_extension_atp, atp_date, other_issues

But removed the Create a New Set of Variance Ratio Sets on the Screen

Then implemented the rest of Mcladrey Changes with Richard Sell’s fixes

Code Changes to ECLASS

6-12-2012

In C:\inetpub\eclass\model\course\schedule\courseschedulegateway.cfc, line 70 was commented out and replaced by line 71. The Start Date is >= ‘2012-02-01’ as requested by Debra Beacham to fix defect.

9-18-2012

Defect: FHA cases not showing up for some lenders when doing HECM extension requests, even though they are in the HECM_REF table and Lender ID is in the Lender_REF table.

In C:\inetpub\evars\model\mExtension\act_getFhaInfo.cfm, line 76 and 81, the session variable, “SelVarianceType” was changed to “SelExtensionType”. Was later reversed.

Code Changes to EHLP

06-28-2012

Changed C:\inetpub\EHLP\form.cfm to allow various types of Excel Files to be uploaded. Backup saved as form2012-06-28.