Listed below are the available custom reports written by the LOUIS staff.

Acquisitions

Booking

Catalog

Cataloging

Cataloging/acquisitions

Circulation

Reserve

Serials

User

Other

Acquisitions

Source Name	Brief Description	STATUS
ia3025	This report sets the load date of selected orders from NEVER to TODAY. By updating the load date, iLink will no longer display the ON ORDER or RECEIVED message. The API transaction in the script is hardcoded with the OLOL library. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list	Production
lt3025	This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for sites who have multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list	Training
lu3025	This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for Southeastern who has multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list	Production
lw3025	This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for sites who have multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list	Training
no3025	This report sets the load date of selected orders from NEVER to TODAY. By updating the load date, iLink will no longer display the ON ORDER or RECEIVED message. The API transaction in the script is hardcoded with the UNO library. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list	Production
sl3025	This report sets the load date of subscription orders to TODAY if the load date is NEVER. It is used to load subscription orders from prior fiscal years. This program was written for Southeastern who has multiple orderlines for an orderid. By updating the load date, in iLink the message which displays the number of copies on order is changed to reflect the current number of copies on order. This report is based on the Sirsi delivered report List Orders Distribution (distlist). The report output remains the same as the Sirsi delivered report. INPUT: vendor, vendor cycle, order, orderline, distribution OUTPUT: updates the date loaded to TODAY, outputs the same report as List Orders Distribution (distlist) SORT OPTIONS: order ID, vendor ID, packing list	Production
lu3030	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: title, tag001, tag022, library, call number, amount paid, date paid, fiscal cycle total amount paid, order type. SORT OPTIONS: none	Production
lu3047	This report lists unlinked orders. INPUT: orderline, callnumber, order selection criteria. OUTPUT: tab delimited file containing these fields: library, fiscal cycle, order ID, order type, title SORT OPTIONS: None.	Production
lu5000	This report is an exact duplicate of the bibload report, with one difference: this one flips the flexkeys from the 020 (ISBN) to the 035 (OCLC number) for the records. As a result, this report is unique to an LSU process. The process involves 3 steps: 1) load brief bib records from YBP creating the flexkey from the 020 (ISBN) 2) Load order records that link to the YBP records 3) overlay the brief YBP records with full marc records from OCLC matching on the flexkey (ISBN) and then change the flexkey from the ISBN to the OCLC number. This report MUST BE RUN AS STEP 3 IN ORDER TO CHANGE THE FLEXKEY FROM 020 (ISBN) TO 001 (OCLC).	Test
ax5001	This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id	Production
lt5001	This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id	Production
lu5001	This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id	Production
lw5001	This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id	Production
ni5001	This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id	Production
no5001	This report outputs a tab-delimited file and a formatted report. It is a copy of the Sirsi delivered report fundcyclelist with the addition of a tab-delimited file. INPUT: Selection criteria includes fund and fundcycle OUTPUT: The original formatted Sirsi report and a tab-delimited report. The first record in the file shows the fields and their order in the tab-delimited file: fundcycle key, fund library, fund id, fund name, fund level1, fund level2, fund level3, fund level4, account, fund key, fiscal cycle, amount allocated, amount invoiced, unextended amount ordered, amount encumbered, amount paid SORT OPTIONS: fund, fund id	Production
ax5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
lt5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
lu5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
lw5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
mn5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
ne5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
no5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
sl5004	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: author, title, flexkey, tag001, format, item id, total charges, call number, fund library, fund id, fund name, level1, level2, level3, level4, acct number, funding total amt paid, funding date paid, funding type (except multiple funding), holding code, orderline number, orderline amt paid, orderline extended price, orderline date ordered, fiscal cycle, p.o.number, order type, item type, category1, category2, home location, item library SORT OPTIONS: none	Production
ia5007	Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none	Production
lt5007	Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none	Production
lu5007	Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none	Production
ne5007	Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none	Production
no5007	Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for distribution, vendor, and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, distribution, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Order ID,Order Type,Line Number,Description,Fund ID,Account Number,Level 1,Level 2,Level 3,Level 4,Amt Encumbered,Amt Invoiced,Amt Paid,Date Paid,Date Received,Date Created,Date Modified,Vendor SORT OPTIONS: none	Production
ax5008	This report outputs a tab-delimited file only. It is similar to ig5004, except ax5008 outputs less fields, but does include year published and publisher (260 tag). INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT:The first record in the file shows the fields and their order in the tab-delimited file: author, title, publisher (260 tag), year of publication, item id, call number, fundname, level1, level2, level3, level4, funding total amount paid, funding date paid, orderline amount paid, orderline extended price, orderline date ordered, fiscal cycle, p.o. number, item type Sort Options: call number/title/author, title/author/call number	Production
no5008	This report outputs a tab-delimited file only. It is similar to ig5004, except ax5008 outputs less fields, but does include year published and publisher (260 tag). INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT:The first record in the file shows the fields and their order in the tab-delimited file: author, title, publisher (260 tag), year of publication, item id, call number, fundname, level1, level2, level3, level4, funding total amount paid, funding date paid, orderline amount paid, orderline extended price, orderline date ordered, fiscal cycle, p.o. number, item type Sort Options: call number/title/author, title/author/call number	Production
lu5009	This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none	Production
mn5009	This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none	Production
sl5009	This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none	Production
ax5010	Based on Sirsi delivered report: List Funded Orders. This report also has selection criteria for vendor and vendorcycle. INPUT: Selection criteria includes fund, funding, orderline, order, vendor, vendorcycle. OUTPUT: This report outputs a tab-delimited file only. The first record in the file shows the fields and their order in the tab-delimited file: Fund ID, Budgeted, Encumbered, Invoiced, Paid, Free Balance. SORT OPTIONS: none	Development
bp5011	This report outputs a tab-delimited file only. Selection criteria includes fund, fundcycle, funding, orderline, order, title, and copy. The report shows the list price of a title (list price will be used to charge users) and the unit price which is in the orderline. List price is calculated by dividing the unit price by the parts-in-set field. DELIVERED SCRIPT: fundtitlecost.pl INPUT: fund, fund cycle, funding, orderline, order, title, and copy OUTPUT:item id,title,pubyear,fund id,date received,order id,orderline number,vendor id,unit price,list price,parts-in-set SORT OPTIONS: none	Production
mn5012	This report creates a new user order notice (called acqcatconfirm) with the following notice text: "The items which you recommended for purchase have been received and are available in the library. The following is a list of what has been received." Selection criteria includes title and distribution as well as orderline. DELIVERED SCRIPT: User Order/Request Notice (acqnotice.pl) INPUT: orderline, title, distribution OUTPUT: notices with the above text as well as all output options in delivered report	Production
sl5012	This report creates a new user order notice (called acqcatconfirm) with the following notice text: "The items which you recommended for purchase have been received and are available in the library. The following is a list of what has been received." Selection criteria includes title and distribution as well as orderline. DELIVERED SCRIPT: User Order/Request Notice (acqnotice.pl) INPUT: orderline, title, distribution OUTPUT: notices with the above text as well as all output options in delivered report	Production
lt5013	This report is a duplicate of biborderload.pl. However, whereas the delivered report does not output the file of matched bib records, this custom report does output a list of matched bib records in the log of the finished report. Selection criteria remains the same as the delivered report. DELIVERED SCRIPT: biborderload.pl INPUT: Selection criteria includes an input file menu, title control processing options, order. OUTPUT: This report loads bibliographic records and extracts a flat ASCII text file of order records that can be loaded into the Unicorn order database. SORT OPTIONS: none	Production
lu5013	This report is a duplicate of biborderload.pl. However, whereas the delivered report does not output the file of matched bib records, this custom report does output a list of matched bib records in the log of the finished report. Selection criteria remains the same as the delivered report. DELIVERED SCRIPT: biborderload.pl INPUT: Selection criteria includes an input file menu, title control processing options, order. OUTPUT: This report loads bibliographic records and extracts a flat ASCII text file of order records that can be loaded into the Unicorn order database. SORT OPTIONS: none	Production
lw5013	This report is a duplicate of biborderload.pl. However, whereas the delivered report does not output the file of matched bib records, this custom report does output a list of matched bib records in the log of the finished report. Selection criteria remains the same as the delivered report. DELIVERED SCRIPT: biborderload.pl INPUT: Selection criteria includes an input file menu, title control processing options, order. OUTPUT: This report loads bibliographic records and extracts a flat ASCII text file of order records that can be loaded into the Unicorn order database. SORT OPTIONS: none	Production
dl5014	This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none	Production
lw5014	This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none	Production
mn5014	This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none	Production
ns5014	This report outputs catalog and call number information for those titles that DO NOT have an order attached to them. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, date created, date cataloged, call number, class scheme, created by SORT OPTIONS: none	Production
lu5015	This report is identical to ig5014.pl except it outputs an additional field: title control number. It outputs catalog and call number information for those titles that DO NOT have an order attached to them, as does ig5014. INPUT: title, call number OUTPUT:tab-delimited file with the following fields: title, title control number, date created, date cataloged, call number, call number library, class scheme, created by SORT OPTIONS: none	Production
ax5016	This report is a copy of ig5004.pl. The only difference is that this report also outputs the NOTE field in the orderline. It also outputs a tab-delimited file. Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. The first record in the file shows the fields and their order in the tab-delimited file:author,title,flexkey,tag001,format,itemid,total charges,callnumber,fund library,fundid,fundname,level1,level2,level3,level4,acct number,funding total amt paid,funding date paid,funding type,holding code,orderline number,orderline amt paid,orderline ext price,orderline date ordered,orderline note field,fiscalcyc,p.o.number,ordertype,item type,category1,category2	Production
sl5016	This report is a copy of ig5004.pl. The only difference is that this report also outputs the NOTE field in the orderline. It also outputs a tab-delimited file. Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. The first record in the file shows the fields and their order in the tab-delimited file:author,title,flexkey,tag001,format,itemid,total charges,callnumber,fund library,fundid,fundname,level1,level2,level3,level4,acct number,funding total amt paid,funding date paid,funding type,holding code,orderline number,orderline amt paid,orderline ext price,orderline date ordered,orderline note field,fiscalcyc,p.o.number,ordertype,item type,category1,category2	Training
lu5017	This report updates the Unit Price in the orderline from a dollar amount to a zero amount. INPUT: Selection criteria includes orderline, order. OUTPUT: This report outputs a tab-delimited file. The first record in the file shows the fields and their order in the tab-delimited file: Description, Unit Price Before Update, Order ID SORT OPTIONS: none	Production
mn5018	This report sends a user a notices that the items the user requested could not be satisfied. DELIVERED SCRIPT: Based on: User Order/Request Notice (acqnotice.pl) INPUT: Cancel selections. OUTPUT: notices as well as all output options in delivered report	Production
ia5019	This report is a copy of lu5009.pl except this report does not output holding codes. It outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none	Production
lu5019	This report is a copy of lu5009.pl except this report does not output holding codes. It outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, callnum, fund ID, fund levels 1-4, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid) SORT OPTIONS: none	Production
lw5020	This report outputs catalog, vendor, and order information. One call number per order record is output - the one to which the order record is linked. INPUT: fund, fundcycle, funding, order, orderline, vendor, title, call number OUTPUT:tab-delimited file with the following fields: author, title, 260 tag, callnum, fund ID, fund levels 1-4, holding code, PO number, orderline number, fiscal cycle, vendor, orderline unit price (encumbered), orderline amount (paid), order type SORT OPTIONS: none	Production
ni5021	This report outputs acquisitions and bibliographic data to a tab-delimited file only. INPUT: Selection criteria includes fund, fundcycle, funding, orderline, order, title, call number, and copy. OUTPUT: The first record in the file shows the fields and their order in the tab-delimited file: title, tag001, tag022, library, call number, amount paid, date paid, fiscal cycle total amount paid, order type, fund id. SORT OPTIONS: none	Production
lw5025	Originated from invdetail.pl, a custom report Margaret Pelfrey at Sirsi, wrote for LOUIS. Differences: no search box for invoice ids; outputs order ids in addition to original output; invoice ids begin with apostrophe to allow leading zeroes to display correctly in a spreadsheet. INPUT: Selection criteria includes invoice, invoice line, fund, fundcycle. OUTPUT: Tab-delimited file with Invoice ID, Invoice Date, Invoice Create Date, Vendor ID, Invoice Line Type, Invoice Line Number, Invoice Line Amount, Amount Invoiced, Amount Paid, Library, Fund ID, Account Number, Fund Level 1, Fund Level 2, Fund Level 3, Fund Level 4, Order ID.	Production
lu5026	This program will FTP invoice files from YBP to Xfer, add an extension to the files in Xfer and rename the files on YBP's server.	Production
lu5027	This report will move a selected EDI invoice file from Xfer to Edi/Incoming.	Production
no5030	This report outputs a comma delimited file of invoice data which will be sent to UNO's business office. INPUT: invoice OUTPUT: record type(UNO field),vendor id, invoice amount, freight amount (UNO field), vendor name, invoice number, invoice date, speedkey (UNO field), account (extended info field in invoice), bookstore PO (UNO field) SORT OPTIONS: none	Production
ax5031	This report is a copy of ig5016.pl. The only difference is that this report does not output item information. It also outputs a tab-delimited file. Selection criteria includes fund, fundcycle, funding, distribution, orderline, order, title, and call number. The first record in the file shows the fields and their order in the tab-delimited file: author,title,flexkey,callnumber,fundid,level3,level4,funding total amt paid,holding code,orderline date ordered,extended info field,fiscalcyc,p.o.number.	Production

