Delete Rules

The Delete Rules option in Admin Corner allows you to view the Delete Rules table. The deletion rules specify the conditions that allow the deletion of a record.

The system only allows deletion of a particular type of record if it matches all rules for that record type. If a record fails a rule, the message shown in parentheses on the last line of that rule displays to the user and the deletion is refused.

For example, in the set of rules shown below, an item record can be deleted only if it meets the conditions in the first four rules. If an item record has a hold (i.e., the HOLD field does exist), rule 2 prevents the deletion, and the system displays the message: <item record #> has a hold on it.

                                   DELETERULE
01 > RECTYPE is ITEM
     AND OUT DATE = '   '(Delete only if  checkout date is blank)
     AND DUE DATE = '   '(and due date is blank)
     AND ODUE DATE = '   '(and no overdue date)
     AND RECAL DATE = '   '(and no recall date)
     AND PATRON# = '   '(and no patron # in patron# fixed len field)
     AND LINK REC[p] = '0'(is checked out)
02 > RECTYPE is ITEM
     AND HOLD does not exist (has a hold on it)
03 > RECTYPE is ITEM
     AND COURSE ID does not exist (is on reserve)
04 > RECTYPE is ITEM
     AND BOOKING does not exist (has a booking on it)
05 > RECTYPE is PATRON
     AND CUR CHKOUT = '0' (Delete only if current checkouts is zero)
     AND LINK REC[i] = '0' (has items checked out)
06 > RECTYPE is PATRON
     AND HOLD does not exist (has holds outstanding)
07 > RECTYPE is PATRON
     AND FINE does not exist (has fines outstanding)
08 > RECTYPE is PATRON
     AND BOOKING does not exist (has items booked)
09 > RECTYPE is COURSE
     AND ITEM ID does not exist (is on reserve)
10 > RECTYPE is ORDER
     AND STATUS <> 'c' (is status "c")
11 > RECTYPE is ORDER
     AND STATUS <> 'o' (is status "o")
12 > RECTYPE is ORDER
     AND STATUS <> 'e' (is status "e")
13 > RECTYPE is ORDER
     AND STATUS <> 'q' (is status "q")
14 > RECTYPE is CHECKIN
     AND ROUTING does not exist (is routed)
15 > RECTYPE is BIBLIOGRAPHIC
     AND LINK REC[i] = '0'  (has item record attached)
___________________________________________________________________
 F > FORWARD       J > JUMP       P > PRINT       Q > QUIT
 Choose one (F,J,P,Q)

You can edit the Deletion Rules file with Advanced System Access & Administration. See Rules for Deletion of Records for more information.