...
| Name | Description |
|---|---|
| action | Name of last action in household history |
| carbal | Total A/R Ending Balance for Current Month (Does include Repayment balance) |
| ha_city | Housing Authority City |
| ha_csz | Housing Authroty City State Zip |
| ha_email | Housing Authority Email |
| ha_fax | Housing Authority Fax |
| ha_name | Housing Authority Name |
| ha_phone | Housing Authority Phone |
| ha_state | Housing Authority State |
| ha_str1 | Housing Authority Street 1 |
| ha_str2 | Housing Authority Street 2 |
| hh_careof | Head of Household mailing Care/Of |
| hh_csz | Head of Household mailing city, state, zip |
| hh_dob | Head of Household Date of Birth |
| hh_email | Head of Household email |
| hh_fmlname | Head of Household full name: First M. Last |
| hh_fname | Head of Household First Name |
| hh_lfmname | Head of Household full name: Last, First M. |
| hh_mname | Head of Household middle name |
| hh_prphone | Head of Household Primary Phone # |
| hh_ssn | Head of Household SSN |
| hh_strapt | Head of Household mailing with with apt no |
| hh_surname | Head of Household surname, including title. |
| insdtsched | Date of Scheduled Inspection |
| newten | Tenant's Monthly Charge/Rent |
| nextardt | Date of next annual recertification |
| ofc_city | Other HA Office City |
| ofc_csz | Other HA Office City State Zip |
| ofc_email | Other HA Office Email |
| ofc_fax | Other HA Office Fax |
| ofc_name | Other HA Office Name |
| ofc_phone | Other HA Office Phone |
| ofc_state | Other HA Office State |
| ofc_str1 | Other HA Office Street 1 |
| ofc_str2 | Other HA Office Street 2 |
| oldten | Previous tenant rent amount |
| outputdate | Current Date |
| pgmname | Program Name |
| prjname | Project Name |
| totarbal | Total A/R Ending Balance for Current Month (Does include Repayment balance) |
| typesched | Type of Inspection Scheduled |
| u_aptno | Unit Apartment Number |
| u_baths | Unit's # of Bathrooms |
| u_bdrms | Unit Size (# of Bedrooms) |
| u_city | Unit City |
| u_csz | Unit City State Zip |
| u_state | Unit State |
| u_str1 | Unit Street Address Line 1 |
| u_strapt | Unit Street Address Line 1 plus Apt Number |
| u_yrbuilt | Year Built |
| u_unitNumber | Unit Number |
| user_email | HA employee/user email |
| user_fname | HA employee/user first name |
| user_lname | HA employee/user last name |
| user_name | HA employee/user name |
| user_signature | N/A |
| user_title | HA employee/user title |
| work_order_table | Iterate over all work order's tied to a household |
| members_table | household members table |
| waiting_list_table | All waiting lists that this household is assigned to |
balDueCurrentMonth | Balance for the last 0-30 days |
| balDue30To60 | Balance for the last 30-60 days |
| balDue60To90 | Balance for the last 60-90 days |
| balDue90To120 | Balance for the last 90-120 days |
| balDueOver120 | Balance over 120+ days old |
| balDueOver90 | Balance over 90+ days old. |
...