Versions Compared

Version Old Version 9 New Version Current
Changes made by

Michael Abramczyk

Will Rensmith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Find the desired Alternative Name Type Row in table REF_SITE_ALT_NAME_TYPE, and set IS_NFORM_LOOKUP = 1.
  2. Updating this row will create a new entry in nForm.LOOKUP, where the LOOKUP.NAME = REF_SITE_ALT_NAME_TYPE.CODE.
  3. At the same time, nForm.LOOKUP_VALUE will be populated with entries for each SITE_ALT_NAME record for the given type.
    1. LOOKUP_VALUE.NAME  NAME is set to the Site Alternative Name (SITE_ALT_NAME.SITE_NAME).
    2. LOOKUP_VALUE.DESCRIPTION is set to "Site Alternative Name - Site Name" (SITE_ALT_NAME.SITE_NAME + ' - ' + SITE.SITE_NAME).
  4. When new Site Alternative Names are added in nCORE, corresponding nFORM lookup values are added in real-time.
  5. Nightly, when the end date for a given Site Alternative Name passes, the corresponding nFORM lookup value is set to Inactive.
  6. Nightly, when the start date for a given Site Alternative Name passes, the corresponding nFORM lookup value is set to Active.

See the following page for information on creating submission contacts from referenced nFORM Alternative Name lookups: nCORE - nFORM Data Integration Tags