...
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 | |
SITE_LAT | SITE_LATITUDE | |
SITE_LONG | SITE_LONGITUDE | |
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_CodeCODE | |
ICONT_CONTCT_ZIP_CODE | CONTCT.ZIP_CODE | |
ICONT_CONTCT_COUNTRY | CONTCT.DESCR | |
ICONT_CONTCT_PHONE | PHONE.PHONE | WHERE IS_PRIMARY = 1 |
ICONT_CONTCT_PHONE_EXT | PHONE.PHONE_EXT | |
ICONT_CONTCT_PHONE_TYPE_CODE | PHONE.REF_PHONE_TYPE_CODE | Primary phone type type . E.g. mobile, office, etc. |
ICONT_CONTCT_EMAIL | CONTCT.EMAIL | |
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_ZIP_CODE | CONTCT.ZIP_CODE | |
PERMT_CONTCT_COUNTRY | CONTCT.DESCR | |
PERMT_CONTCT_PHONE | PHONE.PHONE | WHERE IS_PRIMARY = 1 |
PERMIT_CONTCT_PHONE_EXT | PHONE.PHONE_EXT | |
PERMIT_CONTCT_PHONE_TYPE | PHONE.REF_PHONE_TYPE_CODE | Primary phone type. E.g. mobile, office, etc. |
INSPECTOR_NAME | USER.DISP_NAME |
...