FY20 SLAA Edit Validation Reference Guide

FY20 SLAA Edit Validation Reference Guide.pdf

State Library Agencies (StLA) Survey

FY20 SLAA Edit Validation Reference Guide

OMB: 3137-0072

Document [pdf]
Download: pdf | pdf
State Library Administrative
Agency Survey, FY 2020
Edit Validation Reference Guide
Institute of Museum and Library Services
The Institute of Museum and Library Services is authorized under 20 U.S.C. Chapter 72 to fulfill the congressional mandate to
carry out analyses of the impact of library services.

Please note: This reference guide is intended for informational purposes only. The information contained within
this guide should not be used as a tool while completing the survey.

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
1

Line Number
A-230

Edit Message
FISCAL YEAR DATES (A-230, A-240) invalid.
Please report on fiscal year 2019-2020. The start
date should be prior to the end date. The
reporting period should be a full year.

Edit Condition
FISCAL YEAR STARTING DATE (A-230) is invalid. All data
in this survey (except Parts B and I) are to be reported
on the basis of State fiscal year 2019-2020. The start
date should be prior to the end date. The reporting
period should be a full year.
Year of FISCAL YEAR ENDING DATE (A-240) is invalid.
All data in this survey (except Parts B and I) are to
be reported on the basis of State fiscal year
2019-2020.
Board or commission (B-020) is selected but
APPOINTED BY GOVERNOR (B-030) and APPOINTED BY
OTHEROFFICIAL (B-040) are blank. Or, (B-020) is blank
and (B-030) or (B-040) is selected.

Severity
Fatal

2

A-240

FISCAL YEAR DATES (A-230, A-240) invalid.
Please report on fiscal year 2019-2020. The start
date should be prior to the end date. The
reporting period should be a full year.

7

B-020

Board or commission (B-020) is selected
but methods of selection are blank, or vice
versa.

11

E-020

TOTAL HOURS / WEEK (main or central outlet) (E020) is greater than 0 but is less than 32.
TOTAL HOURS/WEEK (main or central outlet) (E020) are greater than 60.
MONDAY-FRIDAY AFTER 5 P.M. hours (main
or central outlet) (E-030) are greater than
12.
SATURDAY
AND SUNDAY hours (main or
central outlet) (E-040) are greater than 16.
PART OF LARGER AGENCY (B-050) is selected but (B70) is not selected Yes or No (does SLAA have board
or commission).

TOTAL HOURS / WEEK (main or central outlet) (E-020)
is greater than 0 but less than 32.
TOTAL HOURS/WEEK (main or central outlet) (E-020)
are greater than 60.
MONDAY-FRIDAY AFTER 5 P.M. hours (main or
central outlet) (E-030) are greater than 12.
SATURDAY AND SUNDAY hours (main or central
outlet) (E-040) are greater than 16.
PART OF LARGER AGENCY (B-050) is selected but (B070) (does SLAA have board or commission) is not
selected Yes or No.

Explanation

12

E-020

13

E-030

14

E-040

15

B-050

16

B-070

BOARD OR COMMISSION (B-070) is selected
"yes" but APPOINTED BY GOVERNOR (B-080)
and/or APPOINTED BY OTHER OFFICIAL (B-090)
are not selected (does your SLAA have a board
or commission).

Yes to (B-070) (does SLAA have board or commission)
but APPOINTED BY GOVERNOR (B-080) and
APPOINTED BY OTHER OFFICIAL (B-090) are both
blank.

Fatal

1

Fatal

Fatal

Explanation
Explanation
Explanation
Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
17

Line Number
E-060

Edit Message
OTHER OUTLETS number (E-060) is too small
compared to user group numbers in column b of
(E- 090) to (E-130).
BOOKMOBILES number (E-070) is too small
compared to user group numbers in column c of
(E- 090) to (E-130).
MAIN OR CENTRAL OUTLET (E-050) does not
serve STATE GOVERNMENT EMPLOYEES (E-120)
and GENERAL PUBLIC (E-130).

Edit Condition
OTHER OUTLETS (E-060) is less than largest number in
column b of user groups (E-090) to (E-130).

Severity
Explanation

BOOKMOBILES (E-070) is less than largest number in
column c of user groups, (E-090) to (E-130) and not
equal to sum of column c.
MAIN OR CENTRAL OUTLET (E-050) is greater than 0 but
column a of STATE GOVERNMENT EMPLOYEES (E-120)
and GENERAL PUBLIC (E-130) is less than or equal to 0.

Explanation

18

E-070

20

E-050

21

F-070

Have FEDERAL DEPOSITORY LIBRARY (F-070)
but REGIONAL (F-080) and SELECTIVE (F-090)
are selected No.

Have FEDERAL DEPOSITORY LIBRARY (F-070) but
REGIONAL (F-080) and SELECTIVE (F-090) are selected
No. Enter Yes to (F-080) or (F-090) to designate type.

Fatal

22

G-010

Annual CIRCULATION per annual LIBRARY VISITS less
than 75% of last year, and the prior year to current year
change is greater than 0.5. Perform edit only when both
items' current year values are greater than 0.

Explanation

23

G-010

Annual CIRCULATION (G-010) per annual LIBRARY VISITS
(G-050) is greater than 8. Note: Perform edit only when
both items current year values are greater than 0.

Explanation

24

G-040

Annual CIRCULATION (G-010) per annual LIBRARY
VISITS (G-050) is lower than expected. Please check
both and update or explain. Please check for
possible errors or explain why the correct data are
out of range.
Annual CIRCULATION (G-010) per annual LIBRARY
VISITS (G-050) is higher than expected. Please
check both and update or explain. Please check for
possible errors or explain why the correct data are
out of range.
The amount of REFERENCE TRANSACTIONS (G-040)
per LIBRARY VISIT (G-050) is higher than expected.

Explanation

25

H-020

Annual REFERENCE TRANSACTIONS (G-040) per annual
LIBRARY VISITS (G-050) is greater than 3.0. Note: If prior
year ratio is greater than 3.0, don't flag. Perform edit
only when both items current year values are greater
than 0.
Continuing education programs: The NUMBER OF
EVENTS (H-020) is greater than the TOTAL ATTENDANCE
AT EVENTS (H-030).

Continuing education programs: NUMBER OF
EVENTS (H-020) is greater than TOTAL
ATTENDANCE AT EVENTS (H-030).

2

Explanation

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
26

Line Number
H-020

27

H-030

28

H-030

29

K_TE-010a

30

K_TE-010b

31

I-010d

32

I-020d

Edit Message
NUMBER OF EVENTS (H-020) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
ATTENDANCE AT EVENTS (H-030) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
ATTENDANCE AT EVENTS (H-030) per NUMBER OF
EVENTS (H-020) for the current reporting period has
had a large change from prior reporting period.
Please check for possible errors or explain why the
correct data are out of range.

Edit Condition
Continuing Education EVENTS (H-020) not 25% to
225% of last year, and the prior year to current year
change is greater than + or - 50. Note: Run this edit
only when values are greater than 0 for the current
and prior year.
ATTENDANCE AT EVENTS (H-030) not 50% to 200% of
last year, and the prior year to current year change is
greater than + or - 1000. Note: Run this edit only when
values are greater than 0 for current and prior year.

Severity
Explanation

(H-030)/(H-020) Average Attendance at Continuing
Education Events and the change from prior year
average to current year average is greater than + or 50. Note: Divide ATTENDANCE AT EVENTS (H-030) by
Continuing Education EVENTS (H-020).

Explanation

TOTAL FEDERAL EXPENDITURES (K_TE-010) in
column a must be greater than 0.
TOTAL STATE EXPENDITURES (K_TE-010) in column b
must be greater than 0.
ADMINISTRATION (I-010d) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
LIBRARY DEVELOPMENT (I-020d) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.

TOTAL FEDERAL EXPENDITURES (K_TE-010) in column a
must be greater than 0.
TOTAL STATE EXPENDITURES (K_TE-010) in column b
must be greater than 0.
ADMINISTRATION (I-010d) not 50% to 125% of last
year, and the prior year to current year change is
greater than + or - 2. Note: Run this edit only when
values are greater than 0 for the current and prior
year.
LIBRARY DEVELOPMENT (I-020d) not 50% to 125% of
last year, and the prior year to current year change is
greater than + or - 2. Note: Run this edit only when
values are greater than 0 for the current and prior year.

Explanation

3

Explanation

Explanation
Explanation

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Line Number
E-010

Edit Message
TOTAL HOURS / WEEK (E-010) are provided,
but TOTAL OUTLETS (E-080) is not, or vice
versa.

Edit Condition
TOTAL HOURS/WEEK (all SLAA outlets) (E-010) is
greater than 0 but TOTAL OUTLETS (E-080) is -1 or 0.
Or, TOTAL HOURS/WEEK (all SLAA outlets) (E-010) is -1
or 0 but TOTAL OUTLETS (E-080) is greater than 0.

Severity
Fatal

34

E-020

Have public service hours (E-020) to (E-040) but
no public outlets (E-120) and (E-130), or vice
versa.

TOTAL HOURS/WEEK (main or central outlet) (E-020),
or MONDAY-FRIDAY AFTER 5:00 P.M. (E-030), or
SATURDAY AND SUNDAY (E-040) is greater than 0, and
STATE GOVERNMENT EMPLOYEES (E-120) and
GENERAL PUBLIC (E-130) outlets is -1 or 0 in column a.
Or, (E-120) or (E-130) is greater than 0 in column a,
and (E-020) to (E-040) are all -1 or 0.

Fatal

35

I-030d

I-040d

LIBRARY SERVICES (I-030d) not 50% to 125% of last
year, and the prior year to current year change is
greater than + or - 2. Note: Run this edit only when
values are greater than 0 for the current and prior
year.
OTHER SERVICES (I-040d) not 75% to 125% of last year,
and the prior year to current year change is greater
than + or - 2. Note: Run this edit only when values are
greater than 0 for the current and prior year.

Explanation

36

37

I-050d

TOTAL STAFF (I-050d) not 50% to 125% of last year, and
the prior year to current year change is greater than +
or - 2. Note: Run this edit only when values are greater
than 0 for the current and prior year.

Explanation

42

K_AO-010d

LIBRARY SERVICES (I-030d) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
OTHER SERVICES (I-040d) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
TOTAL STAFF (I-050d) for the current reporting
period has had a large change from prior
reporting period. Please check for possible
errors or explain why the correct data are out of
range.
SALARIES AND WAGES (K_AO-010) are less than
or equal to EMPLOYEE BENEFITS (K_AO-020).

SALARIES AND WAGES (K_AO-010) in column d is
less than or equal to EMPLOYEE BENEFITS (K_AO020) in column d.

Explanation

Edit Code
33

4

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
43

Line Number
K_OE-020a

Edit Message
OTHER EXPENDITURES (K_OE-020a) from federal
sources equals the sum of TOTAL OPERATING
EXPENDITURES (K_AO-060a), TOTAL FINANCIAL
ASSISTANCE (K_FA-080a), CAPITAL OUTLAY
(K_OE-010a) from federal sources. This row
should not be a summation of the preceding
rows. Please check for possible errors or explain
why the correct data are out of range.

Edit Condition
TOTAL OPERATING EXPENDITURES (K_AO-060) +
TOTAL FINANCIAL ASSISTANCE (K_FA-080) + CAPITAL
OUTLAY (K_OE-010) in column a = OTHER
EXPENDITURES (K_OE-020) in column a.

Severity
Fatal

44

K_OE-020b

OTHER EXPENDITURES (K_OE-020b) from State
sources equals the sum of TOTAL OPERATING
EXPENDITURES (K_AO-060b), TOTAL FINANCIAL
ASSISTANCE (K_FA-080b), CAPITAL OUTLAY (K_OE010b) from State sources. This row should not be a
summation of the preceding rows. Please check for
possible errors or explain why the correct data are
out of range.

TOTAL OPERATING EXPENDITURES (K_AO-060) +
TOTAL FINANCIAL ASSISTANCE (K_FA-080) + CAPITAL
OUTLAY (K_OE-010) in column b = OTHER
EXPENDITURES (K_OE-020) in column b.

Fatal

45

K_OE-020c

OTHER EXPENDITURES (K_OE-020c) from other
sources equals the sum of TOTAL OPERATING
EXPENDITURES (K_AO-060c), TOTAL FINANCIAL
ASSISTANCE (K_FA-080c), CAPITAL OUTLAY (K_OE010c) from other sources. This row should not be a
summation of the preceding rows. Please check for
possible errors or explain why the correct data are
out of range.

TOTAL OPERATING EXPENDITURES (K_AO-060) +
TOTAL FINANCIAL ASSISTANCE (K_FA-080) + CAPITAL
OUTLAY (K_OE-010) in column c = OTHER
EXPENDITURES (K_OE-020) in column c.

Fatal

5

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
47

Line Number
D_PA-010a

Edit Message
Provide CONTINUING EDUCATION PROGRAMS
(D_PA-010) but NUMBER OF EVENTS (H-020) or
TOTAL ATTENDANCE AT EVENTS (H-030) is -1 or 0,
or vice versa.

55

F-010

Have collections (F-010) to (F-050) but no
service transactions (G-010) to (G-050), or vice
versa.

58

J-090

Difference between TOTAL FEDERAL REVENUE
(J-090) and TOTAL FEDERAL EXPENDITURES
(K_TE- 010a) is greater than expected. Please check
for possible errors or explain why the correct data
are out of range.

59

J-100

60

J-110

Difference between State revenue for SLAA
OPERATION (J-100) and TOTAL OPERATING
EXPENDITURES (K_AO-060b) from State funds is
greater than expected. Please check for possible
errors or explain why the correct data are out of
range.
Difference between State revenue for STATE AID
TO LIBRARIES (J-110) and FINANCIAL ASSISTANCE
(K_FA-080b) from State funds is greater than
expected. Please check for possible errors or
explain why the correct data are out of range.

6

Edit Condition
Directly or Contract to CONTINUING EDUCATION
PROGRAMS (D_PA-010) in any of columns a-e, but
NUMBER OF EVENTS (H-020) or TOTAL ATTENDANCE
AT EVENTS (H-030) is -1 or 0. Or, Not Provided to
(D_PA-010) in all of columns a-e, but (H-020) or (H030) is greater than 0.
If any of collections (F-010) to (F-050) is greater than
0, but service transactions (G-010) to (G-050) are
each equal to –1 or 0. Or, (F-010) to (F-050) are each
equal to–1 or 0, but any of (G-010) to (G-050) is
greater than 0.
TOTAL FEDERAL REVENUE (J-090) is less than 80% or
more than 120% of TOTAL federal EXPENDITURES
(K_TE-010) in column a, and difference is greater than
+ or - 200,000.

Severity
Explanation

State revenue for SLAA OPERATION (J-100) is less
than 70% or more than 150% of TOTAL OPERATING
EXPENDITURES (K_AO-060) from State funds in
column b.

Explanation

STATE AID TO LIBRARIES revenue (J-110) is less than
70% or more than 150% of TOTAL FINANCIAL
ASSISTANCE (K_FA-080) to libraries and library
cooperatives from State funds in column b. Note: Run
this edit only if STATE AID TO LIBRARIES revenue (J110) is greater than 0.

Explanation

Explanation

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
61

Line Number
J-130

Edit Message
Difference between TOTAL STATE REVENUE (J130) and TOTAL EXPENDITURES (K_TE-010b)
from State funds is greater than expected.
Please check for possible errors or explain why
the correct data are out of range.
Difference between TOTAL REVENUE (J-150) and
TOTAL EXPENDITURES (K_TE-010d) is greater than
expected. Please check for possible errors or
explain why the correct data are out of range.

Edit Condition
TOTAL STATE REVENUE (J-130) is less than 80% or
more than 120% of TOTAL EXPENDITURES (K_TE-010)
from State funds in column b, and difference is
greater than + or - 200,000.

Severity
Explanation

TOTAL REVENUE (J-150) is less than 90% or more
than 110% of TOTAL EXPENDITURES (K_TE-010) in
column d, and difference is greater than + or 200,000.

Explanation

62

J-150

67

L-020

GRANTS (L-020) expenditures, but no
expenditures on INDIVIDUAL PUBLIC LIBRARIES
(K_FA-010) or LIBRARY COOPERATIVES SERVING
PUBLIC LIBRARIES
ONLY (K_FA-020), or vice versa.

GRANTS (L-020) expenditures from LSTA is greater
than 0, but expenditures on both INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) and LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) are -1 or
0 in column a. Or, (L-020) is -1 or 0, and (K_FA-010) or
(K_FA-020) is greater than 0 in column a.

Explanation

68

K_FA-050a

Have SINGLE AGENCY OR LIBRARY
PROVIDING STATEWIDE SERVICE (K_FA-050)
federal expenditures, but no expenditures
for GRANTS (L- 020).

SINGLE AGENCY OR LIBRARY PROVIDING STATEWIDE
SERVICE (K_FA-050) federal expenditures in column a
are greater than 0, but expenditures for GRANTS (L020) are -1 or 0. Note: If any LSTA funds are reported
in (K_FA-050), they must also be reported in GRANTS
(L- 020); DO NOT report them in STATEWIDE SERVICES
(L-010).

Explanation

69

K_FA-050a

SINGLE AGENCY OR LIBRARY (K_FA-050) federal
expenditures are greater than GRANTS (L-020).

SINGLE AGENCY OR LIBRARY (K_FA-050) expenditures
from federal funds in column a are greater than
expenditures for GRANTS (L-020). Note: (K_FA-050)
cannot be greater than (L-020) unless some or all of
the expenditures are grants expenditures from federal
funds other than LSTA.

Explanation

7

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
70

Line Number
K_TE-010a

