It appears you are using an out of date browser. This site is best used with the following browsers:
Microsoft Edge
|
Google Chrome
|
Firefox
Inspections Home
Dashboard
Mecklenburg County Public Health
249 Billingsley Road Charlotte, NC 28211 |
Visit Official Website
|
Mecklenburg County Public Health
| SIP Site
SIP Site
Please fill out the form below and click "Submit" at the bottom of the screen.
Confirm You're a Real Person
Submit
Thank you for submitting this information. We will follow-up on this as soon as possible.
Oops! Something went wrong while submitting the form.
{"allowAdd":"YES","allowTimeActivity":"","singular":"SIP Site","src":"Sip_Site","doRequireParent":"","pkey":"sip_siteID","defaultParentFormID":"E258F9BD-4073-4E7E-BB65-7CBFA4DFD1CD","addToPrintableName":"","pullParentPanelData":"","allowClone":"NO","allowCopy":"","icon":"map-location1.png","schedulerEvents":"","plural":"SIP Site","dsn":"local","updateAssignmentsOnChange":"","doAutoSave":"YES","isDashboard":"","allowAssignment":"","allowSaveAndAdd":"","showHistory":"YES","myhdLogic":{"questionnaireSettings":{"emailSubject":"You have a new {questionnaire.singular}","parentSrc":"","frequency":"1","parentPkey":"","timeRange":{"start":"7:00 AM","end":"7:00 PM"},"triggerFields":[],"emailContent":"Hi {userRecord.firstName}, a new {questionnaire.singular} is ready for you to submit. {url}","textContent":"Hi {userRecord.firstName}, a new {questionnaire.singular} is ready for you to submit. {url}","parentFormID":"","frequencyUnit":"daily"},"singular":"SIP Site","instructions":"Please fill out the form below and click \"Submit\" at the bottom of the screen.","emailNotificationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com","textNoficationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com","notificationConditions":[],"title":"SIP Site","settings":{"contactList":[{"userID":"3D2CDCFB-EA8E-445E-8C3D-2DE9C90189ED","method":"Email","type":"user"},{"userID":"C940F4E2-6FC0-436A-A482-40BC710CF4F7","method":"Email","type":"user"}],"allowFileUploads":"YES","includeFields":["sipMyHDApplicationAddress","sipSiteName","sipThisinvestigationisbeingconductedaspartofaregulatoryrequirement","sipProvidethenameoftheregulatingagency","sipSiteProvidetheregulatoryIDnumberoftheincident","sipIfthissiteisregulatedbytheNCDENRUSTSectionisthissiteconsideringHighRisk","sipExemptSite","sipNotes","sipSiteBillingContact"],"expose":"YES","flags":[],"additionalFees":[],"type":"Public","fieldSettings":{},"requireMinimumFileUploads":"0"},"submittedMessage":"Thank you for submitting this information. We will follow-up on this as soon as possible.","subForms":[{"singular":"Contact","instructions":"","isChild":"false","title":"Contact Manager","settings":{"includeFields":["sipMyHDApplicationAddress","sipSiteName","sipThisinvestigationisbeingconductedaspartofaregulatoryrequirement","sipProvidethenameoftheregulatingagency","sipSiteProvidetheregulatoryIDnumberoftheincident","sipIfthissiteisregulatedbytheNCDENRUSTSectionisthissiteconsideringHighRisk","sipExemptSite","sipNotes","sipSiteBillingContact","organization","firstName","lastName","Title","cmPrimaryPhone","CMFaxNumber","CellPhone","cmPrimaryPhone909","CMPrimaryEmail","CMSecondaryEmail","addressID"],"conditions":[],"flags":[],"fieldSettings":{}},"formID":"9F78A09D-25F9-4C7F-A092-1AF3C19C24CB","isLookup":"true","plural":"Contacts","fields":[{"properties":{"label":"Organization/Company","id":"organization","maxlength":500},"type":"text","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"First Name","id":"firstName","maxlength":500},"type":"text","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Last Name","id":"lastName","maxlength":500},"type":"text","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Status","id":"status","maxlength":500},"required":true,"options":[{"text":"Select a Status","value":""},{"text":"Active","value":"Active"},{"text":"Inactive","value":"Inactive"}],"type":"select","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Home/Work Phone","id":"cmPrimaryPhone909","maxlength":500},"type":"phone","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Cell Phone","id":"CellPhone","maxlength":500},"type":"phone","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Fax Number","id":"CMFaxNumber","maxlength":500},"type":"phone","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Primary Email","id":"CMPrimaryEmail","maxlength":500},"type":"text","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Address","id":"addressID","formID":"66D1B03E-AF72-4D51-8AA1-512B61923722"},"type":"formSearch","dbType":"UNIQUEIDENTIFIER","dbNullable":true},{"properties":{"id":"appContactAddress","label":"Contact Address"},"type":"textarea","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":"MAX","dbNullable":true}],"formConfig":{"allowAdd":"YES","allowTimeActivity":"","singular":"Contact","src":"Contacts","doRequireParent":"","pkey":"contactsID","defaultParentFormID":"","pullParentPanelData":"","addToPrintableName":"","allowClone":"","allowCopy":"","icon":"user81.png","schedulerEvents":"","plural":"Contacts","dsn":"local","updateAssignmentsOnChange":"","doAutoSave":"YES","isDashboard":"","allowAssignment":"NO","allowSaveAndAdd":"","validation":{"entries":[{"action":"warn","label":"Duplicate Check","formula":{"value":[{"value":[{"value":"firstName","type":"field"},{"value":"AND","type":"operator"},{"value":"lastName","type":"field"},{"value":"AND","type":"operator"},{"value":"addressID","type":"field"}],"type":"logic"},{"value":"OR","type":"operator"},{"value":[{"value":"organization","type":"field"},{"value":"AND","type":"operator"},{"value":"addressID","type":"field"}],"type":"logic"}],"type":"logic"},"type":"duplicateCheck"}]},"showHistory":"YES","doShowHistoryViews":"","allowDelete":"","majorLabelDescription":"","allowAttach":"YES","doChangeLog":"YES","version":"","exportConfig":{"lkp":[{"alias":"Address_Manager","from":"addressID","to":"Contacts","type":"left","key":"Address","on":"addressID"}],"columns":[{"src":"Contacts","format":"","label":"Organization","hideFromOutput":false,"mask":"","out":"{organization}"},{"src":"Contacts","format":"","label":"Name","hideFromOutput":false,"mask":"","out":"{firstName} {lastName}"},{"src":"Contacts","format":"","label":"Status","hideFromOutput":false,"mask":"","out":"{status}"},{"src":"Address","format":"","label":"Address","hideFromOutput":false,"mask":"","out":"{addressLine1} {addressLine2} {city} {state} {zip}"},{"primaryCol":false,"src":"Contacts","format":"","label":"Contact Type","isLocation":"undefined","majorLabel":"undefined","hideFromOutput":true,"mask":"","out":"{contactType}"},{"primaryCol":"undefined","src":"Contacts","format":"","schedulerDesc":"undefined","label":"Certification Number","isLocation":"undefined","schedulerName":"undefined","majorLabel":"undefined","hideFromOutput":false,"filterable":"undefined","mask":"","out":"{certNumber}"},{"src":"Contacts","format":"","alias":"This_Form","schedulerDesc":"undefined","isLocation":"undefined","schedulerName":true,"majorLabel":"undefined","filterable":"undefined","mask":"","out":"{certificationType}","primaryCol":"undefined","label":"Certification Type","hideFromOutput":false},{"src":"Contacts","format":"","alias":"This_Form","label":"Body Artist Type","mask":"","out":"{typeArtist}","hideFromOutput":false,"filterable":true}]},"title":"Contact Manager","allowExport":"YES","allowEdit":"","formID":"9F78A09D-25F9-4C7F-A092-1AF3C19C24CB","listPageConfig":{"lkp":[{"alias":"Address_Manager","from":"addressID","to":"Contacts","type":"left","key":"Address","on":"addressID"}],"columns":[{"src":"Contacts","format":"","label":"Organization/Company","hideFromOutput":"NO","mask":"","out":"{organization}","alias":"This_Form"},{"src":"Contacts","format":"","label":"Name","hideFromOutput":"NO","mask":"","out":"{firstName} {lastName}"},{"src":"Contacts","format":"","label":"Status","hideFromOutput":"NO","mask":"","out":"{status}"},{"src":"Address","format":"","label":"Address","hideFromOutput":"NO","mask":"","out":"{addressLine1} {addressLine2} {city} {state} {zip}"},{"src":"Contacts","format":"phone","alias":"This_Form","label":"Home/Work #","mask":"","out":"{cmPrimaryPhone909}","hideFromOutput":"NO"},{"src":"Contacts","format":"phone","alias":"This_Form","label":"Cell #","mask":"","out":"{CellPhone}","hideFromOutput":"NO"},{"src":"Contacts","format":"phone","alias":"This_Form","label":"Fax #","mask":"","out":"{CMFaxNumber}","hideFromOutput":"NO"},{"mask":"","out":"{CMPrimaryEmail}","alias":"This_Form","src":"Contacts","format":"","label":"Email","hideFromOutput":"NO"}],"listInfoBox":{"infoBoxType":"","infoBox":"alert","infoText":""}},"dataEntryConfig":{"panels":[{"form":"Financial_Account","layout":{"columns":[{"src":"Financial_Account","format":"money","label":"Balance","hideFromOutput":false,"mask":"","out":"{balance}"}]},"isChild":true},{"form":"Land_Use_Application","layout":{"columns":[{"src":"Land_Use_Application","format":"date","sortBy":"","label":"Application Date","outOverride":"","hideFromOutput":false,"mask":"","out":"{gwsApplicationEntryDate}"},{"src":"Land_Use_Application","format":"","sortBy":"","label":"Permit/Application ID","outOverride":"","hideFromOutput":false,"mask":"","out":"{applicationID}"},{"src":"Land_Use_Application","format":"","sortBy":"","label":"GWS Program","outOverride":"","hideFromOutput":false,"mask":"","out":"{gwsProgram}"}]},"isLookupReverse":true,"isLookup":true},{"form":"Sip_Site","layout":{"columns":[{"src":"Sip_Site","format":"","sortBy":"","label":"Site Name ","outOverride":"","hideFromOutput":false,"mask":"","out":"{sipSiteName}"},{"src":"Sip_Site","format":"","sortBy":"","label":"Site Customer Number ","outOverride":"","hideFromOutput":false,"mask":"","out":"{sipSiteCustomerNumber}"}]},"isLookupReverse":true,"isLookup":true}],"form":[{"properties":{"label":"Organization/Company","id":"organization","maxlength":500},"type":"text","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"First Name","id":"firstName","maxlength":500},"type":"text","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Last Name","id":"lastName","maxlength":500},"type":"text","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Status","id":"status","maxlength":500},"required":true,"options":[{"text":"Select a Status","value":""},{"text":"Active","value":"Active"},{"text":"Inactive","value":"Inactive"}],"type":"select","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Home/Work Phone","id":"cmPrimaryPhone909","maxlength":500},"type":"phone","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Cell Phone","id":"CellPhone","maxlength":500},"type":"phone","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Fax Number","id":"CMFaxNumber","maxlength":500},"type":"phone","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Primary Email","id":"CMPrimaryEmail","maxlength":500},"type":"text","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Address","id":"addressID","formID":"66D1B03E-AF72-4D51-8AA1-512B61923722"},"type":"formSearch","dbType":"UNIQUEIDENTIFIER","dbNullable":true},{"properties":{"id":"appContactAddress","label":"Contact Address"},"type":"textarea","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":"MAX","dbNullable":true}]}}}],"plural":"SIP Site","path":"sip-site"},"doShowHistoryViews":"","allowDelete":"","majorLabelDescription":"SIP Site","allowAttach":"YES","doChangeLog":"YES","version":"","title":"SIP Site","allowExport":"","allowEdit":"","formID":"74B5A4A7-7575-4B91-B316-F5FACA6A743E","listPageConfig":{"lkp":[{"filter":"{sipContactType} LIKE '%Well Owner%'","alias":"wellOwner","from":"contactsID","multiFrom":false,"multiTo":false,"to":"This_Form","row":0,"type":"left","key":"Contacts","lkpto":"sip_siteID","dsn":"","on":"rdplookupID"},{"filter":"","alias":"wellOwner_Addr","from":"addressID","multiFrom":false,"multiTo":false,"to":"wellOwner","row":0,"type":"left","key":"Address","lkpto":"","dsn":"","on":"addressID"},{"filter":"{sipContactType} LIKE '%Property Owner%'","alias":"propertyOwner","from":"contactsID","multiFrom":false,"multiTo":false,"to":"This_Form","row":0,"type":"left","key":"Contacts","lkpto":"sip_siteID","dsn":"","on":"rdplookupID"},{"filter":"","alias":"propertyOwner_Addr","from":"addressID","multiFrom":false,"multiTo":false,"to":"propertyOwner","row":0,"type":"left","key":"Address","lkpto":"","dsn":"","on":"addressID"},{"updn":"","lookupType":"","filter":"{sipContactType} LIKE '%Agent%'","alias":"agent","from":"contactsID","multiFrom":false,"includeDeleted":false,"queryType":"default","multiTo":false,"sort":"","row":"","to":"This_Form","type":"left","dsn":"","key":"Contacts","lkpto":"sip_siteID","on":"rdplookupID"},{"filter":"","alias":"agent_Addr","from":"addressID","multiFrom":false,"multiTo":false,"to":"agent","row":0,"type":"left","key":"Address","lkpto":"","dsn":"","on":"addressID"},{"filter":"","alias":"GIS_Address_Manager","from":"gis_address_managerID","multiFrom":false,"multiTo":false,"to":"This_Form","row":0,"type":"left","key":"Gis_Address_Manager","lkpto":"","dsn":"","on":"parentFormID"}],"listInfoBox":{"infoBoxType":"","infoText":"","infoBox":"alert"},"columns":[{"src":"Sip_Site","format":"","alias":"This_Form","label":"Customer Number","mask":"","out":"{sipSiteCustomerNumber}","hideFromOutput":"NO"},{"src":"Sip_Site","format":"","alias":"This_Form","label":"Site Name","mask":"","out":"{sipSiteName}","hideFromOutput":"NO","filterable":true},{"src":"Gis_Address_Manager","format":"","alias":"GIS_Address_Manager","label":"Address","mask":"","out":"{SiteAddress}","hideFromOutput":"NO","filterable":true},{"src":"Gis_Address_Manager","format":"","alias":"GIS_Address_Manager","label":"Site Parcel","mask":"","out":"{SiteParcel}","hideFromOutput":"NO"},{"src":"Gis_Address_Manager","format":"","alias":"GIS_Address_Manager","label":"Well Parcel","mask":"","out":"{WellParcel}","hideFromOutput":"NO"},{"src":"Sip_Site","format":"","alias":"This_Form","label":"NCDEQ High Risk? ","mask":"","out":"{sipIfthissiteisregulatedbytheNCDENRUSTSectionisthissiteconsideringHighRisk}","hideFromOutput":"NO"},{"src":"Sip_Site","format":"","alias":"This_Form","label":"Exempt Y/N","mask":"","out":"{sipExemptSite}","hideFromOutput":"NO"},{"src":"Contacts","format":"","alias":"wellOwner","label":"Well Owner","mask":"","out":"{firstName} {lastName} {organization}","hideFromOutput":"NO"},{"src":"Address","format":"","alias":"wellOwner_Addr","label":"Well Owner Address","mask":"","out":"{addressLine1} {addressLine2} {city} {state} {zip}","hideFromOutput":"NO"},{"src":"Contacts","format":"phone","alias":"wellOwner","label":"Well Owner Phone","nonsearchable":true,"mask":"","out":"{cmPrimaryPhone}","hideFromOutput":"NO"},{"src":"Contacts","format":"phone","alias":"wellOwner","label":"Well Owner Phone909","nonsearchable":false,"mask":"","out":"{cmPrimaryPhone909}","hideFromOutput":"NO"},{"src":"Contacts","format":"","alias":"wellOwner","label":"Well Owner Email","mask":"","out":"{CMPrimaryEmail}","hideFromOutput":"NO"},{"src":"Contacts","format":"","alias":"propertyOwner","label":"Property Owner","mask":"","out":"{propertyOwnerorganization} {propertyOwnerfirstName} {propertyOwnerlastName}","hideFromOutput":"NO"},{"src":"Address","format":"","alias":"propertyOwner_Addr","label":"Property Owner Address","mask":"","out":"{propertyOwner_AddraddressLine1} {propertyOwner_AddraddressLine2} {propertyOwner_Addrcity} {propertyOwner_Addrstate} {propertyOwner_Addrzip}","hideFromOutput":"NO"},{"src":"Contacts","format":"phone","alias":"propertyOwner","label":"Property Owner Phone","mask":"","out":"{propertyOwnercmPrimaryPhone}","hideFromOutput":"NO"},{"src":"Contacts","format":"phone","alias":"propertyOwner","label":"Property Owner Phone909","mask":"","out":"{propertyOwnercmPrimaryPhone909}","hideFromOutput":"NO"},{"mask":"","out":"{propertyOwner_Addrcity}","alias":"propertyOwner_Addr","src":"Address","format":"","label":"Property Owner City","hideFromOutput":"NO"},{"mask":"","out":"{propertyOwner_AddraddressLine2}","alias":"propertyOwner_Addr","src":"Address","format":"","label":"Property Owner Address_2","hideFromOutput":"NO"},{"src":"Contacts","format":"","alias":"propertyOwner","label":"Property Owner Email","mask":"","out":"{propertyOwnerCMPrimaryEmail}","hideFromOutput":"NO"},{"src":"Contacts","format":"","alias":"agent","label":"Agent","mask":"","out":"{agentfirstName} {agentlastName} {agentorganization}","hideFromOutput":"NO"},{"src":"Address","format":"","alias":"agent_Addr","label":"Agent Address","mask":"","out":"{agent_AddraddressLine1} {agent_AddraddressLine2} {agent_Addrcity} {agent_Addrstate} {agent_Addrzip}","hideFromOutput":"YES"},{"src":"Contacts","format":"phone","alias":"agent","label":"Agent Phone","mask":"","out":"{agentcmPrimaryPhone}","hideFromOutput":"YES"},{"src":"Contacts","format":"phone","alias":"agent","label":"Agent Phone909","mask":"","out":"{agentcmPrimaryPhone909}","hideFromOutput":"NO"},{"src":"Contacts","format":"","alias":"agent","label":"Agent Email","mask":"","out":"{agentCMPrimaryEmail}","hideFromOutput":"NO"},{"src":"Gis_Address_Manager","format":"","alias":"GIS_Address_Manager","label":"GIS_Address_ID","mask":"","out":"{gis_address_managerID}","hideFromOutput":"YES"},{"mask":"","out":"{propertyOwner_Addrstate}","alias":"propertyOwner_Addr","src":"Address","format":"","label":"Property Owner State","hideFromOutput":"NO","outOverride":""},{"mask":"","out":"{state}","alias":"wellOwner_Addr","src":"Address","format":"","label":"Well Owner State","hideFromOutput":"NO"},{"mask":"","out":"{propertyOwner_Addrstate}","alias":"propertyOwner_Addr","src":"Address","format":"","label":"Property Owner State","hideFromOutput":"NO"},{"mask":"","out":"{firstName}","alias":"wellOwner","src":"Contacts","format":"","label":"Contact Name","hideFromOutput":"NO"}]},"dataEntryConfig":{"panels":[{"form":"Contacts","layout":{"columns":[{"src":"Contacts","format":"","sortBy":"","label":"Organization","outOverride":"","hideFromOutput":"NO","mask":"","out":"{organization}"},{"src":"Contacts","format":"","sortBy":"","label":"Name","outOverride":"","hideFromOutput":"NO","mask":"","out":"{firstName} {lastName}"},{"src":"Contacts","format":"","sortBy":"","label":"Relationship","outOverride":"","hideFromOutput":false,"mask":"","out":"{sipContactType}"},{"src":"Contacts","format":"phone","sortBy":"","label":"Work #","outOverride":"","hideFromOutput":false,"mask":"","out":"{cmPrimaryPhone909}"},{"src":"Contacts","format":"phone","sortBy":"","label":"Cell #","outOverride":"","hideFromOutput":false,"mask":"","out":"{CellPhone}"},{"src":"Contacts","format":"phone","sortBy":"","label":"Fax #","outOverride":"","hideFromOutput":false,"mask":"","out":"{CMFaxNumber}"},{"src":"Contacts","format":"","sortBy":"","label":"Email","outOverride":"","hideFromOutput":"NO","mask":"","out":"{CMPrimaryEmail}"}]},"descriptionFields":[{"properties":{"label":"Contact Type","id":"sipContactType","multiple":"multiple"},"options":[{"text":"Well Owner","value":"Well Owner"},{"text":"Property Owner","value":"Property Owner"},{"text":"Agent","value":"Agent"},{"text":"SIP Contact","value":"SIP Contact"}],"type":"select","subfields":[]}],"isLookup":true},{"form":"Subsurface_Investigation_Permit","layout":{"columns":[{"src":"Subsurface_Investigation_Permit","format":"","sortBy":"","label":"Permit Number","outOverride":"","hideFromOutput":false,"mask":"","out":"{sipPermitNumber}"},{"src":"Subsurface_Investigation_Permit","format":"date","sortBy":"","label":"Issue Date","outOverride":"","hideFromOutput":false,"mask":"","out":"{sipPermitIssuanceDate}"}]},"isChild":true}],"form":[{"properties":{"label":"Site Name","id":"sipSiteName","maxlength":500},"required":true,"type":"text","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"This investigation is being conducted as part of a regulatory requirement","id":"sipThisinvestigationisbeingconductedaspartofaregulatoryrequirement","maxlength":1500},"required":true,"options":[{"text":"YES","value":"YES"},{"text":"NO","value":"NO"}],"type":"select","logic":[],"subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":1500,"dbNullable":true},{"properties":{"label":"Provide the name of the regulating agency","id":"sipProvidethenameoftheregulatingagency","maxlength":500},"type":"text","logic":[{"target":"field","inputType":"input,select","src":"","field":"sipThisinvestigationisbeingconductedaspartofaregulatoryrequirement","calculationType":"","value":"YES","targetValue":"","validationType":"","filterType":"field","valueAction":"indexOf","idOverride":"","rules":[],"type":"show"},{"target":"field","col":"","inputType":"input,select","src":"","field":"sipThisinvestigationisbeingconductedaspartofaregulatoryrequirement","calculationType":"","value":"YES","targetValue":"","validationType":"","filterType":"field","valueAction":"notIndexOf","idOverride":"","rules":[],"type":"hide"}],"subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"If this site is regulated by the NCDENR UST Section, is this site considering High Risk?","id":"sipIfthissiteisregulatedbytheNCDENRUSTSectionisthissiteconsideringHighRisk","maxlength":500},"options":[{"text":"YES","value":"YES"},{"text":"NO","value":"NO"},{"text":"UNKNOWN","value":"UNKNOWN"}],"type":"select","logic":[{"target":"field","inputType":"input,select","src":"","field":"sipThisinvestigationisbeingconductedaspartofaregulatoryrequirement","calculationType":"","value":"YES","targetValue":"","validationType":"","filterType":"field","valueAction":"indexOf","idOverride":"","rules":[],"type":"show"},{"target":"field","col":"","inputType":"input,select","src":"","field":"sipThisinvestigationisbeingconductedaspartofaregulatoryrequirement","calculationType":"","value":"YES","targetValue":"","validationType":"","filterType":"field","valueAction":"notIndexOf","idOverride":"","rules":[],"type":"hide"}],"subfields":[],"default":"NO","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Exempt Site","id":"sipExemptSite","maxlength":500},"options":[{"text":"YES","value":"YES"},{"text":"NO","value":"NO"}],"type":"select","subfields":[],"default":"NO","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"label":"Notes","id":"sipNotes"},"type":"textarea","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":"MAX","dbNullable":true},{"properties":{"label":"Billing Contact","id":"sipSiteBillingContact","maxlength":500},"required":true,"options":[{"text":"Well Owner","value":"Well Owner"},{"text":"Owner Agent","value":"Owner Agent"}],"type":"select","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true}]},"hsScripts":[{"runWhen":"onload","runWhere":"cloudEntry","code":"//Ticket: 1160381195\n//Written By: Donnie Marges\n//Date: May 25, 2021\n\n/*\nThis script shows a warning message when the user tries to\ncreate a new SIP Site for a Parcel that already has one assigned\nto it. Note, I did not add functionality to delete\nexisting SIP Sites assigned to the parcel.\n\nOriginal ticket text is as follows:\n\n\"warning message\" should occur if adding a new SIP Site for a parcel \nthat already has a SIP Site. The new SIP Site could then be deleted \nif not appropriate.\n\nTicket Link: https://hscloudsuite-project-manager.monday.com/boards/783244672/pulses/1160381195\n*/\n\n/*\ndocument.getElementById('saveButton').addEventListener('click', () => {\n ((((igov || {}).ph || {}).control || {}).data) ? \n hs.api.getRecord({\n set: 'tblCHLD_Gis_Address_Manager_Sip_Site',\n c: ['gis_address_managerID'],\n v: [igov.ph.control.data[0].gis_address_managerID]\n }).then((res) => (res.length > 0) ? alert('This parcel already has a SIP Site assigned to it') : '')\n : '';\n});\n*/"}]}