re:Members (formerly Impexium) Custom Data Tables
Custom Data Tables are stored directly live on the Report Server, but are connected to the Portal UI. The full list is found under "Custom Data" in the Portal, but under the Individual or Organization record in the Custom tab at the top is the data linked to that customer.
While editing capability are allowed in re:Members (formerly Impexium), nearly all data is managed via web site or Intranet tools.
Table Types
There are five different sets of these tables:
- Active Data - These extend re:Members (formerly Impexium) baseline capabilities, linking usually INDs or ORGs to "rows" of data (versus just a single value in a Custom Field.)
- Nightly Tables - These are recreated but SPROCS in the Nightly scripts to flatten data, then move to our DB for faster web access. The SPROC name is the same as the table with the prefix "sp_".
- Static Data - A few manually created tables for some global data and settings.
- API Workarounds - Some tables are used by custom scripts for when the API can't do something, so it's written to a table, then processed by a script regularly.
- History Tables - These contain older information from GoMembers. This was much more actively used in the past, but after spending a few years fully in re:Members (formerly Impexium), the only time we need to dip into these is for looking at stats and data for more than a few years.