Edit Message
TOTAL EXPENDITURES (K_TE-010) from federal
funds are less than TOTAL LSTA EXPENDITURES (L040).

Edit Condition
TOTAL EXPENDITURES (K_TE-010) from federal funds
in column a are less than TOTAL LSTA EXPENDITURES
(L- 040). Note: (K_TE-010) cannot be less than (L040).
MAIN OR CENTRAL OUTLET (E-050) is greater than 0
but main or central outlets reported in column a of
user groups (E-090) to (E-130) are each equal to –1 or
0. Or, MAIN OR CENTRAL OUTLET (E-050) is equal to 0
but any of main or central outlets reported in column
a of user groups (E-090) to (E-130) is greater than 0.

Severity
Fatal

72

E-050

MAIN OR CENTRAL OUTLET (E-050) greater than 0
but sum of column a of user groups (E-090) to (E130) is less than or equal to 0, or vice versa.

73

E-060

OTHER OUTLETS (E-060) greater than 0 but sum
of column b of user groups (E-090) to (E-130) is
less than or equal to 0.

OTHER OUTLETS (EXCLUDING BOOKMOBILES) (E-060) is
greater than 0 but other outlets (excluding
bookmobiles) reported in column b of user groups (E090) to (E-130) are each equal to –1 or 0. Or, OTHER
OUTLETS (EXCLUDING BOOKMOBILES) (E-060) is equal
to 0 but any of other outlets (excluding bookmobiles)
reported in column b of user groups (E-090) to (E-130)
is greater than 0.

Fatal

74

E-070

BOOKMOBILES (E-070) greater than 0 but sum
of column c of user groups (E-090) to (E-130) is
less than or equal to 0.

Fatal

E-080

TOTAL OUTLETS (E-080) greater than 0 but sum
of column d of user groups (E-090) to (E-130) is
less than or equal to 0.

BOOKMOBILES (E-070) is greater than 0 but
bookmobiles reported in column c of user groups
(E-090) to (E-130) are each equal to –1 or 0. Or,
BOOKMOBILES (E-070) is equal to 0 but any of
bookmobiles (E-070) reported in column c of user
groups (E-090) to (E-130) is greater than 0.
TOTAL OUTLETS (E-080) is greater than 0 but total
outlets reported in column d of user groups E-090 to
E- 130 are each equal to –1 or 0. Or, TOTAL OUTLETS
(E-080) is equal to 0 but any of total outlets (E-080)
reported in column d of user groups (E-090) to (E130) is greater than 0.

75

8

Fatal

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
77

Line Number
K_FA-060d

Edit Message
LIBRARY CONSTRUCTION K_FA-060 total
expenditures are equal to CAPITAL OUTLAY K_OE010 total expenditures.

84

M-020

85

F-070

Yes to ELECTRONIC NETWORK OPERATION (M020) but No to ELECTRONIC NETWORK
PLANNING OR MONITORING (M-010).
No to FEDERAL DEPOSITORY LIBRARY (F-070) but
Yes to REGIONAL (F-080) or SELECTIVE (F-090).

86

F-080

Yes to REGIONAL (F-080) and SELECTIVE (F-090).

90

J-120

OTHER STATE REVENUE (J-120) was expended
and reported in Part K (items K_AO-010 to
K_TE-010) incorrectly in Other column (c)
instead of State column (b).

91

J-140

OTHER REVENUE (J-140) greater than 0 but TOTAL
EXPENDITURES (K_TE-010) in Other column (c)
equal 0, or vice versa.

9

Edit Condition
LIBRARY CONSTRUCTION K_FA-060 expenditures in
column d are equal to CAPITAL OUTLAY K_OE-010
expenditures in column d. (This edit check only
applies when items K_FA-060 and item K_OE-010 are
both > 0.)
Yes to ELECTRONIC NETWORK OPERATION (M-020)
but No to ELECTRONIC NETWORK PLANNING OR
MONITORING (M-010).
No to FEDERAL DEPOSITORY LIBRARY (F-070) but Yes
to REGIONAL (F-080) or SELECTIVE (F-090). Enter Yes
to (F-070) if you have a REGIONAL (F-080) or
SELECTIVE (F-090) Federal depository library.

Severity
Explanation

Yes to REGIONAL (F-080) and SELECTIVE (F-090). Enter
Yes to only one.
OTHER STATE REVENUE (J-120) was expended and
reported in Part K (items K_AO-010 to K_TE-010)
incorrectly in Other column (c) instead of State column
(b). Expenditures of OTHER STATE REVENUE (J-120)
must be reported in State column in Part K. (If the
exact dollar figure reported in item J-120 (Other State
revenue) appears in any of items K_AO-010 to K_TE010 in column c, it should trigger an edit message.)

Fatal

OTHER REVENUE (J-140) greater than 0 but TOTAL
EXPENDITURES (K_TE-010) in Other column (c) equal
0. Or, OTHER REVENUE (J-140) is less than or equal
to 0 but TOTAL EXPENDITURES (K_TE-010) in Other
column (c) is greater than 0.

Explanation

Fatal

Fatal

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
92

Line Number
K_TE-010c

Edit Message
TOTAL EXPENDITURES (K_TE-010c)
compared to OTHER REVENUE (J-140) in
other sources has had a large change.
Please check for possible errors or explain
why the correct data are out of range.

Edit Condition
TOTAL EXPENDITURES (K_TE-010) in Other column
(c) are less than 80% or more than 120% of OTHER
REVENUE (J-140), and difference is greater than +
or - 200,000. Note: Run this edit only if TOTAL
EXPENDITURES in Other column (c) is greater than
0.
OTHER REVENUE (J-140) was expended and reported
in Part K (items K_AO-010 to K_TE-010) incorrectly in
State column (b) instead of Other column (c).
Expenditures of OTHER REVENUE (J-140) must be
reported in Other column in Part K. If the exact dollar
figure reported in item 171 (Other revenue) appears
in any of items K_AO-010 -K_TE-010 in column b, it
should trigger an edit message.

Severity
Explanation

93

J-140

OTHER REVENUE (J-140) was expended and
reported in Part K (items K_AO-010 to K_TE010) incorrectly in State column (b) instead
of Other column (c).

98

J-140

OTHER REVENUE (J-140) compared to TOTAL
REVENUE (J-150) is higher than expected.
Please check for possible errors or explain
why the correct data are out of range.

OTHER REVENUE (J-140) greater than 20% of TOTAL
REVENUE (J-150). Note: Report State revenue for any
purpose other than SLAA operation or State aid to
libraries as OTHER STATE REVENUE (J-120), not as
OTHER REVENUE (J-140). For example, interagency
transfers should be reported as OTHER STATE
REVENUE (J-120), not as OTHER REVENUE (J-140).

Explanation

99

K_OE-020d

OTHER EXPENDITURES (K_OE-020d)
compared to TOTAL EXPENDITURES (K_TE010d) is higher than expected. Please check
for possible errors or explain why the
correct data are out of range.

OTHER EXPENDITURES (K_OE-020) in column d are
greater than 20% of TOTAL EXPENDITURES (K_TE-010)
in column d.

Explanation

10

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
102

Line Number
J-020

Edit Message
No to (J-020) ACADEMIC LIBRARIES State funds and
(J-040) SPECIAL LIBRARIES State funds, but (K_FA030) OTHER INDIVIDUAL LIBRARIES in column b is
greater than 0.

Edit Condition
No to (J-020) ACADEMIC LIBRARIES State funds and (J040) SPECIAL LIBRARIES State funds, but (K_FA-030)
OTHER INDIVIDUAL LIBRARIES in column b is greater
than 0. Note: Do not report grants to school library
media centers in (K_FA-030). Report them in (K_FA070) instead.

Severity
Explanation

103

M-140

INTERNET WORKSTATIONS FOR GENERAL PUBLIC
(M-140) or (M-150) but no GENERAL PUBLIC (E-130)
outlets.

INTERNET WORKSTATIONS FOR GENERAL PUBLIC (M140) or (M-150) are greater than 0 but GENERAL
PUBLIC (E-130) outlets in column d is less than or
equal to 0.

Fatal

104

K_AO-060a

Sum of TOTAL OPERATING EXPENDITURES
(K_AO- 060a), CAPITAL OUTLAY (K_OE-010a),
and OTHER EXPENDITURES(K_OE-020a) from
federal sources is less than the sum of
STATEWIDE SERVICES (L-010) and LSTA
ADMINISTRATION (L-030).

Sum of TOTAL OPERATING EXPENDITURES (K_AO-060)
+ CAPITAL OUTLAY (K_OE-010) + OTHER
EXPENDITURES (K_OE-020) in column a is less than
sum of STATEWIDE SERVICES (L-010) + LSTA
ADMINISTRATION (L-030). Note: All expenditures for
statewide services (L-010) and LSTA administration (L030) in Part L should also be reported in Part K, but
DO NOT report them as financial assistance to
libraries (items K_FA-010 to K_FA-080).

Fatal

105

K_FA-080a

TOTAL FINANCIAL ASSISTANCE (K_FA-080) in column
a is less than GRANTS (L-020).

TOTAL FINANCIAL ASSISTANCE (K_FA-080) in column a
is less than GRANTS (L-020). Note: All expenditures for
grants to libraries (L-020) in Part L should also be
reported under financial assistance to libraries (items
K_FA-010 to K_FA-080) in Part K.

Fatal

106
109

H-010
H-030

GRANTS AWARDED (H-010) greater than 400.
TOTAL ATTENDANCE AT EVENTS (H-030) greater
than 6,000.

GRANTS AWARDED (H-010) greater than 400.
TOTAL ATTENDANCE AT EVENTS (H-030) greater
than 6,000.

Explanation
Explanation

12

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
111

Line Number
M-160d

Edit Message
STATEWIDE DATABASE LICENSING (M-160) is greater
than 0 and no user groups are reported, or vice
versa.

Edit Condition
STATEWIDE DATABASE LICENSING (M-160) in column d
is greater than 0 and all user groups, items (M-170)
through (M-220), are selected No. Or, STATEWIDE
DATABASE LICENSING (M-160) in column d is less than
or equal to 0 and one or more user groups, items (M
170) through (M-220), is selected Yes.

Severity
Explanation

112

M-230

REMOTE USER (M-230) is Yes and STATEWIDE
DATABASE LICENSING (M-160) is less than or equal
to 0.

REMOTE USER (M-230) is Yes and STATEWIDE
DATABASE LICENSING (M-160) is less than or equal to
0.

Explanation

114

L-020

GRANTS (L-020) not equal to TOTAL
FINANCIAL ASSISTANCE (K_FA-080a) minus
LIBRARY CONSTRUCTION (K_FA-060a) from
federal sources.

Explanation

115

L-040

TOTAL LSTA EXPENDITURES (L-040) compared to
TOTAL EXPENDITURES (K_TE-010a) from federal
sources is lower than expected. Please check for
possible errors or explain why the correct data are
out of range.

GRANTS (L-020) not equal to TOTAL FINANCIAL
ASSISTANCE (K_FA-080) minus LIBRARY
CONSTRUCTION (K_FA-060) in column a. Item (L-020)
should equal item (K_FA-080) minus item (K_FA-060)
in column a unless federal funds other than
LSTA/LSCA are included in item (K_FA-080) in column
a.
TOTAL LSTA EXPENDITURES (L-040) are less than 70% of
TOTAL EXPENDITURES (K_TE-010) of federal funds in
column a.

116

M-160d

STATEWIDE DATABASE LICENSING (M-160d)
compared to TOTAL EXPENDITURES (K_TE-010d)
from all sources is higher than expected. Please
check for possible errors or explain why the correct
data are out of range.

STATEWIDE DATABASE LICENSING (M-160) in column d
is greater than 30% of TOTAL EXPENDITURES (K_TE010) in column d.

Explanation

117

M-160a

STATEWIDE DATABASE LICENSING (M-160a)
compared to TOTAL EXPENDITURES (K_TE-010a)
from federal sources is higher than expected.
Please check for possible errors or explain why the
correct data are out of range.

STATEWIDE DATABASE LICENSING (M-160) in column a
is greater than 50% of TOTAL EXPENDITURES (K_TE010) in column a.

Explanation

13

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
118

Line Number
M-160b

Edit Message
STATEWIDE DATABASE LICENSING (M-160b)
compared to TOTAL EXPENDITURES (K_TE-010b)
from State sources is higher than expected. Please
check for possible errors or explain why the correct
data are out of range.

Edit Condition
STATEWIDE DATABASE LICENSING (M-160) in column b
is greater than 30% of TOTAL EXPENDITURES (K_TE010) in column b.

Severity
Explanation

119

M-160c

STATEWIDE DATABASE LICENSING (M-160c)
compared to TOTAL EXPENDITURES (K_TE-010c)
from other sources is higher than expected. Please
check for possible errors or explain why the correct
data are out of range.

STATEWIDE DATABASE LICENSING (M-160) in column c
is greater than 30% of TOTAL EXPENDITURES (K_TE010) in column c.

Explanation

122

E-060

OTHER OUTLETS (E-060) is greater than sum of
user group numbers in column b of (E-090) to (E130).

Explanation

123

E-070

BOOKMOBILES (E-070) is greater than sum of user
group numbers in column c of (E-090) to (E-130).

Explanation

125

L-030

OTHER OUTLETS (E-060) is greater than sum of
user groups in column b of (E-090) to (E-130).
Please check for possible errors or explain why
the correct data is greater.
BOOKMOBILES (E-070) is greater than sum of
user groups in column c of (E-090) to (E-130).
Please check for possible errors or explain why
the correct data is greater.
LSTA ADMINISTRATION (L-030) compared to TOTAL
LSTA EXPENDITURES (L-040) is higher than
expected. Please check for possible errors or
explain why the correct data are out of range.

LSTA ADMINISTRATION (L-030) expenditures
greater than 5% of TOTAL LSTA EXPENDITURES (L040).

Explanation

126

J-130

Sum of TOTAL STATE REVENUE (J-130) and
OTHER REVENUE (J-140) is equal to TOTAL
EXPENDITURES (K_TE-010b) from State sources
within + or - 1. Please check for possible errors
or explain why the correct data are out of range.

TOTAL STATE REVENUE (J-130) + OTHER REVENUE (J140) = TOTAL EXPENDITURES (K_TE-010) in column b
(within + or - 1). Expenditures of OTHER REVENUE (J140) must be reported in Other column in Part K. Note:
Execute this edit only if OTHER REVENUE (J-140) > 0.

Explanation

14

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
127

Line Number
L-030

Edit Message
LSTA ADMINISTRATION (L-030) compared to LSTA
STATE PROGRAM (J-070) revenue is greater than
expected. Please check for possible errors or
explain why the correct data are out of range.

Edit Condition
LSTA ADMINISTRATION (L-030) expenditures are
greater than 5% of LSTA STATE PROGRAM (J-070)
revenue. This edit is a rough approximation of the
LSTA requirement that the amount spent on LSTA
administration cannot exceed the greater of: (a) 5% of
the LSTA State Program allotment or (b) $60,000.

Severity
Explanation

128

E-010

E-010

130

E-010

131

E-050

Only one outlet may be designated as the main
or central outlet.

(E-010) / (E-080) Average hours open per outlet per
week less than 10. Note: Divided TOTAL
HOURS/WEEK (all outlets, regardless of whom they
serve) (E-010) by TOTAL OUTLETS (E-080).
(E-010) / (E-080) Average hours open per outlet
per week greater than 70. Note: Divided TOTAL
HOURS/WEEK (all outlets, regardless of whom
they serve) (E-010) by TOTAL OUTLETS (E-080).
TOTAL HOURS/WEEK (all outlets, regardless of
whom they serve) (E-010) is less than or equal to
TOTAL HOURS/WEEK (main or central outlet) (E020). Note: Run this edit only if main or central
outlet (E-050) > 0 and TOTAL OUTLETS (E-080) >= 2.
MAIN OR CENTRAL OUTLET (E-050), (E-090a), (E-100a),
(E-110a), (E-120a), or (E-130a) greater than 1. Note:
Only 1 outlet may be designated as the main or central
outlet.

Explanation

129

Average weekly hours open per outlet ((E-010)
divided by (E-080)) is less than 10. Please check
for possible errors or explain why the correct
data are out of range.
Average weekly hours open per outlet ((E-010)
divided by (E-080)) is greater than 70. Please
check for possible errors or explain why the
correct data are out of range.
TOTAL HOURS/WEEK (all outlets, regardless of
whom they serve) (E-010) is less than or equal to
TOTAL HOURS/WEEK (main or central outlet) (E020).

137

J-010

Yes to (J-010) SLAA administration of all PUBLIC
LIBRARY State funds, but INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) and LIBRARY
COOPERATIVES SERVING PUBLIC LIBRARIES ONLY
(K_FA-020) in column b are both equal to 0.

Yes to (J-010) SLAA administration of all PUBLIC
LIBRARY State funds but INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) and LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column b are both equal to 0.

Fatal

15

Explanation

Explanation

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
138

Line Number
J-020

139

J-030

140

J-040

141

J-050

142

J-050

Edit Message
Yes to (J-020) SLAA administration of ACADEMIC
LIBRARIES State funds, but OTHER INDIVIDUAL
LIBRARIES (K_FA-030), SINGLE AGENCY OR
LIBRARY PROVIDING STATEWIDE SERVICE (K_FA050), and OTHER ASSISTANCE (K_FA-070) in
column b are all equal to 0.
Yes to (J-030) SLAA administration of SCHOOL
LIBRARY MEDIA CENTERS State funds, but SINGLE
AGENCY OR LIBRARY PROVIDING STATEWIDE
SERVICE (K_FA-050) and OTHER ASSISTANCE
(K_FA-070) in column b are equal to 0.

