TownSq
Sign In

Glossary

Definitions and terminology for data onboarding

A

Association: A homeowners association (HOA) or similar community organization that manages common areas and enforces community rules.

Association GL Account: Association-specific general ledger account that provides local account codes and names while mapping to corporate GL accounts. Stored in the association_gl_accounts table.

Association ID: Unique identifier for each association in the TownSq system.

Assessment: Monthly or annual fee charged to property owners for association services and maintenance.

B

Business Rules: Logic that governs how data should be transformed, validated, or processed during onboarding.

Business Stakeholder: Person responsible for business decisions and requirements during the onboarding process.

C

Chart of Accounts (COA): Structured list of general ledger accounts used for financial reporting and accounting. See also Corporate GL Account and Standard GL Account.

COA Mapping: Process of mapping an organization's legacy GL accounts (Corporate GL Accounts) to Associa's standardized chart of accounts (Standard GL Accounts).

Corporate GL Account: Organization-level general ledger account from legacy systems that maps to Standard GL Accounts. Stored in the corporate_gl_accounts table.

CSV: Comma-Separated Values file format used for data exchange.

Cutover: The process of switching from old systems to the new TownSq system.

D

Data Assessment: Initial evaluation of source system data quality and completeness.

Data Availability Status: Indicator of whether a field can be populated from source data. Values include: Available (can provide), Quasi-Available (partial or conditional), Not Available (cannot provide), Unknown (needs investigation).

Data Validation: Process of checking data accuracy, completeness, and compliance with business rules.

Delinquency Configuration: Settings that control late fee and late interest calculations, including methods, amounts, cutoff days, and intervals. Part of operational setup.

Direct Debit: Automated payment method that withdraws funds directly from bank accounts.

E

EIN: Employer Identification Number, federal tax ID for associations.

Emergency Contact: Person designated to be contacted in case of property-related emergencies.

F

FDIC: Federal Deposit Insurance Corporation, provides bank deposit insurance.

Field Mapping: Process of matching source system fields to TownSq system requirements.

Field Mapping Notes: Documentation of data availability status and implementation details for specific entity fields. Tracks what data can be provided and any special considerations.

Fiscal Settings: Configuration of fiscal year parameters including fiscal month end and fiscal year start month. Part of operational setup.

Fiscal Year: 12-month accounting period used by the association for financial reporting.

G

Global Settings: Organization-level operational configuration that serves as the default template for all associations. Also called Organization Settings.

Go-Live: The date when the new system becomes operational for end users.

H

HOA: Homeowners Association, organization that manages residential communities.

Homeowner: Property owner within an association, responsible for assessments and compliance. In the system, homeowners are represented as Members with the OWNER role.

I

Implementation Wave: A named group of associations organized for phased rollout during migration. Includes name, description, go-live date, and status.

ISO 8601: International standard for date formatting (YYYY-MM-DD).

L

Lease: Legal agreement between property owner and tenant for rental occupancy.

Lien: Legal claim against property for unpaid assessments or fees.

M

Member: Person associated with an account in the system. Members can have one or more roles: OWNER (property owner), TENANT (renter), or OCCUPANT (resident). This consolidated entity replaces the separate Owner and Tenant entities.

Migration: Process of moving data from source systems to TownSq platform.

Milestone: Key deliverable or checkpoint in the onboarding process.

O

Operational Setup: JSON configuration stored in the wave_associations table containing delinquency config, billing config, fiscal settings, and custom charts of accounts.

Operations User: Person responsible for coordinating and managing onboarding workflows.

Ownership Percentage: Portion of property owned by each individual (must total 100% per property).

P

Primary Contact: Main person for communication regarding a property or account.

Property Address: Physical street address of the residential unit or property.

R

Referential Integrity: Ensures that relationships between data records are valid and consistent.

Routing Number: Nine-digit code identifying the financial institution for bank transactions.

S

Signatory: Person authorized to sign checks or conduct banking transactions for the association.

Stakeholder: Person with interest in or responsibility for the onboarding project success.

Standard GL Account: Associa's reference chart of accounts used for consistent reporting across all associations. Corporate GL Accounts map to Standard GL Accounts.

Standard Vendor Type: Associa's reference vendor classifications used for consistent vendor categorization and 1099 reporting. Organization vendor types map to Standard Vendor Types.

Standardization: Process of mapping organization-specific data (GL accounts, vendor types) to Associa's standard reference data for consistent portfolio-wide reporting.

T

Technical User: Person responsible for data extraction, transformation, and technical validation.

Tenant: Person renting a property from the owner. In the system, tenants are represented as Members with the TENANT role.

TownSq: The target platform for HOA management and community services.

U

UAT: User Acceptance Testing, final validation by business users before go-live.

UTF-8: Character encoding standard that supports international characters.

V

Validation Rules: Automated checks that ensure data meets format and business requirements.

Validation Error: Issue identified during automated data checking that must be resolved.

Vendor: Service provider or contractor who works with the organization or associations. Examples include landscapers, plumbers, attorneys, and maintenance companies.

Vendor Type: Organization-specific vendor classification that maps to Standard Vendor Types. Used for categorizing vendors and determining 1099 requirements.

Vendor Type Mapping: The relationship between an organization's vendor type and Associa's Standard Vendor Type, enabling consistent vendor classification across the portfolio.

W

Wave Association: Record linking an association to an implementation wave and storing its operational setup. Stored in the wave_associations table in the onboarding schema.

Data Types

String: Text data type with specified maximum length.

Date: Date value in YYYY-MM-DD format.

DateTime: Date and time value in YYYY-MM-DD HH:MM:SS format.

Boolean: True/false value (lowercase).

Decimal: Numeric value with decimal places (e.g., currency amounts).

Integer: Whole number without decimal places.

Glossary | TownSq Data Onboarding