Versions Compared
Version | Old Version 11 | New Version 12 |
---|---|---|
Changes made by | ||
Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
This page lists the available data integration tags that can be used when configuring nSPECT form controls for both inbound and outbound data transfer between nCORE and nSPECT.
Configuring and using nSPECT Integration tags is discussed on the nCORE / nSPECT Data Integration page.
Table of Contents |
---|
Prepopulating nSPECT Inspections with data from nCORE
Different data integration tags must be used for repeating and non-repeating sections in an nSPECT Inspection form depending.
Non-repeating data includes information about the site, inspection, related permit, inspection contact, or permit permittee contact.
Repeating data includes information about all other contacts associated with the inspection, features, and permits.
Prepopulating Non-Repeating Data (Site, Evaluation, Permit, Inspection Contact, Permittee Contact)
Technical Note: the following data is provided by the nSpectImport.CME_INSPECTION_MASTER database view.
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_OWNER_TYPE | REF_OWNRSH_TYPE.DESCR | |
SITE_LAT | SITE_LATITUDE | |
SITE_LONG | SITE_LONGITUDE | |
PARCEL_NUM | SITE.TAX_PARCEL_NUM | |
EVAL_NUM | EVAL.EVAL_NUM | |
INSPECTION_TYPE_NAME | REF_EVAL_TYPE.DESC | The type of inspection |
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_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. 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 | |
LAST_INSP_DATE | EVAL.START_DATE | Is the last date the site was inspected with the same inspection type. |
Prepopulating Repeating Data - Inspection Contacts
Technical note: the following data is provided by the nSpectImport.CME_INSPECTION_EVAL_CONTCT database view
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.
Technical note: the following data is provided by nSpectImport.CME_INSPECTION_PRMT_CONTCT database view.
nSPECT Data Integration Tag | nCORE Database Field Name | Comments |
---|---|---|
PRMT_CONTCT_NAME | CONTCT.CONTCT_NAME | |
PRMT_CONTCT_FIRST_NAME | CONTCT.FIRST_NAME | |
PRMT_CONTCT_LAST_NAME | CONTCT.LAST_NAME | |
PRMT_CONTCT_TITLE | CONTCT.TITLE | |
PRMT_CONTCT_ORG_NAME | CONTCT.ORG_NAME | |
PRMT_CONTCT_ADDR | CONTCT.ADDR_1, CONTCT.ADDR_2, CONTCT.CITY, CONTCT.REF_STATE_CODE, CONTCT.ZIP_CODE | Concatenated Contact Address fields |
PRMT_CONTCT_ADDR_1 | CONTCT.ADDR_1 | |
PRMT_CONTCT_ADDR_2 | CONTCT.ADDR_2 | |
PRMT_CONTCT_CITY | CONTCT.CITY | |
PRMT_CONTCT_STATE | CONTCT.REF_STATE_CODE | |
PRMT_CONTCT_ZIP_CODE | CONTCT.ZIP_CODE | |
PRMT_CONTCT_PHONE | PHONE.PHONE | |
PRMT_CONTCT_PHONE_EXT | PHONE.PHONE_EXT | |
PRMT_CONTCT_EMAIL | CONTCT.EMAIL | |
PRMT_CONTCT_CMNTS | CONTCT.ADDR_CMNTS | |
PRMT_CONTCT_AFFIL_CONCAT | REF_AFFIL_TYPE.DESCR | Concatenated Contact Permit Affiliation (Role) Types separated by commas |
Prepopulating Repeating Data - Features
These tags populate features for the permit specified in the evaluation record.
Technical Note: the following data is provided by the nSpectImport.CME_INSPECTION_PRMT_FEATR database view.
nSPECT Data Integration Tag | nCORE Database Field Name | Comments |
---|---|---|
FEATR_LOC | FEATR_LOC_GEOG.LAT, FEATR_LOC_GEOG.LONG | Concatenated feature latitude, longitude separated by a comma |
PRMT_FEATR_DESCR | FEATR.DESCR | |
PRMT_FEATR_ID_TXT | FEATR.FEATR_ID_TXT | |
PRMT_FEATR_TYPE | REF_FEATR_TYPE.DESCR |
Outbound: nSPECT Inspections to nCORE Evaluations
...
Data integration tags can also be used to populate data back into the nCORE evaluation.
See below for configured tags and integration descriptions:
nSPECT Data Integration Tag | nCORE Field Tag | Description |
---|---|---|
START_DATE | EVAL.START_DATE | In conjunction with START_TIME, Will fill in nCORE Evaluation Field "Start Date" when inspection is completed in nSPECT. APP_DEPLOY_SETTING for code NSPECT_OVRRD_START_DATE must be set to "1". |
START_TIME | EVAL.START_TIME | In conjunction with START_DATE, Will fill in nCORE Evaluation Field "Start Date" when inspection is completed in nSPECT. APP_DEPLOY_SETTING for code NSPECT_OVRRD_START_DATE must be set to "1". |
END_DATE | EVAL.END_DATE | In conjunction with END_TIME, Will fill in nCORE Evaluation Field "End Date" when inspection is completed in nSPECT. APP_DEPLOY_SETTING for code NSPECT_OVRRD_START_DATE must be set to "1". |
END_TIME | EVAL.END_TIME | In conjunction with END_DATE, Will fill in nCORE Evaluation Field "End Date" when inspection is completed in nSPECT. APP_DEPLOY_SETTING for code NSPECT_OVRRD_START_DATE must be set to "1". |
FOLLOWUP_DATE | See Description | Creates a new Evaluation (EVAL) record in nCORE using the date specified in the control and the Evaluation Type (REF_EVAL_TYPE_CODE) specified as the followup inspection type. |
EVAL_DCSN | EVAL.REF_DCSN_CODE | Matches values from nSPECT control to REF_DCSN.DESCR, and populates Evaluation Decision (EVAL.REF_DCSN_CODE) with the matching value. |
n/a | EVAL.RPT_TRANSMT_DATE | If Application Deployment Setting flag NSPECT.SET_RPT_TRANMIT_DATE is set to true (1), the Report Transmittal Date will be set to the date the inspection was marked complete in nSPECT. This flag affects all inspections performed in nSPECT, regardless of type or program area. |
Table of Contents |
---|