- Maintaining Lookup Type Codes
- Maintaining Lookup Type Codes
- Begin by navigating to the
- Maintain Lookup Type Codes
- page.
- You have completed the
- Maintaining Lookup Type Codes
- topic.
- These are the lookup types shipped with Oracle PSIR. You modify all lookup types using the same steps. In this topic, you will modify the
- Incident Location Type
- .
- First, add a lookup type code.
- Lookup Codes
- are unique keys in the data tables and built into the logic of Oracle PSIR.
- A
- Lookup Code
- can be upper or lower case.
- Next, specify a short display value. Display values appear when an incident report is created or reviewed.
- Saving the lookup type code makes it available when you create incident reports.
- Next, modify the
- Waterway
- lookup type code by editing the description.
- You can reverse any modifications to a single selected row using the
- Undo
- button. To save the modification, you would click
- Save
- instead.
- There are two types of delete, a hard delete and soft delete.
- A hard delete removes the lookup type code from the database table, provided it is not used in an incident report.
- First, perform a hard delete on the code
- Waterway
- .
- Confirm that you want to delete the
- Waterway
- lookup type code.
- A soft delete inactivates a lookup type code already used in incident reports. Inactivated codes are not displayed as options for creating or reviewing incident reports.
- Next, perform a soft delete on the
- Open Area
- code.
- Use the
- Maintain Lookup Type Codes
- page to modify the lookup type codes made available when creating or reviewing an incident report.
- The lookup type code
- Waterway
- is now added.
- The lookup type code
- Waterway
- is now deleted.
- The lookup type code
- Open Area
- is now inactive.
- Use the
- Description
- field to add an optional description.
- Original Path
- Adding a lookup type code
- Modifying a lookup type code
- Deleting a lookup type code
- Links
- Maintain Lookup Type Codes
- Select a Lookup Type
- Incident Location Type
- Add
- Lookup Code
- Lookup Code
- Display Value
- Display Value
- Save
- Description
- Description
- Save
- Delete
- Yes
- Active
- Save
- Description
- Description
- Save
- Manage Incident Reports
- Lookup type codes specify values used in incident reports. Oracle Public Sector Incident Reporting ships with seeded values for lookup type codes.
- The seeded values are:
- Incident Type
- Arson
- Burglary
- Assault
- Car Jacking
- Cyber Attack
- Drug Related Activity
- Emotionally Disturbed Person
- Fraud
- Graffiti
- Graffiti, Political
- Homicide
- Materials Acquisition
- Observation/Surveillance
- Public Health Threat
- Traffic Accident
- Weapons Discovery
- Incident Status
- New
- Open
- Withdrawn
- Closed
- Invalid
- Incident Severity
- Trivial
- Moderate
- Urgent
- Incident Location Type
- Business
- Business Park
- Government Building
- Highway
- Hospital
- Industry
- Mall
- Open Area
- Park
- Private Home
- School
- Street
- Person Involvement Type
- Witness
- Suspect
- Victim
- Attacker
- Responder
- Responder Jurisdiction Type
- City
- State
- County
- Federal
- International
- Responder Type
- Animal Control
- Emergency Medical Services
- Environmental Protection
- Federal Agency
- Fire Department
- International Agency
- Police Department
- Social Services
- State Agency
- State Police
- C
- ounty Agency
- Vehicle Type
- Truck
- Car
- Sports Utility Vehicle (SUV)
- Pickup Truck
- Motor Cycle
- You can add additional lookup type codes to meet your organization's needs.
- In this topic, you will modify lookup type code options.