What's New
The release introduces the following new functionality.
Added Fields to Data Views
We added the following fields to a number of data views:
Previous Month Deal Ending Book Balance—Value defaults to the previous month from the current date. Sums the Ending Book Balance for all owners by deal and month.
Previous Calendar Year Deal End Ending Book Balance—Value as of the December prior to the current date. Sums the Ending Book Balance for all owners by deal and month.
Previous Quarter Deal End Ending Book Balance—Value as of the quarter (March, June, September, or December) prior to the current date. Sums the Ending Book Balance for all owners by deal and month.
Partnership—The legal entity on the deal with a role of Partnership.
Asset Manager—The name of the associated Asset Manager. If multiple Asset Managers, the Role Lead is shown.
Developer—The name of the deal entity with the role of Developer. If multiple Developers, the first one is shown.
Actual PISD—If multiple properties, the latest date is shown.
Projected PISD—If multiple properties, the date from the same record as the Actual PISD is shown. If no Actual PISD, the latest projected PISD is shown.
The following table lists the data views that were updated with the new fields. Some of the views below previously included some of the fields above; in this case, the field is not duplicated in the view.
Adjusters | Annual Cash Flow Distributions | Annual Financials |
Benefits | Building | Cash Collection |
Commercial Leases | Commercial Occupancy | Commercial Spaces |
Committee Reviews | Compliance Events | Construction Budget |
Construction Budget Change Orders | Construction Draw | Deal Capital Contributions |
Deal Costs | Deal Covenant | Deal Equity |
Deal Legal Entity | Deal OPA Commitment | Deal Put Call Option |
Deal QEI | Deal QLICI Equity | Deal Source |
Deal Use | Deal Working Capital | Debt Instrument |
Direct Tracing Sub All Tests | Dispositions | Dispositions Use of Proceeds |
Events | Fee Distribution Priorities | File Audit |
Funding Schedule | Goals | Guarantees |
HUD 2530 Submissions | Impairments | Inspection Follow Up |
Inspections | Installment | Insurance |
LIC Accountability | Occupancy | Operating Budgets |
Operating Deficit Guarantees | Payment Allocations | Payments |
Periodic Financials | Pricing Model | Property |
Property Tax | QALICB Certifications | QALICB Questionnaires |
Recapture | Redemption Tests | Reports Received |
Reserves | Risk Review | Safe Harbor Sub All Tests |
SOX Approvals | Status Reports | Sub CDE Certifications |
Subsidized Units | Tax Return | Unit Mix |
Workout Plans |
New Investment Allocation Report
The ProLinkAIM Reports menu includes a new Excel report, called Investment Allocation Report, which helps investors meet their reporting obligations to bank regulators in terms of demonstrating how much CRA investments they have made on their books. You can view the report for data as of the selected date or for data as of the end of the exam cycle.
 | Download this sample spreadsheet to review the report specifications. |