Legacy LL Upgrade Steps

Instructions to Upgrade from Legacy Format Tables Find the table version you subscribe to, then follow the steps.
FhlLoan	FnmLoan
Legacy 63-Column Format --> Current 64-Column Format Step 1. Run FhlLoan Special Eligibility Program alter statement for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 2. Submit a request to subscribe to current FhlLoan (64-column) format going forward.	Legacy 59-Column Format --> Current 60-Column Step 1. Run Special Eligibility Program alter statement for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 2. Submit a request to subscribe to current FnmLoan (60-column) format going forward.
Legacy 59-Column Format --> Current 64-Column Format Step 1. Run these alter statements for your DBMS. 1a) Run FhlLoan Seller/Servicer alter statements for your DBMS. FhlLoanAlterSyntaxOracle_202106.sql.txt FhlLoanAlterSyntaxPostgres_202106.sql.txt FhlLoanAlterSyntaxSQLServer_202106.sql.txt FhlLoanAlterSyntaxMySQL_202106.sql.txt 1b) Run FhlLoan Special Eligibility Program alter statement for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 2. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 2a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 2b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FhlLoan.ctl.txt FhlLoanUI.ctl.txt Step 3. Submit a request to subscribe to current FhlLoan (64-column) format going forward.	Legacy 55-Column Format --> Current 60-Column Step 1. Run these alter statements for your DBMS. 1a) Run FnmLoan Seller/Servicer alter statements for your DBMS. FnmLoanAlterSyntaxOracle_202106.sql.txt FnmLoanAlterSyntaxPostgres_202106.sql.txt FnmLoanAlterSyntaxSQLServer_202106.sql.txt FnmLoanAlterSyntaxMySQL_202106.sql.txt 1b) Run Special Eligibility Program alter statements for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 2. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 2a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 2b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FnmLoan.ctl.txt FnmLoanUI.ctl.txt Step 3. Submit a request to subscribe to current FnmLoan (60-column) format going forward.
Legacy 57-Column Format --> 64-Column Format Step 1. Run FhlLoan BAP/DQ alter statements for your DBMS. BAPAlterSyntaxSQLServer.sql.txt BAPAlterSyntaxPostgres.sql.txt BAPAlterSyntaxOracle.sql.txt BAPAlterSyntaxMySQL.sql.txt Step 2. Run FhlLoan Seller/Servicer alter statements for your DBMS. FhlLoanAlterSyntaxOracle_202106.sql.txt FhlLoanAlterSyntaxPostgres_202106.sql.txt FhlLoanAlterSyntaxSQLServer_202106.sql.txt FhlLoanAlterSyntaxMySQL_202106.sql.txt Step 3. Run FhlLoan Special Eligibility Program alter statements for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 4. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 3a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 3b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FhlLoan.ctl.txt FhlLoanUI.ctl.txt Step 5. Submit a request to subscribe to current FhlLoan (64-column) format going forward.	Legacy 53-Column Format --> Current 60-Column Format Step 1. Run FnmLoan BAP/DQ alter statements for your DBMS. BAPAlterSyntaxSQLServer.sql.txt BAPAlterSyntaxPostgres.sql.txt BAPAlterSyntaxOracle.sql.txt BAPAlterSyntaxMySQL.sql.txt Step 2. Run FnmLoan Seller/Servicer alter statements for your DBMS. FnmLoanAlterSyntaxOracle_202106.sql.txt FnmLoanAlterSyntaxPostgres_202106.sql.txt FnmLoanAlterSyntaxSQLServer_202106.sql.txt FnmLoanAlterSyntaxMySQL_202106.sql.txt Step 3. Run FnmLoan Special Eligibility Program alter statements for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 4. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 3a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 3b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FnmLoan.ctl.txt FnmLoanUI.ctl.txt Step 5. Submit a request to subscribe to current FnmLoan (60-column) format going forward.
Legacy 54-Column Format --> Current 64-Column Format Step 1. Run FhlLoan ADR alter statements for your DBMS. ADRAlterSyntaxSQLServer.sql.txt ADRAlterSyntaxPostgres.sql.txt ADRAlterSyntaxOracle.sql.txt ADRAlterSyntaxMySQL.sql.txt Step 2. Run FhlLoan BAP/DQ alter statements for your DBMS. BAPAlterSyntaxSQLServer.sql.txt BAPAlterSyntaxPostgres.sql.txt BAPAlterSyntaxOracle.sql.txt BAPAlterSyntaxMySQL.sql.txt Step 3. Run FhlLoan Seller/Servicer alter statements for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 4. Run FhlLoan Special Eligibility Program alter statements for your DBMS. LoanLevelAlterOracle_202108.sql.txt LoanLevelAlterPostgres_202108.sql.txt LoanLevelAlterSQL_202108.sql.txt LoanLevelAlterMySQL_202108.sql.txt Step 5. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 4a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 4b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FhlLoan.ctl.txt FhlLoanUI.ctl.txt Step 6. Submit a request to subscribe to current FhlLoan (64-column) format going forward.	Legacy 50-Column Format --> Current 60-Column Format Step 1. Download the latest Fnmloan distribution package (60-column) for your DBMS. FnmLoanLevelSQL.zip FnmLoanLevelMySQL.zip FnmLoanLevelOracle.zip FnmLoanLevelPostgreSQL.zip Step 2. Drop and recreate FnmLoan. NOTE: The data will be removed from the table. Step 3. Reload FnmLoan history. Submit a request for historical FnmLoan files in 59-column format. Step 4. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 4a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 4b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FnmLoan.ctl.txt FnmLoanUI.ctl.txt Step 5. Submit a request to subscribe to current FnmLoan (60-column) format going forward.
Legacy 53-Column Format (to be retired 8/2021) --> Current 64-Column Format Step 1. Download the latest Fhlloan distribution package (64-column) for your DBMS. FhlLoanLevelSQL.zip FhlLoanLevelMySQL.zip FhlLoanLevelOracle.zip FhlLoanLevelPostgreSQL.zip Step 2. Drop and recreate FhlLoan. NOTE: The data will be removed from the table. Step 3. Reload FhlLoan history. Submit a request for historical FhlLoan files in 64-column format. Step 4. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 4a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 4b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108pgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FhlLoan.ctl.txt FhlLoanUI.ctl.txt Step 5. Submit a request to subscribe to current FhlLoan (64-column) format going forward.	Legacy 41-Column Format (to be retired 8/2021) --> Current 60-Column Format Step 1. Download the latest Fnmloan distribution package (60-column) for your DBMS. FnmLoanLevelSQL.zip FnmLoanLevelMySQL.zip FnmLoanLevelOracle.zip FnmLoanLevelPostgreSQL.zip Step 2. Drop and recreate FnmLoan. NOTE: The data will be removed from the table. Step 3. Reload FnmLoan history. Submit a request for historical FnmLoan files in 60-column format. Step 4. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 4a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 4b) Download and add the records from the README file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FnmLoan.ctl.txt FnmLoanUI.ctl.txt Step 5. Submit a request to subscribe to current FnmLoan 60-column) format going forward.
Legacy 52-Column Format (to be retired 8/2021) --> Current 64-Column Format Step 1. Download the latest Fhlloan distribution package (64-column) for your DBMS. FhlLoanLevelSQL.zip FhlLoanLevelMySQL.zip FhlLoanLevelOracle.zip FhlLoanLevelPostgreSQL.zip Step 2. Drop and recreate FhlLoan. NOTE: The data will be removed from the table. Step 3. Reload FhlLoan history. Submit a request for historical FhlLoan files in 64-column format. Step 4. Install the new database update scripts. This step is optional, but recommended. It will allow clients to stay on legacy versions of the file as long as needed. 4a) Download and install the new distribution (readme.txt included) for your DBMS. eMBSUITruncateMySQL.zip eMBSUITruncatePostgres.zip eMBSUITruncateSQLServer.zip eMBSUITruncateOracle.zip 4b) Download and add the records from the README202108TXT file to eMBSUpdt.bat or eMBSUpdt.sh for your DBMS. README_LoanLevel202108Upgrade_MySQL.TXT README_LoanLevel202108Upgrade_SQLServer.TXT README_LoanLevel202108Upgrade_Postgres.TXT README_LoanLevel202108Upgrade_Oracle.TXT Oracle .ctl files: FhlLoan.ctl.txt FhlLoanUI.ctl.txt Step 5. Submit a request to subscribe to current FhlLoan (64-column) format going forward.

eMBS. You'll Love Us for a Million Reasons.

Last updated: 08/09/2021