Comment 5 for bug 978287

Revision history for this message
Robert J Jackson (rjackson-deactivatedaccount) wrote :

More documentation from the backdating session that showed some entries being backdated while others were not. Here is an example action.circulation entry for one that worked followed by one that did not:

evergreen=# select * from action.circulation where id = 29515118;
-[ RECORD 1 ]-------+------------------------------
id | 29515118
usr | 1310603
xact_start | 2012-10-26 13:51:56-04
xact_finish | 2012-11-01 10:16:44.522933-04
unrecovered |
target_copy | 29424547
circ_lib | 115
circ_staff | 1305905
checkin_staff | 1373245
checkin_lib | 115
renewal_remaining | 1
due_date | 2012-11-02 23:59:00-04
stop_fines_time | 2012-10-31 23:59:00-04
checkin_time | 2012-10-31 23:59:00-04
duration | 7 days
fine_interval | 1 day
recurring_fine | 0.25
max_fine | 10.00
phone_renewal | f
desk_renewal | f
opac_renewal | f
duration_rule | 14_7_21_1
recurring_fine_rule | 25_cent_per_day
max_fine_rule | overdue_mid
stop_fines | CHECKIN
create_time | 2012-10-26 13:51:56-04
workstation | 10167
parent_circ |
checkin_workstation | 9700
checkin_scan_time | 2012-11-01 10:16:44.522933-04
grace_period | 1 day
copy_location | 16801

evergreen=# select * from action.circulation where id = 29274112;
-[ RECORD 1 ]-------+-----------------------------
id | 29274112
usr | 1310358
xact_start | 2012-10-16 17:29:33-04
xact_finish | 2012-11-01 10:13:22.41029-04
unrecovered |
target_copy | 28013870
circ_lib | 115
circ_staff | 1305905
checkin_staff | 1373245
checkin_lib | 115
renewal_remaining | 1
due_date | 2012-11-06 23:59:00-05
stop_fines_time | 2012-11-01 00:59:00-04
checkin_time | 2012-11-01 00:59:00-04
duration | 21 days
fine_interval | 1 day
recurring_fine | 0.25
max_fine | 10.00
phone_renewal | f
desk_renewal | f
opac_renewal | f
duration_rule | 21_21_21_1
recurring_fine_rule | 25_cent_per_day
max_fine_rule | overdue_mid
stop_fines | CHECKIN
create_time | 2012-10-16 17:29:33-04
workstation | 9483
parent_circ |
checkin_workstation | 9700
checkin_scan_time | 2012-11-01 10:13:22.41029-04
grace_period | 1 day
copy_location | 16830