Context: Household
...
Waiting List Table (Household Context)
(<<rr_waiting_list_table>><<er_waiting_list_table>>)
| Name | Merge Field |
|---|---|
| Waiting List Name | wl_name |
| Waiting List Application Date | wl_dton |
...
Household Action (Household Action Context)
The initial need for this new merge field coordinator and the merge fields it provides is to support Tax Credits including TIC forms/templates and the TTP template.
| Name | Merge Field |
|---|---|
| annual | checkbox on top of the TIC form, shows if this is an annual recertification |
| effdt | effective date of the action initiating the TTP or TIC form |
| fixedRentReason | reason for household's fixed rent |
| hh_moveindt | household move in date |
| imputedAssetIncome | imputed asset income calculated at the time the action took place |
| inclimit | current income limit of household per family size |
| inclimitx140 | current income limit of household multiplied by 140% (1.4) |
| init | checkbox on top of the TIC form, shows if this tenant income certification is for an initial move in |
| isFixedRateRent | does the household have a fixed rate rent |
| maximumCharge | maximum rent charge allowed |
| minimumCharge | minimum rent charge allowed |
| mi_famcnt | count of family members at the time of the move in |
| mi_inc | total income of the househole at the time of move in |
| spec | checkbox on top of the TIC form, shows if this is a certification for a reason other than move in or annual recertification |
| otherdesc | note field used if spec field above it set |
| passbookRate | imputed asset rate, currently set at 0.06% as defined by HUD |
| ppuCode | PPU Code / account number |
| totalAssetIncome | total annual income from assets |
| totalCashValue | total cash value of assets |
| totalExpenseAnnual | total annual expenses |
| totalIncomeAnnualAdjusted | total annual income, adjusted |
| totalIncomeOther | total value of other income |
| totalIncomePensions | total value of pensions |
| totalIncomeWages | total value of wages |
| totalIncomeWelfare | total value of welfare |
| ttpFinalRent | final rent charge |
| ttpFixedRent | household's fixed rent amount |
| ttpPercent | total tenant payment percent |
| utilityAllowance | unit's utility allowance for household |
| u_unitNumber | unit number |
Tenant Ledger Context
Mergefields:
"_id"
"accountRecords"
"actionId"
"closingBalances"
"closingDate"
"conveyanceDate"
"deactivatedOn"
"formattedUnitTenantStatus"
"headFirstName"
"headLastName"
"household"
"householdActions"
"moveInDate"
"moveOutDate"
"openingDate"
"ppuCode"
"program"
"programName"
"programType"
"project"
"projectName"
"projectSegmentCode"
"tenantLedgerName"
"unit"
"unitAddress"
"unitCSZ"
"unitNumber"
"unitPPUCode"
"unitSegmentCode"
"unitStreetAddress"
"unitTenantStatus"
"transactions"
"__v"
"numAccountRecords"
"sortField"
Tables:
"accountRecords"
"householdActions"
"transactions".
accountRecords
"name"
"accountDefinitionId"
"accountId"
"actionId"
"chartOfAccountsId"
"deactivatedOn"
"displayName"
"isAR"
"isPrimary"
"isBadDebt"
"isDeposit"
"isPrincipal"
"programId"
"projectId"
"unitId"
"openingBalance"
"closingBalance"
"transactionIds"
Deposit Report Context
Deposit Transactions Table
«rr_depositTransactions»/«er_depositTransactions»
«sequenceNumber»
«householdName»
«categoryName»
«subCategoryName»
«amount»
«postedOn»
«accountName»
«ppuCode»
Deposit Groups Table
«rr_depositGroups»/«er_depositGroups»
«groupName»
«groupTotal»
«subGroups»
SubGroups Table
«rr_subGroups»/«er_subGroups»
«subGroupName»
«subGroupTotal»
Non-Table Mergefields
«depositSequence»
«depositCreatedOn»
«depositPostedOn»
«depositTotal»
...