Edit Condition
Yes to (J-020) SLAA administration of ACADEMIC
LIBRARIES State funds but OTHER INDIVIDUAL
LIBRARIES (K_FA-030), SINGLE AGENCY OR LIBRARY
PROVIDING STATEWIDE SERVICE (K_FA-050), and
OTHER ASSISTANCE (K_FA-070) in column b are all
equal to 0.
Yes to (J-030) SLAA administration of SCHOOL
LIBRARY MEDIA CENTERS State funds but SINGLE
AGENCY OR LIBRARY PROVIDING STATEWIDE
SERVICE (K_FA-050) and OTHER ASSISTANCE (K_FA070) in column b are equal to 0.

Yes to (J-040) SLAA administration of SPECIAL
LIBRARIES State funds, but OTHER INDIVIDUAL
LIBRARIES (K_FA-030), SINGLE AGENCY OR
LIBRARY PROVIDING STATEWIDE SERVICE (K_FA050), and OTHER ASSISTANCE (K_FA-070) in
column b are all equal to 0.
Yes to (J-050) SLAA administration of LIBRARY
COOPERATIVES State funds, but LIBRARY
COOPERATIVES SERVING PUBLIC LIBRARIES ONLY
(K_FA-020) and LIBRARY COOPERATIVES SERVING
MORE THAN ONE TYPE OF LIBRARY (K_FA-040)
and LIBRARY PROVIDING STATEWIDE SERVICE
(K_FA-050b) in column b are equal to 0.

Yes to (J-040) SLAA administration of SPECIAL
LIBRARIES State funds but OTHER INDIVIDUAL
LIBRARIES (K_FA- 030), SINGLE AGENCY OR LIBRARY
PROVIDING STATEWIDE SERVICE (K_FA-050), and
OTHER ASSISTANCE (K_FA-070) in column b are all
equal to 0.
Yes to (J-050) SLAA administration of LIBRARY
COOPERATIVES State funds but LIBRARY
COOPERATIVES SERVING PUBLIC LIBRARIES ONLY
(K_FA-020) and LIBRARY COOPERATIVES SERVING
MORE THAN ONE TYPE OF LIBRARY (K_FA-040) and
LIBRARY PROVIDING STATEWIDE SERVICE (K_FA-050b)
in column b are equal to 0.

Fatal

No to (J-050) SLAA administration of LIBRARY
COOPERATIVES State funds, but LIBRARY
COOPERATIVES SERVING PUBLIC LIBRARIES
ONLY (K_FA-020) or LIBRARY COOPERATIVES
SERVING MORE THAN ONE TYPE OF LIBRARY
(K_FA-040) in column b is greater than 0.

No to (J-050) SLAA administration of LIBRARY
COOPERATIVES State funds but LIBRARY
COOPERATIVES SERVING PUBLIC LIBRARIES ONLY
(K_FA-020) or LIBRARY COOPERATIVES SERVING MORE
THAN ONE TYPE OF LIBRARY (K_FA-040) in column b is
greater than 0.

Fatal

16

Severity
Fatal

Explanation

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Line Number
M-160a

Edit Message
STATEWIDE DATABASE LICENSING (M-160) in
column a is greater than TOTAL EXPENDITURES
(K_TE-010) in column a.

Edit Condition
STATEWIDE DATABASE LICENSING (M-160) in column a
is greater than TOTAL EXPENDITURES (K_TE-010) in
column a.

144

M-160b

STATEWIDE DATABASE LICENSING (M-160) in
column b is greater than TOTAL EXPENDITURES
(K_TE-010) in column b.

STATEWIDE DATABASE LICENSING (M-160) in column b
is greater than TOTAL EXPENDITURES (K_TE-010) in
column b.

Fatal

145

M-160c

STATEWIDE DATABASE LICENSING (M-160) in
column c is greater than TOTAL EXPENDITURES
(K_TE-010) in column c.

STATEWIDE DATABASE LICENSING (M-160) in column c
is greater than TOTAL EXPENDITURES (K_TE-010) in
column c.

Fatal

Please enter a value for this item.

Edit check message is generated for the
following character (alphanumeric) fields that
are left blank:
* SLAANAME (A-010)
* STREET (A-020)
* CITY (A-030)
* STATE (A-040)
* ZIP CODE (A-050)
* STREET (A-070)
* CITY (A-080)
* STATE (A-090)
* ZIP CODE (A-100)
* WEB ADDRESS (A-120)
* NAME (A-130)
* TITLE (A-140)
* VOICE (A-150)
* INTERNET (A-170)
* NAME (A-180)
* TITLE (A-190)
* VOICE (A-200)
* INTERNET (A-220)
* FISCAL YEAR STARTING DATE (A-230)
* FISCAL YEAR ENDING DATE (A-240)

Fatal

Edit Code
143

501

A-010
A-020
A-030
A-040
A-050
A-070
A-080
A-090
A-100
A-120
A-130
A-140
A-150
A-170
A-180
A-190
A-200
A-220
A-230
A-240
17

Severity
Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
502

Line Number

Edit Message
Have item but not specified, or vice versa.

Edit Condition
Edit check message is generated for the
following conditions:
* OTHER AGENCY (B-050) is selected but SPECIFY (B060) is blank, or vv.
* Yes to OTHER ALLIED OPERATION (C-050) but SPECIFY
(C-060) is blank, or vv.
* Annual REFERENCE TRANSACTIONS (G-040)
* OTHER FEDERAL REVENUE PROGRAM (J-080.1a - J080.10a) is entered but AMOUNT (J-080.1b - J-080.10b)
is blank, or vv.

B-050
C-050
G-040
J-080

M-250

503

Severity
Fatal

* Yes to OTHER TYPE OF ELECTRONIC ACCESS (M-250)
but SPECIFY (M-260) is blank. Or, No to (M-250) but
(M-260) is not blank.
Please enter a numeric value for this item.

E-050
E-060

Edit check message is generated if no value was
entered for a numeric data item.
* TOTAL HOURS/WEEK (E-010)
* TOTAL HOURS/WEEK (E-020)
* MONDAY-FRIDAY after 5:00 p.m. (main or
central outlet) (E-030)
* SATURDAY AND SUNDAY (main or central outlet)
(E- 040)
* MAIN OR CENTRAL OUTLET (E-050)
* OTHER OUTLETS, EXCLUDING BOOKMOBILES (E-060)

E-070

* BOOKMOBILES (E-070)

E-080

* TOTAL OUTLETS (E-080)

E-090a

* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in column a
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in column b
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in column c

E-010
E-020
E-030
E-040

E-090b
E-090c

18

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
E-090d

Edit Message

Edit Condition
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in column d
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column a
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column b
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column c
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column d
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column a
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column b
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column c
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column d
* STATE GOVERNMENT EMPLOYEES (E-120) in column a
* STATE GOVERNMENT EMPLOYEES (E-120) in column b
* STATE GOVERNMENT EMPLOYEES (E-120) in column c
* STATE GOVERNMENT EMPLOYEES (E-120) in column d
* GENERAL PUBLIC (E-130) in column a
* GENERAL PUBLIC (E-130) in column b
* GENERAL PUBLIC (E-130) in column c
* GENERAL PUBLIC (E-130) in column d
* BOOK AND SERIAL VOLUMES (F-010)
* AUDIO MATERIALS (F-020)

E-100a
E-100b
E-100c
E-100d
E-110a
E-110b
E-110c
E-110d
E-120a
E-120b
E-120c
E-120d
E-130a
E-130b
E-130c
E-130d
F-010
F-020

19

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
F-030
F-040
F-050
G-010
G-020
G-030

Edit Message

Edit Condition
* VIDEO MATERIALS (F-030)
* CURRENT SERIAL SUBSCRIPTIONS (F-040)
* GOVERNMENT DOCUMENTS (F-050)
* Total CIRCULATION (G-010)
* PROVIDED TO OTHER LIBRARIES (G-020)
* RECEIVED FROM OTHER LIBRARIES AND
DOCUMENT DELIVERY SERVICES (G-030)
* Annual REFERENCE TRANSACTIONS (G-040)
* Annual LIBRARY VISITS (G-050)
* GRANTS AWARDED (H-010)
* Continuing education EVENTS (H-020)
* ATTENDANCE AT EVENTS (H-030)
* ALA-MLS LIBRARIANS - ADMINISTRATION (I-010) in
column a
* NON ALA LIBRARIANS - ADMINISTRATION (I-010) in
column b
* OTHER STAFF - ADMINISTRATION (I-010) in column c

G-040
G-050
H-010
H-020
H-030
I-010a
I-010b
I-010c
I-010d
I-020a

* ADMINISTRATION (I-010) in column d
* ALA-MLS LIBRARIANS - LIBRARY DEVELOPMENT (I020) in column a
* NON ALA LIBRARIANS - LIBRARY DEVELOPMENT (I020) in column b
* OTHER STAFF - LIBRARY DEVELOPMENT (I-020) in
column c
* LIBRARY DEVELOPMENT (I-020) in column d
* ALA-MLS LIBRARIANS - LIBRARY SERVICES (I-030) in
column a
* NON ALA LIBRARIANS - LIBRARY SERVICES (I-030) in
column b
* OTHER STAFF - LIBRARY SERVICES (I-030) in column c

I-020b
I-020c
I-020d
I-030a
I-030b
I-030c

20

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
I-030d
I-040a

Edit Message

Edit Condition
* LIBRARY SERVICES (I-030) in column d
* ALA-MLS LIBRARIANS - OTHER SERVICES (I-040) in
column a
* NON ALA LIBRARIANS - OTHER SERVICES (I-040) in
column b
* OTHER STAFF - OTHER SERVICES (I-040) in column c

I-040b
I-040c
I-040d
I-050a
I-050b
I-050c
I-050d
J-070
J-080
J-090
J-100
J-110
J-120
J-130
J-140
J-150
K_AO-010a

* OTHER SERVICES (I-040) in column d
* TOTAL STAFF (I-050) in column a
* TOTAL STAFF (I-050) in column b
* TOTAL STAFF (I-050) in column d
* TOTAL STAFF (I-050) in column d
* LSTA STATE PROGRAMS revenue (J-070)
* FEDERAL REVENUE - OTHER (J-080)
* TOTAL FEDERAL REVENUE (J-090)
* SLAA OPERATION revenue (J-100)
* STATE AID TO LIBRARIES (J-110)
* STATE REVENUE - OTHER (J-120)
* TOTAL STATE REVENUE (J-130)
* OTHER REVENUE (J-140)
* TOTAL REVENUES (J-150)
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column a
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column b
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column c
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column d
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column a

K_AO-010b
K_AO-010c
K_AO-010d
K_AO-020a

21

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_AO-020b

Edit Message

Edit Condition
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column b
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column c
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column d
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column a
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column b
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column c
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column d
* OPERATING EXPENDITURES - COLLECTION (K_AO-040)
in column a
* OPERATING EXPENDITURES - COLLECTION (K_AO-040)
in column b
* OPERATING EXPENDITURES - COLLECTION (K_AO-040)
in column c
* OPERATING EXPENDITURES - COLLECTION (K_AO-040)
in column d
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column a
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column b
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column c
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column d
* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column a

K_AO-020c
K_AO-020d
K_AO-030a
K_AO-030b
K_AO-030c
K_AO-030d
K_AO-040a
K_AO-040b
K_AO-040c
K_AO-040d
K_AO-050a
K_AO-050b
K_AO-050c
K_AO-050d
K_AO-060a

22

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_AO-060b

Edit Message

Edit Condition
* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column b

K_AO-060c

* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column c

K_AO-060d

* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column d

K_OE-010a
K_OE-010b
K_OE-010c
K_OE-010d
K_OE-020a
K_OE-020b
K_OE-020c
K_OE-020d
K_FA-010a

* CAPITAL OUTLAY (K_OE-010) in column a
* CAPITAL OUTLAY (K_OE-010) in column b
* CAPITAL OUTLAY (K_OE-010) in column c
* CAPITAL OUTLAY (K_OE-010) in column d
* OTHER EXPENDITURES in column a
* OTHER EXPENDITURES in column b
* OTHER EXPENDITURES in column c
* OTHER EXPENDITURES in column d
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column a
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column b
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column c
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column d
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column a
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column b
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column c

K_FA-010b
K_FA-010c
K_FA-010d
K_FA-020a

K_FA-020b

K_FA-020c

23

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_FA-020d

Edit Message

Edit Condition
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in column
d
* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES

K_FA-030a

(K_FA-030) in column a
K_FA-030b

* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column b

K_FA-030c

* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column c
* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column d
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column a
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column b
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column c
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column d
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column a
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column b

K_FA-030d
K_FA-040a

K_FA-040b

K_FA-040c

K_FA-040d

K_FA-050a

K_FA-050b

24

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_FA-050c

Edit Message

Edit Condition
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column c

K_FA-050d

* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column d

K_FA-060a

* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column a
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column b
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column c
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column d
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column a
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column b
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column c
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column d
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in
column a
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in
column b
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in
column c
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in
column d
* TOTAL EXPENDITURES (K_TE-010) in column a
* TOTAL EXPENDITURES (K_TE-010) in column b

K_FA-060b
K_FA-060c
K_FA-060d
K_FA-070a
K_FA-070b
K_FA-070c
K_FA-070d
K_FA-080a
K_FA-080b
K_FA-080c
K_FA-080d
K_TE-010a
K_TE-010b
25

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_TE-010c
K_TE-010d
L-010
L-020
L-030
L-040
M-140

Edit Message

M-150
M-160a
M-160b
M-160c
M-160d
504

Value contains invalid number of digits for this item.
A-050
A-060
A-100
A-110
A-150
A-160
A-200
A-210
A-230
A-240

26

Edit Condition
* TOTAL EXPENDITURES (K_TE-010) in column c
* TOTAL EXPENDITURES (K_TE-010) in column d
* STATEWIDE SERVICES (L-010)
* GRANTS (L-020)
* LSTA ADMINISTRATION (L-030)
* TOTAL LSTA EXPENDITURES (L-040)
* LIBRARY–OWNED PUBLIC–ACCESS
INTERNET WORKSTATIONS (M-140)
* ALL OTHER PUBLIC–ACCESS INTERNET
WORKSTATIONS (M-150)
* EXPENDITURES FOR STATEWIDE DATABASE LICENSING
(M-160) in column a
* EXPENDITURES FOR STATEWIDE DATABASE LICENSING
(M-160) in column b
* EXPENDITURES FOR STATEWIDE DATABASE LICENSING
(M-160) in column c
* STATEWIDE DATABASE LICENSING (M-160) in
column d
Edit check message is generated if the following
items contain invalid digits:
* ZIP CODE (A-050)
* ZIP + 4 (A-060)
* ZIP CODE (A-100)
* ZIP + 4 (A-110)
* VOICE (A-150)
* FAX (A-160)
* VOICE (A-200)
* FAX (A-210)
* FISCAL YEAR STARTING DATE (A-230)
* FISCAL YEAR ENDING DATE (A-240)

Severity

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code
509

Line Number

Edit Message
Select yes or no for this item.

Edit Condition
Edit check message is generated for the following
items that require a Yes or No response when the
items are left blank:
* BRANCH OF GOVERNMENT (B-010)
* Combined with SLAA - STATE ARCHIVES (C-010)
* Combined with SLAA - PRIMARY STATE
LEGISLATIVE RESEARCH ORGANIZATION (C-020)
* Combined with SLAA - STATE HISTORY
MUSEUM/ART GALLERY (C-030)
* Combined with SLAA - STATE RECORDS
MANAGEMENT SERVICE (C-040)
* Combined with SLAA - OTHER ALLIED OPERATION
(C- 050)
* Contract with LOCAL PUBLIC LIBRARY OR
ACADEMIC LIBRARY (C-070)
* Provide funding to a STATE CENTER FOR THE BOOK
(C- 080)
* STATE DEPOSITORY LIBRARY (F-060)
* FEDERAL DEPOSITORY LIBRARY (F-070)
* REGIONAL (F-080)
* SELECTIVE (F-090)
* State funds administered by SLAA (J-010)
* State funds to ACADEMIC LIBRARIES (J-020)
* State funds to SCHOOL LIBRARY MEDIA CENTERS
(J- 030)
* State funds to SPECIAL LIBRARIES (J-040)
* State funds to LIBRARY COOPERATIVES (J-050)
* ELECTRONIC NETWORK PLANNING OR
MONITORING (M-010)
* ELECTRONIC NETWORK OPERATION (F-070)
* BIBLIOGRAPHIC DATABASES (M-030)
* FULL TEXT OR DATA FILES (M-040)

B-010
C-010
C-020
C-030
C-040
C-050
C-070
C-080
F-060
F-070
F-080
F-090
J-010
J-020
J-030
J-040
J-050
M-010
M-020
M-030
M-040

27

Severity
Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
M-050
M-060

Edit Message

M-110
M-120

Edit Condition
* Digital programs - FOR THE SLAA (M-050)
* Digital programs - TO OTHER STATE AGENCIES (M060)
* Digital programs - TO OTHER
LIBRARIES/LIBRARY COOPERATIVES (M-070)
* Training - LIBRARY STAFF (M-080)
* Training - STATE LIBRARY END USERS (M-090)
* PROVIDE DIRECT FUNDING FOR INTERNET ACCESS
(M- 100)
* PROVIDING EQUIPMENT (M-110)
* PROVIDING ACCESS TO DIRECTORIES, ETC. (M-120)

M-130
M-170
M-180
M-190

* MANAGING A WEB SITE, ETC. (M-130)
* Access by PUBLIC LIBRARIES (M-170)
* Access by ACADEMIC LIBRARIES (M-180)
* Access by SCHOOL LIBRARY MEDIA CENTERS (M-190)

