Create the following Complaints Report.
Input:
• Date Range (or all dates)
• Watershed (or all watersheds)
• Status Codes (or all Status codes)
o On-going Investigation
o Problem found, referred to agency, not resolved
o …
Fields
• Watershed – PST_WATERSHEDS_LU.WATERSHED_NAME
• Stream - PST_Streamcodes.STREAM_DESC
• Complainant – PST_ComplainantSourceCodes.COMPLAINANT_SOURCE_DESC
• Complaint Date - PST_Investigations.INV_COMPLDATE
• Service Request – PST_SERVICE_REQUESTS.SR_NUM
• Ref No - PST_Investigations.INVESTIGATION_ID
• Problem Type – PST_ProblemCodes.PROBLEM_DESC
• Status Code – PST_SERVICE_REQUESTS.INV_STATUS_DESC
• Complainant Code/Origin – PST_OriginCodes.ORIGIN_DESC
• Date Solved - PST_Investigations.INV_SOLVEDATE
• Common Name - PST_Investigations.INV_NAME
• Location Description - PST_Investigations.INV_LOC_DESC
• Agency Referral – PST_RefAgencyCodes.REF_AGENCY_DESC
• Approx Address - PST_Investigations.LOCATION
• Explanation - PST_Investigations.INV_DESC
Create the following Complaints Report. Input: • Date Range (or all dates) • Watershed (or all watersheds) • Status Codes (or all Status codes) o On-going Investigation o Problem found, referred to agency, not resolved o … Fields • Watershed – PST_WATERSHEDS_LU.WATERSHED_NAME![rep2_complaints](https://cloud.githubusercontent.com/assets/5039052/4741944/095af4c4-5a1b-11e4-8bae-a10f6d31ffe8.GIF)
• Stream - PST_Streamcodes.STREAM_DESC
• Complainant – PST_ComplainantSourceCodes.COMPLAINANT_SOURCE_DESC • Complaint Date - PST_Investigations.INV_COMPLDATE • Service Request – PST_SERVICE_REQUESTS.SR_NUM • Ref No - PST_Investigations.INVESTIGATION_ID
• Problem Type – PST_ProblemCodes.PROBLEM_DESC
• Status Code – PST_SERVICE_REQUESTS.INV_STATUS_DESC
• Complainant Code/Origin – PST_OriginCodes.ORIGIN_DESC • Date Solved - PST_Investigations.INV_SOLVEDATE • Common Name - PST_Investigations.INV_NAME
• Location Description - PST_Investigations.INV_LOC_DESC
• Agency Referral – PST_RefAgencyCodes.REF_AGENCY_DESC • Approx Address - PST_Investigations.LOCATION • Explanation - PST_Investigations.INV_DESC