Oregon Health Authority - Oregon Tobacco Retail License (TRL) Program
800 NE Oregon Street, Suite 730, Portland, OR 97232 | Visit Official Website

Complaint Manager

Please complete the following form to report a tobacco retailer violation to the Oregon Health Authority (OHA).

Thank you for your Tobacco Retailer Violation Report

Thank you for reaching out to the Oregon Tobacco Retail License (TRL) Program. This message is to confirm that the Oregon TRL Program has received your tobacco retailer violation report. We will review your tobacco retailer violation report and investigate as appropriate.

If you have any questions about your tobacco retailer violation report, please contact Annie Masuda via email (anne.masuda2@oha.oregon.gov) or phone (503-569-8695).

Oops! Something went wrong while submitting the form.

{"allowAdd":"YES","allowTimeActivity":"NO","singular":"Complaint","src":"Complaints","doRequireParent":"","pkey":"complaintsID","defaultParentFormID":"","addToPrintableName":"","pullParentPanelData":"","allowClone":"","allowCopy":"NO","icon":"chatting7.png","schedulerEvents":"none","plural":"Complaints","dsn":"local","updateAssignmentsOnChange":"","doAutoSave":"YES","isDashboard":"NO","allowAssignment":"NO","allowSaveAndAdd":"","showHistory":"YES","doShowHistoryViews":"","allowDelete":"","majorLabelDescription":"","allowAttach":"YES","doChangeLog":"NO","assignmentLogic":{"logic":[],"notificationType":"none","notificationText":"","notificationMessage":""},"version":"1.0","title":"Complaint Manager","allowExport":"YES","allowEdit":"","validation":{"entries":[]},"configureAssignmentLogic":{"logic":[]},"showConversationPanel":"","disableRecordPreview":"","allowQuickEdit":"","messageLogic":{"settings":{"expose":"NO","allowFileUploads":"NO","type":"Public","includeFields":[],"flags":[]},"singular":"Complaint","plural":"Complaints","title":"Complaint Manager","instructions":"Please fill out the form below and click \"Submit\" at the bottom of the screen.","submittedMessage":"Thank you for submitting this information. We will follow-up on this as soon as possible.","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","messages":[{"contacts":[{"userID":"4C793567-714A-47AB-BEB0-04CC2A7F5ABA","method":"Email","type":"user"},{"userID":"1336EEFF-69B0-46EA-8330-8861AF51A328","method":"Email","type":"user"}],"conditions":[{"field":"Whatjurisdiction","operator":"EQUAL","value":"Klamath","from":"Complaint Manager"}],"parentFormID":"thisForm","emailContent":"Hello, This email is to notify you that the Oregon Tobacco Retail License (TRL) Program recently received a public complaint for a business located in your jurisdiction. As you are enforcing a local TRL program, please click \"here\" below to view the complaint and respond as appropriate.Please let us know if you have any questions.Thank you,Oregon Health Authority Tobacco Retail License ProgramTobacco.Inspections@odhsoha.oregon.gov ","title":"Public complaint for county with TRL","emailSubject":"public complaint for county with TRL"},{"contacts":[{"userID":"CA628F9A-C26D-4833-8966-D19378F55725","method":"Email","type":"user"},{"userID":"4C793567-714A-47AB-BEB0-04CC2A7F5ABA","method":"Email","type":"user"}],"conditions":[{"field":"Whatjurisdiction","operator":"EQUAL","value":"Multnomah","from":"Complaint Manager"}],"parentFormID":"thisForm","emailContent":"Hello, This email is to notify you that the Oregon Tobacco Retail License (TRL) Program recently received a public complaint for a business located in your jurisdiction. As you are enforcing a local TRL program, please click \"here\" below to view the complaint and respond as appropriate.Please let us know if you have any questions.Thank you,Oregon Health Authority Tobacco Retail License Program<a href=\"mailto:tobacco.inspections@dhsoha.state.or.us\" target=\"_blank\">Tobacco.Inspections@odhsoha.oregon.gov</a>","title":"Public complaint for county with TRL","emailSubject":"Public complaint for county with TRL"},{"contacts":[{"userID":"158A5DC8-3725-4DEB-B735-2E9169423908","method":"Email","type":"user"},{"userID":"4C793567-714A-47AB-BEB0-04CC2A7F5ABA","method":"Email","type":"user"}],"conditions":[{"field":"Whatjurisdiction","operator":"EQUAL","value":"Benton","from":"Complaint Manager"}],"parentFormID":"thisForm","title":"Public complaint for county with TRL","emailContent":"Hello, This email is to notify you that the Oregon Tobacco Retail License (TRL) Program recently received a public complaint for a business located in your jurisdiction. As you are enforcing a local TRL program, please click \"here\" below to view the complaint and respond as appropriate.Please let us know if you have any questions.Thank you,Oregon Health Authority Tobacco Retail License Program<a href=\"mailto:tobacco.inspections@dhsoha.state.or.us\" target=\"_blank\">Tobacco.Inspections@odhsoha.oregon.gov</a>","emailSubject":"Public complaint for county with TRL","textContent":""},{"contacts":[{"userID":"743A4045-B2F4-4410-85B4-6AA11A07992E","method":"Email","type":"user"},{"userID":"4C793567-714A-47AB-BEB0-04CC2A7F5ABA","method":"Email","type":"user"}],"conditions":[{"field":"Whatjurisdiction","operator":"EQUAL","value":"Clatsop","from":"Complaint Manager"}],"parentFormID":"thisForm","emailContent":"Hello, This email is to notify you that the Oregon Tobacco Retail License (TRL) Program recently received a public complaint for a business located in your jurisdiction. As you are enforcing a local TRL program, please click \"here\" below to view the complaint and respond as appropriate.Please let us know if you have any questions.Thank you,Oregon Health Authority Tobacco Retail License Program<a href=\"mailto:tobacco.inspections@dhsoha.state.or.us\" target=\"_blank\">Tobacco.Inspections@odhsoha.oregon.gov</a>","title":"Public complaint for county with TRL","emailSubject":"Public complaint for county with TRL"},{"contacts":[{"userID":"4C793567-714A-47AB-BEB0-04CC2A7F5ABA","method":"Email","type":"user"},{"userID":"63471041-BF23-45F8-9490-90575354837B","method":"Email","type":"user"}],"conditions":[{"field":"ReferraltoDOROWOLnolicenseposted","operator":"EQUAL","value":"Yes","from":"Complaint Manager"}],"parentFormID":"thisForm","emailContent":"Hello,This email is to notify you that OHA received a complaint about a business operating without a license or not having their TRL posted. Please click \"here\" below to view the complaint and respond as appropriate.Please let us know if you have any follow-up questions.Thank you,Oregon Health Authority Tobacco Retail License Program<a href=\"mailto:tobacco.inspections@dhsoha.state.or.us\" target=\"_blank\">Tobacco.Inspections@odhsoha.oregon.gov</a>","emailSubject":"Complaint DOR OWOL or no license posted","title":"Complaint DOR OWOL or no license posted"}],"subForms":[]},"myhdLogic":{"settings":{"expose":"YES","allowFileUploads":"NO","requireMinimumFileUploads":"","maxSummaryColumns":8,"type":"Public","includeFields":["ComplaintDescription","Zipcode","City","Address","Businessname"],"fieldSettings":{"Businessname":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"id":"Businessname","label":"Business Name","group":"Information on where violation occurred:~expanded","required":"YES"},"type":"text","subfields":[],"required":"YES"}},"Address":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"id":"Address","label":"Address","group":"Information on where violation occurred:~expanded","required":"YES"},"type":"textarea","subfields":[],"required":"YES"}},"State":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"NO","overrideConfigs":{"properties":{"id":"State"}}},"City":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"id":"City","label":"City","group":"Information on where violation occurred:~expanded","required":"YES"},"type":"text","subfields":[],"required":"YES"}},"complainantFirstName":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"label":"First Name","id":"complainantFirstName","maxlength":500,"required":"NO"},"type":"text","logic":[{"type":"hide","target":"field","validationType":"","calculationType":"","src":"","col":"","filterType":"field","field":"Complainantrequestfollowup","valueAction":"===","idOverride":"","inputType":"input,select","value":"NO","targetValue":"","rules":[]},{"type":"show","target":"field","validationType":"","calculationType":"","src":"","col":"","filterType":"field","field":"Complainantrequestfollowup","valueAction":"===","idOverride":"","inputType":"input,select","value":"YES","targetValue":"","rules":[]},{"type":"require","target":"","validationType":"","calculationType":"","src":"","col":"","filterType":"field","field":"Complainantrequestfollowup","valueAction":"===","idOverride":"","inputType":"input,select","value":"YES","targetValue":"","rules":[]}],"default":"","dbType":"VARCHAR","dbUnicode":"NO","dbMaxLength":500,"dbNullable":"YES","required":"NO"}},"Howwascomplaintsubmitted":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"required":"NO","id":"Howwascomplaintsubmitted","label":"How was complaint submitted?","group":"Complaint Details~expanded"},"type":"select","subfields":[],"required":"NO","default":"MyHD","options":[{"text":"MyHD","value":"MyHD"},{"text":"Email","value":"Email"},{"text":"Phone","value":"Phone"},{"text":"Other","value":"Other"}]}},"IsThisComplaintActionable":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"id":"IsThisComplaintActionable","label":"Is This Complaint Actionable?","group":"Complaint Details~expanded","required":"NO"},"type":"select","subfields":[],"options":[{"text":"Yes","value":"Yes"},{"text":"No","value":"No"}],"required":"NO"}},"dateReceived":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"group":"Complaint Details","label":"Date Received","id":"dateReceived"},"required":"YES","scheduler":[{"target":"self","triggerField":"dateReceived","date":"dynamic","unit":"day","src":"3CA28874-348A-4DFE-A7F8-92DDBAB914B0","trigger":"!==","field":"investigateWithin","triggerValue":"","title":"Complaint Investigation"}],"type":"date","default":"{now}","dbType":"DATETIME","dbNullable":"YES"}},"ComplaintsubmittedOther":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"id":"ComplaintsubmittedOther","label":"Complaint submitted Other","group":"Complaint Details~expanded"},"type":"text","subfields":[],"logic":[{"idOverride":"","type":"show","target":"field","validationType":"","calculationType":"","src":"","col":"","filterType":"field","field":"Howwascomplaintsubmitted","valueAction":"===","value":"Other","targetValue":"","valueType":"input","rules":[]},{"idOverride":"","type":"hide","target":"field","validationType":"","calculationType":"","src":"","col":"","filterType":"field","field":"Howwascomplaintsubmitted","valueAction":"!==","value":"Other","targetValue":"","valueType":"input","rules":[]}],"default":"MyHD"}}},"flags":[{"field":"dateReceived","value":"{now}"},{"field":"Howwascomplaintsubmitted","value":"MyHD"}],"contactList":[{"userID":"A883214E-C2C8-4F44-A392-3EFB69F12AE5","method":"Email","type":"user"},{"userID":"A883214E-C2C8-4F44-A392-3EFB69F12AE5","method":"Text","type":"user"}],"fees":[]},"singular":"Complaint","plural":"Complaints","title":"Complaint Manager","instructions":"Please complete the following form to report a tobacco retailer violation to the Oregon Health Authority (OHA). ","submittedMessage":"Thank you for your Tobacco Retailer Violation ReportThank you for reaching out to the Oregon Tobacco Retail License (TRL) Program. This message is to confirm that the Oregon TRL Program has received your tobacco retailer violation report. We will review your tobacco retailer violation report and investigate as appropriate. If you have any questions about your tobacco retailer violation report, please contact Annie Masuda via email (anne.masuda2@oha.oregon.gov) or phone (503-569-8695).  ","emailNotificationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com.Details {record.ComplaintDescription}. Complaint ID: {record.complaintsID} ALL CAPS Hi {CONTACT.firstName}, a new {FORM.singular} has been submitted from My Health Department.com.Details {RECORD.ComplaintDescription}. Complaint ID: {RECORD.complaintsID}","textNoficationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com.Details {record.ComplaintDescription}. Complaint ID: {record.complaintsID}\n\nALL CAPS\nHi {CONTACT.firstName}, a new {FORM.singular} has been submitted from My Health Department.com.Details {RECORD.ComplaintDescription}. Complaint ID: {RECORD.complaintsID}","notificationConditions":[{"action":"NIN","field":"Businessname","value":"EVERYBODY"}],"subForms":[],"questionnaireSettings":{"parentFormID":"","parentPkey":"","parentSrc":"","triggerFields":[],"frequency":1,"frequencyUnit":"daily","timeRange":{"start":"7:00 AM","end":"7:00 PM"},"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}","emailSubject":"You have a new {questionnaire.singular}"},"path":"complaint-manager"},"listCaption":"","formID":"3CA28874-348A-4DFE-A7F8-92DDBAB914B0","listPageConfig":{"lkp":[{"filter":"","alias":"Complaint_Address_Manager","from":"addressID","to":"This_Form","row":0,"type":"left","key":"Address","lkpto":"","dsn":"","on":"addressID"},{"filter":"","alias":"User_Manager_Assigned","from":"userID","to":"This_Form","row":0,"type":"left","key":"users","lkpto":"","dsn":"","on":"recordAssignedToUserID"},{"filter":"","alias":"User_Manager_Received","from":"userID","to":"This_Form","row":0,"type":"left","key":"users","lkpto":"","dsn":"","on":"receivedByUserID"},{"filter":"","alias":"Establishment_LKP","from":"establishmentID","to":"This_Form","row":0,"type":"left","key":"Establishment","lkpto":"","dsn":"","on":"establishmentID"},{"alias":"Note_ToFile","key":"Note_to_File_Manager","from":"note_to_file_managerID","to":"This_Form","on":"rdplookupID","filter":"","row":0,"lkpto":"complaintsID","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"Establishment_Address_LKP","key":"Address","from":"addressID","to":"Establishment_LKP","on":"parentFormID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"License_Manager_LKP","key":"Permit","from":"permitID","to":"This_Form","on":"permitID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false}],"columns":[{"mask":"","out":"{complaintNumber}","alias":"This_Form","src":"Complaints","format":"","label":"Complaint Number","hideFromOutput":"NO","schedulerName":true,"schedulerDesc":false},{"src":"Complaints","format":"date","alias":"This_Form","label":"Date Received","hideFromOutput":"NO","mask":"mm/dd/yyyy","out":"{dateReceived}","filterable":true},{"mask":"","out":"{InJurisdiction}","alias":"This_Form","src":"Complaints","format":"","label":"In Jurisdiction","hideFromOutput":"NO"},{"src":"Complaints","format":"","alias":"This_Form","label":"Status","mask":"","out":"{status}","hideFromOutput":"NO","filterable":true},{"src":"Establishment","format":"","alias":"Establishment_LKP","label":"Facility Name","mask":"","out":"{name}","hideFromOutput":"NO"},{"mask":"","out":"{addressLine1}","alias":"Establishment_Address_LKP","src":"Address","format":"","label":"Facility Address","hideFromOutput":"NO"},{"mask":"","out":"{addressLine2}","alias":"Establishment_Address_LKP","src":"Address","format":"","label":"Facility Unit Info","hideFromOutput":"NO"},{"mask":"","out":"{city}","alias":"Establishment_Address_LKP","src":"Address","format":"","label":"Facility City","hideFromOutput":"NO"},{"mask":"","out":"{zip}","alias":"Establishment_Address_LKP","src":"Address","format":"","label":"Facility Zip","hideFromOutput":"NO"},{"mask":"","out":"{County}","alias":"Establishment_Address_LKP","src":"Address","format":"","label":"Facility County","hideFromOutput":"NO","nonsearchable":true,"filterable":true},{"src":"Complaints","format":"","alias":"This_Form","label":"How Received","mask":"","out":"{howReceived}","hideFromOutput":"YES","filterable":false},{"mask":"","out":"{SellingtoMinors}","alias":"This_Form","src":"Complaints","format":"","label":"Selling to Minors","hideFromOutput":"YES","filterable":false},{"src":"Address","format":"","alias":"Complaint_Address_Manager","label":"Complaint Address","mask":"","out":"{Complaint_Address_ManageraddressLine1} {Complaint_Address_ManageraddressLine2}","hideFromOutput":"YES","filterable":true,"alwaysIncludeAlias":"YES"},{"mask":"","out":"{Complaint_Address_ManageraddressLine2}","alias":"Complaint_Address_Manager","src":"Address","format":"","label":"Complaint Unit Info","hideFromOutput":"YES","filterable":true,"alwaysIncludeAlias":"YES"},{"mask":"","out":"{Complaint_Address_Managercity}","alias":"Complaint_Address_Manager","src":"Address","format":"","label":"Complaint City","hideFromOutput":"YES","filterable":true,"alwaysIncludeAlias":"YES"},{"mask":"","out":"{Complaint_Address_Managerzip}","alias":"Complaint_Address_Manager","src":"Address","format":"","label":"Complaint Zip","hideFromOutput":"YES","filterable":true,"alwaysIncludeAlias":"YES"},{"mask":"","out":"{Complaint_Address_Managerstate}","alias":"Complaint_Address_Manager","src":"Address","format":"","label":"Complaint State","hideFromOutput":"YES","filterable":true},{"src":"Complaints","format":"","alias":"This_Form","label":"Primary Complaint Type","mask":"","out":"{PrimaryComplaintType}","hideFromOutput":"NO","filterable":true},{"mask":"","out":"{SecondaryComplaintType}","alias":"This_Form","src":"Complaints","format":"","label":"Secondary Complaint Type","hideFromOutput":"NO","filterable":true},{"mask":"","out":"{TertiaryComplaintType}","alias":"This_Form","src":"Complaints","format":"","label":"Tertiary Complaint Type","hideFromOutput":"NO","filterable":true},{"mask":"","out":"{firstName} {lastName}","alias":"User_Manager_Assigned","src":"users","format":"","label":"Assigned To","hideFromOutput":"NO"},{"mask":"","out":"{MultnomahCountyJurisdiction}","alias":"This_Form","src":"Complaints","format":"","label":"MC Jurisdiction","hideFromOutput":"YES","filterable":false,"nonsearchable":true},{"src":"Complaints","format":"","alias":"This_Form","label":"Result of Complaint","mask":"","out":"{status}","hideFromOutput":"YES","filterable":false,"nonsearchable":true},{"src":"Complaints","format":"","alias":"This_Form","label":"Multnomah County Jurisdiction","mask":"","out":"{MultnomahCountyJurisdiction}","hideFromOutput":"YES","filterable":false},{"mask":"","out":"{complainantFirstName} {complainantLastName}","alias":"This_Form","src":"Complaints","format":"","label":"Who made it?","hideFromOutput":"YES"},{"mask":"","out":"{complainantFirstName} {complainantLastName}","alias":"This_Form","src":"Complaints","format":"","label":"Owner_Name","hideFromOutput":"YES","nonsearchable":true},{"mask":"","out":"{CountyPermissions}","alias":"This_Form","src":"Complaints","format":"","label":"County Permissions","hideFromOutput":"NO","filterable":true,"nonsearchable":true},{"mask":"","out":"{DORIDLocalID}","alias":"License_Manager_LKP","src":"Permit","format":"","label":"DORID/LocalID","hideFromOutput":"NO"},{"mask":"","out":"{InspectionTypeNeeded}","alias":"This_Form","src":"Complaints","format":"","label":"Inspection Type Needed","hideFromOutput":"YES"},{"hideFromOutput":"YES","alias":"This_Form","mask":"","out":"{dateAdd}","label":"Date Added","src":"dateAdd","format":"date"},{"hideFromOutput":"YES","alias":"This_Form","mask":"","out":"{dateLastModified}","label":"Date Last Modified","src":"dateLastModified","format":"date"},{"hideFromOutput":"YES","alias":"This_Form","mask":"","out":"{modifiedBy}","label":"Last Modified By","src":"modifiedBy","format":""}],"listInfoBox":{"infoBoxType":"","infoBox":"alert","infoText":""},"COLUMNLIST":"Complaints.complaintNumber,Complaints.dateReceived,Complaints.InJurisdiction,Complaints.status,Establishment.name,Address.addressLine1,Address.addressLine2,Address.city,Address.zip,Address.County,Complaints.howReceived,Complaints.SellingtoMinors,Address.Complaint_Address_ManageraddressLine1,Address.Complaint_Address_ManageraddressLine2,Address.Complaint_Address_ManageraddressLine2,Address.Complaint_Address_Managercity,Address.Complaint_Address_Managerzip,Address.Complaint_Address_Managerstate,Complaints.PrimaryComplaintType,Complaints.SecondaryComplaintType,Complaints.TertiaryComplaintType,users.firstName,users.lastName,Complaints.MultnomahCountyJurisdiction,Complaints.status,Complaints.MultnomahCountyJurisdiction,Complaints.complainantFirstName,Complaints.complainantLastName,Complaints.complainantFirstName,Complaints.complainantLastName,Complaints.CountyPermissions,Permit.DORIDLocalID,Complaints.InspectionTypeNeeded","LABELMAP":{"SecondaryComplaintType":19,"DORIDLocalID":28,"AssignedTo":21,"MCJurisdiction":22,"FacilityZip":9,"SellingtoMinors":12,"Status":4,"ComplaintNumber":1,"InspectionTypeNeeded":29,"ComplaintState":17,"FacilityUnitInfo":7,"ComplaintAddress":13,"PrimaryComplaintType":18,"ComplaintCity":15,"Whomadeit":25,"FacilityAddress":6,"TertiaryComplaintType":20,"HowReceived":11,"OwnerName":26,"MultnomahCountyJurisdiction":24,"ResultofComplaint":23,"ComplaintUnitInfo":14,"CountyPermissions":27,"FacilityName":5,"FacilityCity":8,"FacilityCounty":10,"DateReceived":2,"InJurisdiction":3,"ComplaintZip":16},"SEARCHPOINTS":["Complaints.complaintNumber","Complaints.dateReceived","Complaints.InJurisdiction","Complaints.status","Establishment.name","Address.addressLine1","Address.addressLine2","Address.city","Address.zip","Complaints.howReceived","Complaints.SellingtoMinors","Address.Complaint_Address_ManageraddressLine1,Address.Complaint_Address_ManageraddressLine2","Address.Complaint_Address_ManageraddressLine2","Address.Complaint_Address_Managercity","Address.Complaint_Address_Managerzip","Address.Complaint_Address_Managerstate","Complaints.PrimaryComplaintType","Complaints.SecondaryComplaintType","Complaints.TertiaryComplaintType","users.firstName,users.lastName","Complaints.MultnomahCountyJurisdiction","Complaints.complainantFirstName,Complaints.complainantLastName","Permit.DORIDLocalID","Complaints.InspectionTypeNeeded"],"COLUMNPOINTS":["Complaints.complaintNumber","Complaints.dateReceived","Complaints.InJurisdiction","Complaints.status","Establishment.name","Address.addressLine1","Address.addressLine2","Address.city","Address.zip","Address.County","Complaints.howReceived","Complaints.SellingtoMinors","Address.Complaint_Address_ManageraddressLine1,Address.Complaint_Address_ManageraddressLine2","Address.Complaint_Address_ManageraddressLine2","Address.Complaint_Address_Managercity","Address.Complaint_Address_Managerzip","Address.Complaint_Address_Managerstate","Complaints.PrimaryComplaintType","Complaints.SecondaryComplaintType","Complaints.TertiaryComplaintType","users.firstName,users.lastName","Complaints.MultnomahCountyJurisdiction","Complaints.status","Complaints.MultnomahCountyJurisdiction","Complaints.complainantFirstName,Complaints.complainantLastName","Complaints.complainantFirstName,Complaints.complainantLastName","Complaints.CountyPermissions","Permit.DORIDLocalID","Complaints.InspectionTypeNeeded"],"FORMATTEDCOLUMNS":[]},"dataEntryConfig":{"panels":[{"form":"Note_to_File_Manager","layout":{"columns":[{"src":"Note_to_File_Manager","sortBy":"","hideFromOutput":"NO","format":"date","label":"Date","mask":"mm/dd/yyyy","out":"{dateNoteFile}","outOverride":""},{"src":"users","sortBy":"","hideFromOutput":"NO","format":"","label":"User","mask":"","out":"{User_ManagerfirstName} {User_ManagerlastName}","outOverride":""}]},"isLookup":true,"allowRDPAdd":true},{"form":"Form_Letter_Manager","layout":{"columns":[{"src":"Form_Letter_Manager","sortBy":"","hideFromOutput":"NO","format":"","label":"Letter Title","mask":"","out":"{form_letter_libraryID}","outOverride":""},{"src":"Form_Letter_Manager","sortBy":"","hideFromOutput":"NO","format":"","label":"Letter Date","mask":"","out":"{LetterDate}","outOverride":""}]},"isChild":true},{"form":"Inspection","layout":{"columns":[{"src":"Inspection","sortBy":"","hideFromOutput":"NO","format":"date","label":"Date","mask":"mm/dd/yyyy","out":"{inspectionDate}","outOverride":""},{"src":"Inspection","sortBy":"","hideFromOutput":"NO","format":"","label":"Purpose","mask":"","out":"{InspectionType}","outOverride":""},{"src":"Inspection","hideFromOutput":"NO","format":"","label":"Result","mask":"","out":"{Result}","outOverride":""}]},"isChild":true,"allowRDPAdd":true,"allowCopy":false,"isLookupReverse":false,"isLookup":true}],"form":[{"properties":{"id":"Businessname","label":"Business Name","group":"Information on where violation occurred:~expanded","required":"YES"},"type":"text","subfields":[],"required":"YES"},{"properties":{"id":"Address","label":"Address","group":"Information on where violation occurred:~expanded","required":"YES"},"type":"textarea","subfields":[],"required":"YES"},{"properties":{"id":"City","label":"City","group":"Information on where violation occurred:~expanded","required":"YES"},"type":"text","subfields":[],"required":"YES"},{"properties":{"id":"Zipcode","label":"Zip code","group":"Information on where violation occurred:~expanded"},"type":"text","subfields":[]},{"properties":{"label":"Please provide a description of the tobacco retailer violation","id":"ComplaintDescription","required":true},"required":true,"type":"textarea","subfields":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":"MAX","dbNullable":true,"logic":[]}]},"hsScripts":[{"runWhen":"onload","runWhere":"cloudEntry","code":"/**\r\n * DCS-654 State of Oregon Tobacco GIS Integration: Inspetor Assignment \r\n * Get the zipcode and county from the address entry (parent form) and assign the staff accordingly.\r\n */\r\n\r\nconst mappings = {\r\n staffIDField: \"userID\",\r\n assignToField: \"recordAssignedToUserID\"\r\n}\r\n\r\n\r\nconst getStaffID = async (linkedLicenseID) => {\r\n const staffToAssign = await hs.api.getHSQueryResult({\r\n formID: '3CA28874-348A-4DFE-A7F8-92DDBAB914B0',\r\n alias: 'get-assignment-query',\r\n params: JSON.stringify({ permitID: linkedLicenseID })\r\n }).catch(console.warn);\r\n \r\n if (staffToAssign && staffToAssign?.DATA?.[0]) {\r\n const inspector = staffToAssign.DATA[0][mappings.staffIDField]\r\n igov.entry.meta.form['0'].dataInstance[mappings.assignToField] = inspector;\r\n igov.entry.meta.form['0'].fieldInstance[mappings.assignToField].load();\r\n console.log(\"successfully found the inspector \")\r\n } \r\n else {\r\n // this may not happen but just in case.\r\n // the state is not responsible for inspecting some retailers which are located in some zipcodes.\r\n // the assignement should be done by its locality, so leave it blank. \r\n console.log(\"failed to found the inspector \")\r\n app.ui.modal.warning('The inspector for this retailer should be assigned by its locality');\r\n }\r\n}\r\n// Since a complaint is created from a license, we will need the linked permitID\r\n\r\nif (igov.isNew && urlObj.permitID) {\r\n getStaffID(urlObj.permitID)\r\n}"}]}