M-200
M-210
M-220
M-230
M-240

* Access by SPECIAL LIBRARIES (M-200)
* Access by LIBRARY COOPERATIVES (M-210)
* Access by OTHER STATE AGENCIES (M-220)
* Access by REMOTE USERS (M-230)
* Subsidize electronic access - WEB-BASED
UNION CATALOG (M-240)
* Subsidize electronic access - OTHER (M-250)
* UNIVERSAL SERVICE (E-RATE DISCOUNT)
PROGRAM (M-270)
Edit check is generated for the following numeric
items that are missing:
* TOTAL HOURS/WEEK (E-010)
* TOTAL HOURS/WEEK (E-020)
* MONDAY-FRIDAY after 5:00 p.m. (main or
central outlet) (E-030)

M-070
M-080
M-090
M-100

M-250
M-270
510

Item is -1.
E-010
E-020
E-030

28

Severity

Explanation

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
E-040

Edit Message

Edit Condition
* SATURDAY AND SUNDAY (main or central outlet)
(E- 040)
* MAIN OR CENTRAL OUTLET (E-050)
* OTHER OUTLETS, EXCLUDING BOOKMOBILES (E-060)

E-050
E-060
E-070
E-080
E-090a

* BOOKMOBILES (E-070)
*TOTAL OUTLETS (E-080)
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in
*column
BLINDa& PHYSICALLY HANDICAPPED INDIVID (E-090)
in column b
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in column c
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column a
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column b
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column c
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column a
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column b
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110)
In column c
* STATE GOVERNMENT EMPLOYEES (E-120) in
column a
* STATE GOVERNMENT EMPLOYEES (E-120) in
column b
* STATE GOVERNMENT EMPLOYEES (E-120) in
column c
* GENERAL PUBLIC (E-130) in column a

E-090b
E-090c
E-100a
E-100b
E-100c
E-110a
E-110b
E-110c
E-120a
E-120b
E-120c
E-130a

29

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
E-130b
E-130c
F-010
F-020
F-030
F-040
F-050
G-010
G-020
G-030

Edit Message

Edit Condition
* GENERAL PUBLIC (E-130) in column b
* GENERAL PUBLIC (E-130) in column c
* BOOK AND SERIAL VOLUMES (F-010)
* AUDIO MATERIALS (F-020)
* VIDEO MATERIALS (F-030)
* CURRENT SERIAL SUBSCRIPTIONS (F-040)
* GOVERNMENT DOCUMENTS (F-050)
* Total CIRCULATION (G-010)
* PROVIDED TO OTHER LIBRARIES (G-020)
* RECEIVED FROM OTHER LIBRARIES AND
DOCUMENT DELIVERY SERVICES (G-030)
* Annual REFERENCE TRANSACTIONS (G-040)
* Annual LIBRARY VISITS (G-050)
* GRANTS AWARDED (H-010)
* Continuing education EVENTS (H-020)
* ATTENDANCE AT EVENTS (H-030)
* (I-010a) ALA-MLS LIBRARIANS - ADMINISTRATION
* (I-010b) NON ALA LIBRARIANS - ADMINISTRATION
* (I-010c) OTHER STAFF - ADMINISTRATION
* (I-020a) ALA-MLS LIBRARIANS LIBRARY DEVELOPMENT
* (I-020b) NON ALA LIBRARIANS LIBRARY DEVELOPMENT
* (I-020c) OTHER STAFF - LIBRARY DEVELOPMENT
* (I-030a) ALA-MLS LIBRARIANS - LIBRARY SERVICES
* (I-030b) NON ALA LIBRARIANS - LIBRARY SERVICES
* (I-030c) OTHER STAFF - LIBRARY SERVICES
* (I-040a) ALA-MLS LIBRARIANS - OTHER SERVICES
* (I-040b) NON ALA LIBRARIANS - OTHER SERVICES
* (I-040c) OTHER STAFF - OTHER SERVICES
* (J-070) LSTA STATE PROGRAMS revenue
* FEDERAL REVENUE - OTHER

G-040
G-050
H-010
H-020
H-030
I-010a
I-010b
I-010c
I-020a
I-020b
I-020c
I-030a
I-030b
I-030c
I-040a
I-040b
I-040c
J-070
J-080

30

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
J-100
J-110
J-120
J-140
K_AO-010a

Edit Message

Edit Condition
* (J-100) SLAA OPERATION revenue
* STATE AID TO LIBRARIES (J-110)
* STATE REVENUE - OTHER (J-120)
* OTHER REVENUE(J-140)
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column a
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column b
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column c
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column a
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column b
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column c
* OPERATING EXPENDITURES - COLLECTION (K_AO040) in column a
* OPERATING EXPENDITURES - COLLECTION (K_AO040) in column b
* OPERATING EXPENDITURES - COLLECTION (K_AO040) in column c
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column a
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column b
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column c
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column a
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column b

K_AO-010b
K_AO-010c
K_AO-020a
K_AO-020b
K_AO-020c
K_AO-040a
K_AO-040b
K_AO-040c
K_AO-050a
K_AO-050b
K_AO-050c
K_FA-010a
K_FA-010b

31

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_FA-010c

Edit Message

Edit Condition
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column c
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column a
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column b
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column c
* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column a

K_FA-020a

K_FA-020b

K_FA-020c

K_FA-030a
K_FA-030b

* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column b

K_FA-030c

* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column c

K_FA-040a

* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column a
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column b
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column c
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column a

K_FA-040b

K_FA-040c

K_FA-050a

32

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_FA-050b

Edit Message

Edit Condition
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column
*b FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column
*c FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column a
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column b
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column c
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column
*a FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column
*b FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column c
* CAPITAL OUTLAY (K_OE-010) in column a
* CAPITAL OUTLAY (K_OE-010) in column b
* CAPITAL OUTLAY (K_OE-010) in column c
* OTHER EXPENDITURES in column a
* OTHER EXPENDITURES in column b
* OTHER EXPENDITURES in column c
* (L-010) STATEWIDE SERVICES
* (L-020) GRANTS
* (L-030) LSTA ADMINISTRATION
* (M-140) LIBRARY–OWNED PUBLIC–ACCESS
INTERNET WORKSTATIONS
* (M-150) ALL OTHER PUBLIC–ACCESS
INTERNET WORKSTATIONS

K_FA-050c

K_FA-060a
K_FA-060b
K_FA-060c
K_FA-070a
K_FA-070b
K_FA-070c
K_OE-010a
K_OE-010b
K_OE-010c
K_OE-020a
K_OE-020b
K_OE-020c
L-010
L-020
L-030
M-140
M-150

33

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
M-160a

Edit Message

Edit Condition
* EXPENDITURES FOR STATEWIDE DATABSE LICENSING
(M-160) in column a
* EXPENDITURES FOR STATEWIDE DATABSE LICENSING
(M-160) in column b
* EXPENDITURES FOR STATEWIDE DATABSE LICENSING
(M-160) in column c
Edit check message is generated for the following
numeric items that exceed the maximum
allowable value (9,999) for the item:
* TOTAL HOURS/WEEK (all SLAA outlets) (E-010)
* TOTAL HOURS/WEEK (main or central outlet) (E-020)

M-160b
M-160c
517

Value exceeds the limit (9,999) for this item.

E-010
E-020
E-030

* MONDAY-FRIDAY AFTER 5 P.M. hours (main or
central outlet) (E-030)
* SATURDAY AND SUNDAY hours (main or
central outlet) (E-040)
* TOTAL OUTLETS (main or central outlet) (E-050)
* TOTAL OUTLETS (other outlets) (E-060)
* TOTAL OUTLETS (bookmobiles) (E-070)
* TOTAL OUTLETS (E-080)
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in
a-d OF STATE CORRECTIONAL INST. (E-100) in
*columns
RESIDENTS
columns a-d
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
columns a-d
* STATE GOVERNMENT EMPLOYEES (E-120) in columns
a-d
* GENERAL PUBLIC E-130 in columns a- d
* LIBRARY-OWNED PUBLIC-ACCESS
GRAPHICAL INTERNET WORKSTATIONS (M140)

E-040
E-050
E-060
E-070
E-080
E-090
E-100
E-110
E-120
E-130
M-140

34

Severity

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
M-150

519

Edit Message

Edit Condition
* ALL OTHER PUBLIC-ACCESS INTERNET
WORKSTATIONS (M-150)
Edit check message is generated for numeric items
that exceed the maximum allowable value (999,999)
for the item. Part H—items H-010–H-030.

Value exceeds the limit (999,999) for this item.

H-010
H-020
H-030
520

* GRANTS AWARDED (H-010)
* Continuing education EVENTS (H-020)
* ATTENDANCE AT EVENTS (H-030)
Edit check message is generated for numeric items
that exceed the maximum allowable value
(9,999,999) for the item. Part G—items G-010–G-050.

Value exceeds the limit (9,999,999) for this item.

G-010
G-020
G-030
G-050
521

Value exceeds the limit (99,999,999) for this item.

F-010
F-020
F-030
F-040
F-050
522

Value exceeds the limit (999,999,999) for this item.

K_AO-010
K_AO-020
35

* Total CIRCULATION (G-010)
* PROVIDED TO OTHER LIBRARIES (G-020)
* RECEIVED FROM OTHER LIBRARIES AND
DOCUMENT DELIVERY SERVICES (G-030)
* Annual LIBRARY VISITS (G-050)
Edit check message is generated for numeric items
that exceed the maximum allowable value
(99,999,999) for the item. Part F—items F-010–F-050.
* BOOK AND SERIAL VOLUMES (F-010)
* AUDIO MATERIALS (F-020)
* VIDEO MATERIALS (F-030)
* CURRENT SERIAL SUBSCRIPTIONS (F-040)
* GOVERNMENT DOCUMENTS (F-050)
Edit check message is generated for numeric items that
exceed the maximum allowable value (999,999,999)
for the following items:
* SALARIES AND WAGES (K_AO-010) in columns a-d
* EMPLOYEE BENEFITS (K_AO-020) in columns a-d

Severity

Fatal

Fatal

Fatal

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_AO-030

Edit Message

Edit Condition
* TOTAL STAFF EXPENDITURES (K_AO-030) in columns
a-d
* TOTAL COLLECTION EXPENDITURES (K_AO-040) in
columns a-d
* TOTAL OTHER OPERATING EXPENDITURES (K_AO-050)
in columns a-d
* TOTAL FEDERAL OPERATING EXPENDITURES (K_AO060) in columns a-d
* TOTAL CAPITAL OUTLAY (K_OE-010) in columns a-d

K_AO-040
K_AO-050
K_AO-060
K_OE-010
K_OE-020

* TOTAL OTHER EXPENDITURES (K_OE-020) in columns
a-d
* TOTAL EXPENDITURES FOR INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in columns a-d
* TOTAL EXPENDITURES FOR LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
columns
*a-d
TOTAL EXPENDITURES FOR OTHER INDIVIDUAL
LIBRARIES (K_FA-030) in columns a-d
* TOTAL EXPENDITURES FOR LIBRARY COOPERATIVES
SERVING MORE THAN ONE TYPE OF LIBRARY (K_FA040)
columns
a-d
*inTOTAL
EXPENDITURES
FOR SINGLE AGENCY OR
LIBRARY PROVIDING STATEWIDE SERVICE (K_FA-050)
in columns a-d
* TOTAL EXPENDITURES FOR LIBRARY CONSTRUCTION
(K_FA-060) in columns a-d
* TOTAL EXPENDITURES FOR OTHER ASSISTANCE (K_FA070) in columns a-d
* TOTAL FEDERAL EXPENDITURES FINANCIAL
ASSISTANCE (K_FA-080) in columns a-d
* STATEWIDE SERVICES (L-010)

K_FA-010
K_FA-020

K_FA-030
K_FA-040

K_FA-050

K_FA-060
K_FA-070
K_FA-080
L-010
36

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
L-020
L-030
L-040
M-160

523

Edit Message

Edit Condition
* GRANTS (L-020)
* LSTA ADMINISTRATION (L-030)
* TOTAL LSTA EXPENDITURES (L-040)
* STATEWIDE DATABASE LICENSING (M-160) in columns
a-d
Edit check message is generated for numeric items that
exceed the maximum allowable value (9,999.99) for
the following items:
* ALA-MLS LIBRARIANS - ADMINISTRATION (I-010) in
column a
* NON ALA LIBRARIANS - ADMINISTRATION (I-010) in
column b
* OTHER STAFF - ADMINISTRATION (I-010) in column c

Value exceeds the limit (9,999.99) for this item.

I-010a
I-010b
I-010c
I-010d
I-020a

* ADMINISTRATION (I-010) in column d
* ALA-MLS LIBRARIANS - LIBRARY DEVELOPMENT (I020)
column
*inNON
ALAaLIBRARIANS - LIBRARY DEVELOPMENT
(I-020) in column b
* OTHER STAFF - LIBRARY DEVELOPMENT (I-020) in
column c

I-020b
I-020c
I-020d
I-030a

* LIBRARY DEVELOPMENT (I-020) in column d
* ALA-MLS LIBRARIANS - LIBRARY SERVICES (I-030) in
column a
* NON ALA LIBRARIANS - LIBRARY SERVICES (I-030) in
column b
* OTHER STAFF - LIBRARY SERVICES (I-030) in column c

I-030b
I-030c
I-030d
I-040a

* LIBRARY SERVICES (I-030) in column d
* ALA-MLS LIBRARIANS - OTHER SERVICES (I-040) in
column a

37

Severity

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
I-040b

Edit Message

Edit Condition
* NON ALA LIBRARIANS - OTHER SERVICES (I-040) in
column b
* OTHER STAFF - OTHER SERVICES (I-040) in column c

I-040c
I-040d
I-050a
I-050b
I-050c
I-050d
524

* OTHER SERVICES (I-040) in column d
* TOTAL STAFF (I-050) in column a
* TOTAL STAFF (I-050) in column b
* TOTAL STAFF (I-050) in column d
* TOTAL STAFF (I-050) in column d
Edit check message is generated for any item that
requires a Directly/Contract/Not provided response
and the item is left blank:
* ACCREDITATION OF LIBRARIES (D_SV-010)
* ADMINISTRATION OF STATE AID (D_SV-020)
* CERTIFICATION OF LIBRARIANS (D_SV-030)
* COLLECTION OF LIBRARY STATISTICS (D_SV-040)
* CONSULTING SERVICES (D_SV-050)
* LIBRARY LEGISLATION PREPARATION/REVIEW
(D_SV- 060)
* STATE STANDARDS/GUIDELINES (D_SV-070)
* ADMINISTRATION OF LIBRARY SYSTEM
SUPPORT (D_SV-080)

Must select a response.

D_SV-010
D_SV-020
D_SV-030
D_SV-040
D_SV-050
D_SV-060
D_SV-070
D_SV-080

D_SV-090
D_SV-100
D_OA-010

* LSTA STATE PROGRAM GRANTS (D_SV-090)
* LSTA STATEWIDE SERVICES (D_SV-100)
* COOPERATIVE PURCHASING OF LIBRARY
MATERIALS (D_OA-010)
* INTERLIBRARY LOAN REFERRAL SERVICES (D_OA-020)

D_OA-020
D_OA-030
D_CI-010

* REFERENCE REFERRAL SERVICES (D_OA-030)
* STATEWIDE COORDINATED DIGITAL PROGRAM
OR SERVICE (D_CI-010)
38

Severity

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
D_CI-020

Edit Message

Edit Condition
* STATEWIDE PUBLIC RELATIONS/LIBRARY
PROMOTION CAMPAIGNS (D_CI-020)
* STATEWIDE VIRTUAL REFERENCE SERVICE (D_CI-030)
* UNIVERSAL SERVICE PROGRAM (D_CI-040)
* STATEWIDE RESOURCE SHARING (D_CI-050)
* INVOLVEMENT IN THE ACQUISITION OF
OTHER FEDERAL PROGRAM FUNDS (D_CI-050)
* CONTINUING EDUCATION PROGRAMS (D_PA-010)
* LIBRARY PLANNING/EVALUATION/RESEARCH
(D_PA- 020)
* LITERACY PROGRAMS (D_PA-030)
* PRESERVATION/CONSERVATION SERVICES (D_PA-040)

D_CI-030
D_CI-040
D_CI-050
D_CI-060
D_PA-010
D_PA-020
D_PA-030
D_PA-040
D_PA-050
D_PA-060
525

* SUMMER READING PROGRAMS (D_PA-050)
* STATEWIDE READING PROGRAMS (D_PA-060)
Edit check message is generated for numeric items that
exceed the maximum allowable value (9,999,999,999)
for the following items:
* LSTA STATE PROGRAMS revenue (J-070)
* FEDERAL REVENUE - OTHER (J-080)
* TOTAL FEDERAL REVENUE (J-090)
* SLAA OPERATION revenue (J-100)
* STATE AID TO LIBRARIES (J-110)
* STATE REVENUE - OTHER (J-120)
* TOTAL STATE REVENUE (J-130)
* OTHER REVENUE (J-140)
* TOTAL REVENUES (J-150)
* TOTAL CAPITAL OUTLAY (K_OE-010) in columns a-d
* TOTAL OTHER EXPENDITURES (K_OE-020) in columns
a-d

Value exceeds the limit (9,999,999,999) for this
item.
J-070
J-080
J-090
J-100
J-110
J-120
J-130
J-140
J-150
K_OE-010
K_OE-020

39

Severity

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
600

Line Number
K_TE-010
E-010

601

E-060

602

E-070

603

Edit Message
TOTAL HOURS/WEEK (all SLAA outlets) (E-010) for
the current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data are
out of range.

