[OPEN-ILS-GENERAL] Configuring applied penalties and messages

[Thomas Berezansky]

You need to do two things.

1 - Update the org_depth for the STAFF_* penalties (and possibly any  
INVALID_* ones) to be 0. Don't change them all, some should be  
ignoring it anyway but are placed based on the owner of group penalty  
thresholds.

2 - Update the existing standing penalties of those IDs to be owned by  
the consortia, as the org_depth only applies on *new* ones. This is  
easiest in the DB itself, and if you only changed the STAFF_ and maybe  
INVALID_ ones this should work:

UPDATE actor.usr_standing_penalty SET org_unit = 1 WHERE  
standing_penalty IN (SELECT id FROM config.standing_penalty WHERE  
org_depth = 0);

Thomas Berezansky
Merrimack Valley Library Consortium


Quoting "Turner, Jennifer M" <jennifer.turner at mnsu.edu>:

> How can staff-applied standing penalties and messages be configured  
> to display at all org units in a consortium?  Currently, when we  
> apply an alert  or note message from a branch library, it only  
> displays to staff logged in at that library.  Messages applied from  
> the headquarters location (system-level) may be viewed at all org  
> units.
>
> We've looked at the settings for Standing Penalty Types (Admin >  
> Local Admin > Standing Penalties).  Do we need to adjust the  
> org_depth setting here?  Currently this field is NULL for all  
> penalty types.  If it needs to be adjusted, what integer value  
> should be entered.  I've experimented with 0, 1, 2, and 3, but none  
> of those seemed to change the system's behavior.
>
> Thanks for any assistance!
>
> Jenny
>
>
> Jennifer Turner | PALS, A Program of the Minnesota State Colleges  
> and Universities | 507-389-2000
>
>