Booking back to top

Source Name	Brief Description	STATUS
lu5003	This report outputs a pipe-delimited file and a formatted report. It is a copy of the Sirsi delivered report List Booking with the addition of a pipe-delimited file. INPUT: Booking OUTPUT: Pipe Delimited SORT OPTIONS: patron booking start/user name, title/author, user ID, user name, call number, library/call number, library/title/author, library user ID or library/user name	Production

Cataloging back to top

Source Name	Brief Description	STATUS
br1014	North American Title Count for LC, LCPER. Counts titles. INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none	Production
fl1014	North American Title Count for LC, LCPER. Counts titles. INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none	Production
ia1014	North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
le1014	North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
lt1014	North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
lu1014	North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
lw1014	North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
mn1014	North American Title Count for LC, LCPER. Counts titles. INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none	Production
ne1014	North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
sc1014	North American Title Count for LC, LCPER. Counts titles INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
sl1014	North American Title Count for LC, LCPER. Counts titles. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of titles	Production
lu1015	North American Title Count for Dewey NOTE: This report converts Dewey to LC and outputs the number of titles in LC call number ranges. It is not a report which outputs the number of titles in Dewey call number ranges. INPUT: Selection criteria for title, call number and item. OUTPUT: Tab-delimited files with the folowing fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none	Production
sl1015	North American Title Count for Dewey NOTE: This report converts Dewey to LC and outputs the number of titles in LC call number ranges. It is not a report which outputs the number of titles in Dewey call number ranges. INPUT: Selection criteria for title, call number and item. OUTPUT: Tab-delimited files with the following fields: line number, subject area, NATC line number, call number range, number of titles SORT OPTIONS: none	Production
lw1016	North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sl1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range.	Production
ne1016	North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in ne1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range.	Production
no1016	North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sl1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range.	Production
sc1016	North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sc1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range.	Production
sl1016	North American Title Count Counts items within call number ranges (not titles) for LC, LCPER. The call number ranges used are the same ones in sl1014.pl. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items per call number range.	Production
bp1017	North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none	Production
dl1017	North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none	Production
gu1017	North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none	Production
lu1017	North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none	Testing
ni1017	North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none	Production
sl1017	North American Title Count for Dewey. Dedups catalog keys. This report counts only Dewey classification scheme. DELIVERED SCRIPT: none INPUT: Selection criteria for title and item. OUTPUT: Tab-delimited files with the folowing fields: subject area, Dewey call number range, number of titles SORT OPTIONS: none	Production
ne1018	This report is based on ne1016.pl, North American Title Count for LC, LCPER, which counts items. It also outputs the average years of publication and the number of charges per LC classification subclasses. INPUT: title, call number, copy selections OUTPUT:tab-delimited file for spreadsheet which includes line number, subject area, NATC line number, call number range, number of items, average years of publication, total number of charges	Training
ns3003	DELIVERED SCRIPT: None INPUT: catalog, callnumber, and item selection criteria OUTPUT: Holdings in Ingenta's specified fixed length record format.	Production
lu3008	Extracts serials holdings for RAPID. Enables selections for location. The user is responsible for transfering the output file to RAPID company. The selection criteria in this report narrows down selections to the title level only. If you want the holdings for a specific library and location the report takes the item library and location selection criteria and looks for these values in the 852 tag of holdings data. This is the only way to output holdings for a specific library and location. For example: 852|\bMIDL-MAIN\cSTACKS\hPS4637.43|866|\81\v.23-34.	TESTING
dl3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
lt3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
lu3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
mn3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
ne3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. DELIVERED SCRIPT: titleuselst INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
no3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. DELIVERED SCRIPT: titleuselst INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
sc3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. DELIVERED SCRIPT: titleuselst INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
sl3012	Program is a copy of Titles Used/Unused (titleuselst) with the addition of call number as output and also as sorting option. Read the Help on titleuselst for a full description. INPUT: title, call number, copy, transaction OUTPUT: title, author, library, usage count within library, call number, and total usage count SORT OPTIONS: descending, ascending, title/author, call number	Production
ax3013	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number	Production
ia3013	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number	Production
lu3013	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number	Production
lw3013	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number	Production
ne3013	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id, call number, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library SORT OPTIONS: author/title, title/author, call number	Production
br3014	This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number	Production
lu3014	This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number	Production
no3014	This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number	Production
sc3014	This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number	Production
sl3014	This report is identical to lu3013.pl, but also include these fields: item create date, charges, inhouse charges, total charges, last use date. INPUT: title, call number, copy OUTPUT: item id, call number, shelving key, author, title, flexkey, publication year, create date, item category 1, item category 2, home location, current location, permanent or temporary, item type, library, item createdate, charges, inhousecharges, total charges, lastuseddate, extended info DELIVERED SCRIPT: List Bibliography (bibliography) SORT OPTIONS: author/title, title/author, call number	Production
lz3015	This program will FTP MARC files from Ebsco on a monthly basis and copy them into each site's Marcimport directory. This runs for the sites who have their own A to Z with MARC subscription. The site will then load their A-Z MARC file into their catalog via the Sirsi bibload report.	Production
lu3017	This report is a copy of Sirsi delivered report List Items. It outputs a tab-delimited file. The first record in the file shows the fields and their order in the tab-delimited file. DELIVERED SCRIPT: List Items (itemlist) INPUT: call number, copy OUTPUT: flexkey, title, entry 001, entry 022, call number, itemid, library, item type, item category 1, item category 2, create date, charges, inhouse charges, total charges, last use date, home location, current location, extended information: CIRCNOTE,PUBLIC,STAFF,SUFFIX. SORT OPTIONS: title, flexkey	Production
sa3017	This report is a copy of Sirsi delivered report List Items. It outputs a tab-delimited file. The first record in the file shows the fields and their order in the tab-delimited file. DELIVERED SCRIPT: List Items (itemlist) INPUT: call number, copy OUTPUT: flexkey, title, entry 001, entry 022, call number, itemid, library, item type, item category 1, item category 2, create date, charges, inhouse charges, total charges, last use date, home location, current location, extended information: CIRCNOTE,PUBLIC,STAFF. SORT OPTIONS: title, flexkey	Production
lz3018	This program(aka ECAT) FTPs a MARC file from Ebsco on a monthly basis and copies it to each site's Marcimport directory to be loaded into the catalogs via the Sirsi bibload report. Processing has been added for some sites prior to the load in order to remove bib records that contain an 856 field for specified resources for which they do not have access This runs for the sites who do not have their own A to Z with MARC subscription.	Production
lw3019	This report outputs a tab-delimited file with bib data and subject headings (subject headings are from 6xx entry ids). Note: if a record has more than one 6xx entry id, only the first 2 6xx entry ids are displayed in the output. The first record in the file shows the fields and their order in the tab-delimited file: Subjects, Author, Title, Call Number, Location DELIVERED SCRIPT: List Bibliography (bibliography.pl) INPUT: title, call number, item OUTPUT:tab-delimited file with subject, author, title, call number and home location	Production
ne3019	This report outputs a tab-delimited file with bib data and subject headings (subject headings are from 6xx entry ids). Note: if a record has more than one 6xx entry id, only the first 2 6xx entry ids are displayed in the output. The first record in the file shows the fields and their order in the tab-delimited file: Subjects, Author, Title, Call Number, Location DELIVERED SCRIPT: List Bibliography (bibliography.pl) INPUT: title, call number, item OUTPUT:tab-delimited file with subject, author, title, call number and home location	Training
bp3020	Extracts serials holdings information. DELIVERED SCRIPT: none INPUT: item, serial control OUTPUT: ISSN, Title, Call number, Holdings, 852 Entry id SORT OPTIONS: none	Production
lu3021	This report outputs a tab-delimited file with bib data with the following entry ids: flexkey, all 856 entry ids. The first record in the file shows the fields and their order in the tab-delimited file: Flexkey, 856 Entries. This report is based on the delivered report catlist. Review records are excluded from output. DELIVERED CODE: catlist.pl INPUT: catalog OUTPUT: flexkey, 856 entries SORT OPTIONS: flexkey, 856 entry	Production
lu3032	This report is based on Sirsi delivered report List Bibliography (bibliography.pl). It outputs a tab-delimited file with the following fields: flexkey, title, 856 entres. INPUT: title,copy,callnum OUTPUT: flexkey, title, 856 entries SORT OPTIONS: flexkey, title, 856 entries	Production
br3035	Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title.	Production
lt3035	Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title.	Production
ne3035	Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title.	Production
ns3035	Extracts ISSN & title and outputs a tab-delimited report that can be saved into a file and sent to a vendor. Unique ISSNs will be output. Titles with no ISSN will be excluded. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISSN and title.	Production
dl3037	This report is based on the delivered report: Edit Item Types by Call Number. This report will allow the selection criteria of title, call number, and copy to be used to change the item type of copy records. Rebuildtext must be run after this report in order to pick up the changes to items. lt3037.pl is password protected. DELIVERED SCRIPT: calledititype INPUT: title, call number, copy, value modification of item type OUTPUT: tab-delimited file with itemid, original item type	Production
lt3037	This report is based on the delivered report: Edit Item Types by Call Number. This report will allow the selection criteria of title, call number, and copy to be used to change the item type of copy records. Rebuildtext must be run after this report in order to pick up the changes to items. lt3037.pl is password protected. DELIVERED SCRIPT: calledititype INPUT: title, call number, copy, value modification of item type OUTPUT: tab-delimited file with itemid, original item type	Production
mn3037	This report is based on the delivered report: Edit Item Types by Call Number. This report will allow the selection criteria of title, call number, and copy to be used to change the item type of copy records. Rebuildtext must be run after this report in order to pick up the changes to items. mn3037.pl is password protected. DELIVERED SCRIPT: calledititype INPUT: title, call number, copy, value modification of item type OUTPUT: tab-delimited file with itemid, original item type	Production
ax3038	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none	Production
bp3038	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none	Production
ne3038	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none	Production
no3038	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none	Production
sh3038	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (pupblisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library SORT OPTIONS: none	Production
lu3039	This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None	Production
mn3039	This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None	Production
ne3039	This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None	Production
no3039	This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None	Production
sc3039	This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None	Production
sl3039	This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None	Production
ax3042	This report edits items globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Training
br3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
gu3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
lt3042	This report edits items globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
lu3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
ne3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
no3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
sl3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
sn3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
vw3042	This report edits items globally. It has a search box which uses the keyword index. INPUT: catalog, call number, item OUTPUT: updates Item Type, Home Location, Item Category 1, Item Category 2, or copy shadowing for all items matching the title, call number, or copy search selections. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
sl3043	This report outputs a tab-delimited file. It is a copy of the Sirsi delivered report bibliography. The first record in the file shows the fields and their order in the tab-delimited file. INPUT: title, call number, copy OUTPUT: tab delimited output SORT OPTIONS: none	Production
lu3046	Extracts keys for exporting marc records. DELIVERED CODE: derived in part from prepmarcexp.pl and bibliography.pl INPUT: Identical to prepmarcexp except the field in which to enter item ids is replaced with a field to enter a search string. Added selection criteria: copy selection, callnum selection, title selection. If you want to enter item ids you must use the delivered report. OUTPUT: keys for export utility in the Xfer directory SORT OPTIONS: none	Production
lw3046	Extracts keys for exporting marc records. DELIVERED CODE: derived in part from prepmarcexp.pl and bibliography.pl INPUT: Identical to prepmarcexp except the field in which to enter item ids is replaced with a field to enter a search string. Added selection criteria: copy selection, callnum selection, title selection. If you want to enter item ids you must use the delivered report. OUTPUT: keys for export utility in the Xfer directory SORT OPTIONS: none	Production
gu3048	This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
lu3048	This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
ne3048	This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
sl3048	This report allows the circ flag on items to be edited globally. It has a search box which uses the keyword index. It also has an update database buttom which allows the report to run with or without updating the database. INPUT: catalog, call number, item OUTPUT: updates the circulate flag for all items matching the title, call number, or copy search selections. Items that are checked out will be skipped. Editing is done via API transactions, so changed items are reindexed almost immediately. SORT OPTIONS: title/author,call number, item id	Production
sc3050	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: Outputs 3 different reports with these fields: call number, author, title, number of call numbers, number of copies, price Report 1: List of Titles and Call Numbers with No Copies Report 2: List of Titles with One Call Number and One or More Copies Report 3: List of Titles with Multiple Call Numbers Each with One or More Copies	Production
lw3053	This report looks at titles that have a 599 entry. It outputs the title, title control number, the data in the 599 and the data in the 362 if the 362 entry exists. The 599 is a local field. DELIVERED SCRIPT: List Entries (entrylist.pl) INPUT: title OUTPUT:tab-delimited file with title control number, title, data in 599, data in 362. If no 362 is in bib record, the field is blank.	Production
dl3054	This report looks at titles that have a 999 entry. It outputs the title and the data in the 999. DELIVERED SCRIPT: none INPUT: call number, title OUTPUT:tab-delimited file with title (245) and data in 999. If no 999 is in bib record, the record is not output.	Production
lm3055	This report looks at titles that have a 556 entry. It outputs the title, and the data in the 556 DELIVERED SCRIPT: List Entries (entrylist.pl) INPUT: title OUTPUT:tab-delimited file with title, data in 556.	Production
lw3056	Extracts ISBN, title, and date created and outputs a tab-delimited report. Unique ISBNs will be output. Titles with no ISBN will be excluded. In the output each ISBN is prefaced by an apostrophe(') so that Excel will retain the leading zeroes. View or print the finished report in WorkFlows with Excel. Check off "View Result", but uncheck "Format Report" and "View Log". INPUT: Selection criteria includes title and copy. OUTPUT: Tab-delimited report with ISBN, title, and date created.	Production
le3060	Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections.	Production.
lt3060	Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections.	Production.
lw3060	Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections.	Production.
mn3060	Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections.	Production.
ns3060	Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections.	Production.
sa3060	Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections.	Production.
sc3060	Originated from catitemlist.pl from Michael Ridinger from INFOhio. Produce a shelflist in one of three formats: Brief, Long and Spreadsheet. This report can take quite a while to run depending on your selections.	Production.
lw3062	INPUT: text from search string gadget, title, call number, item info OUTPUT: This report will change the Current Location Status of MISSING copies to DISCARD for selected records.	Production
ns3062	INPUT: text from search string gadget, title, call number, item info OUTPUT: This report will change the Current Location Status of MISSING copies to DISCARD for selected records.	Production
lu3065	This report is a duplicate of additemlist.pl which is for the New Books List which appears in iLink. This script has the addition of call number selection. DELIVERED SCRIPT: additemlist.pl INPUT: selorder, selcatalog, selitem, selcallnum OUTPUT: same as delivered script SORT OPTIONS: None.	Production
lt3070	Originated from globaledit.pl, this report also includes call number and item selection criteria. DELIVERED SCRIPT: globaledit.pl INPUT: Selection criteria includes title, call number and copy. OUTPUT: Same output as delivered globaledit. SORT OPTIONS: none	Production
sl3071	in progress	Production
ns3072	This report is a copy of titleuselst (Titles Used/Unused). This report takes a while to run even if compare database is NO. DELIVERED SCRIPT: titleuselst.pl INPUT: title, call number, copy, transaction OUTPUT: tab-delimited file with title, author, publication year, library, flexkey, tag 022, usage count within library, call number, and total usage count SORT OPTIONS: None	Production
ns3073	This report is a copy of List Titles. DELIVERED SCRIPT: catlist.pl INPUT: title OUTPUT: a text file with title from subfields a and b only SORT OPTIONS: None	Production
lm3074	This report outputs a tab-delimited file with bib data and subject headings from 653 and 650 entry ids and where the 650 entries have non-zero indicators. 653 entry ids are output regardless of indicator values. The first record in the file shows the fields and their order in the tab-delimited file: Subjects, Title DELIVERED SCRIPT: none INPUT: title, call number, item OUTPUT:tab-delimited file with title, entry id, and subject	Production
ns3075	This report is a copy of List Titles. DELIVERED SCRIPT: catlist.pl INPUT: title OUTPUT: a text file with title from subfields a, b, n, p only SORT OPTIONS: None	Production
ax3076	Program is a copy of List Bibliography (bibliography), but it outputs a tab-delimited file. DELIVERED SCRIPT: bibliograpy INPUT: title, call number, copy OUTPUT: item id; call number; author; title; flexkey; entry ids 050, 082, first 650, first 856, 260 (publisher); publication year; create date; item category 1; item category 2; home location; current location; permanent or temporary; item type; library; is item checked out; in-house charges; total charges; last used date SORT OPTIONS: none	Production
bp3077	IMPORTANT! This report will remove all 863 fields when update option is selected. This custom report allows you to enter a flexkey and a year in the search tab. The year is found in subfield i of the 863. This report will remove 863's in batch. In the search field make sure the flexkey and year are entered in this format: flexkey=year, example: i0747-4733=2005. DELIVERED SCRIPT: none INPUT: Selection criteria includes search tab, catalog, and an update option. OUTPUT: Tab formatted list of titles and 863's. SORT OPTIONS: none	Production
mn3081	This report outputs a list of ISBN's. McNeese will send the list to the vendor ParaText Reference who will attach their holding to searches. The list will be put in Xfer. DELIVERED SCRIPT: none INPUT: Selection criteria includes catalog, call number, item. OUTPUT: list of ISBN's.	Production
sl4000	The "Set Inventory Date" was customized by Christopher Sterback at Rutgers to be able to select on call number and title. This report can be used to set inventory date based on call number range. DELIVERED SCRIPT: initinv.pl INPUT: title, call number, item OUTPUT: same output as the delivered report SORT OPTIONS: none	Production
lu5006	Analyzes all index policy settings INPUT: Policies file, OUTPUT: Output is simply a tab-delimited text file in the form of formatname|indextype (KIND or BIND)|indexname|fieldname|field description|subfields SORT OPTIONS: None	Production
sc5024	This program creates a tab-delimited file of items. The tab-delimited report contains the price found in the item record. DELIVERED SCRIPT: bibliograpy INPUT: item, catalog, call number OUTPUT: current location, itemtype, library, pubyear, Dewey call number, item price, Title	Production
sn5024	This program creates a tab-delimited file of items. The tab-delimited report contains the price found in the item record. DELIVERED SCRIPT: bibliograpy INPUT: item, catalog, call number OUTPUT: current location, itemtype, library, pubyear, Dewey call number, item price, Title	Production
ns7016	This report is a copy of avgpubyrbyityp.pl (Avg Pub Yr By Item Type). There are 4 reports that output average publication year. One each for call number, location, item type, and item category 1. This report combines the selection criteria for all four. The output is the same as the delivered report. DELIVERED SCRIPT: avgpubyrbyityp.pl INPUT: Call number, Item OUTPUT : Same as delivered script: Number of titles read, Non-Zero Pub Years Selected, Average Pub Year, Most Recent, Oldest	Training
sh7017	This report is a copy of "Step 3b) Inventory Date NEVER" (invnever.pl) and is found under the "My Inventory" tab of reports. The original report has this warning which should be observered when running this report: "Be sure that you have scanned all barcodes and uploaded your complete collection to the central Server before running this report. Also, the System Administrator must perform Steps ! and 2, before you run this report." DELIVERED SCRIPT: invnever.pl INPUT: item OUTPUT: tab-delimited file with call number, title, item id SORT OPTIONS: None	Production
bp8001	This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none	Production
dl8001	This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none	Production
lw8001	This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none	Production
sl8001	This report is a copy of Item Statistics (itemstat), but, whereas itemstat provides statistics for all items, this report provides statistics for only the first item which represents a title. Output remains the Sirsi delivered report. INPUT: title, call number, copy OUTPUT: the Sirsi delivered report for itemstat SORT OPTIONS: none	Production
ne9991	This report lists invalid, mis-entered, and mis-scanned item ids as described by ULM. INPUT: Selection criteria is title call number, and item. OUTPUT: tab-delimited file with item id, date item created, call number, title. DELIVERED SCRIPT: none SORT OPTIONS: none	Production
br3064	Selection Criteria: catalog, callnumbers, items. Outputs a pipe delimited file: shelving key | title | price of item. The price is pulled from the item record, not any aquisitions record.	Test/training

Circulation back to top

Source Name	Brief Description	STATUS
sl3006	INPUT: No Selection criteria. OUTPUT:(Format of the report: fixed length fields. Fields:charge date|user id|user name|title|item id|charge code|bill| SORT OPTIONS: None.	Production
lu3009	Extracts user for bills and zeros out bills in batch. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(Format of the report: Pipe Delimited Fields. User id, item type and bill reason. SORT OPTIONS: None.	Production
ns3009	Extracts user for bills and zeros out bills in batch. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(Format of the report: Pipe Delimited Fields. User id, item type and bill reason. SORT OPTIONS: None.	Production
lu3010	Extracts user for bills and zeros out bills in batch. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(Format of the report: Pipe Delimited Fields. User id, item type and bill reason. SORT OPTIONS: None.	Production
br3011	Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode.	Production
dl3011	Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode.	Production
le3011	Prints out one or all user bills. INPUT: Bill, User, Copy, etc. OUTPUT: Item id, library, due date, date billed, bill reason, amount, user id, username, address, zipcode, title, author SORT OPTIONS: User ID, User name and Zipcode	Production
ne3011	Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode.	Production
ni3011	Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode.	Production
rp3011	Prints out one or all user bills. INPUT:(Selection criteria. Bill,User,Copy etc.) OUTPUT:(item id, library, due date, date billed, bill reason, amount, user id, username address, zipcode, title, author.) SORT OPTIONS: User id,User name and Zipcode.	Production
ne3027	Extracts circulation data for auditors into tab-delimited file. Extracts current bills and charges. Report is loosely modelled after "List Users with Bills, Charges" (billchargeuser). INPUT: Bill Selection, Charge Selection, and User Selection. OUTPUT: Name, Userid, Altid, Profile, Bill or Charge, Date, Balance, Billed by, Reason or Location, Call number, Title, Author SORT OPTIONS: none.	Production
le3029	This report is a custom report of cash report per station. INPUT: Transaction in history file.(Selection Criteria: Transaction Selection-->Station,Transaction data range,Command. Bill Selection-->Payment Type) OUTPUT:Format of the report. patron's name, ID, alt ID, time of transaction, payment type, amount, associated item ID and station. SORT OPTIONS: by station.	Production
ne3029	This report is a custom report of cash report per station. INPUT: Transaction in history file.(Selection Criteria: Transaction Selection-->Station,Transaction data range,Command. Bill Selection-->Payment Type) OUTPUT:Format of the report. patron's name, ID, alt ID, time of transaction, payment type, amount, associated item ID and station. SORT OPTIONS: by station.	Production
bp3034	This report is a copy of List Users with Bills,Charges(billusercharge), but only user name and user id are listed. INPUT: bill, user, charge OUTPUT: user name and user id. SORT OPTIONS: user name or user id	Training
sh3036	Derived from List users with charges. INPUT:(Selection criteria: Copy,User,Charge,call number,Title, User Status) OUTPUT:(Format of the report: Pipe Delimited Fields. User ID, User Name, Total number of charges. SORT OPTIONS: User ID, User name.	Training
ia3045	INPUT: Selection Criteria: User id, Charges, Copy, Call number, Title. OUTPUT: This report outputs in columes: user_name, user id, shelving key call number, spine label call number, author, title. SORT OPTIONS: You can sort on User name or user id or author/title or call number (shelving key).	Production
le3045	INPUT: Selection Criteria: User id, Charges, Copy, Call number, Title. OUTPUT: This report outputs in columns: user_name, user id, shelving key call number, spine label call number, author, title. SORT OPTIONS: You can sort on User name or user id or author/title or call number (shelving key).	Production
lw3045	INPUT: Selection Criteria: User id, Charges, Copy, Call number, Title. OUTPUT: This report outputs in columes: user_name, user id, item id, shelving key call number, spine label call number, author, title. SORT OPTIONS: You can sort on User name or user id or author/title or call number (shelving key).	Production