Edit Condition
* TOTAL EXPENDITURES (K_TE-010) in columns a-d
TOTAL HOURS/WEEK (all SLAA outlets) (E-010) not 50%
to 125% of last year. Note: Run this edit only when
values are greater than 0 for the current and prior year.

Severity
Explanation

OTHER OUTLETS EXCLUDING BOOKMOBILES (E-060)
for the current reporting period is greater than 2
and prior reporting period was 0. Please check for
possible errors or explain why the correct data are
out of range.
BOOKMOBILES (E-070) for the current reporting
period is greater than 2 and prior reporting period
was 0. Please check for possible errors or explain
why the correct data are out of range.

OTHER OUTLETS EXCLUDING BOOKMOBILES (E-060) is
greater than 2 this year, but last year = 0. Note: Run
this edit only when current year value is greater than 0
and prior year value is 0.

Explanation

BOOKMOBILES (E-070) is greater than 2 this year, but
last year = 0. Note: Run this edit only when current
year value is greater than 0 and prior year value is 0.

Explanation

E-080

TOTAL OUTLETS (E-080) for the current reporting
period is greater than 2 and prior reporting period
was 0. Please check for possible errors or explain
why the correct data are out of range.

TOTAL OUTLETS (E-080) is greater than 2 this year, but
last year = 0. Note: Run this edit only when current
year value is greater than 0 and prior year value is 0.

Explanation

604

E-060

OTHER OUTLETS, EXCLUDING BOOKMOBILES (E060) for the current reporting period has had a
large change from prior reporting period. Please
check for possible errors or explain why the correct
data are out of range.

OTHER OUTLETS, EXCLUDING BOOKMOBILES (E-060)
not + or – 2 of last year. Note: Run this edit only when
values are greater than 0 for the current and prior year.

Explanation

605

E-070

BOOKMOBILES (E-070) for the current reporting
period has had a large change from prior
reporting period. Please check for possible errors
or explain why the correct data are out of range.

BOOKMOBILES (E-070) not + or – 2 of last year Note:
Run this edit only when values are greater than 0 for
the current and prior year.

Explanation

40

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
606

Line Number
E-080

607

F-010

608

F-020

609

F-030

610

F-040

611

F-050

Edit Message
TOTAL OUTLETS (E-080) for the current reporting
period has had a large change from prior
reporting period. Please check for possible
errors or explain why the correct data are out of
range.
BOOK AND SERIAL VOLUMES (F-010) for the
current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data
are out of range.
AUDIO MATERIAL (F-020) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
VIDEO MATERIALS (F-030) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
CURRENT SERIAL SUBSCRIPTIONS (F-040) for the
current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data
are out of range.
GOVERNMENT DOCUMENTS (F-050) for the
current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data are
out of range.

41

Edit Condition
TOTAL OUTLETS (E-080) not + or – 2 of last year. Note:
Run this edit only when values are greater than 0 for
the current and prior year.

Severity
Explanation

BOOK AND SERIAL VOLUMES (F-010) not 50% to 150%
of last year, and the prior year to current year change
is greater than + or – 1000. Note: Run this edit only
when values are greater than 0 for the current and
prior year.
AUDIO MATERIALS (F-020) not 50% to 150% of last
year, and the prior year to current year change is
greater than + or – 500. Note: Run this edit only
when values are greater than 0 for the current and
prior year.
VIDEO MATERIALS (F-030) not 25% to 175% of last
year, and the prior year to current year change is
greater than + or – 500. Note: Run this edit only
when values are greater than 0 for the current and
prior year.
CURRENT SERIAL SUBSCRIPTIONS (F-040) not 50% to
150% of last year, and the prior year to current year
change is greater than + or – 500. Note: Run this edit
only when values are greater than 0 for the current
year and prior year.
GOVERNMENT DOCUMENTS (F-050) not 50% to 150%
of last year, and the prior year to current year change is
greater than + or – 1000. Note: Run this edit only when
values are greater than 0 for the current and prior year.

Explanation

Explanation

Explanation

Explanation

Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
612

Line Number
G-010

Edit Message
CIRCULATION (G-010) for the current reporting
period has had a large change from prior
reporting period. Please check for possible errors
or explain why the correct data are out of range.

Edit Condition
CIRCULATION (G-010) not 25% to 175% of last year,
and the prior year to current year change is greater
than + or – 1000. Note: Run this edit only when values
are greater than 0 for the current and prior year.

Severity
Explanation

613

G-020

PROVIDED TO OTHER LIBRARIES (G-020) not 50% to
150% of last year, and the prior year to current year
change is greater than + or – 1000. Note: Run this edit
only when values are greater than 0 for the current and
prior year.

Explanation

614

G-030

PROVIDED TO OTHER LIBRARIES (G-020) for the
current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data are
out of range.
RECEIVED FROM OTHER LIBRARIES AND
DOCUMENT DELIVERY SERVICES (G-030) for the
current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data are
out of range.

RECEIVED FROM OTHER LIBRARIES AND DOCUMENT
DELIVERY SERVICES (G-030) not 50% to 150% of last
year, and the prior year to current year change is
greater than + or – 1000. Note: Run this edit only when
values are greater than 0 for the current and prior year.

Explanation

615

G-040

REFERENCE TRANSACTIONS (G-040) not 25% to 175%
of last year, and the prior year to current year change is
greater than + or – 1000. Note: Run this edit only when
values are greater than 0 for the current and prior year.

Explanation

616

G-050

REFERENCE TRANSACTIONS (G-040) for the
current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data are
out of range.
LIBRARY VISITS (G-050) for the current reporting
period has had a large change from prior
reporting period. Please check for possible errors
or explain why the correct data are out of range.

LIBRARY VISITS (G-050) not 50% to 150% of last year,
and the prior year to current year change is greater
than + or – 1000. Note: Run this edit only when values
are greater than 0 for the current and prior year.

Explanation

618

C-010

The response this reporting period is different from
last reporting period. Please check for possible
errors or explain the difference.

Applies to all items with Yes/No answers:

Explanation

C-010

* Combined with SLAA - STATE ARCHIVES (C-010)
42

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
C-020

Edit Message

Edit Condition
* Combined with SLAA - PRIMARY STATE
LEGISLATIVE RESEARCH ORGANIZATION (C-020)
* Combined with SLAA - STATE HISTORY
MUSEUM/ART GALLERY (C-030)
* Combined with SLAA - STATE RECORDS
MANAGEMENT SERVICE (C-040)
* Combined with SLAA - OTHER ALLIED OPERATION
(C-050)
* Contract with LOCAL PUBLIC LIBRARY OR
ACADEMIC LIBRARY (C-070)
* Provide funding to a STATE CENTER FOR THE BOOK
(C-080)
* STATE DEPOSITORY LIBRARY (F-060)
* FEDERAL DEPOSITORY LIBRARY (F-070)
* REGIONAL (F-080)
* SELECTIVE (F-090)
* State funds administered by SLAA (J-010)
* State funds to ACADEMIC LIBRARIES (J-020)
* State funds to SCHOOL LIBRARY MEDIA CENTERS
(J- 030)
* State funds to SPECIAL LIBRARIES (J-040)
* State funds to LIBRARY COOPERATIVES (J-050)
* ELECTRONIC NETWORK PLANNING OR
MONITORING (M-010)
* ELECTRONIC NETWORK OPERATION (F-070)
* BIBLIOGRAPHIC DATABASES (M-030)
* FULL TEXT OR DATA FILES (M-040)
* Digital programs - FOR THE SLAA (M-050)
* Digital programs - TO OTHER STATE AGENCIES
(M-060)
* Digital programs - TO OTHER
LIBRARIES/LIBRARY COOPERATIVES (M-070)

C-030
C-040
C-050
C-070
C-080
F-060
F-070
F-080
F-090
J-010
J-020
J-030
J-040
J-050
M-010
M-020
M-030
M-040
M-050
M-060
M-070

43

Severity
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
M-080
M-090
M-100

Edit Message

M-110
M-120
M-130
M-170
M-180
M-190
M-200
M-210
M-220
M-230
M-240
M-250
M-270
619

J-110

620

K_TE-010d

STATE AID TO LIBRARIES (J-110) revenue for the
current reporting period has had a large change
from prior reporting period. Please check for
possible errors or explain why the correct data are
out of range.
TOTAL EXPENDITURES (K_TE-010d) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.

44

Edit Condition
* Training - LIBRARY STAFF (M-080)
* Training - STATE LIBRARY END USERS (M-090)
* PROVIDE DIRECT FUNDING FOR INTERNET
ACCESS (M-100)
* PROVIDING EQUIPMENT (M-110)
* PROVIDING ACCESS TO DIRECTORIES, ETC. (M-120)

Severity
Explanation
Explanation
Explanation

* MANAGING A WEB SITE, ETC. (M-130)
* Access by PUBLIC LIBRARIES (M-170)
* Access by ACADEMIC LIBRARIES (M-180)
* Access by SCHOOL LIBRARY MEDIA CENTERS (M-190)
* Access by SPECIAL LIBRARIES (M-200)
* Access by LIBRARY COOPERATIVES (M-210)
* Access by OTHER STATE AGENCIES (M-220)
* Access by REMOTE USERS (M-230)
* Subsidize electronic access - WEB-BASED
UNION CATALOG (M-240)
* Subsidize electronic access - OTHER (M-250)
* UNIVERSAL SERVICE (E-RATE DISCOUNT)
PROGRAM (M-270)
STATE AID TO LIBRARIES (J-110) revenue not 70% to
150% of last year. Note: Run this edit only when
values are greater than 0 for the current and prior
year.

Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation
Explanation

TOTAL EXPENDITURES (K_TE-010) in column d not
70% to 150% of last year. Note: Run this edit only
when values are greater than 0 for the current and
prior year.

Explanation

Explanation
Explanation

Explanation
Explanation
Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
624

Line Number
K_AO-010d

Edit Message
SALARIES AND WAGES (K_AO-010d) for the current
reporting period has had a large change from prior
reporting period. Please check for possible errors
or explain why the correct data are out of range.

Edit Condition
SALARIES AND WAGES (K_AO-010) in column d not
70% to 150% of last year. Note: Run this edit only
when values are greater than 0 for the current and
prior year.

Severity
Explanation

625

K_AO-020d

EMPLOYEE BENEFITS (K_AO-020) in column d not 70%
to 150% of last year. Note: Run this edit only when
values are greater than 0 for the current and prior
year.

Explanation

627

M-160d

EMPLOYEE BENEFITS (K_AO-020d) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
STATEWIDE DATABASE LICENSING EXPENDITURES
(M-160d) for the current reporting period has had
a large change from prior reporting period. Please
check for possible errors or explain why the
correct data are out of range.

STATEWIDE DATABASE LICENSING EXPENDITURES (M160) in column d not 40% to 160% of last year, and the
prior year to current year change is greater than + or –
1000. Note: Run this edit only when values are greater
than 0 for the current and prior year.

Explanation

628

M-140

LIBRARY-OWNED PUBLIC-ACCESS GRAPHICAL INTERNET
WORKSTATIONS (M-140): Current year value not 50%
to 150% of last year, and the prior year to current year
change is greater than + or – 10. Note: Run this edit
when values are greater than or equal to 0 in the
current and prior year.

Explanation

629

M-150

ALL OTHER PUBLIC-ACCESS INTERNET WORKSTATIONS
(M-150): Prior year to current year change is greater
than + or – 5. Note: Run this edit only when values
are greater than or equal to 0 in the current and prior
year.

Explanation

630

D_SV-010a

LIBRARY-OWNED PUBLIC-ACCESS GRAPHICAL
INTERNET WORKSTATIONS (M-140) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
ALL OTHER PUBLIC-ACCESS INTERNET
WORKSTATIONS (M-150) for the current
reporting period has had a large change from
prior reporting period. Please check for possible
errors or explain why the correct data are out of
range.
The response this reporting period is different from
the prior reporting period. Please check for
possible errors or explain the difference.

Response this year is different from last year. Items
in part D. If all 5 preservation/conservation services
variables (D_PA-040a-e) switch to "Not Provided",
do not flag this.

Explanation

45

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
631
632

Line Number
D_PA-050b
D_CI-040b

633

Edit Message
Directly or Contract to SUMMER READING
PROGRAM SUPPORT (D_PA-050) in column b.
Directly or Contract to UNIVERSAL SERVICE
PROGRAM (REVIEW AND APPROVAL OF
TECHNOLOGY PLANS) (D_CI-040) in column b.
Total for this item is 0 this year, but was not 0 last
yea

E-080
E-090d

