...
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 |
PPU | wo_ppu |
| Tenant Total | wo_tentot |
| Labor Costs | labor_costs (see table documentation below) |
| Materials Costs | materials_costs (see table documentation below) |
| Vendor / Contractor Costs | vendor_contractor_costs (see table documentation below) |
| Mileage Costs | mileage_costs (see table documentation below) |
| Other Costs | other_costs (see table documentation below) |
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)
...
| 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» | race.hudCode |
Race Description | race.description | |||
| is Full Time Student | isFullTimeStudent | |||
| Household Member # | memberNumber | |||
| Age | age | |||
| Tribe Affiliation | tribe | |||
| Tribe's Enrollment Number | enrollmentNumber |
Members Assets Table (Context: Household)
Wrap the following merge fields in a repeating row under the merge field members_assets EX: <<rr_members_assets>><<er_members_assets>>
| Name | Merge Field |
|---|---|
| Household Member # | memberNumber |
| Asset Type | assetType |
| Cash Value of Asset | cashValue |
| Annual Income from Asset | assetIncome |
Members Income Table (Context: Household)
Wrap the following merge fields in a repeating row under the merge field members_income EX: <<rr_members_income>><<er_members_income>>
| Name | Merge Field |
|---|---|
| Household Member # | memberNumber |
| Income Type | incomeType |
| Annual Income from Income | annualIncome |
| Amount Excluded from Income | excludedAmount |
| Annual Income adjusted (Excluded Amount subtracted from Annual Income | adjustedAnnualIncome |
Members Income Table Groups (Context: Household)
Wrap the following merge fields in repeating row under the merge field members_income_groups EX: <<rr_members_income_groups>><<er_members_income_groups>>
| Name | Merge Field |
|---|---|
| Household Member # | memberNumber |
| Total Value of Member's Wages | incomeWages |
| Total Value of Member's Pensions | incomePensions |
Total Value of Member's Welfare | incomeWelfare |
| Total Value of Member's Other Income | incomeOther |
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 |
Waiting List Table (Household Context)
...
| 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>> |
labor_costs table (Work Order Context)
| Name | Merge Field |
|---|---|
| Charge Type | chargeType |
| Description | description |
| Amount | amount |
| Billable To | billableTo |
| Hours | hours |
Date of Work | dateOfWork |
materials_costs table (Work Order Context)
| Name | Merge Field |
|---|---|
| Charge Type | chargeType |
| Description | description |
| Amount | amount |
| Billable To | billableTo |
| Quantity | quantity |
Unit Cost | unitCost |
vendor_contractor_costs table (Work Order Context)
| Name | Merge Field |
|---|---|
| Charge Type | chargeType |
| Description | description |
| Amount | amount |
| Billable To | billableTo |
| Vendor | vendor |
Purchase Order | purchaseOrder |
mileage_costs table (Work Order Context)
| Name | Merge Field |
|---|---|
| Charge Type | chargeType |
| Description | description |
| Amount | amount |
| Billable To | billableTo |
| Total Mileage | totalMileage |
Cost Per Mile | costPerMile |
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 |