You are here

Reports

There is one type of archived Aleph reports available: CLICS Quarterly Statistics.

In addition to the archives, there are also several automated reports that run on Aleph. Included below are descriptions of each report and information on how to find it in the Task Manager. (xx refers to the 2-letter campus code)

If you need instruction on managing report formats, please visit the Task Manager and Files page.

Not seeing a report you'd like run for your library? Open a work order and OLS will work with you to create a customized Aleph report.

Frequency Purpose File Name Module
Weekly (Friday) Unlinked heading records - bibliographic [manage-15] cun01_unlinked_headings CUN01
Weekly (Friday) Remove patron IDs from closed circ records older than 90 days pat_scrub_<date> CUN50
Weekly (Saturday) Expired hold requests [cir-23] expired_holds_<date> CUN50
Weekly (Sunday) Unlinked heading records - authorities [manage-15] cun10_unlinked_headings CUN10
Weekly (Sunday) Patron unpaid transaction letters [cash-05] xx_bills CUN50
Monthly (on 1st) Circulation statistics by hold requests (any copy) <date>_hold CUN50
Monthly (on 1st) Circulation statistics by hold requests (exact copy) <date>_hold2 CUN50
Monthly (on 1st) Circulation statistics by borrower type <date>_bortype CUN50
Monthly (on 1st) General circulation statistics by patron <date>_pat CUN50
Monthly (on 1st) General circulation statistics by date <date>_date CUN50
Monthly (on 1st) General circulation statistics by item status <date>_is CUN50
Monthly (on 1st) General circulation statistics by material type <date>_mat CUN50
Monthly (on 1st) Cash transactions for the previous month **opted-in campuses only xx_cash_trans CUN50
Monthly (on 1st) Cash waive-transactions for the previous month **opted-in campuses only xx_cash_wave CUN50
Monthly (on 1st) CLICS Statistics clic_statistics.lst CUN50
Monthly (on 1st) Patron Fines **opted-in campuses only (Monthly or End of Semester) xx_fine_rpt, xx_credit_rpt, xx_fine_emplid CUN50
Monthly (on 1st) CUNY-wide Budget Totals commit_expend_<date> CUN50
Monthly (on 2nd) Monograph claims report [acq-12] xx_mcl CUN50
Monthly (on 3rd in months selected by campuses)

Budget report **opted-in campuses only

xx_acq_bud_<date> CUN50
Monthly (on 3rd in months selected by campuses)

Budget report with Object Codes**opted-in campuses only

xx_bud_object_cd_<date>, bud_object_cd_<date>xx_sum CUN50
Monthly (on 4th)

Circulation for Textbooks across CUNY (and Physical Item Counts)

textbook_summary_<date> and textbook_item_count

CUN50
Monthly (on 4th) Circulation for Sub-Libraries with Textbooks

xx_textbook_<date>

CUN50
Monthly (on 4th) Items with no Collection Code (in circulation) items_no_cltn CUN50
Monthly (on 4th) Inactivated Course Reserves Summary

CR_Inactivated_<date>

CUN50
Monthly (on 4th) Course Reserves Summary by Instructor

Instructor_Sum_<date>

CUN50
Monthly (on 4th) Active CR Courses per Library

xx_course_resv_active

CUN50
Monthly (on 4th) Items in Active Courses per Library

xx_course_resv_items

CUN50
Monthly (on 4th) Items in Courses which are No Longer Active per Library

xx_course_resv_inactive

CUN50
Monthly (on 4th) Reserves laptop usage **opted-in campuses only

xx_cr_laptop or xx_rsv_laptop

CUN50
Monthly (on 4th) Current Number of Loans by Call Number Class**opted-in campuses only

xx_circ_call_cnt

CUN50
Monthly (on 5th) Purge expired patrons, excluding those who owe books/money   CUN50
Monthly (on 8th) Outstanding hold requests xx_oldhold CUN50
Monthly (on 8th) In-transit items xx_instransit CUN50
Monthly (on 8th) In-transit items lost within past 12 months lost_intransit CUN50
Monthly (on 8th) Overdue Items **opted-in campuses only xx_circ_overdue CUN50
Monthly (on 8th) Loans that are Lost **opted-in campuses only xx_loans_lost CUN50
Monthly (on 15th) Serials claims report [serial-44] xx_scl CUN50
Monthly (on 15th) Collection Usage Summary cltn_<campus>_<collection> CUN50
Monthly (on 16th) Items with Item Process Status (e.g., 'Searching' or 'Lost / Paid') **opted-in campuses only xx_items_yy (yy = item process status) CUN50
Monthly (on 24th) Budget report **opted-in campuses only xx_acq_bud<date> CUN50
Monthly (on 24th) New Title Listing **opted-in campuses only xx_new_title CUN50
Quarterly (in Jan, Apr, Jul, & Oct on 1st) Quarterly CLICS Statistics [ two versions: Detail and Summary ] CLICSQuarterly_<year>_<month range>.txt and CLICSQuarterly_sum_<year>_<month range>.csv CUN50
Quarterly (in Jan, Apr, Jul, & Oct on 3rd) Orders listed by Budget **opted-in campuses only xx_bud_ordnum_<date> CUN50
Quarterly (in Mar, Jun, Sep, & Dec on 3rd) Standing order claims report [acq-11] xx_socl CUN50
Quarterly (in Mar, Jun, Sep, & Dec on 3rd) Un-invoiced Monograph Orders (incomplete invoicing) xx_fye_mono_unpaid CUN50
Triannually (May, Aug, and Dec on 24th) Patron Fines **opted-in campuses only (End of Semester or monthly) xx_fine_rpt, xx_credit_rpt CUN50
Triannually (in May, Aug, & Dec on 24th, and Jan, Jun, & Sep on 3rd) Overdue semester loan items (w/status 15) **opted-in campuses only xx_overdues_15 CUN50
Triannually (Jan & July 24th, June 15th) Open Monograph Orders (all campuses, to prepare in advance for FYE) xx_fye_mono CUN50
Biannually (in Jan & Jul on 3rd) Report of new & updated catalog records by cataloger [com-03] ctlg_act CUN01
Biannually (in Jan & Jul on 3rd) Items with status 'Missing in Transit' **opted-in campuses only xx_items_MT CUN50
Biannually (April / May, & June on 24th) Unpaid Invoices (all campuses, for FYE) xx_unpaid_inv CUN50
Biannually (April, May, & Nov 24th / June 15th ) Open Serials Orders (all campuses, for FYE) xx_fye_serials CUN50
Biannually (April, May & Nov 24th / June 15th) Open Standing Orders (all campuses, for FYE) xx_fye_stand CUN50
Annually (June 24th ) Items Not Linked to Holdings xx_item_unlink_holding CUN50
Annually (June 24th) Orders by Vendor with totals [2 reports - detailed and summary versions] **opted-in campuses only xx_inv_vend_ordnum_<date> and xx_inv_vend_sum_<date> CUN50
Annually (July 3rd) FYE Statistics: Acquisitions & Circulation CUNY-wide related statistics for ACRL and IPEDS surveys xx_clics_loans, cuny_loan_count_<date>, item_new_count_<date>, item_physical_count_<date>, item_total_count_<date>, bib_all_count_<date>, physical_type_count_<date>, mono_order_new_count_<date> CUN50
Annually (July 24th) Titles without items XX_titles_no_item CUN50