NewViews for Non-Profit Housing offers five views of Member/Tenant accounts that can be used to maintain and display important dates and other information associated with RGI related forms and notices. Information found on these views can be mail merged with the sample templates provided to create personalized forms/notices for members/tenants.
These five views include:
The table below lists names and descriptions of merge fields that are included in data source files that are generated from these RGI views.
| Merge Code | Description | RGI View |
| NAME | Member/tenant account name | All |
| DESCRIPTION | Member/tenant account description | All |
| NOTES | Text entered on the Notes view of the member/tenant account | All |
| ADDRESS_d_COMPANY | Text entered in the Company Name field on the Address view of the member/tenant account | All |
| ADDRESS_d_NAME_d_FREEFORM | Text entered in the Contact Name Freeform field on the Address view of the member/tenant account | All |
| ADDRESS_d_NAME_d_SALUTATION | Text entered in the Salutation field on the Address view of the member/tenant account | All |
| ADDRESS_d_NAME_d_FIRST | Text entered in the First Name field on the Address view of the member/tenant account | All |
| ADDRESS_d_NAME_d_MIDDLE | Text entered in the Middle Name field on the Address view of the member/tenant account | All |
| ADDRESS_d_NAME_d_LAST | Text entered in the Last Name field on the Address view of the member/tenant account | All |
| ADDRESS_d_STREET | Text entered in the Street field on the Address view of the member/tenant account | All |
| ADDRESS_d_STREET2 | Text entered in the Street2 field on the Address view of the member/tenant account | All |
| ADDRESS_d_CITY | Text entered in the City field on the Address view of the member/tenant account | All |
| ADDRESS_d_STATE | Text entered in the State/Province field on the Address view of the member/tenant account | All |
| ADDRESS_d_COUNTRY | Text entered in the Country field on the Address view of the member/tenant account | All |
| ADDRESS_d_ZIPCODE | Text entered in the State/Province field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_d_FREEFORM | The telephone number entered in the Phone Freeform field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_d_COUNTRY_CODE | The digits for the telephone country code entered in the 1st Country Code field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_d_AREA_CODE | The digits for the telephone area code entered in the 1st Area Code field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_d_PREFIX | The first 3 digits of the telephone number entered in the 1st Prefix field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_d_SUFFIX | The last 4 digits of the telephone number entered in the 1st Suffix field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_d_EXTENSION | The telephone number extension entered in the 1st Extension field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_s_FAX_d_FREEFORM | The fax number entered in the Fax Freeform field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_s_FAX_d_COUNTRY_CODE | The digits for the fax country code entered in the 2nd Country Code field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_s_FAX_d_AREA_CODE | The digits for the fax area code entered in the 2nd Area Code field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_s_FAX_d_PREFIX | The first 3 digits of the fax number entered in the 2nd Prefix field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_s_FAX_d_SUFFIX | The last 4 digits of the fax number entered in the 2nd Suffix field on the Address view of the member/tenant account | All |
| ADDRESS_d_PHONE_s_FAX_d_EXTENSION | The fax number extension entered in the 2nd Extension field on the Address view of the member/tenant account | All |
| ADDRESS_d_EMAIL | The email address entered in the Email field on the Address view of the member/tenant account | All |
| ADDRESS_d_WEBSITE | The website URL entered in the Website field on the Address view of the member/tenant account | All |
| ADDITIONAL_INFO_STRING_1 | Text entered into the first extra string column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_STRING_2 | Text entered into the second extra string column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_STRING_3 | Text entered into the third extra string column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_STRING_4 | Text entered into the fourth extra string column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_STRING_5 | Text entered into the fifth extra string column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_DATE_1 | The date entered into the first extra date column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_DATE_2 | The date entered into the second extra date column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_DATE_3 | The date entered into the third extra date column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_DATE_4 | The date entered into the fourth extra date column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| ADDITIONAL_INFO_DATE_5 | The date entered into the fifth extra date column that has been added to one of the RGI views of member/tenant accounts (blue table only) | All |
| COLUMN_LINE | The line number on which the member/tenant account appears | All |
| COLUMN_NAME | Member/tenant account name (alternative to NAME) | All |
| COLUMN_DESCRIPTION | Member/tenant account description (alternative to DESCRIPTION) | All |
| COLUMN_RGI_ITEM_COUNT | Total number of RGI items for the member/account | All |
| COLUMN_RGI_EFFECTIVE_DATE | Effective date of the RGI item used by the RGI calculator (based on the Preview Date on the RGI - Rent Synopsis view. | All |
| COLUMN_RGI_RESIDENT_COUNT | Total number of residents in the unit inhabited by the member/tenant | All |
| COLUMN_RGI_INFO_R1 | Date on which the Annual RGI Eligibility Review package is sent to the member/tenant | RGI - Info Request RGI - Subsidy Terminate Notice |
| COLUMN_RGI_INFO_D1 | Deadline for submission of the Annual RGI Eligibility Review Package by the member/tenant | RGI - Info Request RGI - Subsidy Terminate Notice |
| COLUMN_RGI_INFO_R2 | Date on which the Annual Eligibility Review - Deadline Extended notice is sent to the member tenant | RGI - Info Request RGI - Subsidy Terminate Notice |
| COLUMN_RGI_INFO_D2 | Extended deadline for submission of the Annual Eligibility Review package by the member/tenant | RGI - Info Request RGI - Subsidy Terminate Notice |
| COLUMN_RGI_INFO_R3 | Date on which the Request for Information - Annual Review notice (i.e. 3rd and final notice) is sent to the member/tenant | RGI - Info Request RGI - Subsidy Terminate Notice |
| COLUMN_RGI_INFO_D3 | Final deadline for submission of the Annual Eligibility Review package by the member/tenant | RGI - Info Request RGI - Subsidy Terminate Notice |
| R1_NAME | Name of the 1st resident of the household | All |
| R2_NAME | Name of the 2nd resident of the household | All |
| R3_NAME | Name of the 3rd resident of the household | All |
| R4_NAME | Name of the 4th resident of the household | All |
| R5_NAME | Name of the 5th resident of the household | All |
| R6_NAME | Name of the 6th resident of the household | All |
| R7_NAME | Name of the 7th resident of the household | All |
| R8_NAME | Name of the 8th resident of the household | All |
| R9_NAME | Name of the 9th resident of the household | All |
| R10_NAME | Name of the 10th resident of the household | All |
| TODAYS_DATE | Today's date (i.e. the date on which the mail merged document is generated) | All |
| COLUMN_RGI_TOTAL_RENT | Total housing charge for the unit | RGI - Rent Change Notice RGI - Subsidy Terminate Notice RGI = Subsidy Re-instate Notice |
| COLUMN_RGI_OBTAIN_INCOME_S | Date on which the Notice of Requirement to Obtain Income is sent to the member/tenant | RGI - Obtain Income Notice |
| COLUMN_RGI_OBTAIN_INCOME_D | Deadline for responding to the Notice of Requirement to Obtain Income | RGI - Obtain Income Notice |
| COLUMN_RGI_RENT_CHANGE_S | Date on which the Notice of Housing Charge change is sent to the member/tenant | RGI - Rent Change Notice |
| COLUMN_RGI_RENT_CHANGE_D | Deadline for appealing the change to housing charges (subsidy) | RGI - Rent Change Notice |
| COLUMN_RGI_SUBSIDY_TS | Date on which the Notice of Termination of Subsidy is sent to the member/tenant | RGI - Subsidy Terminate Notice |
| COLUMN_RGI_SUBSIDY_TD | Deadline for appealing the termination of subsidy | RGI - Subsidy Re-instate Notice |
| COLUMN_RGI_SUBSIDY_RS | Date on which the Notice of Housing Charge - Revised (i.e. reinstatement of subsidy) is sent to the member/tenant | RGI _ Subsidy Re-instate Notice |
| COLUMN_RGI_SUBSIDY_RD | Deadline for appealing the reinstatement of subsidy | RGI - Subsidy Re-instate Notice |