Attachment_3_-_PLS_FY2014_Edits.pdf

PLS EDIT MESSAGES AND CONDITIONS

FY 2014 Edit Messages and Conditions

EDIT TYPE CODES

WebPLUS edit messages are coded with 5-digit numbers. The first three numbers are the data element number and the last two numbers are the edit type code. In the example below, the first three numbers represent the data element number for Web Address and the last 2 numbers represent the edit type code for "Invalid" edits. The edit type codes are listed in the following table, followed by the edit messages and conditions.

EXAMPLE: 16220 - CRITICAL EDIT – PHONE number is –2.

Description TYPE#

Global 01 Some detail are reported and equals Total but rest of detail not zero 10 One detail item is -1 but rest does not equal Total 11 Total equals zero but detail does not 12 Detail are reported but Total is not 13 Total is less than reported detail with some -1 values 14 Sum of reported detail does not equal total 15 Summation other (expenditures detail) 16 Invalid 20 Logical 21 Magnitude 22 Comparison GT 23 Comparison EQ 24 Ratio bounds 25 Ratio presence 26 Definition violation 27 Consistency 28 Subset 29 Historical edit format 1: PY = -1 CY = 1 60 Historical edit format 2: PY = -1 CY = 0 61 Historical edit format 3: PY > X CY = 0 62 Historical edit format 4: CY > X PY = 0 63 Historical edit format 5: CY = PY 64 Historical edit format 6: Resistant fences bounds 65 Historical edit format 7: Miscellaneous 66 Historical change in character variable 67 Historical percent change only 68 Historical net change only 69 Historical magnitude 70 Historical difference 71 Historical comparison 72 Historical global percent change 73 Historical net change 74 Other 80 Internal run - unclassified 99

PLS CRITICAL EDIT CHECKS

Critical Edit Checks

Note: The following edit conditions must be resolved before you can lock your data for submission.

Critical Edits New Code Edit Message Edit Condition

10020 CRITICAL EDIT – Reporting Period Start Date is not reported or is not valid.

