Versions Compared

Key

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

...

nSPECT Data Integration Tag

nCORE Database Field Name

Comments

EVAL_CONTCT_NAME

CONTCT.CONTCT_NAME

EVAL_CONTCT_FIRST_NAME

CONTCT.FIRST_NAME

EVAL_CONTCT_LAST_NAME

CONTCT.LAST_NAME

EVAL_CONTCT_TITLE

CONTCT.TITLE

EVAL_CONTCT_ORG_NAME

CONTCT.ORG_NAME

EVAL_CONTCT_ADDR

CONTCT.ADDR_1, CONTCT.ADDR_2, CONTCT.CITY, CONTCT.REF_STATE_CODE, CONTCT.ZIP_CODE

Concatenated Contact Address fields

EVAL_CONTCT_ADDR_1

CONTCT.ADDR_1

EVAL_CONTCT_ADDR_2

CONTCT.ADDR_2

EVAL_CONTCT_CITY

CONTCT.CITY

EVAL_CONTCT_STATE

CONTCT.REF_STATE_CODE

EVAL_CONTCT_ZIP_CODE

CONTCT.ZIP_CODE

EVAL_CONTCT_PHONE

PHONE.PHONE

EVAL_CONTCT_PHONE_EXT

PHONE.PHONE_EXT

EVAL_CONTCT_EMAIL

CONTCT.EMAIL

EVAL_CONTCT_AFFIL_CONCAT

REF_AFFIL_TYPE.DESCR

Concatenated Contact Evaluation Affiliation (Role) Types separated by commas

Prepopulating Repeating Data -

...

Permit Contacts

The following integration tags pulls any contacts related to inspection’s related permit and populates data into a repeating nSPECT section.

...