- Maintaining State Codes
- Maintaining State Codes
- Begin by navigating to the
- Maintain Country and State Codes
- page.
- You have completed the
- Maintaining State Codes
- topic.
- First, select a country to add the state code to.
- 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.
- Use the
- Maintain Country and State Codes
- page to modify the country and state codes made available when creating or reviewing an incident report.
- Use the
- Description
- field to add an optional description.
- Use the
- State Codes
- tab to modify the states codes made available when creating or reviewing an incident report.
- Saving the state code makes it available when you create or review incident reports.
- Next, modify the
- Colorado
- state 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 state code from the database table, provided it is not used in an incident report.
- First, perform a hard delete on the code
- Colorado
- .
- Confirm that you want to delete the
- Colorado
- state code.
- A soft delete inactivates a state 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
- New York
- code.
- The state code
- Colorado
- is now added.
- The state code
- Colorado
- is now deleted.
- The state code
- New York
- is now inactive.
- Original Path
- Adding a new state code
- Modifying a state code
- Deleting a state code
- Links
- Manage Incident Reports
- Maintain Country and State Codes
- State Codes
- Select a Country
- United States of America
- Add
- Lookup Code
- Lookup Code
- Display Value
- Display Value
- Description
- Description
- Save
- Description
- Description
- Undo
- Delete
- Yes
- Save
- Active
- Save
- State codes enable a reporter or citizen to specify the state where the incident occurred. Oracle Public Sector Incident Reporting ships with seeded values for state codes. The seeded values are:
- Argentina
- Buenos Aires Province
- Catamarca Province
- Chaco Province
- Chubut Province
- Mendoza Province
- Australia
- Northern Territory
- South Australia
- Tasmania
- Western Australia
- Victoria
- Brazil
- Acre
- Amazonas
- Bahia
- Rio de Janeiro
- Alagoas
- Cameroon
- Awing
- Babungo
- Bakossi
- Canada
- Alberta
- British Columbia
- Saskatchewan
- Quebec
- Ontario
- China
- Anhu
- Fujian
- Shandong
- Henan
- Shaanxi
- France
- Alsace
- Aquitaine
- Picardy
- Burgundy
- Upper Normandy
- India
- Karnataka
- Maharashtra
- West Bengal
- Tamil Nadu
- Uttar Pradesh
- Somalia
- Somaliland
- Puntland
- Galmudug
- United Kingdom
- Essex
- Derbyshire
- Lincolnshire
- Nottinghamshire
- Surrey
- United States of America
- California
- Arizona
- Florida
- Texas
- New York
- You can add additional state codes to meet your organization's needs.
- In this topic, you will modify options for state codes.