Lookups Admin enables you to configure and maintain the Core+ lookup values to meet statutory recording requirements and locally decided values. Locally defined values can be mapped to Count Types to adhere to system-required values, MI values, and Youth Justice Board-required values.
From the Core+ Administration menu, click Lookups Admin.
The Lookup Admin page, which displays Lookup Types, Lookup Table Names, Custom Descriptions, and Lookup Categories, is displayed. The grid can be filtered by specifying values in the Header fields or ordered by clicking on the column headings.
Click on a row to drill down into a specific Lookup Value table.
Click the Back to Lookup Types button to return to the Lookup Admin page.
Select Show retired lookups to include tilded or deleted lookups in the grid.
The Lookup Type Name, Table Name and Description are displayed above the grid.
Edit or add a Lookup
To edit the Lookup Code or the Description, click Edit on the corresponding row.
Could you amend the Code and Description as required?
Click Save.
Click the Back to Lookup Values List button to return to the Lookup Values List.
To add a new Lookup, click the New button on the page footer of the Lookup Values List
Enter a unique Code and Description on the New Lookup Admin page.
Click Save.
Click the Back To Lookup Values List button to return to the Lookup Values List.
The new Lookup Value will now be selectable within the Lookup Selection.
Edit or add a Lookup Type Description
From the Core+ Administration menu, click Lookups Admin.
To add or edit a Lookup's Custom Description, click "Edit Description" on the corresponding row. This is useful for user-defined fields.
In the Lookup Description dialogue, enter a Custom Description.
Click Ok.
Remove a Lookup
If a Lookup is no longer relevant, it can be removed subject to permissions.
From the Core+ Administration menu, click Lookups Admin.
Click on a row to drill down into the specific Lookup Value table.
Click Delete on the corresponding Lookup row.
Confirmation that you wish to delete the lookup will be displayed. Once confirmed, the lookup row will turn red, and the Lookup will no longer be available for selection.
If the Lookup value is in use within Core+, a prompt will be displayed advising that it will be titled. this denotes that the value will still be visible on the Core+ record, but is not selectable.
Tip: Deleted Lookup values can be restored by selecting the Show retired lookups check box and clicking the restore icon on the corresponding row.
It is worth noting that certain tables are locked out of editing, such as LU_DESTINATION, LU_YOT_LIFE_EVENT_TYPE. In these instances, should you wish to edit a lookup, you can delete the previous lookup. If used historically, this will tilde out the lookup. If it hasn't been used, it will be marked as deleted in the database instead. Then you can move forward with creating your new lookup.