POST-INSTALLATION INSTRUCTIONS for hot fix A24001 on Windows

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.