The REPORTING PERIOD START DATE (state characteristics data element #100) is –2 or missing.

10120 CRITICAL EDIT – Reporting Period End Date is not reported or is not valid.

The REPORTING PERIOD END DATE (state characteristics data element #101) is -2 or missing.

10220 CRITICAL EDIT – The STATE POPULATION ESTIMATE is not reported or is equal to zero.

STATE POPULATION ESTIMATE (state characteristics data element #102) is less than or equal to zero.

10229 CRITICAL EDIT – The TOTAL

UNDUPLICATED POPULATION

OF LEGAL SERVICE AREAS is greater than STATE TOTAL

POPULATION ESTIMATE.

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).

10320 CRITICAL EDIT – The TOTAL

UNDUPLICATED POPULATION

is not reported or is equal to zero.

TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE

AREAS (state characteristics data element #103) is less than or equal to zero.

10329 CRITICAL EDIT – The TOTAL

UNDUPLICATED POPULATION

OF LEGAL SERVICE AREAS is greater than the total

POPULATION OF LEGAL

SERVICE AREAs.

TOTAL UNDUPLICATED POPULATION OF LEGAL SERVICE

AREAS (state characteristics data element #103) is greater than the sum of individual POPULATION OF LEGAL SERIVCE AREA (administrative entity data element #208).

15220 CRITICAL EDIT – Library NAME is not reported.

The library NAME (administrative entity data element #152) is not reported.

15320 CRITICAL EDIT – STREET

ADDRESS is not reported.

The STREET ADDRESS (administrative entity data element #153) is not reported.

15420 CRITICAL EDIT – CITY is not reported.

The CITY name (administrative entity data element #154) is not reported or is not valid.

15520 CRITICAL EDIT – ZIP CODE is not reported or is not valid.

The ZIP CODE (administrative entity data element #155) is not reported or is not a valid 5-digit number.

15720 CRITICAL EDIT – MAILING

ADDRESS is not reported.

The MAILING ADDRESS (administrative entity data element #157) is not reported or is not valid.

Critical Edits New Code Edit Message Edit Condition

15820 CRITICAL EDIT – MAILING

CITY is not reported.

The MAILING CITY name (administrative entity data element #158) is not reported or contains the word ‘same’.

15920 CRITICAL EDIT – MAILING ZIP

CODE is not reported.

The MAILING ZIP CODE (administrative entity data element #159) is not reported or is not a valid 5-digit number.

16120 CRITICAL EDIT – COUNTY is not reported.

The COUNTY name (administrative entity data element #161) is not reported or is not valid.

16220 CRITICAL EDIT – PHONE

number is –2 or is not valid.

The PHONE number (administrative entity data element #162) is –2 or is not a valid 10-digit number.

20020 CRITICAL EDIT –

INTERLIBRARY RELATIONSHIP

CODE is not reported or is not a valid code.

INTERLIBRARY RELATIONSHIP CODE (administrative entity data element #200) is not reported as ‘HQ’, ‘ME’, or ‘NO’.

20120 CRITICAL EDIT – LEGAL BASIS

CODE is not reported or is not a valid code.

LEGAL BASIS CODE (administrative entity data element #201) is not reported as ‘CC’, ‘CI’, ‘CO’, ‘LD’, ‘MJ’, 'NL’, ’NP’, ’SD’, or ’OT’.

20220 CRITICAL EDIT – The

ADMINISTRATIVE STRUCTURE

CODE is not reported or is not a valid code.

The ADMINISTRATIVE STRUCTURE CODE (administrative entity data element #202) is not reported as ‘MA’, ’MO’, or ’SO’.

20320 CRITICAL EDIT – FSCS PUBLIC

LIBRARY is not reported or is not a valid code.

FSCS PUBLIC LIBRARY (administrative entity data element #203) is not reported as ‘Y’ or ‘N’.

20420 CRITICAL EDIT – GEOGRAPHIC

CODE is not reported or is not a valid code.

GEOGRAPHIC CODE (administrative entity data element #204) is not reported as ‘CI1’, ’CI2’, ’CO1’, ’CO2’, ’MA1’, ’MA2’, ’MC1’, ’MC2’, ’SD1’, ’SD2’, or ’OTH’.

20520 CRITICAL EDIT – LSA

BOUNDARY CHANGE is not reported or is not a valid code.

LSA BOUNDARY CHANGE (administrative entity data element #205) is not reported or is not reported as 'Y' or 'N'.

20620 CRITICAL EDIT – Library's

REPORTING PERIOD

STARTING DATE is not reported or is not valid.

REPORTING PERIOD STARTING DATE (administrative entity data element #206) is not reported or is not formatted correctly.

20629 CRITICAL EDIT – Library's

REPORTING PERIOD

STARTING DATE is before the state's REPORTING PERIOD

STARTING DATE.

REPORTING PERIOD STARTING DATE (administrative entity data element #206) is before the state REPORTING PERIOD STARTING DATE (state characteristics data element #100).

Code Edit Message Edit Condition

20720 CRITICAL EDIT – Library's

REPORTING PERIOD ENDING

DATE is not reported or is not valid.

REPORTING PERIOD ENDING DATE (administrative entity data element #207) is not reported or is not formatted correctly.

20729 CRITICAL EDIT – Library's

REPORTING PERIOD ENDING

DATE is after the state's

REPORTING PERIOD ENDING

DATE.

REPORTING PERIOD ENDING DATE (administrative entity data element #207) is after the state's REPORTING PERIOD ENDING DATE (state characteristics data element #101).

20820 CRITICAL EDIT – The

POPULATION OF LEGAL

SERVICE AREA is not reported or is equal to zero.

POPULATION OF LEGAL SERVICE AREA (administrative entity data element #208) is less than or equal to zero.

20920 CRITICAL EDIT – The number of CENTRAL service outlet is not reported.

CENTRAL service outlet (administrative entity data element #209) is less than zero.

20922 CRITICAL EDIT – CENTRAL

service outlet is greater than 1.

CENTRAL service outlet (administrative entity data element #209) is greater than 1. Note: CENTRAL cannot be greater than 1.

20928 CRITICAL EDIT – CENTRAL

service outlet is not equal to the number of central outlet records.

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).

21020 CRITICAL EDIT – The number of BRANCH service outlets is not reported.

BRANCH service outlets (administrative entity data element #210) is not reported.

21028 CRITICAL EDIT – The number of BRANCH service outlets is not equal to the number of branch outlet records.

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).

21120 CRITICAL EDIT – The number of BOOKMOBILE service outlets is not reported.

BOOKMOBILE service outlets (administrative entity data element #211) is not reported.

21128 CRITICAL EDIT – The number of BOOKMOBILE service outlets is not equal to the number of bookmobiles in outlet records.

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).

25020 CRITICAL EDIT – ALA-MLS is – 2.

ALA-MLS librarians (administrative entity data element #250) is –2.

Code Edit Message Edit Condition

25028 CRITICAL EDIT – ALA-MLS is greater than TOTAL

LIBRARIANS.

The number of ALA-MLS librarians (administrative entity data element #250) is greater than TOTAL LIBRARIANS (administrative entity data element #251).

25029 CRITICAL EDIT – ALA-MLS is not consistent with TOTAL

LIBRARIANS.

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.

25120 CRITICAL EDIT – TOTAL

LIBRARIANS is –2.

TOTAL LIBRARIANS (administrative entity data element #251) is –2.

25220 CRITICAL EDIT – OTHER PAID

EMPLOYEES is –2.

OTHER PAID EMPLOYEES (administrative entity data element #252) is –2.

25315 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).

25320 CRITICAL EDIT – TOTAL PAID

EMPLOYEES is –2.

TOTAL PAID EMPLOYEES (administrative entity data element #253) is –2.

30020 CRITICAL EDIT – LOCAL

GOVERNMENT REVENUE is – 2.

LOCAL GOVERNMENT REVENUE (administrative entity data element #300) is –2.

30120 CRITICAL EDIT – STATE

GOVERNMENT REVENUE is – 2.

STATE GOVERNMENT REVENUE (administrative entity data element #301) is –2.

30220 CRITICAL EDIT – FEDERAL

GOVERNMENT REVENUE is – 2.

FEDERAL GOVERNMENT REVENUE (administrative entity data element #302) is –2.

30320 CRITICAL EDIT – OTHER

REVENUE is –2.

OTHER REVENUE (administrative entity data element #303) is –2.

30415 CRITICAL EDIT – TOTAL

OPERATING REVENUE is reported and does not equal to the sum of the detail.

TOTAL OPERATING REVENUE (administrative entity data element #304) is not equal to the sum of reported LOCAL GOVERNMENT (administrative entity data element #300), STATE GOVERNMENT (administrative entity data element #301), FEDERAL GOVERNMENT (administrative entity data element #302), and OTHER OPERATING REVENUE (administrative entity data element #303).

30420 CRITICAL EDIT – TOTAL

OPERATING REVENUE is –2.

TOTAL OPERATING REVENUE (administrative entity data element #304) is –2.

35020 CRITICAL EDIT – SALARIES &

WAGES EXPENDITURES is –2.

SALARIES & WAGES EXPENDITURES (administrative entity data element #350) is –2.

Code Edit Message Edit Condition

35120 CRITICAL EDIT – EMPLOYEE

BENEFITS EXPENDITURES is – 2.

EMPLOYEE BENEFITS EXPENDITURES (administrative entity data element #351) is –2.

35215 CRITICAL EDIT – TOTAL STAFF

EXPENDITURES is reported and does not equal to the sum of the detail.

TOTAL STAFF EXPENDITURES (administrative entity data element #352) is not equal to the sum of reported SALARIES & WAGES EXPENDITURES (administrative entity data element #350) and EMPLOYEE BENEFITS EXPENDITURES (administrative entity data element #351).

35220 CRITICAL EDIT – TOTAL STAFF

EXPENDITURES is –2.

TOTAL STAFF EXPENDITURES (administrative entity data element #352) is –2.

35320 CRITICAL EDIT – PRINT

MATERIALS EXPENDITURES is –2.

PRINT MATERIALS EXPENDITURES (administrative entity data element #353) is –2.

35420 CRITICAL EDIT – ELECTRONIC

MATERIALS EXPENDITURES is –2.

ELECTRONIC MATERIALS EXPENDITURES (administrative entity data element #354) is –2.

35520 CRITICAL EDIT – OTHER

MATERIALS EXPENDITURES is –2.

OTHER MATERIALS EXPENDITURES (administrative entity data element #355) is –2.

35615 CRITICAL EDIT – TOTAL

COLLECTION EXPENDITURES

is reported and does not equal to the sum of the detail.

TOTAL COLLECTION EXPENDITURES (administrative entity data element #356) is not equal to the sum of reported PRINT MATERIALS EXPENDITURES (administrative entity data element #353), ELECTRONIC MATERIALS EXPENDITURES (administrative entity data element #354), and OTHER MATERIALS EXPENDITURES (administrative entity data element #355).

35620 CRITICAL EDIT – TOTAL

COLLECTION EXPENDITURES

is –2.

TOTAL COLLECTION EXPENDITURES (administrative entity data element #356) is –2.

35720 CRITICAL EDIT – OTHER

OPERATING EXPENDITURES is –2.

OTHER OPERATING EXPENDITURES (administrative entity data element #357) is –2.

35815 CRITICAL EDIT – TOTAL

OPERATING EXPENDITURES is reported and does not equal to the sum of the detail.

TOTAL OPERATING EXPENDITURES (administrative entity data element #358) is not equal to the sum of TOTAL STAFF EXPENDITURES (administrative entity data element #352), TOTAL COLLECTION EXPENDITURES (administrative entity data element #356), and OTHER OPERATING EXPENDITURES (administrative entity data element #357).

35820 CRITICAL EDIT – TOTAL

OPERATING EXPENDITURES is –2.

TOTAL OPERATING EXPENDITURES (administrative entity data element #358) is –2.

Code Edit Message Edit Condition

40020 CRITICAL EDIT – LOCAL

GOVERNMENT CAPITAL

REVENUE is –2.

LOCAL GOVERNMENT CAPITAL REVENUE (administrative entity data element #400) is –2.

40120 CRITICAL EDIT – STATE

GOVERNMENT CAPITAL

REVENUE is –2.

STATE GOVERNMENT CAPITAL REVENUE (administrative entity data element #401) is –2.

40220 CRITICAL EDIT – FEDERAL

GOVERNMENT CAPITAL

REVENUE is –2.

FEDERAL GOVERNMENT CAPITAL REVENUE

(administrative entity data element #402) is –2.

40320 CRITICAL EDIT – OTHER

CAPITAL REVENUE is –2.

OTHER CAPITAL REVENUE (administrative entity data element #403) is –2.

40415 CRITICAL EDIT – TOTAL

CAPITAL REVENUE is reported and does not equal to the sum of the detail.

TOTAL CAPITAL REVENUE (administrative entity data element #404) is not equal to the sum of LOCAL GOVERNMENT CAPITAL REVENUE (administrative entity data element #400), STATE GOVERNMENT CAPITAL REVENUE (administrative entity data element #401), FEDERAL GOVERNMENT CAPITAL REVENUE

(administrative entity data element #402), and OTHER CAPITAL REVENUE (administrative entity data element #403).

40420 CRITICAL EDIT – TOTAL

CAPITAL REVENUE is –2.

TOTAL CAPITAL REVENUE (administrative entity data element #404) is –2.

40520 CRITICAL EDIT – TOTAL

CAPITAL EXPENDITURES is –2.

TOTAL CAPITAL EXPENDITURES (administrative entity data element #405) is –2.

45020 CRITICAL EDIT – PRINT

MATERIALS is –2.

PRINT MATERIALS (administrative entity data element #450) is –2.

45120 CRITICAL EDIT – ELECTRONIC

BOOKS is –2.

ELECTRONIC BOOKS (administrative entity data element #451) is –2.

45220 CRITICAL EDIT – AUDIO

PHYSICAL UNITS is –2.

AUDIO PHYSICAL UNITS (administrative entity data element #452) is –2.

45320 CRITICAL EDIT – AUDIO

DOWNLOADABLE UNITS is –2.

AUDIO DOWNLOADABLE UNITS (administrative entity data element #453) is –2.

45420 CRITICAL EDIT – VIDEO

PHYSICAL UNITS is –2.

VIDEO PHYSICAL UNITS (administrative entity data element #454) is –2.

45520 CRITICAL EDIT – VIDEO

DOWNLOADABLE UNITS is –2.

VIDEO DOWNLOADABLE UNITS (administrative entity data element #455) is –2.

45620 CRITICAL EDIT – LOCAL

LICENSED DATABASES is –2.

LOCAL LICENSED DATABASES (administrative entity data element #456) is –2.

45720 CRITICAL EDIT – STATE

LICENSED DATABASES is –2.

STATE LICENSED DATABASES (administrative entity data element #457) is –2.

Code Edit Message Edit Condition

45815 CRITICAL EDIT – TOTAL

LICENSED DATABASES is reported and does not equal to the sum of the detail.

TOTAL LICENSED DATABASES (administrative entity data element #458) is not equal to the sum of LOCAL LICENSED DATABASES(administrative entity data element #456) and STATE LICENSED DATABASES(administrative entity data element #457).

45820 CRITICAL EDIT – TOTAL

LICENSED DATABASES is –2.

TOTAL LICENSED DATABASES (administrative entity data element #458) is –2.

46020 CRITICAL EDIT – CURRENT

PRINT SERIAL SUBSCRIPTIONS

is –2.

CURRENT PRINT SERIAL SUBSCRIPTIONS (administrative entity data element #460) is –2.

50020 CRITICAL EDIT – Annual

PUBLIC SERVICE HOURS PER

YEAR is –2.

Annual PUBLIC SERVICE HOURS PER YEAR (administrative entity data element #500) is –2.

50120 CRITICAL EDIT – Annual LIBRARY VISITS in library is – 2.

Annual LIBRARY VISITS in library (administrative entity data element #501) is zero or –2.

50220 CRITICAL EDIT – Annual REFERENCE TRANSACTIONS is –2.

Annual REFERENCE TRANSACTIONS (administrative entity data element #502) is –2.

50320 CRITICAL EDIT – REGISTERED

USERS is –2.

REGISTERED USERS (administrative entity data element #503) is –2.

55020 CRITICAL EDIT – TOTAL

CIRCULATION is –2.

TOTAL CIRCULATION (administrative entity data element #550) is –2.

55029 CRITICAL EDIT – CIRCULATION

OF CHILDREN'S MATERIALS is greater than TOTAL

CIRCULATION.

TOTAL CIRCULATION (administrative entity data element #550) is less than CIRCULATION OF CHILDREN'S MATERIALS (administrative entity data element #551).

55120 CRITICAL EDIT – CIRCULATION

OF CHILDREN'S MATERIALS is zero or –2.

CIRCULATION OF CHILDREN'S MATERIALS (administrative entity data element #551) is –2.

55220 CRITICAL EDIT – CIRCULATION

OF ELECTRONIC MATERIALS is zero or –2.

CIRCULATION OF ELECTRONIC MATERIALS (administrative entity data element #552) is –2.

55229 CRITICAL EDIT – CIRCULATION

OF ELECTRONIC MATERIALS is greater than TOTAL

CIRCULATION.

TOTAL CIRCULATION (administrative entity data element #550) is less than CIRCULATION OF ELECTRONIC MATERIALS (administrative entity data element #552).

55320 CRITICAL EDIT – LOANS

PROVIDED TO other libraries is –2.

LOANS PROVIDED TO other libraries (administrative entity data element #553) is –2.

Code Edit Message Edit Condition

55420 CRITICAL EDIT – Inter-library loans RECEIVED FROM other libraries is –2.

Inter-library loans RECEIVED FROM other libraries (administrative entity data element #554) is –2.

60020 CRITICAL EDIT – TOTAL

NUMBER OF LIBRARY

PROGRAMS is –2.

TOTAL NUMBER OF LIBRARY PROGRAMS (administrative entity data element #600) is –2.

60023 CRITICAL EDIT – TOTAL

NUMBER OF LIBRARY

PROGRAMS is not consistent with NUMBER OF CHILDREN'S

AND YOUNG ADULT

PROGRAMS.

TOTAL NUMBER OF LIBRARY PROGRAMS (administrative entity data element #600) is less than NUMBER OF CHILDREN'S PROGRAMS (administrative entity data element #601) plus YOUNG ADULT LIBRARY PROGRAMS (administrative entity #602) or TOTAL LIBRARY PROGRAMS is zero and CHILDREN’S LIBRARY PROGRAMS plus YOUNG ADULT PROGRAMSis not zero.

60029 CRITICAL EDIT – TOTAL

NUMBER OF LIBRARY

PROGRAMS is not consistent with NUMBER OF CHILDREN'S

PROGRAMS.

TOTAL NUMBER OF LIBRARY PROGRAMS (administrative entity data element #600) is less than NUMBER OF CHILDREN'S PROGRAMS (administrative entity data element #601) or TOTAL LIBRARY PROGRAMS is zero and CHILDREN’S LIBRARY PROGRAMS is not zero.

60120 CRITICAL EDIT – NUMBER OF

CHILDREN'S PROGRAMS is –2.

NUMBER OF CHILDREN'S PROGRAMS (administrative entity data element #601) is –2.

60220 CRITICAL EDIT – NUMBER OF

YOUNG ADULT PROGRAMS is –2.

NUMBER OF YOUNG ADULT PROGRAMS (administrative entity data element #602) is –2.

60320 CRITICAL EDIT – TOTAL

PROGRAM ATTENDANCE is – 2.

TOTAL PROGRAM ATTENDANCE (administrative entity data element #602) is –2.

60420 CRITICAL EDIT – CHILDREN'S

PROGRAM ATTENDANCE is – 2.

CHILDREN'S PROGRAM ATTENDANCE (administrative entity data element #603) is –2.

60428 CRITICAL EDIT – TOTAL

PROGRAM ATTENDANCE is not consistent with

CHILDREN'S PROGRAM

ATTENDANCE.

TOTAL PROGRAM ATTENDANCE (administrative entity data element #602) is less than CHILDREN'S PROGRAM ATTENDANCE (administrative entity data element #603) or TOTAL PROGRAM ATTENDANCE is zero and CHILDREN’S PROGRAM ATTENDANCE is not zero.

60429 CRITICAL EDIT – TOTAL

PROGRAM ATTENDANCE is not consistent with

CHILDREN'S PROGRAM

ATTENDANCE.

TOTAL PROGRAM ATTENDANCE (administrative entity data element #602) is less than CHILDREN'S PROGRAM ATTENDANCE (administrative entity data element #603) or TOTAL PROGRAM ATTENDANCE is zero and CHILDREN’S PROGRAM ATTENDANCE is not zero.

60520 CRITICAL EDIT - TOTAL

YOUNG ADULT ATTENDANCE

is -2.

YOUNG ADULT PROGRAM ATTENDANCE (administrative entity data element #605) is -2.

Code Edit Message Edit Condition

60528 CRITICAL EDIT - TOTAL

PROGRAM ATTENDANCE is not consistent with YOUNG

ADULT PROGRAM

ATTENDANCE.

TOTAL PROGRAM ATTENDANCE (administrative entity data element #603) is less than YOUNG ADULT PROGRAM ATTENDANCE (administrative entity data element #605).

60529 CRITICAL EDIT – TOTAL

PROGRAM ATTENDANCE is not consistent with YOUNG

ADULT PROGRAM

ATTENDANCE.

TOTAL PROGRAM ATTENDANCE (administrative entity data element #603) is less than YOUNG ADULT PROGRAM ATTENDANCE (administrative entity data element #605) or TOTAL PROGRAM ATTENDANCE is zero and YOUNG ADULT PROGRAM ATTENDANCE is not zero.

65020 CRITICAL EDIT – INTERNET

COMPUTERS USED BY

GENERAL PUBLIC is –2.

INTERNET COMPUTERS USED BY GENERAL PUBLIC

(administrative entity data element #650) is –2.

65120 CRITICAL EDIT – USES OF

PUBLIC INTERNET

COMPUTERS PER YEAR is –2.

USES OF PUBLIC INTERNET COMPUTERS PER YEAR

(administrative entity data element #651) is –2.

65220 CRITICAL EDIT – WIRELESS

SESSIONS is –2.

WIRELESS SESSIONS (administrative entity data element #652) is –2.

70220 CRITICAL EDIT – Library NAME is not reported or is not valid.

Library NAME (outlet data element #702) is not reported.

70320 CRITICAL EDIT – STREET

ADDRESS is not reported.

STREET ADDRESS (outlet data element #703) is not reported.

70420 CRITICAL EDIT – CITY is not reported.

CITY (outlet data element #704) is not reported or is not valid.

70520 CRITICAL EDIT – ZIP CODE is not reported or is not valid.

ZIP CODE (outlet data element #705) is not a valid 5-digit number or is not reported.

70720 CRITICAL EDIT – COUNTY is not reported or is not valid.

The COUNTY name (outlet data element #707) is not reported or is not valid.

70820 CRITICAL EDIT – PHONE

number is not reported or is not valid.

The PHONE number (outlet data element #708) is –2 or is not a valid 10-digit number.

70920 CRITICAL EDIT – OUTLET TYPE

CODE is not reported or is not a valid code.

OUTLET TYPE CODE (outlet data element #709) is not reported as 'CE', 'BR', 'BS', or 'BM'.

71120 CRITICAL EDIT – SQUARE

FOOTAGE OF OUTLET is –2.

SQUARE FOOTAGE OF OUTLET (outlet data element #711) is –2.

71220 CRITICAL EDIT – The OUTLET TYPE CODE is ‘BS’ but

NUMBER OF BOOKMOBILES

is not reported.

OUTLET TYPE CODE (outlet data element #709) is 'BS' and NUMBER OF BOOKMOBILES (outlet data element #712) is less than or equal to zero.

Code Edit Message Edit Condition

71228 CRITICAL EDIT – OUTLET TYPE

CODE is ‘BR’, 'BM', or ‘CE’ but

NUMBER OF BOOKMOBILES

is not equal to zero.

OUTLET TYPE CODE (outlet data element #709) is 'BR', 'BM', or 'CE' and NUMBER OF BOOKMOBILES (outlet data element #712) is not equal to zero.

71320 CRITICAL EDIT – HOURS PER

YEAR is –2.

HOURS PER YEAR (administrative entity data element #713) is -2.

71420 CRITICAL EDIT – WEEKS OPEN

is –2.

WEEKS OPEN (outlet data element #714) is -2.

PLS CURRENT-YEAR EDIT CHECKS

Other Current-Year Edit Checks

Note: “PY” refers to the prior-year value. “CY” refers to the current-year value.

Current Edits

Code Edit Message Edit Condition

10323 The overlap of total POPULATION OF LEGAL SERVICE AREAs to TOTAL

UNDUPLICATED POPULATION OF

LEGAL SERVICE AREAS is questionable.

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.

20025 Percentage of libraries with INTERLIBRARY RELATIONSHIP 'HQ' is greater than 25%.

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%.

20228 The ADMINISTRATIVE STRUCTURE CODE is not consistent with the total number of service outlets.

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.

20228 The ADMINISTRATIVE STRUCTURE CODE is not consistent with the total number of service outlets.

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.

20327 The library is a FSCS PUBLIC LIBRARY and TOTAL STAFF EXPENDITURES is equal to zero.

FSCS PUBLIC LIBRARY (administrative entity data element #203) is ‘Yes’ but TOTAL STAFF EXPENDITURES (administrative entity data element #352) is equal to zero.

Code Edit Message Edit Condition

20521 GEOGRAPHIC CODE changed from prior year and LEGAL SERVICE AREA BOUNDARY CHANGE is 'No'.

GEOGRAPHIC CODE (administrative entity data element #204) changed from PY and LEGAL

SERVICE AREA BOUNDARY CHANGE

(administrative entity data element #205) is 'N'.

20623 Library's REPORTING PERIOD is greater than or less than one year.

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.

25125 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.

25224 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.

25310 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.

25311 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.

25313 Detail items are reported but TOTAL PAID EMPLOYEES is not reported.

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.

25321 TOTAL PAID EMPLOYEES is equal to zero and TOTAL STAFF EXPENDITURES is not equal to zero.

TOTAL STAFF EXPENDITURES (administrative entity data element #352) is not equal to zero and TOTAL PAID EMPLOYEES (administrative entity data element #253) equals zero.

Code Edit Message Edit Condition

25327 TOTAL PAID EMPLOYEES is zero. TOTAL PAID EMPLOYEES (administrative entity data element #253) is zero.

30025 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.

30026 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.

30410 TOTAL OPERATING REVENUE equals reported detail but one or more detail items is equal to –1 or TOTAL OPERATING REVENUE equals zero and detail are all –1. Please review these items and provide corrections.

TOTAL OPERATING REVENUE (administrative entity data element #304) equals the sum of reported detail and at least one out of LOCAL GOVERNMENT (administrative entity data element #300), STATE GOVERNMENT (administrative entity data element #301), FEDERAL GOVERNMENT (administrative entity data element #302), and OTHER REVENUE (administrative entity data element #303) is equal to –1 or the total is zero and detail elements are all –1.

30411 Reported detail is less than reported TOTAL OPERATING REVENUE and one detail item is –1. Either the missing value can be determined or the total is questionable.

Reported detail for LOCAL GOVERNMENT (administrative entity data element #300), STATE GOVERNMENT (administrative entity data element #301), FEDERAL GOVERNMENT (administrative entity data element #302), and OTHER REVENUE (administrative entity data element #303) is less than the reported TOTAL OPERATING REVENUE (administrative entity data element #304) and one detail item is –1.

30413 Detail items are reported but TOTAL OPERATING REVENUE is not reported.

LOCAL GOVERNMENT REVENUE (administrative entity data element #300), STATE GOVERNMENT REVENUE (administrative entity data element

#301), FEDERAL GOVERNMENT REVENUE

(administrative entity data element #302), and OTHER OPERATING REVENUE (administrative entity data element #303) are reported but TOTAL OPERATING REVENUE (administrative entity data element #304) is not reported.

Code Edit Message Edit Condition

30425 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.

30427 TOTAL OPERATING REVENUE is zero. TOTAL OPERATING REVENUE (administrative entity data element #304) is zero.

35021 TOTAL PAID EMPLOYEES is greater than zero but SALARIES & WAGES EXPENDITURES is zero.

TOTAL PAID EMPLOYEES (administrative entity data element #253) > 0 and SALARIES & WAGES EXPENDITURES (administrative entity data element #350) equals zero.

35025 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.

35121 EMPLOYEE BENEFITS EXPENDITURES

is equal to zero and SALARIES & WAGES EXPENDITURES is not equal to zero.

SALARIES & WAGES EXPENDITURES

(administrative entity and outlet data element #350) are reported greater than zero and

EMPLOYEE BENEFITS EXPENDITURES

(administrative entity and outlet data element #351) equals zero.

35123 EMPLOYEE BENEFITS EXPENDITURES

is reported and is greater than reported SALARIES & WAGES

EXPENDITURES.

EMPLOYEE BENEFITS EXPENDITURES

(administrative entity data element #351) is reported and is greater than reported SALARIES & WAGES EXPENDITURES (administrative entity data element #350).

35210 TOTAL STAFF EXPENDITURES equals reported detail but the remaining detail item is equal to –1 or TOTAL STAFF EXPENDITURES equals zero and detail are all –1. Please review these items and provide corrections.

TOTAL STAFF EXPENDITURES (administrative entity data element #352) equals either reported SALARIES & WAGES (administrative entity data element #350) or EMPLOYEE BENEFITS EXPENDITURES (administrative entity data element #351) and the remaining detail item is equal to –1 or the total is zero and detail elements are all –1.

Code Edit Message Edit Condition

35211 Reported detail is less than reported TOTAL STAFF EXPENDITURES and the remaining detail item is –1. Either the missing value can be determined or the total is questionable.

Reported detail for SALARIES & WAGES EXPENDITURES (administrative entity data element #350) or EMPLOYEE BENEFITS EXPENDITURES (administrative entity data element #351) is less than reported TOTAL STAFF EXPENDITURES (administrative entity data element #352) and the other detail item is –1.

35213 Detail items are reported but TOTAL STAFF EXPENDITURES is not reported.

SALARIES & WAGES EXPENDITURES

(administrative entity data element #350) and

EMPLOYEE BENEFITS EXPENDITURES

(administrative entity data element #351) are reported but TOTAL STAFF EXPENDITURES (administrative entity data element #352) is not reported.

35214 Reported detail is greater than reported TOTAL STAFF EXPENDITURES and one detail item is –1. Please check for possible errors or consider –1 for the total.

Reported detail for SALARIES & WAGES EXPENDITURES (administrative entity data element #350) and EMPLOYEE BENEFITS EXPENDITURES (administrative entity data element #351) is greater than reported TOTAL STAFF EXPENDITURES (administrative entity data element #352).

35221 TOTAL STAFF EXPENDITURES is equal to zero and TOTAL PAID EMPLOYEES is not equal to zero.

TOTAL PAID EMPLOYEES (administrative entity data element #253) is not equal to zero and TOTAL STAFF EXPENDITURES (administrative entity data element #352) equals zero.

35225 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.

35227 TOTAL STAFF EXPENDITURES is zero. TOTAL STAFF EXPENDITURES (administrative entity data element #352) is zero.

35325 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.

Code Edit Message Edit Condition

35610 TOTAL COLLECTION EXPENDITURES

equals reported detail but one or more detail items is equal to –1 or

TOTAL COLLECTION EXPENDITURES

equals zero and detail are all –1.

Please review these items and provide corrections.

TOTAL COLLECTION EXPENDITURES

(administrative entity data element #356) equals reported detail but at least one out of PRINT MATERIALS EXPENDITURES (administrative entity data element #353), ELECTRONIC MATERIALS EXPENDITURES (administrative entity data element #354), or OTHER MATERIALS EXPENDITURES (administrative entity data element #355) is equal to –1 or the total is zero and detail elements are all –1.

35611 Reported detail is less than reported

TOTAL COLLECTION EXPENDITURES

and one detail item is –1. Either the missing value can be determined or the total is questionable.

Reported detail for PRINT MATERIALS EXPENDITURES (administrative entity data element #353), ELECTRONIC MATERIALS EXPENDITURES (administrative entity data element #354), and OTHER MATERIALS EXPENDITURES (administrative entity data element #355) is less than TOTAL COLLECTION EXPENDITURES (administrative entity data element #356) and one of the detail items is –1.

35613 Detail items are reported but TOTAL COLLECTION EXPENDITURES is not reported.

PRINT MATERIAL EXPENDITURES (administrative entity data element #353), ELECTRONIC MATERIAL EXPENDITURES (administrative entity data element #354), and OTHER MATERIAL EXPENDITURES (administrative entity data element #355) are reported but TOTAL COLLECTION EXPENDITURES (administrative entity data element #356) is not reported.

35810 TOTAL OPERATING EXPENDITURES

equals reported detail but one or more detail items is equal to –1 or

TOTAL OPERATING EXPENDITURES

equals zero and detail are all –1.

Please review these items and provide corrections.

TOTAL OPERATING EXPENDITURES

(administrative entity data element #358) equals reported detail but at least one out of TOTAL STAFF EXPENDITURES (administrative entity data element #352), TOTAL COLLECTION EXPENDITURES (administrative entity data element #356), or OTHER OPERATING EXPENDITURES (administrative entity data element #357) is equal to –1 or the total is zero and detail elements are all –1.

Code Edit Message Edit Condition

35811 Reported detail is less than reported

TOTAL OPERATING EXPENDITURES

and one detail item is –1. Either the missing value can be determined or the total is questionable.

Reported detail for TOTAL STAFF EXPENDITURES (administrative entity data element #352), TOTAL COLLECTION EXPENDITURES (administrative entity data element #356), and OTHER OPERATING EXPENDITURES (administrative entity data element #357) is less than TOTAL OPERATING EXPENDITURES (administrative entity data element #358) and one of the detail items is –1.

35813 Detail items are reported but TOTAL OPERATING EXPENDITURES is not reported.

TOTAL STAFF EXPENDITURES (administrative entity data element #352), TOTAL COLLECTION EXPENDITURES (administrative entity data element #356), and OTHER OPERATING EXPENDITURES (administrative entity data element #357) are reported but TOTAL OPERATING EXPENDITURES (administrative entity data element #358) is not reported.

35814 Reported detail is greater than reported TOTAL OPERATING EXPENDITURES and one detail item is –1. Please check for possible errors or consider –1 for the total.

Reported detail for TOTAL STAFF EXPENDITURES (administrative entity data element #352), TOTAL COLLECTION EXPENDITURES (administrative entity data element #356), and OTHER OPERATING EXPENDITURES (administrative entity data element #357) is greater than reported

TOTAL OPERATING EXPENDITURES

(administrative entity data element #358).

35825 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.

35827 TOTAL OPERATING EXPENDITURES is zero.

TOTAL OPERATING EXPENDITURES

(administrative entity data element #358) is zero.

Code Edit Message Edit Condition

40410 TOTAL CAPITAL REVENUE equals reported detail but one or more detail items is equal to –1 or TOTAL CAPITAL REVENUE equals zero and detail are all –1. Please review these items and provide corrections.

TOTAL CAPITAL REVENUE (administrative entity data element #404) equals reported detail but at least one out of LOCAL GOVERNMENT CAPITAL REVENUE (administrative entity data element

#400), STATE GOVERNMENT CAPITAL REVENUE

(administrative entity data element #401), FEDERAL GOVERNMENT CAPITAL REVENUE

(administrative entity data element #402), or OTHER CAPITAL REVENUE (administrative entity data element #403) is equal to –1 or the total is zero and detail elements are all –1.

40411 Reported detail is less than reported TOTAL CAPITAL REVENUE and one detail item is –1. Either the missing value can be determined or the total is questionable.

Reported detail for LOCAL GOVERNMENT CAPITAL REVENUE (administrative entity data element #400), STATE GOVERNMENT CAPITAL REVENUE (administrative entity data element

#401), FEDERAL GOVERNMENT CAPITAL

REVENUE (administrative entity data element #402), and OTHER CAPITAL REVENUE (administrative entity data element #403) is less than TOTAL CAPITAL REVENUE (administrative entity data element #404) and one of the detail items is –1.

40413 Detail items are reported but TOTAL CAPITAL REVENUE is not reported.

LOCAL GOVERNMENT CAPITAL REVENUE

(administrative entity data element #400), STATE GOVERNMENT CAPITAL REVENUE (administrative entity data element #401), FEDERAL GOVERNMENT CAPITAL REVENUE (administrative entity data element #402), and OTHER CAPITAL REVENUE (administrative entity data element #403) are reported but TOTAL CAPITAL REVENUE (administrative entity data element #404) is not reported.

40414 Reported detail is greater than reported TOTAL CAPITAL REVENUE and one detail item is –1. Please check for possible errors or consider –1 for the total.

Reported detail for LOCAL GOVERNMENT CAPITAL REVENUE (administrative entity data element #400), STATE GOVERNMENT CAPITAL REVENUE (administrative entity data element

#401), FEDERAL GOVERNMENT CAPITAL

REVENUE (administrative entity data element #402), and OTHER CAPITAL REVENUE (administrative entity data element #403) is greater than reported TOTAL CAPITAL REVENUE (administrative entity data element #404).

Code Edit Message Edit Condition

40423 TOTAL CAPITAL EXPENDITURES is greater than or equal to 1,000,000 and TOTAL CAPITAL REVENUE is zero.

TOTAL CAPITAL EXPENDITURES (administrative entity data element #405) is greater than or equal to 1,000,000 and TOTAL CAPITAL REVENUE (administrative entity data element #404) is zero.

45026 PRINT MATERIALS is greater than 10,000 but TOTAL COLLECTION EXPENDITURES is zero. Please check for possible errors.

PRINT MATERIALS (administrative entity data element #450) is greater than 10,000 and TOTAL COLLECTION EXPENDITURES (administrative entity data element #356) equals zero.

45027 PRINT MATERIALS is zero. PRINT MATERIALS (administrative entity data element #450) is zero.

45226 TOTAL OPERATING EXPENDITURES is greater than 100,000 but AUDIO PHYSICAL UNITS is zero. Please check for possible errors.

TOTAL OPERATING EXPENDITURES

(administrative entity data element #358) is greater than 100,000 and AUDIO PHYSICAL UNITS (administrative entity data element #452) equals zero.

45426 TOTAL CIRCULATION is greater than 50,000 but VIDEO PHYSICAL UNITS is zero. Please check for possible errors.

TOTAL CIRCULATION (administrative entity data element #550) is greater than 50,000 and VIDEO PHYSICAL UNITS (administrative entity data element #454) equals zero.

45810 TOTAL LICENSED DATABASES equals reported detail but one or more detail items is equal to –1 or TOTAL LICENSED DATABASES equals zero and detail are all –1. Please review these items and provide corrections.

TOTAL LICENSED DATABASES (administrative entity data element #458) equals the sum of reported detail and at least one out of LOCAL/OTHER LICENSED (administrative entity data element #456) and STATE LICENSED (administrative entity data element #457) is equal to –1 or the total is zero and detail elements are all –1.

45811 Reported detail is less than reported TOTAL LICENSED DATABASES and one detail item is –1. Either the missing value can be determined or the total is questionable.

Reported detail for LOCAL/OTHER LICENSED DATABASES (administrative entity data element #456) and STATE LICENSED DATABASES (administrative entity data element #457) is less than the reported TOTAL LICENSED DATABASES (administrative entity data element #458) and one detail item is –1.

45813 Detail items are reported but TOTAL LICENSED DATABASES is not reported.

LOCAL/OTHER LICENSED DATABASES

(administrative entity data element #456), and STATE LICENSED DATABASES (administrative entity data element #457) are reported but TOTAL LICENSED DATABASES (administrative entity data element #458) is not reported.

Code Edit Message Edit Condition

45814 Reported detail is greater than reported TOTAL LICENSED DATABASES and one detail item is –1. Please check for possible errors or consider –1 for the total.

Reported detail for LOCAL/OTHER LICENSED DATABASES (administrative entity data element #456) and STATE LICENSED DATABASES (administrative entity data element #457) is greater than reported TOTAL LICENSED DATABASES (administrative entity data element #458).

45822 TOTAL LICENSED DATABASES is greater than 1,000.

TOTAL LICENSED DATABASES (administrative entity data element #458) is greater than 1,000.

50025 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.

50027 Annual PUBLIC SERVICE HOURS PER YEAR is zero.

Annual PUBLIC SERVICE HOURS PER YEAR (administrative entity data element #500) is zero.

50125 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.

50127 Annual LIBRARY VISITS in library is zero.

Annual LIBRARY VISITS in library (administrative entity data element #501) is zero.

50129 CHILDREN'S PROGRAM ATTENDANCE

is greater than the number of LIBRARY

VISITS.

CHILDREN'S PROGRAM ATTENDANCE

(administrative entity data element #603) is greater than annual LIBRARY VISITS in library (administrative entity data element #501).

50327 The NUMBER OF REGISTERED USERS is equal to zero.

NUMBER OF REGISTERED USERS (administrative entity data element #503) is zero.

55025 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.

55027 TOTAL CIRCULATION is zero. TOTAL CIRCULATION (administrative entity data element #550) is zero.

Code Edit Message Edit Condition

55127 CIRCULATION OF CHILDREN'S

MATERIALS is zero.

CIRCULATION OF CHILDREN'S MATERIALS

(administrative entity data element #551) is zero.

55223 CIRCULATION OF ELECTRONIC

MATERIALS is greater than zero and

ELECTRONIC MATERIALS

COLLECTIONS is zero.

CIRCULATION OF ELECTRONIC MATERIALS

(administrative entity data element #552) is greater than zero and the sum of ELECTRONIC BOOKS (administrative entity data element #451) and AUDIO DOWNLOADABLE UNITS (administrative entity data element #453) and VIDEO DOWNLOADABLE UNITS (administrative entity data element #455) is zero.

55227 CIRCULATION OF ELECTRONIC

MATERIALS is zero and ELECTRONIC MATERIALS COLLECTIONS is greater than zero.

CIRCULATION OF ELECTRONIC MATERIALS

(administrative entity data element #552) is zero and the sum of ELECTRONIC BOOKS (administrative entity data element #451) and AUDIO DOWNLOADABLE UNITS (administrative entity data element #453) and VIDEO DOWNLOADABLE UNITS (administrative entity data element #455) is greater than zero.

60021 TOTAL LIBRARY PROGRAMS is equal to zero and TOTAL PROGRAM ATTENDANCE is not equal to zero.

TOTAL LIBRARY PROGRAMS (administrative entity data element #600) is zero and TOTAL PROGRAM ATTENDANCE (administrative entity data element #602) is not equal to zero.

60026 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.

60062 TOTAL PROGRAMS prior year is greater than 50 and current year is zero. Please check the current year value for possible error or provide an explanation for the change.

TOTAL PROGRAMS (administrative entity data element #600) PY is greater than 50 and CY value equals zero.

60063 TOTAL PROGRAMS current year is greater than 100 and prior year value was zero. Please check the current year value for possible error or provide an explanation for the change.

TOTAL PROGRAMS (administrative entity data element #600) CY is greater than 100 and PY value equals zero.

Code Edit Message Edit Condition

60121 TOTAL CHILDREN'S PROGRAMS is equal to zero and CHILDREN'S PROGRAM ATTENDANCE is not equal to zero.

TOTAL CHILDREN'S PROGRAMS (administrative entity data element #601) is zero and CHILDREN'S PROGRAM ATTENDANCE (administrative entity data element #603) is not equal to zero.

60126 The ratio of CHILDREN'S PROGRAM ATTENDANCE to CHILDREN'S PROGRAMS is higher/lower than expected. Please check for possible errors or explain why the correct data are out of range.

The ratio of CHILDREN'S PROGRAM ATTENDANCE (administrative entity data element #603) to TOTAL CHILDREN'S PROGRAMS (administrative entity data element #601) is less than 2.34 or greater than 202.57.

60162 CHILDREN'S PROGRAMS prior year is greater than 40 and current year is zero. Please check the current year value for possible error or provide an explanation for the change.

CHILDREN'S PROGRAMS (administrative entity data element #601) PY is greater than 40 and PY value equals zero.

60221 TOTAL YOUNG ADULT PROGRAMS is equal to zero and YOUNG ADULT PROGRAM ATTENDANCE is not equal to…