Data Warehouse and Reporting

Data Warehouse and Reporting

[DW TABLES WITH PRIORITY] [DW TABLES IN PROCESS] [DW TABLES PENDING] [DW TABLES COMPLETED]
[PENDING ARROW REPORT REQUESTS] [SPECIAL REQUEST EXAMPLES ]

DW TABLES WITH PRIORITY

Patrons
- Needed to allow patron scrubbing without losing links for reports

DW TABLES IN PROCESS

Vendors (programming)
Publication Information (specification)
Invoices
- Line Item (evaluation-most fields available from Transaction Table)
Metalib (specification)

DW TABLES PENDING (unordered)

Item History
Circ Events
- Circ Event Summary
URL-related subfields
- Needed to identify online resources
BIB
- Fixed fields
HOL
- Fixed Fields
Patrons
- Global Patron (Z303)
- Patron's ID (Z308)
Local Authority Files
LCA10 Authority File fields
MESH12 Authority File fields
Acquisitions log
Vendor provided search stats (preliminary evaluation to see if feasible)

PRODUCTION DW TABLES COMPLETED

Authority Bib Links
Authority Headings
Authority Load Before and After Records
Authority Load Institution Keys
Bibliographic Language Code/Language Name
Budget
Budget Totals
Call Numbers
Call Number Counts
Call Number Errors
Call Number Ranges
Circulation Log
Circulation Policy Matrix (Aleph Configuration Table)
Holdings Locations
ISBN
ISSN
Items
Item Processing Status (Aleph Configuration Table)
Item Status (Aleph Configuration Table)
Invoice Header Records
Loans
Loan History
Record Key Links
Acquisitions and Circulation Log Display (Aleph Configuration Table)
Material Types [Acquisitions] (Aleph Configuration Table)
Material Types [Mango]
OCLC
Orders
Own codes from bibliographic records
Own codes/descriptions (Aleph Configuration Table)
Patron Local
Patron Type and Patron Status (Aleph Configuration Table)
STA (Bibliographic and Holdings Record Status)
Sublibrary/Ordering Unit Collection (revised version)
SFX_STAT_OBJECT_OFFLINE (SFX Statistics)
SFX_STAT_TARGET_OFFLINE (SFX Statistics)
Tab Type Config (Aleph Configuration Table)
Titles
Transactions (Acquisitions financials)

PENDING ARROW REPORT REQUESTS (unordered)

Additional Authority reports (working with Auth Subcommittee to spec and prioritize)
Duplicate Call Numbers, initial request from FIU
Duplicate OCLC Numbers (have done one time report, need to set up to run as an ARROW report), initial request from FIU
General Media Designator (GMD), requested by FIU
ARL and ACRL database statistics (working with CPC)
Combined missing/lost item by sublibrary/collection/call number, initial request by FSU
Uncirculated Items within date range, initial request by FSU
List of items overdue within date range initially requested by FAMU for Govt Docs
ShelfCheck Loan Counts initially requested by UF
Summary of Overdue Notices sent, requested by FIU
Shelflist/circulation counts, specifically requested by UF for JUSE Statistical purpose
Arrow form for Ad hoc reporting from Circ Logger - new to V.18
Invoice Totals by Date Range - change existing report to limit by Sublibrary, requested by FSU
- Depending on the values set up for Approval Department, this field could be used to limit by an administrative unit (basically equivalent to a DW UNIT).
Addition of Object Code input and sort options in Expenditures By Invoice report - requested by FGCU
Bib counts by WCA formats - used for comparison with WCA counts - requested by UWF
- Need specification of criteria used by OCLC for format definition.
Monthly orders created list - requested by UF but generic version needed

REQUESTED ARROW REPORTS WHERE NECESSARY DATA IS NOT ENTERED IN ALEPH

Payments by Call Number Range, initial request by FSU
- Data needed to link payments and call numbers is currently not populated
Invoice Totals by Date Range - change existing report to limit by Sublibrary, requested by FSU
- There is nothing that equates to Sublibrary in invoice headers or invoice line items.

SPECIAL REQUEST EXAMPLES

Journal lists
Catalog cleanup reports
Bibs and HOL without items
HOL and items without a sublibrary
OPAC Browse type stats
ISBN reports
Record keys for global changes
Collection counts