Program Awards Database Administrator Tutorial

To access the observing award edit interface go to /award/edit
 
To locate a particular award, you may enter part of the person’s name and click the “Search” button. The form will scroll with the person’s name at the top. Click on the row and the information will be entered in the form below the scroll area. You may then correct the information for that award and then click “Update” or to delete the award click “Delete”.
 
To locate another award for that person — say the “Gold” award, just click the “Search” button a second time. When there no more entries for that person, the “Search” button will appear as “greyed” out and be disabled. To enter a new search just click in the text box to the left of the “Search” button. You may also move through the awards using the scrollbar on the right hand side.
 
 
To enter a new award, go to the end of the table by moving the scroll bar on the right to the bottom. Click on the “New” entry to enter the person’s name, etc. You may also enter a partial name as well, and you’ll get a drop down as you type (ie autocomplete). The society name on the right works the same way. DO NOT simply clear a previous entry in the form and enter new person name etc as it will update that old entry and replace it. A new award will not created correctly unless you click on the “new” row. Information should be entered in the same order as the entries in the scroll area above it (name, level, award number, date, and society).
 
 
The interface to edit program names and levels is at /award/programs/edit

 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
To modify the program name of existing observing program just select it, change the name and press “Update”. You may only add new levels to an existing program.
 
To add a new program select “Create a new awards program”, enter the name and press “Update”. Levels may be added after the new program is selecting an existing program. There is no way edit them in this interface. Deleting programs or award levels is not available in the interface either. These changes can be accomplished by using database tools available to the sysadmin as the need to do this shouldn’t occur very often.
Scroll to top