...
| 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 | |
| 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 | |
| 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 | |
| balanceDue_table | N/A 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. |
Context: Member
| Name | Merge Fields |
|---|---|
| fm_firstName, fm_fname | |
| Last Name | fm_lastName, fm_surname, fm_lname |
| Middle Name | fm_middleName |
| Middle Initial | fm_middleInitial |
| First, Middle, Last Name | fm_fmlname |
| Last, First, Middle Name | fm_lfmname |
| SSN | fm_ssn |
| SSN Masked | fm_ssn_masked |
| Suffix | fm_suffix |
| Sex | fm_sex |
| Date of Birth | fm_dob |
| Race Description | «rs_fm_race»«description»«es_fm_race» |
| Race HUD Code | «rs_fm_race»«hudCode»«es_fm_race» |
| Relation Description | fm_relation.description |
| Relation HUD Code | fm_relation.hudCode |
| Ethnicity Description | fm_ethnicity.description |
| Ethnicity HUD Code | fm_ethnicity.hudCode |
| Email Address | «rs_fm_emailAddresses»«address»«es_fm_emailAddresses» |
| Email Address Category | «rs_fm_emailAddresses»«category»«es_fm_emailAddresses» |
| Address Category | «rs_fm_addresses»«category»«es_fm_addresses» |
| Address Is Mailing Address | «rs_fm_addresses»«isMailingAddress»«es_fm_addresses» |
| Address Postal Code | «rs_fm_addresses»«postalCode»«es_fm_addresses» |
| Address State | «rs_fm_addresses»«state»«es_fm_addresses» |
| Address City | «rs_fm_addresses»«city»«es_fm_addresses» |
| Address Unit | «rs_fm_addresses»«unit»«es_fm_addresses» |
| Address Street Address | «rs_fm_addresses»«streetAddress»«es_fm_addresses» |
| Phone Number | «rs_fm_phoneNumbers»«number»«es_fm_phoneNumbers» |
| Phone Number Category | «rs_fm_phoneNumbers»«category»«es_fm_phoneNumbers» |
| Expense Last Update | «rs_fm_expenses»«lastUpdate»«es_fm_expenses» |
| Expense Amount | «rs_fm_expenses»«amount»«es_fm_expenses» |
| Expense Description | «rs_fm_expenses»«description»«es_fm_expenses» |
| Asset Last Update | «rs_fm_assets»«lastUpdate»«es_fm_assets» |
| Asset Income | «rs_fm_assets»«assetIncome»«es_fm_assets» |
| Asset Cash Value | «rs_fm_assets»«cashValue»«es_fm_assets» |
| Asset Description | «rs_fm_assets»«description»«es_fm_assets» |
| Income Excluded Amount | «rs_fm_incomes»«excludedAmount»«es_fm_incomes» |
| Income Amount | «rs_fm_incomes»«amount»«es_fm_incomes» |
| Income Description | «rs_fm_incomes»«description»«es_fm_incomes» |
| Income Last Update | «rs_fm_incomes»«lastUpdate»«es_fm_incomes» |
| Is Veteran | fm_isVeteran |
| Is Disabled or Handicapped | fm_isDisabledOrHandicap |
...
| Name | Merge Field |
|---|---|
| First Name | firstName |
| Middle Name | middleName |
| Birth Date | birthDate |
| Suffix | suffix |
| Alias | alias |
| Disabled or Handicapped | isDisabledOrHandicap |
| Veteran | isVeteran |
| Sex | sex |
| Masked SSN | ssn |
| Unmaksed SSN | unmasked_ssn |
| Relation Description | relation.description |
| Relation HUD Code | relation.hudCode |
| Relation Short Name | relation.short |
| Ethnicity Description | ethnicity.description |
| Ethnicity HUD Code | ethnicity.hudCode |
| Citizenship Description | citizenship.description |
| Citizenship Hud Code | citizenship.hudCode |
| Created (Date) | created |
| Email Addresses | «rs_emailAddresses»«address»«es_emailAddresses» |
| Email Address Category | «rs_emailAddresses»«category»«es_emailAddresses» |
| Addresses Category | «rs_addresses»«category»«es_addresses» |
| Address Is Mailing Address | «rs_addresses»«isMailingAddress»«es_addresses» |
| Address Postal Code | «rs_addresses»«postalCode»«es_addresses» |
| Address State | «rs_addresses»«state»«es_addresses» |
| Address City | «rs_addresses»«city»«es_addresses» |
| Address Unit | «rs_addresses»«unit»«es_addresses» |
| Address Street Address | «rs_addresses»«streetAddress»«es_addresses» |
| Phone Number | «rs_phoneNumbers»«number»«es_phoneNumbers» |
| Phone Number Category | «rs_phoneNumbers»«category»«es_phoneNumbers» |
| Expense Last Update | «rs_expenses»«lastUpdate»«es_expenses» |
| Expense Amount | «rs_expenses»«amount»«es_expenses» |
| Expense Description | «rs_expenses»«description»«es_expenses» |
| Asset Last Update | «rs_assets»«lastUpdate»«es_assets» |
| Asset Income | «rs_assets»«assetIncome»«es_assets» |
| Asset Cash Value | «rs_assets»«cashValue»«es_assets» |
| Asset Description | «rs_assets»«description»«es_assets» |
| Income Excluded Amount | «rs_incomes»«excludedAmount»«es_incomes» |
| Income Amount | «rs_incomes»«amount»«es_incomes» |
| Income Description | «rs_incomes»«description»«es_incomes» |
| Income Last Update | «rs_incomes»«lastUpdate»«es_incomes» |
| Community Service Code | communityServiceCode |
| Race HUD Code | «rs_race»«hudCode»«es_race» |
| Race Description | «rs_race»«description»«es_race» |
Balance Due Table (Household Context)
| Name | Merge Field |
|---|---|
| Total Balance | totals.totalBalance |
| Total Bal 30 | totals.totalBal30 |
| Total Bal 60 | totals.totalBal60 |
| Total Bal 90 | totals.totalBal90 |
| Total Bal 120 | totals.totalBal120 |
| Total Bal 120 Plus | totals.totalBal120Plus |
| Account Id | «rs_accounts»«account»«es_accounts» |
| Account Name | «rs_accounts»«accountName»«es_accounts» |
| Balance | «rs_accounts»«balance»«es_accounts» |
| Bal 30 | «rs_accounts»«bal30»«es_accounts» |
| Bal 60 | «rs_accounts»«bal60»«es_accounts» |
| Bal 90 | «rs_accounts»«bal90»«es_accounts» |
| Bal 120 | «rs_accounts»«bal120»«es_accounts» |
| Bal 120 Plus | «rs_accounts»«bal120Plus»«es_accounts» |
| Chart of Accounts Name | «rs_accounts»«chartOfAccountsName»«es_accounts» |
| Program Name | «rs_accounts»«programName»«es_accounts» |
Work Order Table (Household Context)
Wrap the following merge fields in a repeating row under the merge field work_order_table EX: <<rr_work_order_table>><<er_work_order_table>>)
Work Order Table (Household Context)
| Name | Merge Field |
|---|---|
| Household's latest Work Order # | wo_num |
...