Context: Household

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

Context: Member

Name	Merge Fields
First Name	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

Context: Work Order

Name	Merge Field
Work Order Number	workOrderNumber
Requested By	requestedBy
Subject	subject
Area Type	areaType
Head First Name	headFirstName
Head Last Name	headLastName
Program Name	programName
Project Name	projectName
Modified By	modifiedBy
Modified On	modifiedOn
Permission To Enter	permissionToEnter
Smoke Detector Was Checked	smokeDetectorWasChecked
Work Completed	workCompleted
Address	address
Closed On	closedOn
Assigned On	assignedOn
Assigned To First Name	assignedToFirstName
Assigned To Last Name	assignedToLastName
Status	status
Priority	priority
Requested On	requestedOn
Comments Created By	«rs_comments»«createdBy»«es_comments»
Comments Created On	«rs_comments»«createdOn»«es_comments»
Comment Body	«rs_comments»«commentBody»«es_comments»
Work Requested	workRequested

Context: Rent Calc

Name	Merge Field
Adjusted Annual Income	adjustedAnnualIncome
Adjusted Monthly Income	adjustedMonthlyIncome
Asset Income	assetIncome
Basic Rent	basicRent
Dependent Deduction	dependentDeduction
Effective Date	effectiveDate
Elderly Or Disabled Deduction	elderlyOrDisabledDeduction
Expenses	expenses
Fair Market Rent	fairMarketRent
Final Rent	finalRent
Gross Household Income	grossHouseholdIncome
Income	income
Minimum Charge	minimumCharge
Maximum Charge	maximumCharge
Net Tenant Charge	netTenantCharge
Note Rate Rent	noteRateRent
Number Of Dependents	numberOfDependents
Rent Limit	rentLimit
Split1	split1
Split2	split2
Split3	split3
Total Annual Expenses	totalAnnualExpenses
Total Deductions	totalDeductions
Total Tenant Payment (TTP)	totalTenantPayment
Total Tenant Payment (TTP) Percentage	ttpPercentage
Unit Number	unitNumber
Unit Street Address	unitStreetAddress
Unit City	unitCity
Unit State	unitState
Unit Postal Code	unitPostalCode
Unit Number Of Bedrooms	unitNumberOfBedrooms
Utility Allowance	utilityAllowance

Context: Waiting List

Name	Merge Field
Name	name
Housing Authority Name	ha_name
Household Assignments	householdAssignments (see table documentation)

Tables

Members Table (Context: Household)

Wrap the following merge fields in a repeating row under the merge field members_table EX: <<rr_members_table>><<er_members_table>>)

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>>)

Name	Merge Field
Household's latest Work Order #	wo_num
Total tenant charges on work order	wo_tentot

Waiting List Table (Household Context)

Name	Merge Field
Waiting List Name	wl_name
Waiting List Application Date	wl_dton

Household Assignments Table (Waiting List Context)

wrap all the following merge fields in a repeating row under the merge field householdAssignments (<<rr_householdAssignments>><<er_householdAssignments)

Name	Merge Field
Rank	$itemnum
Name	household.headLastName, household.headFirstName
Prefer Points	totalPreferencePoints
App Date / Time	applicationDate
Bed	bedroomSize
Num (#) In Fam	numInFam
Income	householdGrossIncome
AMI Pct	percentageOfMedianIncome
Income Level	incomeLevel
Last Update	lastUpdatedDate
Preferences (Name)	<<rs_preferences>><<name>><<es_preferences>>
Preferences (Points)	<<rs_preferences>><<pointValue>> <<es_preferences>>

Doorways Supported Merge Fields