Edit Condition
Directly or Contract to SUMMER READING
PROGRAM SUPPORT (D_PA-050) in column b.
Directly or Contract to UNIVERSAL SERVICE PROGRAM
(REVIEW AND APPROVAL OF TECHNOLOGY PLANS
(D_CI-040) in column b.
Edit check message is generated if the total for the
following items is 0 this year, but was not 0 last
year.
* TOTAL OUTLETS (E-080)
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in column d
* STATE GOVERNMENT EMPLOYEES (E-120) in
column d

E-120d
E-130d
I-010d
I-020d
I-030d
I-040d
I-050d
J-090
J-130
J-150
K_AO-010d
K_AO-020d
K_AO-030d
K_AO-060d

* GENERAL PUBLIC (E-130) in column d
* ADMINISTRATION (I-010d)
* LIBRARY DEVELOPMENT (I-020d)
* LIBRARY SERVICES (I-030d)
* OTHER SERVICES (I-040d)
* TOTAL STAFF (I-050d)
* TOTAL FEDERAL REVENUE (J-090)
* TOTAL STATE REVENUE (J-130)
* TOTAL REVENUES (J-150)
* SALARIES AND WAGES (K_AO-010) in column d
* EMPLOYEE BENEFITS (K_AO-020) in column d
* TOTAL STAFF EXPENDITURES (K_AO-030) in column d
* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column d

K_FA-010d

* INDIVIDUAL PUBLIC LIBRARIES (K_FA-010) in
column d

46

Severity
Fatal
Fatal

Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
K_FA-080d

Edit Message

Edit Condition
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in
column d

K_TE-010c

* TOTAL EXPENDITURES (K_TE-010) in Other column (c)

K_TE-010d
L-040
M-160d

* TOTAL EXPENDITURES (K_TE-010) in column d
* TOTAL LSTA EXPENDITURES (L-040)
* STATEWIDE DATABASE LICENSING (M-160) in
column d
Edit check message is generated if the amount for the
following items is 0 this year, but was not 0 last year.

634

Item is 0 this year, but was not 0 last year.
E-010
E-020
E-030

* TOTAL HOURS/WEEK (E-010)
* TOTAL HOURS/WEEK (E-020)
* MONDAY-FRIDAY after 5:00 p.m. (main or
central outlet) (E-030)
* SATURDAY AND SUNDAY (main or central outlet)
(E- 040)
* MAIN OR CENTRAL OUTLET (E-050)
* OTHER OUTLETS, EXCLUDING BOOKMOBILES (E-060)
* BOOKMOBILES (E-070)
* BOOK AND SERIAL VOLUMES (F-010)
* AUDIO MATERIALS (F-020)
* VIDEO MATERIALS (F-030)
* CURRENT SERIAL SUBSCRIPTIONS (F-040)
* GOVERNMENT DOCUMENTS (F-050)
* Total CIRCULATION (G-010)
* PROVIDED TO OTHER LIBRARIES (G-020)
* RECEIVED FROM OTHER LIBRARIES AND
DOCUMENT DELIVERY SERVICES (G-030)
* Annual REFERENCE TRANSACTIONS (G-040)
* Annual LIBRARY VISITS (G-050)

E-040
E-050
E-060
E-070
F-010
F-020
F-030
F-040
F-050
G-010
G-020
G-030
G-040
G-050

47

Severity

Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
H-010
H-020
H-030
I-010d
I-020d
I-030d
I-040d
J-070
J-100
J-110
J-140
L-010
L-020
L-030
M-140

Edit Message

Edit Condition
* GRANTS AWARDED (H-010)
* Continuing education EVENTS (H-020)
* ATTENDANCE AT EVENTS (H-030)
* (I-010) ADMINISTRATION
* (I-020) LIBRARY DEVELOPMENT
* (I-030) LIBRARY SERVICES
* OTHER SERVICES (I-040)
* (J-070) LSTA STATE PROGRAMS revenue
* (J-100) SLAA OPERATION revenue
* STATE AID TO LIBRARIES (J-110)
* OTHER revenue (J-140)
* (L-010) STATEWIDE SERVICES
* (L-020) GRANTS
* (L-030) LSTA ADMINISTRATION
* (M-140) LIBRARY–OWNED PUBLIC–ACCESS
INTERNET WORKSTATIONS
* (M-150) ALL OTHER PUBLIC–ACCESS
INTERNET WORKSTATIONS
Edit check message is generated for the following
items: if the item was greater than 0 both years, and
the value this year equals last year.

M-150
637

The value reported for this item equals the value
from the prior reporting period. Please check for
possible errors or explain why they are equal.
F-010
F-020
F-030
F-040
F-050
G-010
G-020
G-030

* BOOK AND SERIAL VOLUMES (F-010)
* AUDIO MATERIALS (F-020)
* VIDEO MATERIALS (F-030)
* CURRENT SERIAL SUBSCRIPTIONS (F-040)
* GOVERNMENT DOCUMENTS (F-050)
* Total CIRCULATION (G-010)
* PROVIDED TO OTHER LIBRARIES (G-020)
* RECEIVED FROM OTHER LIBRARIES AND
DOCUMENT DELIVERY SERVICES (G-030)
* Annual REFERENCE TRANSACTIONS (G-040)

G-040

48

Severity

Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
G-050
H-010
H-020
H-030
J-070
J-080
J-100
J-110
J-120
J-140
K_AO-010a
K_AO-010b
K_AO-010c
K_AO-020a
K_AO-020b
K_AO-020c
K_AO-040a
K_AO-040b
K_AO-040c
K_AO-050a
K_AO-050b
K_AO-050c
K_FA-010a
K_FA-010b
K_FA-010c
K_FA-020a

Edit Message

Edit Condition
* Annual LIBRARY VISITS (G-050)
* GRANTS AWARDED (H-010)
* Continuing education EVENTS (H-020)
* ATTENDANCE AT EVENTS (H-030)
* (J-070) LSTA STATE PROGRAMS REVENUE
* OTHER FEDERAL REVENUE (J-080)
* (J-100) SLAA OPERATION REVENUE
* STATE AID TO LIBRARIES (J-110)
* OTHER STATE REVENUE (J-120)
* OTHER REVENUE (J-140)
* SALARIES AND WAGES (K_AO-010) in column a
* SALARIES AND WAGES (K_AO-010) in column b
* SALARIES AND WAGES (K_AO-010) in column c
* EMPLOYEE BENEFITS (K_AO-020) in column a
* EMPLOYEE BENEFITS (K_AO-020) in column b
* EMPLOYEE BENEFITS (K_AO-020) in column c
* COLLECTION EXPENDITURES (K_AO-040) in column a
* COLLECTION EXPENDITURES (K_AO-040) in column b
* COLLECTION EXPENDITURES (K_AO-040) in column c
*OEXPOTHA(K_AO-050a)
*OEXPOTHA(K_AO-050b)
*OEXPOTHA(K_AO-050c)
* INDIVIDUAL PUBLIC LIBRARIES (K_FA-010) in column
a* INDIVIDUAL PUBLIC LIBRARIES (K_FA-010) in column
*b INDIVIDUAL PUBLIC LIBRARIES (K_FA-010) in column c
*AIDPLSA(K_FA-020a)

49

Severity

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
K_FA-020b

Edit Message

Edit Condition
* LIBRARY COOPERATIVES SERVING PUBLIC LIBRARIES
ONLY (K_FA-020) in column b
*AIDPLSC(K_FA-020c)
* OTHER INDIVIDUAL LIBRARIES (K_FA-030) in
column a
*AIDOILB(K_FA-030b)
*AIDOILC(K_FA-030c)
*AIDMLSA(K_FA-040a)
* LIBRARY COOPERATIVES SERVING MORE THAN ONE
TYPE OF LIBRARY (K_FA-040) in column b
*AIDMLSC(K_FA-040c)
* SINGLE AGENCY OR LIBRARY PROVIDING STATEWIDE
SERVICE (K_FA-050) in column a
* SINGLE AGENCY OR LIBRARY PROVIDING STATEWIDE
SERVICE (K_FA-050) in column b
*AIDSALC(K_FA-050c)
*AIDLCA(K_FA-060a)
* LIBRARY CONSTRUCTION (K_FA-060) in column b
*AIDLCC(K_FA-060c)
*AIDOTHA(K_FA-070a)
* OTHER ASSISTANCE (K_FA-070) in column b
*AIDOTHC(K_FA-070c)
*TOTAIDA(K_FA-080a)
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in
column b
*TOTAIDC(K_FA-080c)
*CAPITALA(K_OE-010a)
* CAPITAL OUTLAY (K_OE-010) in column b
*CAPITALC(K_OE-010c)
*OTHEXPA(K_OE-020a)
*OTHEXPB(K_OE-020b)
*OTHEXPC(K_OE-020c)

K_FA-020c
K_FA-030a
K_FA-030b
K_FA-030c
K_FA-040a
K_FA-040b
K_FA-040c
K_FA-050a
K_FA-050b
K_FA-050c
K_FA-060a
K_FA-060b
K_FA-060c
K_FA-070a
K_FA-070b
K_FA-070c
K_FA-080a
K_FA-080b
K_FA-080c
K_OE-010a
K_OE-010b
K_OE-010c
K_OE-020a
K_OE-020b
K_OE-020c
50

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
K_TE-010a
K_TE-010b
K_TE-010c
L-010
L-020
L-030
M-160a

Edit Message

Edit Condition
* TOTAL EXPENDITURES (K_TE-010) in column a
* TOTAL EXPENDITURES (K_TE-010) in column b
* TOTAL EXPENDITURES (K_TE-010) in column c
* (L-010) STATEWIDE SERVICES
* (L-020) GRANTS
* (L-030) LSTA ADMINISTRATION
* STATEWIDE DATABASE LICENSING EXPENDITURES (M160) in column a
* STATEWIDE DATABASE LICENSING EXPENDITURES (M160) in column b
* STATEWIDE DATABASE LICENSING EXPENDITURES (M160) in column c
Edit check message is generated when invalid negative
value is entered for numeric data. The only acceptable
negative value for numeric data is –1 (–1 means the
SLAA has the item but does not collect data on it, or
you don’t know the answer).

M-160b
M-160c
1000

Negative values other than –1 are invalid.

E-010
E-020
E-030

* TOTAL HOURS/WEEK (E-010)
* TOTAL HOURS/WEEK (E-020)
* MONDAY-FRIDAY after 5:00 p.m. (main or central
outlet) (E-030)
* SATURDAY AND SUNDAY (main or central outlet)
(E- 040)
* MAIN OR CENTRAL OUTLET (E-050)
* OTHER OUTLETS, EXCLUDING BOOKMOBILES (E-060)
* BOOKMOBILES (E-070)
* TOTAL OUTLETS (E-080)
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090)
in column a

E-040
E-050
E-060
E-070
E-080
E-090a

51

Severity

Fatal

SLAA Survey 2020 Edit Validation Reference Guide
Edit Code

Line Number
E-090b

Edit Message

Edit Condition
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090) in
column b
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090) in
column c
* BLIND & PHYSICALLY HANDICAPPED INDIVID (E-090) in
column d
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column a
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column b
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column c
* RESIDENTS OF STATE CORRECTIONAL INST. (E-100) in
column d
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column a
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column b
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column c
* RESIDENTS OF OTHER STATE INSTITUTIONS (E-110) in
column d
* STATE GOVERNMENT EMPLOYEES (E-120) in
column a
* STATE GOVERNMENT EMPLOYEES (E-120) in
column b
* STATE GOVERNMENT EMPLOYEES (E-120) in
column c
* STATE GOVERNMENT EMPLOYEES (E-120) in
column d
* GENERAL PUBLIC (E-130) in column a
* GENERAL PUBLIC (E-130) in column b

E-090c
E-090d
E-100a
E-100b
E-100c
E-100d
E-110a
E-110b
E-110c
E-110d
E-120a
E-120b
E-120c
E-120d
E-130a
E-130b
52

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
E-130c
E-130d
F-010
F-020
F-030
F-040
F-050
G-010
G-020
G-030

Edit Message

Edit Condition
* GENERAL PUBLIC (E-130) in column c
* GENERAL PUBLIC (E-130) in column d
* BOOK AND SERIAL VOLUMES (F-010)
* AUDIO MATERIALS (F-020)
* VIDEO MATERIALS (F-030)
* CURRENT SERIAL SUBSCRIPTIONS (F-040)
* GOVERNMENT DOCUMENTS (F-050)
* Total CIRCULATION (G-010)
* PROVIDED TO OTHER LIBRARIES (G-020)
* RECEIVED FROM OTHER LIBRARIES AND
DOCUMENT DELIVERY SERVICES (G-030)
* Annual REFERENCE TRANSACTIONS (G-040)
* Annual LIBRARY VISITS (G-050)
* GRANTS AWARDED (H-010)
* Continuing education EVENTS (H-020)
* ATTENDANCE AT EVENTS (H-030)
* ALA-MLS LIBRARIANS - ADMINISTRATION (I-010) in
column a
* NON ALA LIBRARIANS - ADMINISTRATION (I-010) in
column b
* OTHER STAFF - ADMINISTRATION (I-010) in column c

G-040
G-050
H-010
H-020
H-030
I-010a
I-010b
I-010c
I-010d
I-020a

* ADMINISTRATION (I-010) in column d
* ALA-MLS LIBRARIANS - LIBRARY DEVELOPMENT
(I-020) in column a
* NON ALA LIBRARIANS - LIBRARY DEVELOPMENT
(I-020) in column b
* OTHER STAFF - LIBRARY DEVELOPMENT (I-020) in
column c
* LIBRARY DEVELOPMENT (I-020) in column d

I-020b
I-020c
I-020d

53

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
I-030a

Edit Message

Edit Condition
* ALA-MLS LIBRARIANS - LIBRARY SERVICES (I-030) in
column a
* NON ALA LIBRARIANS - LIBRARY SERVICES (I-030) in
column b
* OTHER STAFF - LIBRARY SERVICES (I-030) in column c

I-030b
I-030c
I-030d
I-040a

* LIBRARY SERVICES (I-030) in column d
* ALA-MLS LIBRARIANS - OTHER SERVICES (I-040) in
column a
* NON ALA LIBRARIANS - OTHER SERVICES (I-040) in
column b
* OTHER STAFF - OTHER SERVICES (I-040) in column c
* OTHER SERVICES (I-040) in column d
* TOTAL STAFF (I-050) in column a
* TOTAL STAFF (I-050) in column b
* TOTAL STAFF (I-050) in column d
* TOTAL STAFF (I-050) in column d
* LSTA STATE PROGRAMS revenue (J-070)
* FEDERAL REVENUE - OTHER (J-080, J-080.1–J-080.10)

I-040b
I-040c
I-040d
I-050a
I-050b
I-050c
I-050d
J-070
J-080
J-090
J-100
J-110
J-120
J-130
J-140
J-150
K_AO-010a

* TOTAL FEDERAL REVENUE (J-090)
* SLAA OPERATION revenue (J-100)
* STATE AID TO LIBRARIES (J-110)
* STATE REVENUE - OTHER (J-120)
* TOTAL STATE REVENUE (J-130)
* OTHER REVENUE (J-140)
* TOTAL REVENUES (J-150)
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column a
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column b

K_AO-010b

54

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
K_AO-010c

Edit Message

Edit Condition
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column c
* OPERATING EXPENDITURES - SALARIES AND WAGES
(K_AO-010) in column d
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column a
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column b
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column c
* OPERATING EXPENDITURES - EMPLOYEE BENEFITS
(K_AO-020) in column d
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column a
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column b
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column c
* OPERATING EXPENDITURES - TOTAL STAFF
EXPENDITURES (K_AO-030) in column d
* OPERATING EXPENDITURES - COLLECTION (K_AO040) in column a
* OPERATING EXPENDITURES - COLLECTION (K_AO040) in column b
* OPERATING EXPENDITURES - COLLECTION (K_AO040) in column c
* OPERATING EXPENDITURES - COLLECTION (K_AO040) in column d
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column a
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column b

K_AO-010d
K_AO-020a
K_AO-020b
K_AO-020c
K_AO-020d
K_AO-030a
K_AO-030b
K_AO-030c
K_AO-030d
K_AO-040a
K_AO-040b
K_AO-040c
K_AO-040d
K_AO-050a
K_AO-050b

55

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
K_AO-050c

Edit Message

Edit Condition
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column c
* OPERATING EXPENDITURES - OTHER (K_AO-050) in
column d
* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column a
* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column b
* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column c
* TOTAL OPERATING EXPENDITURES (K_AO-060) in
column d
* CAPITAL OUTLAY (K_OE-010) in column a
* CAPITAL OUTLAY (K_OE-010) in column b
* CAPITAL OUTLAY (K_OE-010) in column c
* CAPITAL OUTLAY (K_OE-010) in column d
* OTHER EXPENDITURES in column a
* OTHER EXPENDITURES in column b
* OTHER EXPENDITURES in column c
* OTHER EXPENDITURES in column d
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column a
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column b
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column c
* FINANCIAL ASSISTANCE - INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010) in column d
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column a

K_AO-050d
K_AO-060a
K_AO-060b
K_AO-060c
K_AO-060d
K_OE-010a
K_OE-010b
K_OE-010c
K_OE-010d
K_OE-020a
K_OE-020b
K_OE-020c
K_OE-020d
K_FA-010a
K_FA-010b
K_FA-010c
K_FA-010d
K_FA-020a

56

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
K_FA-020b

Edit Message

Edit Condition
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column b
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column c
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020) in
column d
* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column a
* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column b
* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column c
* FINANCIAL ASSISTANCE - INDIVIDUAL LIBRARIES
(K_FA-030) in column d
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column a
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column b
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column c
* FINANCIAL ASSISTANCE - LIBRARY COOPERATIVES
SERVING MORE THAN ONE LIBRARY TYPE (K_FA-040)
in column d
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column a

K_FA-020c

K_FA-020d

K_FA-030a
K_FA-030b
K_FA-030c
K_FA-030d
K_FA-040a

K_FA-040b

K_FA-040c

K_FA-040d

K_FA-050a

57

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
K_FA-050b

Edit Message

K_FA-080a

Edit Condition
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column b
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column c
* FINANCIAL ASSISTANCE - SINGLE AGENCY/LIBRARY
PROVIDING STATEWIDE SERVICES (K_FA-050) in
column d
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column a
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column b
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column c
* FINANCIAL ASSISTANCE - LIBRARY CONSTRUCTION
(K_FA-060) in column d
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column a
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column b
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column c
* FINANCIAL ASSISTANCE - OTHER (K_FA-070) in
column d
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in column a

K_FA-080b

* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in column b

K_FA-080c

* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in column c

K_FA-050c

K_FA-050d

K_FA-060a
K_FA-060b
K_FA-060c
K_FA-060d
K_FA-070a
K_FA-070b
K_FA-070c
K_FA-070d

58

Severity

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code

Line Number
K_FA-080d
K_TE-010a
K_TE-010b
K_TE-010c
K_TE-010d
L-010
L-020
L-030
L-040
M-140

Edit Message

M-150
M-160a
M-160b
M-160c
M-160d
1003

J-070

1004

H-010

LSTA STATE PROGRAMS revenue (J-070) greater
than IMLS LSTA Allotment table
GRANTS AWARDED (H-010) for the current
reporting period has had a large change from prior
reporting period. Please check for possible errors
or explain why the correct data are out of range.

59

Edit Condition
* TOTAL FINANCIAL ASSISTANCE (K_FA-080) in column d
* TOTAL EXPENDITURES (K_TE-010) in column a
* TOTAL EXPENDITURES (K_TE-010) in column b
* TOTAL EXPENDITURES (K_TE-010) in column c
* TOTAL EXPENDITURES (K_TE-010) in column d
* STATEWIDE SERVICES (L-010)
* GRANTS (L-020)
* LSTA ADMINISTRATION (L-030)
* TOTAL LSTA EXPENDITURES (L-040)
* LIBRARY–OWNED PUBLIC–ACCESS
INTERNET WORKSTATIONS (M-140)
* ALL OTHER PUBLIC–ACCESS INTERNET
WORKSTATIONS (M-150)
* EXPENDITURES FOR STATEWIDE DATABASE LICENSING
(M-160) in column a
* EXPENDITURES FOR STATEWIDE DATABASE LICENSING
(M-160) in column b
* EXPENDITURES FOR STATEWIDE DATABASE LICENSING
(M-160) in column c
* STATEWIDE DATABASE LICENSING (M-160) in column
d
LSTA STATE PROGRAMS revenue (J-070) greater
than IMLS LSTA Allotment table
Grants awarded (H-010) not 50% to 150% of last year,
and the prior year to current year change is greater
than + or - 10. Note: Run this edit only when values are
greater than 0 for the current and prior year.

Severity

Explanation
Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1005

Line Number
E-020

1006

L-040

1009

E-080

1010

E-080

1011

E-090d

Edit Message
TOTAL HOURS/WEEK main or central outlet (E-020)
is less than the sum of TOTAL HOURS MondayFriday after 5 main or central outlet (E-030) and
TOTAL HOURS Saturday and Sunday main or central
outlet (E-040). Please correct total or associated
details.
TOTAL LSTA EXPENDITURES (L-040) should be less
than or equal to TOTAL EXPENDITURES (K_TE010b) from State sources.
TOTAL NUMBER OF SLAA OUTLETS (E-080) is less
than the sum of the number of MAIN OR
CENTRAL OUTLET (E-050), OTHER OUTLETS (E060), and BOOKMOBILES (E-070). Please correct
total or associated details.
TOTAL NUMBER OF SLAA OUTLETS (E-080) is greater
than the sum of the number of MAIN OR CENTRAL
OUTLET (E-050), OTHER OUTLETS (E-060), and
BOOKMOBILES (E-070). This should only occur if
one or more of the details contained in the total are
missing (-1). Please correct data or explain/verify
that data are correct.

Edit Condition
TOTHRSCETOTEXPB

Fatal

TOTALOUTsum(MAINOUT,OTHEROUT,BKMOBILE)

Explanation

TOTAL NUMBER OF OUTLETS that serve
Blind/Physically handicapped individuals (E-090d)
is less than the sum of the number of MAIN OR
CENTRAL OUTLETS (E-090a), OTHER OUTLETS
(E-090b), and BOOKMOBILES (E-090c) that serve
Blind/Physically handicapped individuals. Please
correct total or associated details.

BPHOUTDsum(BPHOUTA, BPHOUTB, BPHOUTC)

Severity
Explanation

COROUTDsum(COROUTA, COROUTB, COROUTC)

Explanation

61

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1015

Line Number
E-110d

1016

E-110d

1017

E-120d

