Active Data

These tables are connected to the REM Portal UI live from the Remote Azure Report Server database "ReportALTA". Updates to them must be made directly here.

These are also all copied nightly to the "db1" Local Report Server database "ReportALTALocal".

REM must create these for us and hook them up, then they are accessible in the UI and also directly live in the RS both as a whole, and in each ind/org record. https://portal.alta.org/administration/custom/data

• Address DPV (ALTA_AddressDPV)

  • Contains DP and DPC along with a "fake" GM Address ID so these fields can be used in the RMS/Registry.
  • If re:Members (formerly Impexium) ever includes DPVs in their AVS, code could be redone and this removed.
  • If not necessary in Registry 2.0, could be removed from UI and archived.

• AGDF Donations (ALTA_AGDFDonations)

  • Import location for donations coming from the WordPress site via Stripe, or manually entered
  • Imported via the Intranet

• AGDF Grants (ALTA_AGDFGrants)

  • Import location for grant information.

• County FIPs (ALTA_CountyFIPs)

  • FIP codes for counties, with state and ZIP included.

• Custom Data Categories (ALTA_CustDataCategories)

  • Hierarchical category system for Marketplace and RON
  • Not using baseline re:Members (formerly Impexium) for the same due to API limitations.

• Custom Data Org Categories (ALTA_CustDataOrgCategories)

  • Where categories are linked to organizations

• Custom Information (ALTA_CustomInfo)

  • A way to do something similar to baseline "Custom Fields" when more complex data is necessary, but when we don't want to have re:Members (formerly Impexium) make a whole new table.
  • Used for things like Member Kit dates.

• Education Credits (ALTA_EducationCredits)

  • Used for storing individual/state/type credits.
  • Started late 2024, not in full use as of 2/18/2025.

• Individual Licenses (ALTA_IndividualLicenses)

  • For tracking individuals' state by state license information (Attorney and Title Producer/Agent) CE & REA

• Organization FIPs (ALTA_OrgFIPs)

  • Where FIPs are linked to organizations

• State FIPs (ALTA_StateFIPs)

  • FIP codes for states

• TAN Subscriptions (ALTA_TANSubscriptions)

  • Storage similar to baseline, necessary since API cannot write baseline Subscriptions.

• Temporary Addresses (ALTA_TempAddresses)

  • Creates fake "GoMembers Address ID" for Registry so that RMS code could be kept the same.
  • Could be unnecessary for Registry 2.0, TBD.

• TILN Access (ALTA_TILNAccess)

  • Used for storing the connection between individuals and subscriptions/purchases for Multiuser products (TILN, CG, etc.)
  • Set in Intranet tools

• TIPAC Pledges (ALTA_TIPACPledges)

  • Storage for single total Pledge per year per individual.