1.       Back up the existing Fair Banking solution

2.       Copy <sasroot>\hmdamva\sashelp\*.*  to <rootpath>\global\custom\parameter

3.       Copy <sasroot>\hmdamva\sasmisc\data_model\l_yyyys\* to <rootpath>\global\install\ddl\sas

4.       Copy <sasroot>\hmdamva\sasmisc\data_model\l_ext\* to <rootpath>\global\install\ddl\sas

5.       Copy <sasroot>\hmdamva\sasmisc\setup\* to <rootpath>\global\install\setup

6.       Copy <sasroot>\hmdamva\sasstp\sfb_autoexec_all.sas to  <rootpath>\global\control

7.       Start up Fair Banking SAS environment and run the following codes.

      %inc "&rootpath\global\install\setup\load_job_list.sas"; 

%sfb_rate_job_driver ;

           %inc "&rootpath\global\install\setup\load_columns.sas"; 

              %apply_app_detail_ddl(hmda_or_cra=HMDA);

 

8.       If HMDA data has been loaded before the hotfix is installed, run the following macro for the current submission year. 

              %apply_edits_to_master(hmda_or_cra=HMDA);

           %sfb_reporting_job_driver;

 

9.       Verify the installation.

a.       L_SYS.L_FORMAT_CNTL should have a record with FOR_COLUMN=’FIXED_MORTGAGE_FLG’

b.      L_SYS.L_COUNTY_CODE should not have records with county_desc contains ‘(CA)’.

c.       CNTL.JOB_LIST should have a record with MACRO_CALL=’sfb_rate_job_driver’

d.      L_EXT.EXT_RATE_ARM and L_EXT.EXT_RATE_FIXED should have a lot of records.

e.      CNTL.COLUMNS should have records with NAME in (‘FIXED_MORTGAGE_FLG’ , ‘LOAN_TERM_FIXED_FOR_ARM’ , ‘PRIME_RATE_USED_RT’ ‘PRIME_RATE_USED_DT’)

f.        L_<yyyy>s.APP_HMDA_DETAIL_CURR/ERR/AUDIT tables should have columns FIXED_MORTGAGE_FLG, LOAN_TERM_FIXED_FOR_ARM,  PRIME_RATE_USED_RT, and PRIME_RATE_USED_DT.

g.       Columns FIXED_MORTGAGE_FLG and LOAN_TERM_FIXED_FOR_ARM are added to the current year HMDA correction spreadsheets in <rootpath>\ C:\sas\SFBEntBI\Lev1\Applications\SASFairBanking\4.1\web_imart\error_download\hmda if the spreadsheets exist.

 

Enhance CDS geocoding (CDS only)

The problem described in SAS Note 38307 , requires a customized Dataflux service job that can geocode a street address spanning 2 lines.
Follow the steps below to switch to your customized job.

Copy your customized DataFlux service job to:
<DATAFLUXHOME>/DIS/8.1/svc_job (rename the file to include the .dmc extension).

Modify the following line in   <SASCONFIGDIR>/Lev1/Applications/SASFairBanking/4.1/global/control/sfb_autoexec_all.sas

    call symputx('dfservice','SASFairBanking_AddressVerify_Geocoding');

to replace 'SASFairBanking_AddressVerify_Geocoding’ with your new service job name.

Restart all SAS services.