FY 2023 PLS Edit Check Changes_Final.xlsx

XLSX spreadsheet 89 KB Posted Jul 8, 2024

Attached to: Washington State Public Libraries Survey Collection Instrument
Solicitation number: RFP 24-09
Issued by: Adams County, Asotin County, Benton County, Chelan County, Clallam County, Clark County, Columbia County, Cowlitz County, Douglas County, Ferry County, Franklin County, Garfield County, Grant County, Grays Harbor County, Island County, Jefferson County, King County, Kitsap County, Kittitas County, Klickitat County, Lewis County, Lincoln County, Mason County, Okanogan County, Pacific County, Pend Oreille County, Pierce County, San Juan County, Skagit County, Skamania County, Snohomish County, Spokane County, Stevens County, Thurston County, Wahkiakum County, Walla Walla County, Whatcom County, Whitman County, Yakima County, Asotin City, Clarkston City, Clarkston Heights-Vineland CDP, West Clarkston-Highland CDP, Benton City, Chelan City, Chelan Falls CDP, Clallam Bay CDP, Lewisville CDP, Rock Island City, Pacific Beach CDP, Whidbey Island Station CDP, Mercer Island City, Pacific City, Bainbridge Island City, Kingston CDP, Kitsap Lake CDP, Kittitas City, Klickitat CDP, Okanogan City, Anderson Island CDP, Fort Lewis CDP, Fox Island CDP, Herron Island CDP, Ketron Island CDP, North Fort Lewis CDP, Raft Island CDP, Stevenson City, Hat Island CDP, Lake Stevens City, Snohomish City, Spokane City, Spokane Valley City, Puget Island CDP, Garfield Town, Yakima City, Washington

About this file

Written by GovTribe AI · Jul 23, 2024

This document is a Request for Proposals (RFP) issued by the state of Washington to solicit proposals for providing an online, Software as a Service (SaaS) instrument to collect the annual Public Libraries Survey. The survey collection period usually runs from November to late June each year. The RFP covers survey preparation, collection, cleaning, and final submission for the state's "Group 2" libraries. The jurisdictions included in the scope are various counties, cities, and census-designated places within the state of Washington. Proposals are requested, with no specific due date provided. The contract term and any renewal options are not specified.

The RFP does not provide details on pricing terms, set asides, incumbents, funding requirements and sources, or other financial information. The document focuses on the scope of services requested for the annual public library data collection and submission process within the state of Washington.

View the file

Other files

File	Type	Posted
Exhibit D_Trafficking.pdf	PDF	Jul 8, 2024
RFP 24-09 - Amendment No. 1.docx	DOCX document	Jul 8, 2024
Sample Contract Exhibit B SOW.pdf	PDF	Jul 8, 2024
FY 2023 PLS Import Specs_Final.xlsx	XLSX spreadsheet	Jul 8, 2024
PLS FY 2023 Import and Edit File Memo_Final.pdf	PDF	Jul 8, 2024
RFP 24-09 Final.pdf	PDF	Jul 8, 2024
Sample Contract Exhibit A GT@C.pdf	PDF	Jul 8, 2024
WAPublicLibrariesSurveyRFP_Appendix(Demo).docx	DOCX document	Jul 8, 2024
FY 2023 PLS Users Guide_508C.pdf	PDF	Jul 8, 2024
RFP 24-09 - Amendment No. 2.pdf	PDF	Jul 8, 2024
Sample Contract Exhibit C Debarment.pdf	PDF	Jul 8, 2024
Sample Contract Main Section.pdf	PDF	Jul 8, 2024

Show all 12

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Edit Changes FY23

