Page History

All Reports

missing_or_lost_items

patron_requests_by_type_and_status

services_usage

daily_approved_invoice_exported

daily_appr_inv_vendor

payable_inv_not_fed_notes

borrow_direct_interlibrary_loan_recalls

This query finds books that are on loan to BD and ILL, were recalled and are now overdue

Borrow_direct_interlibrary_loan_overdue_items

ytd_acct_bal_by_ledger_univ_acct

approved_invoices_bib_data

sum_appr_inv_ledger_scct

funds_and_teams_with_expense_class

funds_and_teams

BD_ILL_loans_to_Cornell_patrons

ILL_BD_items_lent_to_others

ILL_BD_counts_loaned_to_others

BD/ILL loans and renewals counts of items loaned BY CUL to others (CUL is LENDER)

ILL_BD_counts_borrowed_by_CUL

ILL and BD counts of items where CUL is the BORROWER

split_funds

laptop_circ_counts

This query counts laptop circs and renewals by library, date, loan type, and laptop type (Mac or PC).  Also
counts how many laptops were used on any given day.

loans_and_renewals

orig_locs_for_phys_collections_no_library_charges

This

query

finds

ceased

or

cancelled

titles

at

the

holdings

level

for

a

specified

owning

library

and

LC

class,

and

shows

if

there

are

holdings

at

the

Annex.

Results

will

include

any

title

(of

any

holdings

type)

that

has

a

holdings

receipt

status

or

holdings

note

that

indicates

the

title

is

no

longer

received

or

is

ceased

or

cancelled.

This

query

finds

ceased

or

cancelled

titles

at

the

item

level,

for

a

specified

owning

library

and

LC

class,

and

shows

if

there

are

holdings

at

the

Annex.

Results

will

include

any

title

(of

any

holdings

type)

that

has

a

holdings

receipt

status

or

holdings

note

that

indicates

the

title

is

no

longer

received

or

is

ceased

or

cancelled.

This

query

provides

item

counts

of

physical

materials,

by

format

type.

It

excludes

microforms

(counted

separately).

This

query

provides

counts

of

unique

titles

(instances)

of

physical

items,

by

format

type.

It

excludes

microforms

(counted

separately).

This

query

provides

counts

of

microform

titles,

by

format

type.

This

query

provides

counts

of

ematerials,

by

format

type.

Formats

are

taken

from

948

field,

and

if

missing

then

taken

from

the

stat

code,

and

if

both

these

fields

are

missing,

formats

are

taken

from

the

MARC

format

code.

Titles

with

multiple

codes

are

assinged

based

on

the

priority

listed

in

the

CASE

clause.

metadb_key_counts

This query counts instances, holdings, items, loans, srs marctab instances, srs marctab records with "001" fields, srs marctab records with "999" fields that include "i" subfields, and srs record instances on the Metadb database. 

approvals_and_firm_orders

This query finds all orders (not just approvals) showing the "bill to" and "ship to" locations in the purchase order or invoice.

funds_for_stewardship

This query was modified from CR134 to accommodate alumni affairs needs for information on stewarded funds. It provides the list of approved invoices within a date range along with primary contributor name, publisher name, publication date, publication place, vendor name, LC classification, LC class, LC class number, 

finance group name, vendor invoice number, fund details, purchase order details, language, instance subject, fund type, and expense class.

lts_receiving

TS Acquisition Statistic Dashboard, LTS Receiving Story

This report gets serials received by LTS personal, on which day it was received, with bill_to location "Law Technical Services not included", 

item format as "Physical, receiving status as "received", po_number, po_number prefix, order_format, ship_to location

inst_updated_date

This query pulls the updated_by_userid and the updated_date field data from the inventory instance record JSONB data array. This data is then joined to the MARC 245/a field to get the instance title and instance HRID.

adc_location_translation_table

CR233

and

MCR233

is

used

to

help

update

the

lm_adc_location_translation_table.

It

pulls

location

code,

location

name,

and

shelving

location

names

data

from

FOLIO’s

inventory_locations

and

inventory_libraries

tables,

and

corresponding

data

from

the

lm_adc_location_translation

table.

In

Excel,

one

can

then

ensure

the

translation

table

data

matches

that

from

the

FOLIO

tables.

get_instance_records

This report uses metadb function and gets MARC record field content for a particular subfield. After function is created it can be called by using provided call statement example at the end of the report.

metadb_key_created_counts_date_series

This query counts holdings, instances, items, and srs_records, then displays each set of counts in a date series.

calendar_settings_by_service_point_and_semester

This query displays the calendar settings for a given service point and semester. Service points using a "Universal" calendar.

clean_up_100e

This report gets 100 field subfiled "e" value to check for the wrongly entered entries of the subfield.

loan_policies_used_in_laptop_charges

This

query

can

be

used

for

the

annual

data

collection

to

see

which

loan

policy

types

units

used

for

laptop

charges,

how

frequently.

create_circ_snapshot

Creates the initial snapshot of loans, capturing patron demographics for each circ tranasaction

update_circ_snapshot

This query creates the "insert into" portion of the circ_snapshot4 query. Updates the file created by MCR403.

previous_day_appr_vouchers

This dashboard query creates a list of vouchers approved the previous day. Used in FBO Daily Reports dashboard