...
nSPECT Data Integration Tag | nCORE Database Field Name | Comments |
|---|---|---|
SITE_NUM | SITE.SITE_NUM | Site Number |
SITE_SITE_NAME | SITE.SITE_NAME | Site Name, non-standard tag as SITE_NAME is reserved by nSpect |
SITE_ADDR | SITE.ADDR_1, SITE.ADDR_2, SITE.CITY, SITE.REF_STATE_CODE, SITE.ZIP_CODE | Concatenated Site Address fields |
SITE_ADDR_1 | SITE.ADDR_1 | |
SITE_ADDR_2 | S.ADDR_2 | |
SITE_CITY | SITE.CITY | |
SITE_STATE | SITE.REF_STATE_CODE | |
SITE_ZIP_CODE | SITE.ZIP_CODE | |
SITE_ADDR_CMNTS | SITE.ADDR_CMNTS | |
SITE_CNTY | REF_CNTY.DESCR | |
PARCEL_NUM | SITE.TAX_PARCEL_NUM | |
EVAL_NUM | EVAL.EVAL_NUM | |
PRMT_NUM | PRMT.PRMT_NUM | Permit information is pulled from corresponding EVAL.PRMT_ID record |
PRMT_VERSN | PRMT.PRMT_VERSN | |
REF_PRMT_CATG_DESCR | REF_PRMT_CATG.DESCR | |
REF_PRMT_STAT_DESCR | REF_PRMT_STAT.DESCR | |
REF_PRMT_TYPE_DESCR | REF_PRMT_TYPE.DESCR | |
PRMT_ISSUE_DATE | PRMT.ISSUE_DATE | |
PRMT_EFCTV_DATE | PRMT.EFCTV_DATE | |
PRMT_EXPR_DATE | PRMT.EXPR_DATE | |
PROJ_NAME | SUBM.RESRC_PROJ_NAME | |
ICONT_CONTCT_NAME | CONTCT.CONTCT_NAME | Pulled from EVAL.ICONT_CONTCT_ID |
ICONT_CONTCT_FIRST_NAME | CONTCT.FIRST_NAME | |
ICONT_CONTCT_LAST_NAME | CONTCT.LAST_NAME | |
ICONT_CONTCT_ORG_NAME | CONTCT.ORG_NAME | |
ICONT_CONTCT_ADDR | CONTCT.ADDR_1, CONTCT.ADDR_2, CONTCT.CITY, CONTCT.REF_STATE_CODE, CONTCT.ZIP_CODE | Concatenated Contact Address fields |
ICONT_CONTCT_ADDR_1 | CONTCT.ADDR_1 | |
ICONT_CONTCT_ADDR_2 | CONTCT.ADDR_2 | |
ICONT_CONTCT_CITY | CONTCT.CITY | |
ICONT_CONTCT_STATE | CONTCT.REF_STATE_Code | |
ICONT_CONTCT_PHONE | PHONE.PHONE | |
PERMT_CONTCT_NAME | CONTCT.CONTCT_NAME | Pulled from PRMT.PERMT_CONTCT_ID |
PERMT_CONTCT_FIRST_NAME | CONTCT.FIRST_NAME | |
PERMT_CONTCT_LAST_NAME | CONTCT.LAST_NAME | |
PERMT_CONTCT_ORG_NAME | CONTCT.ORG_NAME | |
PERMT_CONTCT_ADDR | CONTCT.ADDR_1, CONTCT.ADDR_2, CONTCT.CITY, CONTCT.REF_STATE_CODE, CONTCT.ZIP_CODE | Concatenated Contact Address fields |
PERMT_CONTCT_ADDR_1 | CONTCT.ADDR_1 | |
PERMT_CONTCT_ADDR_2 | CONTCT.ADDR_2 | |
PERMT_CONTCT_CITY | CONTCT.CITY | |
PERMT_CONTCT_STATE | CONTCT.REF_STATE_CODE | |
PERMT_CONTCT_PHONE | PHONE.PHONE | |
INSPECTOR_NAME | USER.DISP_NAME |
Prepopulating Repeating Data - Inspection Contacts
...
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 | INSPECTOR_NAME | USER.DISP_NAME |
Prepopulating Repeating Data - Permit Contacts
...