Description of Change	COVID-19 Temp Off	Pubord	Critical	Old Code	Code	Flag Condition	Edit Message	Edit Condition
Turned back on	N	C	N		30425	TOTINCM > 0 and TOTOPEXP > 0 and (TOTINCM / TOTOPEXP < 0.60 or TOTINCM / TOTOPEXP > 1.88)	NONCRITICAL – The ratio of TOTAL OPERATING REVENUE to TOTAL OPERATING EXPENDITURES is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of TOTAL OPERATING REVENUE (administrative entity data element #304) to TOTAL OPERATING EXPENDITURES (administrative entity data element #358) is less than 0.60 or greater than 1.88.
Turned back on	N	C	N		35025	CYTOTSTAFF > 0 and CYSALARIES > 0 and (PYTOTSTAFF <= 0 or PYSALARIES <= 0) and (CYSALARIES / CYTOTSTAFF < 5,884.14 or CYSALARIES / CYTOTSTAFF > 82,066.18)	NONCRITICAL – The ratio of SALARY & WAGES EXPENDITURES to TOTAL PAID EMPLOYEES is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of SALARY & WAGES EXPENDITURES (administrative entity data element #350) to TOTAL PAID EMPLOYEES (administrative entity data element #253) is less than 5,884.14 or greater than 82,066.18.
Turned back on	N	C	N		35225	CYTOTSTAFF > 0 and CYSTAFFEXP > 0 and (PYTOTSTAFF <= 0 or PYSTAFFEXP <= 0) and (CYSTAFFEXP / CYTOTSTAFF < 5,775.43 or CYSTAFFEXP / CYTOTSTAFF > 116,500.76)	NONCRITICAL – The ratio of TOTAL STAFF EXPENDITURES to TOTAL PAID EMPLOYEES is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of TOTAL STAFF EXPENDITURES (administrative entity data element #352) to TOTAL PAID EMPLOYEES (administrative entity data element #253) is less than 5,775.43 or greater than 116,500.76.
Turned back on	N	C	N		35325	PRMATEXP > 0 and TOTEXPCO > 0 and (PRMATEXP / TOTEXPCO < 0.30 or PRMATEXP / TOTEXPCO > 2.00)	NONCRITICAL – The ratio of PRINT MATERIALS EXPENDITURES to TOTAL COLLECTION EXPENDITURES is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	PRINT MATERIALS EXPENDITURES (administrative entity data element #353) / TOTAL COLLECTION EXPENDITURES (administrative entity data element #356) is < 0.30 or > 2.00.
Turned back on	N	C	I		35625	TOTEXPCO > 0 and TOTINCM > 0 and (TOTEXPCO / TOTINCM < 0.02 or TOTEXPCO / TOTINCM > 0.91)	INTERNAL – The ratio of TOTAL COLLECTION EXPENDITURES to TOTAL OPERATING REVENUE is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	TOTAL COLLECTION EXPENDITURES (administrative entity data element #356) / TOTAL OPERATING REVENUE (administrative entity data element #304) is < 0.02 or > 0.91.
Turned back on	N	C	N		35825	TOTOPEXP > 0 and STAFFEXP > 0 and (TOTOPEXP / STAFFEXP < 0.70 or TOTOPEXP / STAFFEXP > 3.57)	NONCRITICAL – The ratio of TOTAL OPERATING EXPENDITURES to TOTAL STAFF EXPENDITURES is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of TOTAL OPERATING EXPENDITURES (administrative entity data element #358) to TOTAL STAFF EXPENDITURES (administrative entity data element #352) is less than 0.70 or greater than 3.57.
Turned back on	N	C	N		50025	CYHRS_OPEN > 0 and [(CYCENTLIB + CYBRANLIB + CYBKMOB) + (count CYC_OUT_TY = 'BM')] > 0 and {(CYHRS_OPEN / 52 / [(CYCENTLIB + CYBRANLIB + CYBKMOB) + (count CYC_OUT_TY = 'BM')]} < 11.16 or {(CYHRS_OPEN / 52 / [(CYCENTLIB + CYBRANLIB + CYBKMOB) + (count CYC_OUT_TY = 'BM')] > 129.67	NONCRITICAL – The number of PUBLIC SERVICE HOURS per week per outlet is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of PUBLIC SERVICE HOURS (administrative entity data element #500) per week to number of CENTRALS (administrative entity data element #209), BRANCHES (administrative entity data element #210), BOOKMOBILES (administrative entity data element #211) and BOOKS-BY-MAIL ONLY (# of outlet records with data element #709 equal 'BM') is less than 11.16 or greater than 129.67.
Turned back on	N	C	N		50125	VISITS > 0 and TOTCIR > 0 and (TOTCIR / VISITS < 0.18 or TOTCIR / VISITS > 11.85)	NONCRITICAL – The ratio of TOTAL CIRCULATION to LIBRARY VISITS is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of TOTAL CIRCULATION (administrative entity data element #550) to LIBRARY VISITS (administrative entity data element #501) is less than 0.18 or greater than 11.85.
Turned back on	N	C	N		50225	REFERENC > 0 and VISITS > 0 and REFERENC / VISITS > 3	NONCRITICAL – REFERENCE TRANSACTIONS per LIBRARY VISIT is greater than 3.00. Please check for possible errors or explain why the correct data are out of range.	REFERENCE TRANSACTIONS (administrative entity data element #502) per LIBRARY VISIT (administrative entity data element #501) is greater than 3.00.
Turned back on	N	C	N		55025	TOTCIR and POPU_LSA > 0 and TOTCIR / POPU_LSA < 0.47 or TOTCIR / POPU_LSA > 82.21	NONCRITICAL – The ratio of TOTAL CIRCULATION to POPULATION OF LEGAL SERVICE AREA is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of TOTAL CIRCULATION (administrative entity data element #550) to POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) is less than 0.47 or greater than 82.21.
Turned back on	N	C	I		57525	LOANTO > 0 and LOANFM > 0 and (LOANTO / LOANFM < 0.02 or LOANTO / LOANFM > 44.06)	INTERNAL – The ratio of LOANS PROVIDED TO other libraries to LOANS RECEIVED FROM other libraries is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	LOANS PROVIDED TO (administrative entity data element #575) / LOANS RECEIVED FROM (administrative entity data element #576) is less than 0.02 or greater than 44.06.
Turned back on	N	C	I		60025	TOTPRO > 0 and POPU_LSA > 0 and TOTPRO / POPU_LSA > 1.44	INTERNAL – The ratio of TOTAL LIBRARY PROGRAMS to POPULATION OF LEGAL SERVICE AREA is greater than 1.44. Please check for possible errors or explain why the correct data are out of range.	The ratio of TOTAL LIBRARY PROGRAMS (administrative entity data element #600) to POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) is greater than 1.44.
Turned back on	N	C	N		60026	TOTATTEN > 0 and TOTPRO > 0 and (TOTATTEN / TOTPRO < 1.99 or TOTATTEN / TOTPRO > 198.56)	NONCRITICAL – The ratio of TOTAL PROGRAM ATTENDANCE to TOTAL LIBRARY PROGRAMS is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of TOTAL PROGRAM ATTENDANCE (administrative entity data element #603) to TOTAL LIBRARY PROGRAMS (administrative entity data element #600) is less than 1.99 or greater than or equal to 198.56.
Turned back on	N	H	N		61165	CYK0_5ATTEN > 0 and PYK0_5ATTEN > 0 and (CYK0_5ATTEN / PYK0_5ATTEN < 0.45 or CYK0_5ATTEN / PYK0_5ATTEN > 2.25)	NONCRITICAL – ATTENDANCE AT SYNCHRONOUS PROGRAMS TARGETED AT CHILDREN AGES 0-5 has had a large change from last year. Please check for possible errors or provide an explanation for the change.	ATTENDANCE AT SYNCHRONOUS PROGRAMS TARGETED AT CHILDREN AGES 0-5 (administrative entity data element #611) CY / PY is less than 0.45 or greater than 2.25.
Turned back on	N	H	N		61365	CYYAATTEN > 0 and PYYAATTEN > 0 and (CYYAATTEN / PYYAATTEN < 0.20 of CYYAATTEN / PYYAATTEN > 6.50)	NONCRITICAL – The number of YOUNG ADULT PROGRAM ATTENDANCE has had a large change from last year. Please check for possible errors or provide an explanation for the change.	YOUNG ADULT PROGRAM ATTENDANCE (administrative entity data element #613) CY / PY is less than 0.20 or greater than 6.50.
Turned back on	N	C	N		65123	PITUSR > 0 and VISITS > 0 and PITUSR / VISITS > 3	NONCRITICAL – USES OF PUBLIC INTERNET COMPUTERS PER YEAR per VISIT is greater than 3. Please check the value for possible error.	The number of USES OF PUBLIC INTERNET COMPUTERS PER YEAR (administrative entity data element #651) per LIBRARY VISIT (administrative entity data element #501) is greater than 3.
Turned back on	N	C	N		65166	CYPITUSR > 0 and GPTERMS > 0 and HRS_OPEN > 0 and ((CYPITUSR/GPTERMS)/HRS_OPEN < 0.0051 or (CYPITUSR/GPTERMS)/HRS_OPEN > 21.135)	NONCRITICAL – The ratio for USES OF PUBLIC INTERNET COMPUTERS PER YEAR PER GENERAL PUBLIC TERMINAL to NUMBER OF HOURS OPEN is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of (USES OF PUBLIC INTERNET COMPUTERS PER YEAR (administrative entity data element #651) divided by NUMBER OF INTERNET COMPUTERS USED BY GENERAL PUBLIC (administrative entity data element #650) to PUBLIC SERVICE HOURS PER YEAR (administrative entity data element #500) is less than 0.0051 or greater than 21.135.
Turned back on	N	C	N		71322	(0 < HOURS < 20 or HOURS > 6,760)	NONCRITICAL - HOURS is less than 20 or greater than 6,760. Please check for possible errors.	HOURS PER YEAR (outlet data element #713) is less than 20 or greater than 6,760.
Turned back on	N	H	N		71469	\|PYWKS_OPEN - CYWKS_OPEN\| > 4	NONCRITICAL – Please verify the year-to-year change of the WEEKS OPEN.	The difference of WEEKS OPEN (outlet data element #714) from PY is greater than 4.
New	N	H	N		63053	CYTOTVIEWS > 325 and PYTOTVIEWS = 0	NONCRITICAL – TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS current year is greater than 325 and prior year value was zero. Please check the current year value for possible error or provide an explanation for the change.	TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS (administrative entity data element #630) CY is greater than 325 and PY equals zero.
New	N	H	N		63051	PYTOTVIEWS = -1 and CYTOTVIEWS = 0	NONCRITICAL – TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS is zero in the current year and the prior year value was -1. Please check the current year value for possible error.	TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS (administrative entity data element #630) CY equals zero and PY equals -1.
New	N	H	N		63052	PYTOTVIEW > 150 and CYTOTVIEW = 0	NONCRITICAL – TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS prior year is greater than 150 and current year is zero. Please check the current year value for possible error or provide an explanation for the change.	TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS (administrative entity data element #630) PY is greater than 150 and CY equals zero.
New	N	H	N		63054	CYTOTVIEWS > 0 and (CYTOTVIEWS = PYTOTVIEWS)	NONCRITICAL – Current year TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS is the same as the prior year value. Please check the current year value for possible error.	Current year TOTAL VIEWS OF ASYNCHRONOUS PROGRAM PRESENTATIONS WITHIN 30 DAYS (administrative entity data element #630) equals PY.

All Edits FY23

	COVID-19 Temp Off	Pubord	Critical	Code	Flag Condition	Edit Message	Edit Condition
	N	H	N	10370	(CYPOPU_UND >PY POPU_UND and CYPOPU_ST < PYPOPU_ST) or (CYPOPU_UND < PYPOPU_UND and CYPOPU_ST > PYPOPU_ST)	NONCRITICAL – The year-to-year change in TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREA is not consistent with the year-to-year change in the STATE TOTAL POPULATION ESTIMATE. Please check for possible errors or explain why the correct data are out of range.	The year-to-year change in TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREA (state characteristics data element #103) is not consistent with the year-to-year change in the STATE TOTAL POPULATION ESTIMATE (state characteristics data element #102).
	N	H	N	10371	(sum CYPOPU_LSA = CYPOPU_UND and sum PYPOPU_LSA > PYPOPU_UND) or (sum CYPOPU_LSA > CYPOPU_UND and sum PYPOPU_LSA = PYPOPU_UND)	NONCRITICAL – Please verify the change in the relationship between the total POPULATION OF LEGAL SERVICE AREAS and the TOTAL UNDUPLICATED POP OF LEGAL SERVICE AREA from the prior year. Please check for possible errors or explain why the relationship has changed.	The relationship between the sum of individual POPULATION OF LEGAL SERVICE AREAS (administrative entity data element #208) and the TOTAL UNDUPLICATED POP OF LEGAL SERVICE AREA (state characteristics data element #103) is not the same as the prior year.
	N	H	N	61061	PYTOTATTEN = -1 and CYTOTATTEN = 0 and (PYSTATSTRU <> 22 or 25)	NONCRITICAL – TOTAL ATTENDANCE AT SYNCHRONOUS PROGRAMS is zero in the current year and the prior year value was -1. Please check the current year value for possible error.	TOTAL ATTENDANCE AT SYNCHRONOUS PROGRAMS (administrative entity data element #610) CY equals zero and PY equals -1.
	N	C	Y	10020	STARTDAT <= 0 or STARTDAT = 'M' or (not enough characters, e.g. 06/200)	CRITICAL EDIT – Reporting Period Start Date is not reported or is not valid. Please check the value for possible error.	The REPORTING PERIOD START DATE (state characteristics data element #100) is -2 or missing.
	N	H	N	10067	CYSTARTDAT_MONTH <> PYSTARTDAT_MONTH	NONCRITICAL – Please verify the change in state REPORTING PERIOD STARTING DATE month.	The month portion of the REPORTING PERIOD STARTING DATE (state characteristics data element #100) is not equal to PY.
	N	C	Y	10120	ENDDATE <= 0 or ENDDATE = 'M' or (not enough characters, e.g. 06/200)	CRITICAL EDIT – Reporting Period End Date is not reported or is not valid. Please check the value for possible error.	The REPORTING PERIOD END DATE (state characteristics data element #101) is -2 or missing.
	N	H	N	10167	CYENDDATE_MONTH <> PYENDDATE_MONTH	NONCRITICAL – Please verify the change in state REPORTING PERIOD ENDING DATE month.	The month portion of the REPORTING PERIOD ENDING DATE (state characteristics data element #101) is not equal to PY.
	N	C	Y	10220	POPU_ST <= 0	CRITICAL EDIT – The STATE POPULATION ESTIMATE is not reported or is equal to zero. Please check the value for possible error.	STATE POPULATION ESTIMATE (state characteristics data element #102) is less than or equal to zero.
	N	C	Y	10229	POPU_ST > 0 and POPU_UND > 0 and POPU_ST > POPU_UND	CRITICAL EDIT – The TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREAS is greater than STATE TOTAL POPULATION ESTIMATE. Please check the values for possible errors.	STATE TOTAL POPULATION ESTIMATE (state characteristics data element #102) is less than the TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREAS (state characteristics data element #103).
	N	H	N	10265	CYPOPU_ST > 0 and PYPOPU_ST > 0 and (CYPOPU_ST / PYPOPU_ST < 0.95 or CYPOPU_ST / PYPOPU_ST > 1.05)	NONCRITICAL – The STATE TOTAL POPULATION ESTIMATE has had a large change from last year. Please check for possible errors or provide an explanation for the change.	STATE TOTAL POPULATION ESTIMATE (state characteristics data element #102) CY / PY is less than 0.95 or greater than 1.05.
	N	H	N	10271	(sum CYPOPU_LSA < sum PYPOPU_LSA and CYPOPU_ST > PYPOPU_ST) or (sum CYPOPU_LSA > sum PYPOPU_LSA and CYPOPU_ST < PYPOPU_ST)	NONCRITICAL – The year-to-year change in the total POPULATION OF LEGAL SERVICE AREAS is not consistent with the year-to-year change in the STATE TOTAL POPULATION ESTIMATE. Please check for possible errors or explain why the correct data are out of range.	The year-to-year change in the sum of individual POPULATION OF LEGAL SERVICE AREAS (administrative entity data element #208) is not consistent with the year-to-year change in the STATE TOTAL POPULATION ESTIMATE (state characteristics data element #102).
	N	C	Y	10320	POPU_UND <= 0	CRITICAL EDIT – The TOTAL UNDUPLICATED POPULATION is not reported or is equal to zero. Please check the value for possible error.	TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREAS (state characteristics data element #103) is less than or equal to zero.
	N	C	N	10323	0 < sum POPU_LSA - POPU_UND < 500	NONCRITICAL – The overlap of total POPULATION OF LEGAL SERVICE AREAs to TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREAS is questionable. Please check for possible errors or explain why the correct data are out of range.	The difference between the sum of individual POPULATION OF LEGAL SERVICE AREAs (administrative entity data element #208) and TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREAS (state characteristics data element #103) is less than 500.
	N	C	Y	10329	POPU_UND > sum POPU_LSA_AE where FSCSKEY <> -3	CRITICAL EDIT – The TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREAS is greater than the total POPULATION OF LEGAL SERVICE AREAs. Please check the values for possible errors.	TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE AREAS (state characteristics data element #103) is greater than the sum of individual POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208).
	N	H	N	10365	CYPOPU_UND > 0 and PYPOPU_UND > 0 and (CYPOPU_UND / PYPOPU_UND < 0.95 or CYPOPU_UND / PYPOPU_UND > 1.05)	NONCRITICAL – The TOTAL UNDUPLICATED POPULATION OF LSA has had a large change from last year. Please check for possible errors or provide an explanation for the change.	TOTAL UNDUPLICATED POPULATION OF LSA (state characteristics data element #103) is CY / PY is less than 0.95 or greater than 1.05.
	N	H	N	10372	(CYPOPU_ST – CYPOPU_UND = 0 and PYPOPU_ST – PYPOPU_UND <> 0) or (CYPOPU_ST – CYPOPU_UND <> 0 and PYPOPU_ST – PYPOPU_UND = 0)	NONCRITICAL – Please verify the change in the relationship between the STATE TOTAL POPULATION ESTIMATE and the TOTAL UNDUPLICATED POP OF LEGAL SERVICE AREA from the prior year.	The relationship between STATE TOTAL POPULATION ESTIMATE (state characteristics data element #102) and the TOTAL UNDUPLICATED POP OF LEGAL SERVICE AREA (state characteristics data element #103) is not the same as the prior year.
	N	H	N	15073	total number of AE records changed by plus or minus 25%	NONCRITICAL – The total number of administrative entity records has changed by more than 25%. Please check for possible errors or provide an explanation for the change.	The total number of administrative entity records has changed by more than 25%.
	N	C	I	15120	LIBID = blank or LIBID = '-' or LIBID = '----'	INTERNAL – LIBID field is not valid. Please check for blanks, '-', or '----'.	The LIBID field (data element #151) is not a valid entry.
	N	C	Y	15220	LIBNAME < 0 or LIBNAME = M	CRITICAL EDIT – Library NAME is not reported. Please check for error.	The library NAME (administrative entity data element #152) is not reported.
	N	C	I	15280	LIBNAME = 'MAIN LIBRARY'	INTERNAL – Please provide the official library NAME.	The library NAME (administrative entity data element #152) is not valid.
	N	C	Y	15320	ADDRESS < 0 or ADDRESS = 'M'	CRITICAL EDIT – STREET ADDRESS is not reported. Please check for error.	The STREET ADDRESS (administrative entity data element #153) is not reported.
	N	C	I	15380	ADDRESS (contains ‘BOX’, ‘RT.’, ‘HCR’, or ‘ <STABR>’)	INTERNAL – Please provide a physical location if a physical STREET ADDRESS is not available.	The STREET ADDRESS (administrative entity data element #153) is invalid.
	N	C	Y	15420	CITY < 0 or ='M'	CRITICAL EDIT – CITY is not reported. Please check for error.	The CITY name (administrative entity data element #154) is not reported or is not valid.
	N	H	I	15467	FIP_ST_CY = FIP_ST_PY and CITY_CY <> CITY_PY	INTERNAL - Check CITY entry.	The CITY name (administrative entity data element #154) is not equal to PY, but STATE equals PY.
	N	C	Y	15520	ZIP < 0 or ZIP = 'M' or ZIP = '00000' or ZIP contains alpha characters or ZIP is less than five digits.	CRITICAL EDIT – ZIP CODE is not reported or is not valid. Please check for error.	The ZIP CODE (administrative entity data element #155) is not reported or is not a valid 5-digit number.
	N	H	N	15567	(CYZIP <> PYZIP) and (CYADDRESS = PYADDRESS)	NONCRITICAL – The STREET ADDRESS has not changed but the ZIP CODE is not the same as the prior year. Please check for possible errors.	The STREET ADDRESS (administrative entity data element #153) is the same as the PY but the ZIP CODE (administrative entity data element #155) does not equal PY.
	N	C	Y	15720	ADDRES_M < 0 or = 'M'	CRITICAL EDIT – MAILING ADDRESS is not reported. Please check for error.	The MAILING ADDRESS (administrative entity data element #157) is not reported or is not valid.
	N	C	I	15780	ADDRES_M contains 'SAME' or <STABR>	INTERNAL – Please provide specific mailing address information.	The MAILING STREET ADDRESS (administrative entity data element #157) contains the word "SAME".
	N	C	Y	15820	CITY_M < 0 or = 'M'	CRITICAL EDIT – MAILING CITY is not reported. Please check for error.	The MAILING CITY name (administrative entity data element #158) is not reported or contains the word ‘same’.
	N	C	I	15880	CITY_M contains 'SAME' or CITY_M contains <STABR>	INTERNAL – Please provide specific mailing address information.	The MAILING CITY (administrative entity data element #158) contains the word "SAME".
	N	C	Y	15920	ZIP_M < 0 or ZIP_M = 'M' or ZIP_M = '00000' or ZIP_M contains alpha characters or ZIP_M is less than five digits.	CRITICAL EDIT – MAILING ZIP CODE is not reported. Please check for error.	The MAILING ZIP CODE (administrative entity data element #159) is not reported or is not a valid 5-digit number.
	N	C	Y	16120	CNTY < 0 or CNTY = 'M'	CRITICAL EDIT – COUNTY is not reported. Please check for error.	The COUNTY name (administrative entity data element #161) is not reported or is not valid.
	N	H	N	16167	CYCNTY <> PYCNTY and CYCITY = PYCITY (and STATSTRU <> 02 or 22)	NONCRITICAL – The CITY name has not changed but the COUNTY is not the same as the prior year. Please check for possible errors.	The CITY name (administrative entity data element #154) equals PY but COUNTY (administrative entity data element #161) is not equal to PY.
	N	C	I	16180	CNTY includes 'COUNTY' or CNTY includes '/' or CNTY includes <STABR>	INTERNAL – COUNTY name is invalid. Please check the current year value for 'COUNTY' or state abbreviation.	COUNTY name (administrative entity data element #161) contains the state abbreviation or 'County'.
	N	C	Y	16220	PHONE = -2 or PHONE is not a 10 digit number or PHONE = ‘0000000000’ or PHONE contains alpha characters	CRITICAL EDIT – PHONE number is -2 or is not valid. Please check for error. -2 is not a valid response.	The PHONE number (administrative entity data element #162) is -2 or is not a valid 10-digit number.
	N	C	Y	20020	C_RELATN <> ‘HQ’ or ‘ME’ or ‘NO’	CRITICAL EDIT – INTERLIBRARY RELATIONSHIP CODE is not reported or is not a valid code. Please check for error.	INTERLIBRARY RELATIONSHIP CODE (administrative entity data element #200) is not reported as ‘HQ’, ‘ME’, or ‘NO’.
	N	C	N	20025	(count C_RELATN = ‘HQ’ / count AE records) > .25	NONCRITICAL – Percentage of libraries with INTERLIBRARY RELATIONSHIP 'HQ' is greater than 25%. Please check for possible errors or explain why the correct data are out of range.	The ratio of administrative entity records with INTERLIBRARY RELATIONSHIP (administrative entity data element #200) 'HQ' to the total number of administrative entity records is more than 25%.
	N	H	N	20067	CYC_RELATN <> PYC_RELATN (and STATSTRU <> 02 or 22)	NONCRITICAL – Please verify the change in the INTERLIBRARY RELATIONSHIP CODE.	INTERLIBRARY RELATIONSHIP CODE (administrative entity data element #200) is not equal to PY.
	N	C	Y	20120	C_LEGBAS <> ‘CC’ or ‘CI’ or ‘CO’ or ‘LD’ or ‘MJ’ or ‘NL’ or ’NP’ or ’SD’ or ’OT’	CRITICAL EDIT – LEGAL BASIS CODE is not reported or is not a valid code. Please check for error.	LEGAL BASIS CODE (administrative entity data element #201) is not reported as ‘CC’, ‘CI’, ‘CO’, ‘LD’, ‘MJ’, 'NL’, ’NP’, ’SD’, or ’OT’.
	N	H	N	20167	CYC_LEGBAS <> PYC_LEGBAS && (PYSTATSTRU or CYSTATSTRU <> 02 or 22 or 25)	NONCRITICAL – The LEGAL BASIS CODE does not match the prior year. Please verify the change in the LEGAL BASIS CODE.	LEGAL BASIS CODE (administrative entity data element #201) is not equal to PY.
	N	C	Y	20220	C_ADMIN <> ‘MA’ or ’MO’ or ’SO’	CRITICAL EDIT – The ADMINISTRATIVE STRUCTURE CODE is not reported or is not a valid code. Please check the value for possible error.	The ADMINISTRATIVE STRUCTURE CODE (administrative entity data element #202) is not reported as ‘MA’, ’MO’, or ’SO’.
	N	C	N	20228	(C_ADMIN = SO) and {[(CENTLIB + BRANLIB + BKMOB)] + (count C_OUT_TY = BM) <> 1} or (C_ADMIN = MA or MO) and {[(CENTLIB + BRANLIB + BKMOB)] + (count C_OUT_TY = BM) < 2} (and STATSTRU <> 02 or 22)	NONCRITICAL – The ADMINISTRATIVE STRUCTURE CODE is not consistent with the total number of service outlets. Please check the value for possible error.	The ADMINISTRATIVE STRUCTURE CODE (administrative entity data element #202) is ‘SO’ and total number of service outlets (administrative entity data elements #209, #210, and #211) and BOOKS-BY-MAIL ONLY (# of outlet records with data element #709 ‘BM’) is not equal to 1 or the ADMINISTRATIVE STRUCTURE CODE (administrative entity data element #202) is ‘MA’ or ‘MO’ and the total number of service outlets is less than 2.
	N	H	N	20267	CYC_ADMIN <> PYC_ADMIN and (STATSTRU <> 02 or 22) or [(CYCENTLIB + CYBRANLIB + CYBKMOB) + (count CYC_OUT_TY = 'BM')] <> [(PYCENTLIB + PYBRANLIB + PYBKMOB) + (count PYC_OUT_TY = 'BM')]	NONCRITICAL – Please verify the change in the ADMINISTRATIVE STRUCTURE CODE.	The ADMINISTRATIVE STRUCTURE CODE (administrative entity data element #202) is not equal to the prior year.
	N	C	Y	20320	C_FSCS <> ‘Y’ or ‘N’	CRITICAL EDIT – FSCS PUBLIC LIBRARY is not reported or is not a valid code. Please check the value for possible error.	FSCS PUBLIC LIBRARY (administrative entity data element #203) is not reported as ‘Y’ or ‘N’.
	N	C	I	20321	C_FSCS = Y and [(TOTCIR = 0) or (BKVOL + AUDIO_PH + VIDEO_PH = 0)] or [TOTSTAFF = 0 or SALARIES = 0] or [HRS_OPEN = 0] or [VISITS = 0] or [(TOTINCM-OTHINCM) = 0]	INTERNAL – The FSCS Public Library Definition is Yes but the library does not meet one or more of the requirements. Please check the value for possible error.	FSCS PUBLIC LIBRARY (administrative entity data element #203) is ‘Yes’ and [[TOTAL CIRCULATION (administrative entity data element #550) is equal to zero] or [PRINT MATERIALS (administrative entity data element #450) + AUDIO PHYSICAL UNITS (administrative entity data element #452) + VIDEO PHYSICAL UNITS (administrative entity data element #454) is equal to zero]] or [SALARIES & WAGES EXPENDITURES (administrative entity data element #350) are equal to zero] or [PUBLIC SERVICE HOURS PER YEAR (administrative entity data element #500) is equal to zero] or [LIBRARY VISITS (administrative entity data element #501) is equal to zero].
	N	C	I	20328	C_FSCS = N and ((TOTCIR > 0 or = -1) or (BKVOL + AUDIO_PH + VIDEO_PH > 0 or = -1)) and (TOTSTAFF > 0 or = -1 or SALARIES > 0 or = -1) and (HRS_OPEN > 0 or = -1) and (VISITS > 0 or = -1) and ((TOTINCM-OTHINCM) > 0 or = -1)	INTERNAL – The FSCS Public Library Definition is No but the library meets all the requirements of the definition. Please check the current year value for possible error.	FSCS PUBLIC LIBRARY (administrative entity data element #203) is ‘No’ and [[TOTAL CIRCULATION (administrative entity data element #550) is greater than zero or equal to -1] or [PRINT MATERIALS (administrative entity data element #450) + AUDIO PHYSICAL UNITS (administrative entity data element #452) + VIDEO PHYSICAL UNITS (administrative entity data element #454) is greater than zero or equal to -1]] and [TOTAL PAID EMPLOYEES (administrative entity data element #253) or SALARIES & WAGES EXPENDITURES (administrative entity data element #350) are greater than zero or equal to -1] and [PUBLIC SERVICE HOURS PER YEAR (administrative entity data element #500) is greater than zero or equal to -1] and [LIBRARY VISITS (administrative entity data element #501) is greater than zero or equal to -1] and [TOTAL OPERATING REVENUE (administrative entity data element #304) minus OTHER OPERATING REVENUE (administrative entity data element #303)] is greater than zero or equal to -1].
	N	C	Y	20337	C_FSCS = Y and ((TOTSTAFF = 0) or (TOTINCM-OTHINCM = 0))	CRITICAL EDIT – The FSCS Public Library Definition is Yes but the library does not have paid staff or public funding. Please check the value for possible error.	FSCS PUBLIC LIBRARY (administrative entity data element #203) is ‘Yes’ and [TOTAL PAID EMPLOYEES (administrative entity data element #253) is equal to zero] or [TOTAL OPERATING REVENUE (administrative entity data element #304) minus OTHER OPERATING REVENUE (administrative entity data element #303)] is equal to zero].
	N	H	N	20367	CYC_FSCS <> PYC_FSCS (and STATSTRU <> 02 or 22)	NONCRITICAL – Please verify the change in the FSCS PUBLIC LIBRARY status.	FSCS PUBLIC LIBRARY status (administrative entity data element #203) is not equal to PY.
	N	C	Y	20420	GEOCODE <> 'CO1' or 'CO2' or 'CO3' or 'MC1' or 'MC2' or 'MC3' or 'PL1' or 'PL2' or 'MP1' or 'MP2' or 'CD1' or 'CD2' or 'MD1' or 'MD2' or 'SU1' or 'SU2' or 'SE1' or 'SE2' or 'SS1' or 'SS2' or 'OTH'	CRITICAL EDIT – GEOGRAPHIC CODE is not reported or is not a valid code. Please check the value for possible error.	GEOGRAPHIC CODE (administrative entity data element #204) is not reported as 'CO1', 'CO2', 'CO3', 'MC1', 'MC2', 'MC3', 'PL1', 'PL2', 'MP1', 'MP2', 'CD1', 'CD2', 'MD1', 'MD2', 'SU1', 'SU2', 'SE1', 'SE2', 'SS1', 'SS2', or 'OTH'.
	N	C	Y	20520	LSABOUND <> ‘Y’ or ‘N’	CRITICAL EDIT – LSA BOUNDARY CHANGE is not reported or is not a valid code. Please check the value for possible error.	LSA BOUNDARY CHANGE (administrative entity data element #205) is not reported or is not reported as 'Y' or 'N'.
	N	C	N	20521	(GEOCODE_CY <> GEOCODE_PY) and (LSABOUND = N) and (STATSTRU <> 02 or 22)	NONCRITICAL – GEOGRAPHIC CODE changed from prior year and LEGAL SERVICE AREA BOUNDARY CHANGE is 'No'. Please check for possible errors.	GEOGRAPHIC CODE (administrative entity data element #204) changed from PY and LEGAL SERVICE AREA BOUNDARY CHANGE (administrative entity data element #205) is 'N'.
	N	H	I	20564	LSABOUND_CY = Y and LSABOUND_PY = Y	INTERNAL – The LEGAL SERVICE AREA BOUNDARY code is YES current-year and prior-year. Please check the current year value for possible error.	The LEGAL SERVICE AREA BOUNDARY code (administrative entity data element #205) is YES for both the current-year and the prior-year.
	N	C	Y	20620	STARTDAT < 0 or (something that catches not enough characters, e.g. 06/200)	CRITICAL EDIT – Library's REPORTING PERIOD STARTING DATE is not reported or is not valid. Please check the value for possible error.	REPORTING PERIOD STARTING DATE (administrative entity data element #206) is not reported or is not formatted correctly.
	N	C	Y	20623	STARTDAT – ENDDATE <> 12 months	CRITICAL EDIT – Library's REPORTING PERIOD is greater than or less than one year. Please check for possible errors.	The difference between the REPORTING PERIOD STARTING DATE (administrative entity data element #206) and the REPORTING PERIOD ENDING DATE (administrative entity data element #207) is more than 12 months or less than 12 months.
	N	C	Y	20629	STARTDAT_AE < STARTDAT_CHR	CRITICAL EDIT – Library's REPORTING PERIOD STARTING DATE is before the state's REPORTING PERIOD STARTING DATE. Please check the value for possible error.	REPORTING PERIOD STARTING DATE (administrative entity data element #206) is before the state REPORTING PERIOD STARTING DATE (state characteristics data element #100).
	N	H	N	20664	CYSTARTDAT = PYSTARTDAT	NONCRITICAL – The current year REPORTING PERIOD START DATE equals the prior year REPORTING PERIOD START DATE. Please check these values for possible error.	CY REPORTING PERIOD START DATE (administrative entity data element #206) is the same as PY.
	N	C	N	20680	CYSTARTDAT <> PYENDDATE + 1 day	NONCRITICAL – STARTDAT current year is not one day after ENDDATE prior year. Please check the value for possible error.	CY REPORTING PERIOD STARTING DATE (administrative entity data element #206) is not one day after PY REPORTING PERIOD ENDING DATE (administrative entity data element #206).
	N	C	Y	20720	ENDDATE < 0 or (something that catches not enough characters, e.g. 06/200) or Left (ENDDATE, 4) > 1231xxxx, where xxxx = current processing year	CRITICAL EDIT – Library's REPORTING PERIOD ENDING DATE is not reported or is not valid. Please check the value for possible error.	REPORTING PERIOD ENDING DATE (administrative entity data element #207) is not reported or is not formatted correctly.
	N	C	Y	20729	ENDDATE_AE > ENDDATE_CHR	CRITICAL EDIT – Library's REPORTING PERIOD ENDING DATE is after the state's REPORTING PERIOD ENDING DATE. Please check the value for possible error.	REPORTING PERIOD ENDING DATE (administrative entity data element #207) is after the state's REPORTING PERIOD ENDING DATE (state characteristics data element #101).
	N	H	N	20764	CYENDDATE = PYENDDATE	NONCRITICAL – The current year REPORTING PERIOD END DATE equals the prior year. Please check the value for possible error.	CY REPORTING PERIOD END DATE (administrative entity data element #207) is the same as PY.
	N	C	Y	20820	(POPU_LSA <= 0 or NULL) and STATSTRU <> 25	CRITICAL EDIT – The POPULATION OF LEGAL SERVICE AREA is not reported or is equal to zero. Please check the value for possible error.	POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) is less than or equal to zero.
	N	H	N	20860	PYPOPU_LSA = -1 and CYPOPU_LSA = 1	NONCRITICAL – POPULATION OF LEGAL SERVICE AREA is 1 and the prior year value was -1. Please check the current year value for possible error.	POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) CY equals 1 and PY equals -1.
	N	H	N	20865	CYPOPU_LSA > 0 and PYPOPU_LSA > 0 and ((CYPOPU_LSA / PYPOPU_LSA < 0.95 or CYPOPU_LSA / PYPOPU_LSA > 1.07) and LSABOUND = N) or
((CYPOPU_LSA / PYPOPU_LSA < 0.45 or CYPOPU_LSA / PYPOPU_LSA > 1.80) and LSABOUND = Y)	NONCRITICAL – The POPULATION OF LEGAL SERVICE AREA has had a large change from last year. Please check for possible errors or provide an explanation for the change.	POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) CY / PY is less than 0.95 or greater than 1.07, and the LEGAL SERVICE AREA BOUNDARY code (administrative entity data element #205) is NO; or POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) CY / PY is less than 0.45 or greater than 1.80, and the LEGAL SERVICE AREA BOUNDARY code (administrative entity data element #205) is YES.
	N	C	Y	20920	CENTLIB < 0 && (STATSTRU <> 22)	CRITICAL EDIT – The number of CENTRAL service outlet is not reported. Please check the value for possible error.	CENTRAL service outlet (administrative entity data element #209) is less than zero.
	N	C	Y	20922	CENTLIB > 1	CRITICAL EDIT – CENTRAL service outlet is greater than 1. Please check the value for possible error.	CENTRAL service outlet (administrative entity data element #209) is greater than 1. Note: CENTRAL cannot be greater than 1.
	N	C	Y	20928	CENTLIB <> count of C_OUT_TY = CE	CRITICAL EDIT – CENTRAL service outlet is not equal to the number of central outlet records. Please check the value for possible error.	CENTRAL service outlet (administrative entity data element #209) is not equal to the number of outlet records coded ‘CE’ for the OUTLET TYPE CODE (outlet data element #709).
	N	H	N	20969	((PYCENTLIB=1 and CYCENTLIB= 0) or (PYCENTLIB= 0 and CYCENTLIB=1))	NONCRITICAL – Please verify the year-to-year change in the NUMBER OF CENTRALS.	NUMBER OF CENTRALS (administrative entity data element #209) is not equal to PY.
	N	C	Y	21020	BRANLIB < 0 && (STATSTRU <> 22)	CRITICAL EDIT – The number of BRANCH service outlets is not reported. Please check the value for possible error.	BRANCH service outlets (administrative entity data element #210) is not reported.
	N	C	Y	21028	BRANLIB <> count of C_OUT_TY = BR	CRITICAL EDIT – The number of BRANCH service outlets is not equal to the number of branch outlet records. Please check the value for possible error.	The number of BRANCH service outlets (administrative entity data element #210) is not equal to the number of outlet records coded ‘BR’ for the OUTLET TYPE CODE (outlet data element #709).
	N	H	N	21069	\|PYBRANLIB - CYBRANLIB\| > 1	NONCRITICAL – Please verify the year-to-year change of the NUMBER OF BRANCHES.	The difference of NUMBER OF BRANCHES (administrative entity data element #210) from PY is greater than 1.
	N	C	Y	21120	BKMOB < 0 && (STATSTRU <> 22)	CRITICAL EDIT – The number of BOOKMOBILE service outlets is not reported. Please check the value for possible error.	BOOKMOBILE service outlets (administrative entity data element #211) is not reported.
	N	C	Y	21128	BKMOB <> sum L_NUM_BM where C_OUT_TY = BS	CRITICAL EDIT – The number of BOOKMOBILE service outlets is not equal to the number of bookmobiles in outlet records. Please check the value for possible error.	The number of BOOKMOBILE service outlets (administrative entity data element #211) is not equal to the NUMBER OF BOOKMOBILES (outlet data element #712) in outlet records coded ‘BS’ for the OUTLET TYPE CODE (outlet data element #709).
	N	H	N	21169	\|PYBKMOB - CYBKMOB\| > 1	NONCRITICAL – Please verify the year-to-year change of the NUMBER OF BOOKMOBILES.	The difference of NUMBER OF BOOKMOBILES (administrative entity data element #211) from PY is greater than 1.
	N	C	Y	25020	MASTER = -2	CRITICAL EDIT – ALA-MLS is -2. Please check for error. -2 is not a valid response.	ALA-MLS librarians (administrative entity data element #250) is -2.
	N	C	Y	25028	LIBRARIA > -1 and LIBRARIA < MASTER	CRITICAL EDIT – ALA-MLS is greater than TOTAL LIBRARIANS. Please check the value for possible error.	The number of ALA-MLS librarians (administrative entity data element #250) is greater than TOTAL LIBRARIANS (administrative entity data element #251).
	N	C	Y	25029	LIBRARIA = 0 and MASTER <> 0	CRITICAL EDIT – ALA-MLS is not consistent with TOTAL LIBRARIANS. Please check the value for possible error.	The number of ALA-MLS librarians (administrative entity data element #250) is not equal to zero and TOTAL LIBRARIANS (administrative entity data element #251) is equal to zero.
	N	H	N	25061	(PYMASTER = -1 and CYMASTER = 0) && (PYSTATSTRU <> 22 or 25)	NONCRITICAL – ALA-MLS is zero in the current year and the prior year value was -1. Please check the current year value for possible error.	ALA-MLS (administrative entity data element #250) CY equals zero and PY equals -1.
	N	H	N	25062	PYMASTER > 1 and CYMASTER = 0	NONCRITICAL – ALA-MLS prior year is greater than 1 and current year is zero. Please check the current year value for possible error or provide an explanation for the change.	ALA-MLS (administrative entity data element #250) PY is greater than 1 and CY equals zero.
	N	H	N	25063	CYMASTER > 1 and PYMASTER = 0	NONCRITICAL – ALA-MLS current year is greater than 1 and prior year value was zero. Please check the current year value for possible error or provide an explanation for the change.	ALA-MLS (administrative entity data element #250) CY is greater than 1 and PY equals zero.
	N	H	N	25065	CYMASTER > 0 and PYMASTER > 0 and (CYMASTER / PYMASTER < 0.20 or CYMASTER / PYMASTER > 4.91)	NONCRITICAL – The number of ALA-MLS has had a large change from last year. Please check for possible errors or provide an explanation for the change.	ALA-MLS (administrative entity data element #250) CY / PY is less than 0.20 or greater than 4.91.
	N	C	Y	25120	LIBRARIA = -2	CRITICAL EDIT – TOTAL LIBRARIANS is -2. Please check for error. -2 is not a valid response.	TOTAL LIBRARIANS (administrative entity data element #251) is -2.
	N	C	N	25123	LIBRARIA = 0 and TOTSTAFF > 4	NONCRITICAL – TOTAL PAID EMPLOYEES is greater than 4 but TOTAL LIBRARIANS is zero. Please check for possible errors.	TOTAL PAID EMPLOYEES (administrative entity data element #253) is greater than 4 and TOTAL LIBRARIANS (administrative entity data element #251) equals zero.
	N	C	N	25125	LIBRARIA > 0 and TOTSTAFF > 0 and (LIBRARIA / TOTSTAFF < 0.07 or LIBRARIA / TOTSTAFF > 1.0)	NONCRITICAL – The proportion of TOTAL LIBRARIANS to TOTAL PAID EMPLOYEES is either very large or very small. Please check for possible errors or explain why the correct data are out of range.	TOTAL LIBRARIANS (administrative entity data element #251) / TOTAL PAID EMPLOYEES (administrative entity data element #253) is < 0.07 or > 1.00.
	N	H	N	25161	PYLIBRARIA = -1 and CYLIBRARIA = 0 && (PYSTATSTRU <> 22 or 25)	NONCRITICAL – TOTAL LIBRARIANS is zero in the current year and the prior year value was -1. Please check the current year value for possible error.	TOTAL LIBRARIANS (administrative entity data element #251) CY equals zero and PY equals -1.
	N	H	N	25162	PYLIBRARIA > 1 and CYLIBRARIA = 0	NONCRITICAL – TOTAL LIBRARIANS prior year is greater than 1 and current year is zero. Please check the current year value for possible error or provide an explanation for the change.	TOTAL LIBRARIANS (administrative entity data element #251) PY is greater than 1 and CY equals zero.
	N	H	N	25163	CYLIBRARIA > 0 and PYLIBRARIA = 0	NONCRITICAL – TOTAL LIBRARIANS current year is greater than zero and prior year value was zero. Please check the current year value for possible error or provide an explanation for the change.	TOTAL LIBRARIANS (administrative entity data element #251) CY is greater than zero and PY equals zero.
	N	H	N	25165	CYLIBRARIA > 0 and PYLIBRARIA > 0 and (CYLIBRARIA / PYLIBRARIA < 0.17 or CYLIBRARIA / PYLIBRARIA > 5.82)	NONCRITICAL – The number of TOTAL LIBRARIANS has had a large change from last year. Please check for possible errors or provide an explanation for the change.	TOTAL LIBRARIANS (administrative entity data element #251) CY / PY is less than 0.17 or greater than 5.82.
	N	C	Y	25220	OTHPAID = -2	CRITICAL EDIT – OTHER PAID EMPLOYEES is -2. Please check for error. -2 is not a valid response.	OTHER PAID EMPLOYEES (administrative entity data element #252) is -2.
	N	C	N	25224	LIBRARIA > 10 and OTHPAID = 0	NONCRITICAL – TOTAL LIBRARIANS is greater than 10 and OTHER PAID EMPLOYEES is zero.	TOTAL LIBRARIANS (administrative entity data element #251) is greater than 10 and OTHER PAID EMPLOYEES (administrative entity data element #252) is equal to zero.
	N	H	N	25261	PYOTHPAID = -1 and CYOTHPAID = 0 && (PYSTATSTRU <> 22 or 25)	NONCRITICAL – OTHER PAID EMPLOYEES is zero in the current year and the prior year value was -1. Please check the current year value for possible error.	OTHER PAID EMPLOYEES (administrative entity data element #252) CY equals zero and PY equals -1.
	N	H	N	25262	PYOTHPAID > 1.5 and CYOTHPAID = 0	NONCRITICAL – OTHER PAID EMPLOYEES prior year is greater than 1.5 and current year is zero. Please check the current year value for possible error or provide an explanation for the change.	OTHER PAID EMPLOYEES (administrative entity data element #252) PY is greater than 1.5 and CY equals zero.
	N	H	N	25263	CYOTHPAID > 1.5 and PYOTHPAID = 0	NONCRITICAL – OTHER PAID EMPLOYEES current year is greater than 1.5 and prior year value was zero. Please check the current year value for possible error or provide an explanation for the change.	OTHER PAID EMPLOYEES (administrative entity data element #252) CY is greater than 1.5 and PY equals zero.
	N	H	N	25265	CYOTHPAID > 0 and PYOTHPAID > 0 and (CYOTHPAID / PYOTHPAID < 0.16 or CYOTHPAID / PYOTHPAID > 6.40)	NONCRITICAL – The number of OTHER PAID EMPLOYEES has had a large change from last year. Please check for possible errors or provide an explanation for the change.	OTHER PAID EMPLOYEES (administrative entity data element #252) CY / PY is less than 0.16 or greater than 6.40.
	N	C	N	25310	TOTSTAFF >= 0 & (LIBRARIA + OTHPAID = TOTSTAFF) & (LIBRARIA = -1 or OTHPAID = -1)	NONCRITICAL – TOTAL PAID EMPLOYEES equals reported detail but the remaining detail item is equal to -1 or TOTAL PAID EMPLOYEES equals zero and detail are all -1. Please review these items and provide corrections.	TOTAL PAID EMPLOYEES (administrative entity data element #253) equals either reported TOTAL LIBRARIANS (administrative entity data element #251) or OTHER PAID EMPLOYEES (administrative entity data element #252) and the remaining detail item is equal to -1 or the total is zero and detail elements are all -1.
	N	C	N	25311	TOTSTAFF >= 0 and LIBRARIA + OTHPAID<TOTSTAFF and ((LIBRARIA=-1 and OTHPAID>= 0) OR (OTHPAID=-1 and LIBRARIA>= 0))	NONCRITICAL – Reported detail is less than reported TOTAL PAID EMPLOYEES and the other detail item is -1. Either the missing value can be determined or the total is questionable.	Reported detail for TOTAL LIBRARIANS (administrative entity data element #251) or OTHER PAID EMPLOYEES (administrative entity data element #252) is less than reported TOTAL PAID EMPLOYEES (administrative entity data element #253) and the other detail item is -1.
	N	C	N	25313	LIBRARIA => 0 and OTHPAID => 0 and TOTSTAFF < 0	NONCRITICAL – Detail items are reported but TOTAL PAID EMPLOYEES is not reported. Please check for possible errors.	TOTAL LIBRARIANS (administrative entity data element #251) and OTHER PAID EMPLOYEES (administrative entity data element #252) are reported but TOTAL PAID EMPLOYEES (administrative entity data element #253) is not reported.
	N	C	Y	25314	TOTSTAFF >= 0 and (LIBRARIA => 0 and LIBRARIA > TOTSTAFF and OTHPAID = -1) or (OTHPAID => 0 and OTHPAID > TOTSTAFF and LIBRARIA = -1)	CRITICAL EDIT – Reported detail is greater than reported TOTAL PAID EMPLOYEES. Please check for possible errors or consider -1 for the total.	Reported detail for TOTAL LIBRARIANS (administrative entity data element #251) and OTHER PAID EMPLOYEES (administrative entity data element #252) is greater than reported TOTAL PAID EMPLOYEES (administrative entity data element #253).
	N	C	Y	25315	TOTSTAFF => 0 and LIBRARIA => 0 and OTHPAID => 0 and (TOTSTAFF <> LIBRARIA + OTHPAID)	CRITICAL EDIT – TOTAL PAID EMPLOYEES is reported and does not equal the sum of the detail.	TOTAL PAID EMPLOYEES (administrative entity data element #253) is not equal to the sum of TOTAL LIBRARIANS (administrative entity data element #251) and OTHER PAID EMPLOYEES (administrative entity data element #252).
	N	C	Y	25320	TOTSTAFF = -2	CRITICAL EDIT – TOTAL PAID EMPLOYEES is -2. Please check for error. -2 is not a valid response.	TOTAL PAID EMPLOYEES (administrative entity data element #253) is -2.
	N	C	N	25321	TOTSTAFF = 0 and STAFFEXP <> 0	NONCRITICAL – TOTAL PAID EMPLOYEES is equal to zero and TOTAL STAFF EXPENDITURES is not equal to zero. Please check for possible errors.	TOTAL STAFF EXPENDITURES (administrative entity data element #352) is not equal to zero and TOTAL PAID EMPLOYEES (administrative entity data element #253) equals zero.
	N	C	N	25327	TOTSTAFF = 0	NONCRITICAL – TOTAL PAID EMPLOYEES is zero. Please check for possible errors.	TOTAL PAID EMPLOYEES (administrative entity data element #253) is zero.
	N	H	N	25365	(CYLIBRARIA = -1 or CYOTHPAID = -1) and CYTOTSTAFF > 0 and PYTOTSTAFF > 0 and (CYTOTSTAFF / PYTOTSTAFF < 0.36 or CYTOTSTAFF / PYTOTSTAFF > 2.85)	NONCRITICAL – The number of TOTAL PAID EMPLOYEES has had a large change from last year. Please check for possible errors or provide an explanation for the change.	TOTAL PAID EMPLOYEES (administrative entity data element #253) CY / PY is less than 0.36 or greater than 2.85.
	N	C	Y	30020	LOCGVT = -2	CRITICAL EDIT – LOCAL GOVERNMENT REVENUE is -2. Please check for error. -2 is not a valid response.	LOCAL GOVERNMENT REVENUE (administrative entity data element #300) is -2.
	N	C	N	30025	LOCGVT > 0 and POPU_LSA > 0 and (LOCGVT / POPU_LSA < 0.34 or LOCGVT / POPU_LSA > 878.10)	NONCRITICAL – The ratio of LOCAL GOVERNMENT REVENUE to POPULATION OF LEGAL SERVICE AREA is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.	The ratio of LOCAL GOVERNMENT REVENUE (administrative entity data element #300) to POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) is less than 0.34 or greater than 878.10.
	N	C	N	30026	LOCGVT = 0 and POPU_LSA > 50,000	NONCRITICAL – POPULATION OF LEGAL SERVICE AREA is greater than 50,000 and LOCAL GOVERNMENT REVENUE is zero. Please check for possible errors.	POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) is greater than 50,000 and LOCAL GOVERNMENT REVENUE (administrative entity data element #300) equals zero.
	N	H	N	30060	PYLOCGVT = -1 and CYLOCGVT = 1	NONCRITICAL – LOCAL GOVERNMENT REVENUE is 1 and the prior year value was -1. Please check the current year value for possible error.	LOCAL GOVERNMENT REVENUE (administrative entity data element #300) CY equals 1 and PY equals -1.
	N	H	N	30061	PYLOCGVT = -1 and CYLOCGVT = 0 && (PYSTATSTRU <> 22 or 25)	NONCRITICAL – LOCAL GOVERNMENT REVENUE is zero in the current year and the prior year value was -1. Please check the current year value for possible error.	LOCAL GOVERNMENT REVENUE (administrative entity data element #300) CY equals zero and PY equals -1.
	N	H	N	30062	PYLOCGVT > 0 and CYLOCGVT = 0	NONCRITICAL – LOCAL GOVERNMENT REVENUE prior year is greater than zero and current year is zero. Please check the current year value for possible error or provide an explanation for the change.	LOCAL GOVERNMENT REVENUE (administrative entity data element #300) PY is greater than zero and CY equals zero.
	N	H	N	30063	CYLOCGVT > 0 and PYLOCGVT = 0	NONCRITICAL – LOCAL GOVERNMENT REVENUE current year is greater than zero and prior year value was zero. Please check the current year value for possible error or provide an explanation for the change.	LOCAL GOVERNMENT REVENUE (administrative entity data element #300) CY is greater than zero and PY equals zero.
	N	H	N	30065	CYLOCGVT > 0 and PYLOCGVT > 0 and (CYLOCGVT / PYLOCGVT < 0.60 or CYLOCGVT / PYLOCGVT > 1.83)	NONCRITICAL – LOCAL GOVERNMENT REVENUE has had a large change from last year. Please check for possible errors or provide an explanation for the change.	LOCAL GOVERNMENT REVENUE (administrative entity data element #300) CY / PY is less than 0.60 or greater than 1.83.

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jul 23, 2024.