Printable Version of this PageHome PageRecent ChangesSearchSign In
:FCLA-Library Services' Ani Ani Web
LINKS

Data Warehouse Blog











Acquisitions Material Types

Item Material Types

Alternate Call Number Types

Data Warehouse Order Format

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


Last modified 4 July 2009 at 11:02 pm by Donna