Report Types

contra costa
salinas
san mateo
QP1, QP2, QP3, QE, etc… --> QP followed by city code

A16, A17, A18 --> applications
HA --> housing application
IA --> interim application
CA, DA, EA, BA --> different application types for Alameda County

EX, EY, EZ = Types of expense reports
EV = evaluation reports

BR = budget revision

QC = different type of quarterly report (some jursidictions have 6, but if it starts with a Q its a quarterly report)

UA = utility allowance (multifamily)

SU = source and uses (contra costa only)
CS = contract source
DL/DM = request for reimbursement

AD = Advance report (berkeley only)
PD = Occupancy reports (almost everyone that uses multifamily)

HM = housing monitoring report (multifamily report)
AF = Annual financial report (multifamily)
IN = Inspection report (multifamily)
PS = multifamily[???]

TH = housing related

CQP, QPT = quarterly reports

ADS = advance payment related

CSU = contract source

SI = inspection report (multifamily)

CCS = Contract source for Berkley

CAMA = monitoring report (Contra costa)

HQ = housing quarterly report

FC = financial report (housing)

LO = housing inspection [??]

RA = some sort of application

CN = monitoring report, used for public services

HR = housing type report

QH = quarterly housing

MB = federal report for construction reports (e.g. Ventura used it when they did our housing, San Mateo has this too)

CT/CU/CV = contract source variant

AP = early iteration on applications

FR = [???]

CQQ = [???]

CSQ = [???]

Go to reports/ProgramReports.rpt —> this will have the mapping

---

SINGLE FAMILY

Residential Rehab

• sfrprogs = programs that are running single family housing

• sfr

Homeowner Loans

only 4-5 jurisdictions have large amount of loans in them

• loancat has the type of loans; multi-family loans are also included in loans

• loanslist is the list of loans that are in the category
  • has a column called cat which is FK into loancat

• loans table
  • this is very consistent
  • S = setup information for the loan
  • P = payments against that loan
  • stat = A for active

NOTE: to figure out what loans are in multi-family loans, you have to check the webpage and see what categories are for multi-family loans and which ones aren’t

Salinas —> great example of well-executed loans portfolio (multifamily and single family)

most of the rest have either OR, combined/displayed in the same way

MULTIFAMILY

• projs —> has all the information about the projects (equivalent of progs but has names, addresses)
  • This is 100% true for jurisdictions
  • type is largely for display purposes

• props —> individual units
  • property relates to projs’ project column

monitor table —> monitoring of reports; sometimes public services, sometimes multi-family

• Best way to get the true funding amounts, go to each jurisdiction, go to CS documents, find the field for the funding/budget amount

• Unduplicated clients served on the public services side; how many people are they helping