Edit Message
TOTAL NUMBER OF OUTLETS that serve residents
of other State institutions (E-110d) is less than the
sum of the number of MAIN OR CENTRAL
OUTLETS (E- 110a), OTHER OUTLETS (E-110b), and
BOOKMOBILES (E-110c) that serve residents of
other State institutions. Please correct total or
associated details.
TOTAL NUMBER OF OUTLETS that serve residents
of other State institutions (E-110d) is greater than
the sum of the number of MAIN OR CENTRAL
OUTLETS (E-110a), OTHER OUTLETS (E-110b), and
BOOKMOBILES (E-110c) that serve residents of
other State institutions. This should only occur if
one or more of the details contained in the total
are missing (-1). Please correct data or
explain/verify that data are correct.

Edit Condition
OTSTOUTDsum(OTSTOUTA, OTSTOUTB, OTSTOUTC)

Explanation

TOTAL NUMBER OF OUTLETS that serve State
government employees (E-120d) is less than the
sum of the number of MAIN OR CENTRAL OUTLETS
(E- 120a), OTHER OUTLETS (E-120b), and
BOOKMOBILES (E-120c) that serve State
government employees. Please correct total or
associated details.

GVEMOUTDsum(GVEMOUTA,
GVEMOUTB, GVEMOUTC)

Severity
Explanation

1019

E-130d

TOTAL NUMBER OF OUTLETS that serve the general
public (E-130d) is less than the sum of the number
of MAIN OR CENTRAL OUTLETS (E-130a), OTHER
OUTLETS (E-130b), and BOOKMOBILES (E-130c)
that serve the general public. Please correct total
or associated details.

GPOUTDsum(GPOUTA, GPOUTB, GPOUTC)

Explanation

1021

I-010d

TOTAL NUMBER OF ADMINISTRATION STAFF (I010d) is less than the sum of the number of ALAMLS LIBRARIANS (I-010a), NON ALA-MLS
LIBRARIANS (I-010b), and OTHER STAFF (I-010c).
Please correct total or associated details.

ADMINsum(MADMIN,NADMIN,OADMIN)

Severity
Explanation

1023

I-020d

TOTAL NUMBER OF LIBRARY DEVELOPMENT STAFF
(I-020d) is less than the sum of the number of ALAMLS LIBRARIANS (I-020a), NON ALA-MLS
LIBRARIANS (I-020b), and OTHER STAFF (I-020c).
Please correct total or associated details.

LIBDEVsum(MLIBDEV,NLIBDEV,OLIBDEV)

Explanation

1025

I-030d

TOTAL NUMBER OF LIBRARY SERVICES STAFF
(I-030d) is less than the sum of the number of ALAMLS LIBRARIANS (I-030a), NON ALA-MLS
LIBRARIANS (I-030b), and OTHER STAFF (I-030c).
Please correct total or associated details.

LIBSERVsum(MLIBSERV,NLIBSERV,OLIBSERV)

Severity
Explanation

1027

I-040d

TOTAL NUMBER OF OTHER SERVICES STAFF (I-040d)
is less than the sum of the number of ALA-MLS
LIBRARIANS (I-040a), NON ALA-MLS LIBRARIANS (I040b), and OTHER STAFF (I-040c). Please correct
total or associated details.

OTHSERVsum(MOTHSERV,NOTHSERV,OOTHSERV)

Explanation

1029

I-050a

TOTAL NUMBER OF ALA-MLS LIBRARIANS (I-050a) is
less than the sum of the number of
ADMINISTRATION (I-010a), LIBRARY DEVELOPMENT
(I-020a), LIBRARY SERVICES (I-030a), and OTHER
SERVICES (I-040a) ALA-MLS LIBRARIANS. Please
correct total or associated details.

MTOTSTAFsum(MADMIN,MLIBDEV,MLIBSER
V, MOTHSERV)

Severity
Explanation

1031

I-050b

TOTAL NUMBER OF NON ALA-MLS LIBRARIANS (I050b) is less than the sum of the number of
ADMINISTRATION (I-010b), LIBRARY DEVELOPMENT
(I-020b), LIBRARY SERVICES (I-030b), and OTHER
SERVICES (I-040b) NON ALA-MLS LIBRARIANS.
Please correct total or associated details.

NTOTSTAFsum(NADMIN,NLIBDEV,NLIBSER
V, NOTHSERV)

Explanation

1033

I-050c

TOTAL NUMBER OTHER STAFF (I-050c) is less than
the sum of the number of ADMINISTRATION (I010c), LIBRARY DEVELOPMENT (I-020c), LIBRARY
SERVICES (I-030c), and OTHER SERVICES (I-040c)
OTHER STAFF. Please correct total or associated
details.

OTOTSTAFsum(OADMIN,OLIBDEV,OLIBSER
V, OOTHSERV)

Severity
Explanation

1035

I-050d

TOTAL NUMBER OF STAFF (I-050d) is less than the
sum of the TOTAL number of ALA-MLS LIBRARIANS
(I- 050a), NON ALA-MLS LIBRARIANS (I-050b), and
OTHER STAFF (I-050c). Please correct total or
associated details.

TOTSTAFsum(MTOTSTAF,NTOTSTAF,OTOTSTAF)

Explanation

1037

J-090

TOTAL NUMBER OF STAFF (I-050d) is greater than
the sum of the TOTAL number of ALA-MLS
LIBRARIANS (I-050a), NON ALA-MLS LIBRARIANS
(I-050b), and OTHER STAFF (I-050c). This should
only occur if one or more of the details
contained in the total are missing (-1). Please
correct data or explain/verify that data are
correct.
TOTAL FEDERAL REVENUE (J-090) is less than the
sum of FEDERAL LSTA STATE PROGRAM (J-070)
and OTHER FEDERAL (J-080) REVENUE. Please
correct total or associated details.

TOTAL_FISUM(LSTAINC,FIOTH)

Severity
Explanation

TOTAL_SIsum(SISTLAOP,SIAIDLIB,SIOTHER)

Explanation

TOTINCMsum(TOTAL_FI,TOTAL_SI, OTHINCM)

Explanation

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1043

Line Number
K_AO-010d

Edit Message
TOTAL EXPENDITURES SALARIES AND WAGES
(K_AO-010d) is less than the sum of the FEDERAL
(K_AO- 010a), STATE (K_AO-010b), and OTHER
(K_AO-010c) EXPENDITURES for SALARIES AND
WAGES. Please correct the total or the associated
details.

Edit Condition
OEXPSALDsum(OEXPSALA-OEXPSALC)

Explanation

1045

K_AO-020d

TOTAL EXPENDITURES EMPLOYEE BENEFITS (K_AO020d) is less than the sum of the FEDERAL (K_AO020a), STATE (K_AO-020b), and OTHER (K_AO-020c)
EXPENDITURES for EMPLOYEE BENEFITS. Please
correct the total or the associated details.

OEXPPBENDsum(OEXPBENA-OEXPBENC)

Explanation

69

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1047

Line Number
K_AO-030a

Edit Message
TOTAL FEDERAL STAFF EXPENDITURES (K_AO-030a)
is less than the sum of FEDERAL SALARIES and
WAGES (K_AO-010a) and FEDERAL EMPLOYEE
BENEFITS (K_AO-020a). Please correct the total or
the associated details.

Edit Condition
TOTOXSTASUM(OEXPSALA, OEXPBENA)

Explanation

1049

K_AO-030b

TOTAL STATE STAFF EXPENDITURES (K_AO-030b) is
less than the sum of STATE SALARIES and WAGES
(K_AO-010b) and STATE EMPLOYEE BENEFITS
(K_AO-020b). Please correct total or associated
details.

TOTOXSTBSUM(OEXPSALB, OEXPBENB)

Explanation

1051

K_AO-030c

TOTAL OTHER STAFF EXPENDITURES (K_AO-030c) is
less than the sum of OTHER SALARIES and WAGES
(K_AO-010c) and OTHER EMPLOYEE BENEFITS
(K_AO-020c). Please correct total or associated
details.

TOTOXSTCSUM(OEXPSALC, OEXPBENC)

Severity
Explanation

1053

K_AO-030d

TOTAL STAFF EXPENDITURES (K_AO-030d) is less
than the sum of the FEDERAL (K_AO-030a), STATE
(K_AO-030b), and OTHER (K_AO-030c) TOTAL STAFF
EXPENDITURES. Please correct total or associated
details.

TOTOXSTDsum(TOTOXSTA-TOTOXSTC)

Explanation

1055

K_AO-040d

TOTAL COLLECTION EXPENDITURES (K_AO-040d) is
less than the sum of FEDERAL (K_AO-040a), STATE
(K_AO-040b), and OTHER (K_AO-040c) COLLECTION
EXPENDITURES. Please correct total or associated
details.

OEXPCOLDsum(OEXPCOLA-OEXPCOLC)

Severity
Explanation

1057

K_AO-050d

TOTAL OTHER OPERATING EXPENDITURES (K_AO050d) is less than the sum of FEDERAL (K_AO050a), STATE (K_AO-050b), and OTHER (K_AO-050c)
OTHER OPERATING EXPENDITURES. Please correct
total or associated details.

OEXPOTHDsum(OEXPOTHA-OEXPOTHC)

Explanation

1059

K_AO-060a

TOTAL FEDERAL OPERATING EXPENDITURES (K_AO060a) is less than the sum of FEDERAL SALARIES
AND WAGES (K_AO-010a), FEDERAL EMPLOYEE
BENEFITS (K_AO-020a), FEDERAL COLLECTION
EXPENDITURES (K_AO-040a), and FEDERAL OTHER
OPERATING EXPENDITURES (K_AO-050a). Please
correct total or associated details.

TOTOPEXAsum(OEXPSALA,OEXPBENA,OEXPCOL
A, OEXPOTHA)

Severity
Explanation

1061

K_AO-060b

TOTAL STATE OPERATING EXPENDITURES (K_AO060b) is less than the sum of STATE SALARIES AND
WAGES (K_AO-010b), STATE EMPLOYEE BENEFITS
(K_AO-020b), STATE COLLECTION EXPENDITURES
(K_AO-040b), and STATE OTHER OPERATING
EXPENDITURES (K_AO-050b). Please correct total or
associated details.

TOTOPEXBsum(OEXPSALB,OEXPBENB,OEXPCOL
B, OEXPOTHB)

Explanation

73

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1063

Line Number
K_AO-060c

Edit Message
TOTAL OTHER OPERATING EXPENDITURES (K_AO060c) is less than the sum of OTHER SALARIES AND
WAGES (K_AO-010c), OTHER EMPLOYEE BENEFITS
(K_AO-020c), OTHER COLLECTION EXPENDITURES
(K_AO-040c), and OTHER OTHER OPERATING
EXPENDITURES (K_AO-050c). Please correct total or
associated details.

Edit Condition
TOTOPEXCsum(OEXPSALC,OEXPBENC,OEXPCOL
C, OEXPOTHC)

Explanation

1065

K_AO-060d

TOTOPEXDsum(TOTOPEXA-TOTOPEXC)

Explanation

74

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1067

Line Number
K_FA-010d

Edit Message
TOTAL EXPENDITURES FOR INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010d) is less than the sum of
FEDERAL (K_FA-010a), STATE (K_FA-010b), and
OTHER (K_FA-010c) EXPENDITURES FOR
INDIVIDUAL PUBLIC LIBRARIES. Please correct total
or associated details.

Edit Condition
AIDIPLDsum(AIDIPLA-AIDIPLC)

Explanation

1069

K_FA-020d

TOTAL EXPENDITURES FOR LIBRARY
COOPERATIVES SERVING PUBLIC LIBRARIES ONLY
(K_FA-020d) is less than the sum of FEDERAL
(K_FA-020a), STATE (K_FA- 020b), and OTHER
(K_FA-020c) EXPENDITURES FOR LIBRARY
COOPERATIVES SERVING PUBLIC LIBRARIES ONLY.
Please correct total or associated details.

AIDPLSDsum(AIDPLSA-AIDPLSC)

Severity
Explanation

AIDOILDsum(AIDOILA-AIDOILC)

Explanation

76

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1073

Line Number
K_FA-040d

1074

K_FA-040d

1075

K_FA-050d

Edit Message
TOTAL EXPENDITURES FOR LIBRARY
COOPERATIVES SERVING MORE THAN ONE TYPE
OF LIBRARY (K_FA-040d) is less than the sum of
FEDERAL (K_FA-040a), STATE (K_FA-040b), and
OTHER (K_FA-040c) EXPENDITURES FOR LIBRARY
COOPERATIVES SERVING MORE THAN ONE TYPE
OF LIBRARY. Please correct total or associated
details.
TOTAL EXPENDITURES FOR LIBRARY
COOPERATIVES SERVING MORE THAN ONE TYPE
OF LIBRARY (K_FA-040d) is greater than the sum
of FEDERAL (K_FA- 040a), STATE (K_FA-040b), and
OTHER (K_FA-040c) EXPENDITURES FOR LIBRARY
COOPERATIVES SERVING MORE THAN ONE TYPE
OF LIBRARY. This should only occur if one or more
of the details contained in the total are missing (1). Please correct data or explain/verify that data
are correct.
TOTAL EXPENDITURES FOR SINGLE AGENCY OR
LIBRARY PROVIDING STATEWIDE SERVICE
(K_FA-050d) is less than the sum of FEDERAL
(K_FA-050a), STATE (K_FA-050b), and OTHER
(K_FA-050c) EXPENDITURES FOR SINGLE
AGENCY OR LIBRARY PROVIDING STATEWIDE
SERVICE. Please correct total or associated
details.

77

Edit Condition
AIDMLSDsum(AIDMLSA-AIDMLSC)

Explanation

AIDSALDsum(AIDSALA-AIDSALC)

Severity
Explanation

AIDLCDsum(AIDLCA-AIDLCC)

Explanation

1079

K_FA-070d

TOTAL EXPENDITURES FOR OTHER ASSISTANCE
(K_FA-070d) is less than the sum of FEDERAL (K_FA070a), STATE (K_FA-070b), and OTHER (K_FA-070c)
EXPENDITURES FOR OTHER ASSISTANCE. Please
correct total or associated details.

AIDOTHDsum(AIDOTHA-AIDOTHC)

Severity
Explanation

K_FA-080a

TOTAL FEDERAL EXPENDITURES FINANCIAL
ASSISTANCE (K_FA-080a) is less than the sum of
FEDERAL EXPENDITURES for INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010a), LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020a),
OTHER INDIVIDUAL LIBRARIES (K_FA-030a), LIBRARY
COOPERATIVES SERVING MORE THAN ONE TYPE OF
LIBRARY (K_FA-040a), SINGLE AGENCY OR LIBRARY
PROVIDING STATEWIDE SERVICE (K_FA-050a),
LIBRARY CONSTRUCTION (K_FA-060a), and OTHER
ASSISTANCE (K_FA-070a). Please correct total or
associated details.

TOTAIDAsum(AIDIPLA,AIDPLSA,AIDOILA,AIDMLSA,AI
DS ALA,AIDLCA,AIDOTHA)

Severity
Explanation

K_FA-080b

TOTAL STATE EXPENDITURES FINANCIAL ASSISTANCE
(K_FA-080b) is less than the sum of STATE
EXPENDITURES for INDIVIDUAL PUBLIC LIBRARIES
(K_FA-010b), LIBRARY COOPERATIVES SERVING
PUBLIC LIBRARIES ONLY (K_FA-020b), OTHER
INDIVIDUAL LIBRARIES (K_FA-030b), LIBRARY
COOPERATIVES SERVING MORE THAN ONE TYPE OF
LIBRARY (K_FA-040b), SINGLE AGENCY OR LIBRARY
PROVIDING STATEWIDE SERVICE (K_FA-050b),
LIBRARY CONSTRUCTION (K_FA-060b), and OTHER
ASSISTANCE (K_FA-070b). Please correct total or
associated details.

TOTAIDBsum(AIDIPLB,AIDPLSB,AIDOILB,AIDMLSB,AID
S ALB,AIDLCB,AIDOTHB)

Severity
Explanation

K_FA-080c

TOTAL OTHER EXPENDITURES FINANCIAL
ASSISTANCE (K_FA-080c) is less than the sum of
OTHER EXPENDITURES for INDIVIDUAL PUBLIC
LIBRARIES (K_FA-010c), LIBRARY COOPERATIVES
SERVING PUBLIC LIBRARIES ONLY (K_FA-020c),
OTHER INDIVIDUAL LIBRARIES (K_FA-030c), LIBRARY
COOPERATIVES SERVING MORE THAN ONE TYPE OF
LIBRARY (K_FA-040c), SINGLE AGENCY OR LIBRARY
PROVIDING STATEWIDE SERVICE (K_FA-050c),
LIBRARY CONSTRUCTION (K_FA-060c), and OTHER
ASSISTANCE (K_FA-070c). Please correct total or
associated details.

TOTAIDCsum(AIDIPLC,AIDPLSC,AIDOILC,AIDMLSC,AID
S ALC,AIDLCC,AIDOTHC)

Severity
Explanation

1087

K_FA-080d

TOTAL FINANCIAL ASSISTANCE (K_FA-080d) is less
than the sum of TOTAL FEDERAL FINANCIAL
ASSISTANCE (K_FA-080a), TOTAL STATE FINANCIAL
ASSISTANCE (K_FA-080b), and TOTAL OTHER
FINANCIAL ASSISTANCE (K_FA-080c). Please correct
total or associated details.

TOTAIDDsum(TOTAIDA-TOTAIDC)

Explanation

82

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1089

Line Number
K_OE-010d

Edit Message
TOTAL CAPITAL OUTLAY (K_OE-010d) is less than
the sum of FEDERAL CAPITAL OUTLAY (K_OE010a), STATE CAPITAL OUTLAY (K_OE-010b), and
OTHER CAPITAL OUTLAY (K_OE-010c). Please
correct total or associated details.

