BUILD CONTEXT This is a working demo / pilot tool to accompany our government RFP response to the Texas Department of Housing and Community Affairs (TDHCA) RFO 332-RFO26-1007 for a Multifamily Management System. The agency manages 9% / 4% LIHTC (Low-Income Housing Tax Credit), HOME, NHTF (National Housing Trust Fund), and tax-exempt bond programs. They are replacing manual paper / spreadsheet workflows. We need to build a functional web app demo we can show TDHCA evaluators, with seeded sample data (10-20 fake multifamily applications) so the demo shows real screens with real-looking data flowing through them. Live deployable URL is the priority. THE SOFTWARE WE'RE BUILDING Core capabilities: 1. Application intake portal - developer applies for an affordable housing tax credit allocation. Multi-page form with property details (address, units, AMI mix, construction type), sponsor information, financial pro forma upload, supporting documents upload, deadline gating per allocation cycle. 2. Underwriting workbench - TDHCA underwriter reviews applications. Side-by-side application + scoring criteria. Threshold tests, scoring rubric, conditional approval flow, deficiency letters with editable templates. 3. Asset management - once an allocation is awarded, properties enter the long-term compliance period (15-30 years). Track lease-up status, tenant income certifications, annual owner certifications, physical inspection schedules. 4. Compliance monitoring - automatic generation of LURAs (Land Use Restriction Agreements), IRS Forms 8823 (Tenant Income Certification) and 8609 (Tax Credit Allocation Certification). Workflow rules trigger when inspections lapse or income limits are exceeded. 5. Document generation - generate signed PDF contracts, LURAs, deficiency letters, award letters, regulatory agreements from configurable templates. Template editor for TDHCA admin to modify wording. 6. Pipeline dashboard - admin view of all applications, status (intake / underwriting / awarded / monitoring), deadlines coming up, exceptions and overdue items. 7. Public lookup - search-only view for the public to see awarded properties, allocation amounts, period of affordability. User roles: - Developer applicant (external, self-registered) - TDHCA application admin (intake, deadline management) - TDHCA underwriter (scoring, threshold tests) - TDHCA asset manager (post-award monitoring, compliance) - TDHCA supervisor (override / approve / configure) - Public (read-only search) Integrations: - E-signature provider (DocuSign or Adobe Sign) for LURA execution - Payment processor for application fees - ESRI / mapping for property location verification - Texas Comptroller for sponsor entity verification (test/mock for demo) - Email / SMS for deadline reminders Technical baseline: - Web app, responsive (mobile-aware but desktop-first since this is back-office) - AuthN: SSO + traditional login. AuthZ: role-based. - Data: PostgreSQL or SQL Server compatible. - Document storage: S3-compatible blob store. - Audit log: every state transition logged with actor + timestamp. - API-first - all UI calls go through a documented REST/JSON API; future TDHCA in-house tools can integrate. - Hosted: a single dev URL (we'll redirect this to a fake-TDHCA-branded landing page so the demo is convincing). Demo storyline we need the build to support: 1. A developer named "Riverside Apartments LLC" submits an application for 120-unit LIHTC project in Travis County 2. The underwriter logs in, sees the new application in the queue, runs the threshold tests, scores it 3. Compliance fires a LURA generation, generates a signed PDF 4. Dashboard shows the property entering the 30-year compliance period 5. A second view shows the public lookup of the same property Build-out priorities for the 2-week sprint: - Working UI for steps 1-5 of the storyline (real screens, real data flow) - 10-20 seeded fake applications across different statuses - LURA generation with sample template - Pipeline dashboard with charts - Public lookup page - Deployed to a public URL we can include in the proposal documentation Out-of-scope for the 2-week build: - Real e-signature integration (mock it) - Real Comptroller integration (mock it) - Real payment processing (mock it) - Long-term compliance period accruals (just show the screen)