Inconsistent subscription statuses between tables

Notes

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

Assignee

Maura Byrne

Reporter

Maura Byrne

Labels

None

Priority By Function

None

Solr Version

None

Work Group

None

Process & Sub-Process

None

Parent Jira

None

Co-Assignee/s

None

Due By

None

Contribution

No

Contributing Developer

None

Contributing Institution

None

Contribution Type

None

Value Proposition

None

Components

Fix versions

Priority

Critical
Configure