Spectrum Loan Reports - Revision history

Paulae at 19:55, 21 December 2021

2021-12-21T19:55:59Z

2021-12-15T19:19:30Z

2021-12-15T18:41:41Z

2021-12-15T18:22:00Z

2021-12-14T18:24:10Z

2021-12-14T18:13:35Z

2021-12-13T17:25:20Z

2021-12-10T19:30:08Z

2021-12-10T19:19:16Z

2021-12-10T18:57:32Z

@@ Line 120: / Line 120: @@
 {{SampleContext|
-name=NEW-LOANS-BY-COLLATERAL|
+name=New Loans by Officer|
-h1=New Loans Summary by Collateral Code.|
+h1=New Loans detail by Officer.|
-h2=This report pulls all new loans that are put on the books during a year, month.  The year and month are specified by an entry in the user prompt in CCYYMM format.  It sorts the loans by COLLATERAL and displays a summary by collateral code.|
+h2=This report pulls all loans opened in the prior month.|
-link=NEW-LOANS-BY-COLLATERAL.ctx|
+link=New Loans by Officer.ctx|
 created=2016/09/01|
 results={{Results_NEW-LOANS-BY-COLLATERAL|}}

@@ Line 113: / Line 113: @@
 name=LOANS-BY-COLLATERAL|
 h1=Loan Portfolio Summary by Collateral Code.|
-h2=This report pulls all loans that have a balance > 0.  It sorts the loans by COLLATERAL and displays a summary by collateral code showing the collateral code, the collateral description, the total number of loans for that collateral code, the total outstanding balance and the average rate on loans in each collateral code.|
+h2=This report pulls all open loans that have a balance > 0.  It sorts the loans by COLLATERAL and displays a summary by collateral code showing the collateral code, the collateral description, the total number of loans for that collateral code, the total outstanding balance and the average rate on loans in each collateral code.|
 link=LOANS-BY-COLLATERAL.ctx|
 created=2016/09/01|

@@ Line 104: / Line 104: @@
 name=DELINQUENT-LOANS-BY-OFFICER|
 h1=Gathers and displays all delinquent loans by loan officer.|
-h2=This report pulls loans that have a balance greater than zero that are 15 days or more past due and are not collateral 999 (charged off).  It is sorted by loan officer and shows how many loans and the total loan balance that are 15-30, 31-60, 61-90, and over 90 days delinquent.|
+h2=This report pulls loans that have a balance greater than zero that are 15 days or more past due and are not charged off.  It is sorted by loan officer and shows how many loans and the total loan balance that are 15-30, 31-60, 61-90, and over 90 days delinquent.|
 link=DELINQUENT-LOANS-BY-OFFICER.ctx|
 created=2016/09/01|

@@ Line 96: / Line 96: @@
 name=OFFICER-LOANS-BY-CREDIT-SCORE|
 h1=Created in REPORT.  Will find all Open Loans, sort by Officer and group by Credit Score.|
 link=OFFICER-LOANS-BY-CREDIT-SCORE.ctx|
 created=2016/09/01|

@@ Line 78: / Line 78: @@
 name=DELINQUENT-LOANS-BY-COLLATERAL|
 h1=Created in REPORT.  Example of how to create arrays in Visimage.|
 link=DELINQUENT-LOANS-BY-COLLATERAL.ctx|
 created=2016/09/01|

@@ Line 71: / Line 71: @@
 name=PAID-OFF-REALESTATE|
 h1=Created in REPORT.  Tracks paid off Real Estate Loans.|
 link=PAID-OFF-REAL-ESTATE.ctx|
 created=2016/09/01|

@@ Line 61: / Line 61: @@
 {{SampleContext|
 name=INSURED-LOANS-BY-OFFICER|
-h1=Created in REPORT.  Contains 2 REPORTS: By Detail and by Summary.|
+h1=Created in REPORT.  Contains 2 REPORTS:  Detail and Summary.|
 h2=Pulls all loans that have been disbursed (MEMBRS.LOAN-FILE.ACTION = D) and have an entry date in between and inclusive (IB) certain entry dates.|
 link=INSURED-LOANS-BY-OFFICER.ctx|

@@ Line 42: / Line 42: @@
 }}
 {{SampleContext|
 name=LOANS-BY-APR|

@@ Line 37: / Line 37: @@
 name=Weighted Average by Collateral|
 h1=The weighted average of loans by collateral code.|
 link=WEIGHTED-AVERAGE-BY-COLLATERAL-CODE.ctx|
 created=2016/09/01|