I received this report from serials staff, and I don't know which tables have which information. Can you tell me this information?
I am finding a lot of instances where the subscription status that displays in the Serials Receiving Record search results does not match the status in the SRR or what is in the table: ole_ser_rcv_rec
In the attached example, when I do an SRR search for Publisher's monthly it shows Status "Currently received" but when I open the SRR, it has Subscription Status "Received and complete or ceased."
I ran a query trying to get titles that were "Currently received" in RR2Per but I got a lot of false positives.
For Publisher's Monthly (bib# 8459715)SUBSCR_STAT in ole_ser_rcv_rec is 4 (curr rec'd)
In what table and field is the actual SRR Subscription Status?
Other examples: bib# 206085 & 208842, Search results = curr rec'd, SRR = blank