Edit Condition
CAPITALDsum(CAPITALA-CAPITALC)

Explanation

1091

K_OE-020d

TOTAL OTHER EXPENDITURES (K_OE-020d) is less
than the sum of FEDERAL OTHER EXPENDITURES
(K_OE-020a), STATE OTHER EXPENDITURES (K_OE020b), and OTHER OTHER EXPENDITURES (K_OE020c). Please correct total or associated details.

OTHEXPDsum(OTHEXPA-OTHEXPC)

Explanation

83

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1093

Line Number
K_TE-010a

Edit Message
TOTAL FEDERAL OTHER EXPENDITURES (K_TE-010a)
is less than the sum of FEDERAL TOTAL OPERATING
EXPENDITURES (K_AO-060a), FEDERAL CAPITAL
OUTLAY (K_OE-010a), FEDERAL OTHER
EXPENDITURES (K_OE-020a), AND FEDERAL TOTAL
FINANCIAL ASSISTANCE (K_FA-080a). Please correct
total or associated details.

Edit Condition
TOTEXPAsum(TOTOPEXA,TOTAIDA)

Explanation

1095

K_TE-010b

TOTAL STATE OTHER EXPENDITURES (K_TE-010b) is
less than the sum of STATE TOTAL OPERATING
EXPENDITURES (K_AO-060b), STATE CAPITAL
OUTLAY (K_OE-010b), STATE OTHER EXPENDITURES
(K_OE-020b), AND STATE TOTAL FINANCIAL
ASSISTANCE (K_FA-080b). Please correct total or
associated details.

TOTEXPBsum(TOTOPEXB,TOTAIDB)

Explanation

84

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1097

Line Number
K_TE-010c

Edit Message
TOTAL STATE OTHER EXPENDITURES (K_TE-010b) is
greater than the sum of STATE TOTAL OPERATING
EXPENDITURES (K_AO-060b), STATE CAPITAL
OUTLAY (K_OE-010b), STATE OTHER EXPENDITURES
(K_OE-020b), AND STATE TOTAL FINANCIAL
ASSISTANCE (K_FA-080b). Please correct total or
associated details.

Edit Condition
TOTEXPCsum(TOTOPEXC,TOTAIDC)

Explanation

1099

K_TE-010d

TOTEXPDsum(TOTOPEXD,TOTAIDD)

Explanation

85

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1101

Line Number
L-040

Edit Message
TOTAL LSTA EXPENDITURES (L-040) is less than the
sum of EXPENDITURES for STATEWIDE SERVICE (L010), GRANTS (L-020), and LSTA ADMINISTRATION
(L-030). Please correct total or associated details.

Edit Condition
TOTEXPTsum(SWEXPT,GREXPT,ADMEXPT)

Explanation

1103

M-160d

SWDBLICDsum(SWDBLICA-SWDLICC)

Explanation

86

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1105

Line Number
D_SV-090a

Edit Message
ADMINISTRATION OF LSTA STATE PROGRAM
GRANTS (D_SV-090a-e) cannot be contracted.

1105

D_SV-090b

ADMINISTRATION OF LSTA STATE PROGRAM
GRANTS (D_SV-090a-e) cannot be contracted.

1105

D_SV-090c

ADMINISTRATION OF LSTA STATE PROGRAM
GRANTS (D_SV-090a-e) cannot be contracted.

1105

D_SV-090d

ADMINISTRATION OF LSTA STATE PROGRAM
GRANTS (D_SV-090a-e) cannot be contracted.

1105

D_SV-090e

ADMINISTRATION OF LSTA STATE PROGRAM
GRANTS (D_SV-090a-e) cannot be contracted.

Edit Condition
Contract was selected for ADMINISTRATION OF LSTA
STATE PROGRAM GRANTS (D_SV-090) in any of
columns a to e. Note: IMLS has indicated that states
cannot contract out the administration of LSTA grants;
the answer should be Directly if you provide this
service.
Contract was selected for ADMINISTRATION OF LSTA
STATE PROGRAM GRANTS (D_SV-090) in any of
columns a to e. Note: IMLS has indicated that states
cannot contract out the administration of LSTA grants;
the answer should be Directly if you provide this
service.
Contract was selected for ADMINISTRATION OF LSTA
STATE PROGRAM GRANTS (D_SV-090) in any of
columns a to e. Note: IMLS has indicated that states
cannot contract out the administration of LSTA grants;
the answer should be Directly if you provide this
service.
Contract was selected for ADMINISTRATION OF LSTA
STATE PROGRAM GRANTS (D_SV-090) in any of
columns a to e. Note: IMLS has indicated that states
cannot contract out the administration of LSTA grants;
the answer should be Directly if you provide this
service.
Contract was selected for ADMINISTRATION OF LSTA
STATE PROGRAM GRANTS (D_SV-090) in any of
columns a to e. Note: IMLS has indicated that states
cannot contract out the administration of LSTA grants;
the answer should be Directly if you provide this
service.

87

Severity
Fatal

Fatal

Fatal

Fatal

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1106

Line Number
D_SV-100a

Edit Message
ADMINISTRATION OF LSTA STATEWIDE SERVICES
(D_SV-100a-e) cannot be contracted.

1106

D_SV-100b

ADMINISTRATION OF LSTA STATEWIDE SERVICES
(D_SV-100a-e) cannot be contracted.

1106

D_SV-100c

ADMINISTRATION OF LSTA STATEWIDE SERVICES
(D_SV-100a-e) cannot be contracted.

1106

D_SV-100d

ADMINISTRATION OF LSTA STATEWIDE SERVICES
(D_SV-100a-e) cannot be contracted.

1106

D_SV-100e

ADMINISTRATION OF LSTA STATEWIDE SERVICES
(D_SV-100a-e) cannot be contracted.

Edit Condition
Contract was selected for ADMINISTRATION OF
LSTA STATEWIDE SERVICES GRANTS (D_SV-100) in
any of columns a to e. Note: IMLS has indicated
that states cannot contract out the administration
of LSTA grants; the answer should be Directly if
you provide this service.
Contract was selected for ADMINISTRATION OF
LSTA STATEWIDE SERVICES GRANTS (D_SV-100) in
any of columns a to e. Note: IMLS has indicated
that states cannot contract out the administration
of LSTA grants; the answer should be Directly if
you provide this service.
Contract was selected for ADMINISTRATION OF
LSTA STATEWIDE SERVICES GRANTS (D_SV-100) in
any of columns a to e. Note: IMLS has indicated
that states cannot contract out the administration
of LSTA grants; the answer should be Directly if
you provide this service.
Contract was selected for ADMINISTRATION OF
LSTA STATEWIDE SERVICES GRANTS (D_SV-100) in
any of columns a to e. Note: IMLS has indicated
that states cannot contract out the administration
of LSTA grants; the answer should be Directly if
you provide this service.
Contract was selected for ADMINISTRATION OF
LSTA STATEWIDE SERVICES GRANTS (D_SV-100) in
any of columns a to e. Note: IMLS has indicated
that states cannot contract out the administration
of LSTA grants; the answer should be Directly if
you provide this service.

88

Severity
Fatal

Fatal

Fatal

Fatal

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1107

Line Number
D_SV-090a

Edit Message
All SLAAs must directly administer LSTA State
program grants or statewide services for
public libraries.

Edit Condition
Not Provided was selected for Administration of LSTA
State program grants (D_SV-090) in column a (public
libraries) AND Not Provided was selected for
Administration of LSTA statewide services (D_SV-100)
in column a (public libraries). Note: This answer is not
possible, as all SLAAs must directly administer LSTA
grants or statewide services to public libraries in order
to receive LSTA funds.

Severity
Fatal

1108

D_SV-100a

All SLAAs must directly administer LSTA State
program grants or statewide services for
public libraries.

Not Provided was selected for Administration of LSTA
State program grants (D_SV-090) in column a (public
libraries) AND Not Provided was selected for
Administration of LSTA statewide services (D_SV-100)
in column a (public libraries). Note: This answer is not
possible, as all SLAAs must directly administer LSTA
grants or statewide services to public libraries in order
to receive LSTA funds.

Fatal

1109

D_SV-090a

Provide ADMINISTRATION OF LSTA STATE
PROGRAM GRANTS (D_SV-090) but no GRANTS
AWARDED (H-010), or vice versa.

Directly or Contract to ADMINISTRATION OF LSTA
STATE PROGRAM GRANTS (D_SV-090) in any of
columns a-e but GRANTS AWARDED (H-010) is -1 or 0.
Or, Not Provided to (D_SV-090) in all of columns a-e
but (H-010) is greater than 0.

Explanation

1110

D_SV-100a

Provide ADMINISTRATION OF LSTA STATE
STATEWIDE SERVICES (D_SV-100) but no
GRANTS AWARDED (H-010), or vice versa.

Directly or Contract to ADMINISTRATION OF LSTA
STATEWIDE SERVICES (D_SV-100) in any of columns ae but GRANTS AWARDED (H-010) is -1 or 0. Or, Not
Provided to (D_SV-100) in all of columns a-e but (H010) is greater than 0.

Explanation

89

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1114

Line Number
D_PA-060.1

Edit Message
You provide program assistance for Statewide
Reading Programs (D_PA-060a-e) and you selected
“Yes” to all statewide reading program target
population items for D_PA-060.1 - D_PA-060.5.
Please explain how all populations are targeted.
NOTE: If you target the general population and no
population item specifically, then you should select
“No” to all target population items.

Edit Condition
At least one value of D_PA-060a-e = "Directly" or
"Contract" and D_PA-060.1.5 through D_PA-060.1.5 =
"Yes".

Severity
Explanation

1115

D_PA-060.1

At least one value of D_PA-060a-e = "Directly" or
"Contract" and D_PA-060.1.1 through D_PA-060.1.5 =
"Don't Know".

Explanation

1116

D_SV050.1.10

OTHER (D_SV-050.1.9) is selected as "Yes" but OTHER
(D_SV-050.1.10) comment box is blank, or vv.

Fatal

1117

D_CI-060.1.6

OTHER (D_CI-060.1.5) is selected as "Yes" but OTHER
(D_CI-060.1.6) comment box is blank, or vv.

Fatal

1118

D_SV-050.1.1

You provide program assistance for Statewide
Reading Programs (D_PA-060a-e) and you selected
“Don’t Know” to all statewide reading program
target population items for D_PA-060.1 - D_PA060.5.
You selected “Yes” for D_SV-050.1.9 “Other” but did
not submit a comment in the D_SV-050.1.10 “Other”
comment box.
You selected “Yes” for D_CI-060.1.5 “Other” but did
not submit a comment in the D_CI-060.1.6 “Other”
comment box.
Please select a response for this item.

At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.1=blank/not answered.

Fatal

1119

D_SV-050.1.2

Please select a response for this item.

At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.2=blank/not answered.

Fatal

1120

D_SV-050.1.3

Please select a response for this item.

At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.3=blank/not answered.

Fatal

1121

D_SV-050.1.4

Please select a response for this item.

At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.4=blank/not answered.

Fatal

90

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1122

Line Number
D_SV-050.1.5

Edit Message
Please select a response for this item.

1123

D_SV-050.1.6

Please select a response for this item.

1124

D_SV-050.1.7

Please select a response for this item.

1125

D_SV-050.1.8

Please select a response for this item.

1126

D_SV-050.1.9

Please select a response for this item.

1127

D_CI-060.1.1

Please select a response for this item.

1128

D_CI-060.1.2

Please select a response for this item.

1129

D_CI-060.1.3

Please select a response for this item.

1130

D_CI-060.1.4

Please select a response for this item.

1131

D_CI-060.1.5

Please select a response for this item.

Edit Condition
At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.5=blank/not
answered.
At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.6=blank/not
answered.
At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.7=blank/not
answered.
At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.8=blank/not
answered.
At least one value of D_SV-050a-e = "Directly" or
"Contract" and D_SV-050.1.9=blank/not
answered.
At least one value of D_CI-060a-e = "Directly" or
"Contract" and D_CI-060.1.1 = blank/not
answered
At least one value of D_CI-060a-e = "Directly" or
"Contract" and D_CI-060.1.2 = blank/not
answered
At least one value of D_CI-060a-e = "Directly" or
"Contract" and D_CI-060.1.3 = blank/not
answered
At least one value of D_CI-060a-e = "Directly" or
"Contract" and D_CI-060.1.4 = blank/not
answered
At least one value of D_CI-060a-e = "Directly" or
"Contract" and D_CI-060.1.5 = blank/not
answered

91

Severity
Fatal

Fatal

Fatal

Fatal

Fatal

Fatal

Fatal

Fatal

Fatal

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1132

Line Number
D_PA-060.1.1

Edit Message
Please select a response for this item.

1133

D_PA-060.1.2

Please select a response for this item.

1134

D_PA-060.1.3

Please select a response for this item.

1135

D_PA-060.1.4

Please select a response for this item.

1136

D_PA-060.1.5

Please select a response for this item.

1137

D_PA-030.1

1138

D_PA-030.1.1

You provide literacy program support (D_PA-030ae) but selected Don’t Know to D_PA-030.1.1D_PA- 030.1.7.
Please select a response for this item.

1139

D_PA-030.1.2

Please select a response for this item.

1140

D_PA-030.1.3

Please select a response for this item.

1141

D_PA-030.1.4

Please select a response for this item.

92

Edit Condition
At least one value of D_PA-060a-e = "Directly" or
"Contract" and D_PA-060.1.1 = blank/not
answered
At least one value of D_PA-060a-e = "Directly" or
"Contract" and D_PA-060.1.2 = blank/not
answered
At least one value of D_PA-060a-e = "Directly" or
"Contract" and D_PA-060.1.3 = blank/not
answered
At least one value of D_PA-060a-e = "Directly" or
"Contract" and D_PA-060.1.4 = blank/not
answered
At least one value of D_PA-060a-e = "Directly" or
"Contract" and D_PA-060.1.5 = blank/not
answered
At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.1 through D_PA-030.1.7 =
" Don’t Know "
At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.1 = blank/not
answered
At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.2 = blank/not
answered
At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.3 = blank/not
answered
At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.4 = blank/not
answered

Severity
Fatal

Fatal

Fatal

Fatal

Fatal

Explanation

Fatal

Fatal

Fatal

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1142

Line Number
D_PA-030.1.5

Edit Message
Please select a response for this item.

Edit Condition
At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.5 = blank/not answered

Severity
Fatal

1143

D_PA-030.1.6

Please select a response for this item.

At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.6 = blank/not answered

Fatal

1144

D_PA-030.1.7

Please select a response for this item.

At least one value of D_PA-030a-e = "Directly" or
"Contract" and D_PA-030.1.7 = blank/not answered

Fatal

1145

D_SV-050.1

D_PA-030.1

1147

D_CI-060.1

1150

J_080

At least one value of 053a-053e = "Directly" or
"Contract" and D_SV-050.1.1 through D_SV050.1.9=”No”.
At least one value of 059a-059e = "Directly" or
"Contract" and D_PA-030.1.1 through D_PA-030.1.7 =
"No"
At least one value of D_CI-060a-e = "Directly" or
"Contract" and 0D_CI-060.1.1 through D_CI-060.1.5 =
"No".
FIOTH <
sum(FIOTH1B,FIOTH2B,FIOTH3B,FIOTH4B,FIOTH5B,FI
OT H6B,FIOTH7B,FIOTH8B,FIOTH9B,FIOTH10B)

Fatal

1146

You provide consulting services (D_SV-050a-e)
but selected No to D_SV-050.1.1 - D_SV050.1.9.
You provide literacy program support (D_PA-030ae) but selected No to D_PA-030.1.1 - D_PA030.1.7.
You apply for non-IMLS funds (D_CI-060a-e) but
you selected No to D_CI-060.1.1 - D_CI-060.1.5.

1151

J_080

FIOTH >
sum(FIOTH1B,FIOTH2B,FIOTH3B,FIOTH4B,FIOTH5B,FIO
T H6B,FIOTH7B,FIOTH8B,FIOTH9B,FIOTH10B)

Explanation

OTHER FEDERAL REVENUE (J-080) is less than the
sum of the individual other revenue sources
reported in J-080.1 - J-080.10. Please correct total
or associated details.
OTHER FEDERAL REVENUE (J-080) is greater than
the sum of the individual other revenue sources
reported in J-080.1 - J-080.10. Please correct total
or associated details. This should only occur if one
or more of the details contained in the total are
missing (-1). Please correct data or explain/verify
that data are correct.

93

Explanation

Fatal

Fatal

SLAA Survey 2020 Edit Validation Reference Guide

Edit Code
1152

1153

Line Number
J-080

B-010

Edit Message
OTHER FEDERAL REVENUE (J-080) is reported but
no individual other revenue sources reported in J080.1 - J.080-10. Please correct total or associated
details.
The executive branch is selected for branch of
government (B-010). Provide information in A or
B, as appropriate.

94

Edit Condition
* OTHER FEDERAL REVENUE (J-080) is greater than 0
but all SPECIFY PROGRAM(S) AND TITLE(S) AND
AMOUNT (J-080.1-J-080.10) is blank, or vv.
The executive branch is selected for B-010, but both
B- 20 and B-50 are blank.

Severity
Fatal


File Typeapplication/pdf
File TitleEdit Validation Reference Guide for the State Library Administrative Agency Survey FY 2018
SubjectEdit Validation, Reference Guide, State Library Administrative Agency Survey, 2018, Institute of Museum and Library Services
AuthorRTI International
File Modified2019-11-12
File Created2018-09-13

© 2024 OMB.report | Privacy Policy