search

rssidlowski / Pollution_Source_Tracking

City of Baltimore Pollution Source Tracking
0 stars 0 forks source link

Data: add reference type #68

Closed rssidlowski closed 9 years ago

rssidlowski commented 9 years ago

We currently have service request and can have many associated to one investigation. Additionally would like to have a reference category to include Work Order ID (Cityworks) Service Request ID (311)

So add to the database table PST_SERVICE_REQUESTS a field REQUEST_TYPE_ID and have it look up to the domain table 'PST_RequestType'.

Once done pass this issue to Lu to update the application on the Service Requests page to do the following 1) change label at top to 'Investigation: References' 2) change to allow user to enter 'Reference Number' and select from drop down 'Reference Type'.

kanglu666 commented 9 years ago

done

rssidlowski commented 9 years ago

Add the reference type to be displayed with the reference number after it is added. Add a reference type of "Other".

kanglu666 commented 9 years ago

done

rssidlowski commented 9 years ago

Verified.