FY 2023 PLS Import Specs_Final.xlsx
XLSX spreadsheet 37 KB Posted
- Solicitation number
- RFP 24-09
- Issued by
- Adams County, Asotin County, Benton County, Chelan County, Clallam County, Clark County, Columbia County, Cowlitz County, Douglas County, Ferry County, Franklin County, Garfield County, Grant County, Grays Harbor County, Island County, Jefferson County, King County, Kitsap County, Kittitas County, Klickitat County, Lewis County, Lincoln County, Mason County, Okanogan County, Pacific County, Pend Oreille County, Pierce County, San Juan County, Skagit County, Skamania County, Snohomish County, Spokane County, Stevens County, Thurston County, Wahkiakum County, Walla Walla County, Whatcom County, Whitman County, Yakima County, Asotin City, Clarkston City, Clarkston Heights-Vineland CDP, West Clarkston-Highland CDP, Benton City, Chelan City, Chelan Falls CDP, Clallam Bay CDP, Lewisville CDP, Rock Island City, Pacific Beach CDP, Whidbey Island Station CDP, Mercer Island City, Pacific City, Bainbridge Island City, Kingston CDP, Kitsap Lake CDP, Kittitas City, Klickitat CDP, Okanogan City, Anderson Island CDP, Fort Lewis CDP, Fox Island CDP, Herron Island CDP, Ketron Island CDP, North Fort Lewis CDP, Raft Island CDP, Stevenson City, Hat Island CDP, Lake Stevens City, Snohomish City, Spokane City, Spokane Valley City, Puget Island CDP, Garfield Town, Yakima City, Washington
About this file
This document contains the file specifications for the FY 2023 Public Libraries Survey (PLS) data collection instrument used by the Washington State Library to collect annual survey data from public libraries across the state. The PLS data collection usually runs from November to June each year and covers over 50 jurisdictions in Washington including counties, cities, and census-designated places. The state is seeking proposals for an online, Software as a Service (SaaS) solution to facilitate the survey preparation, collection, cleaning, and final submission process.
The pricing terms, funding requirements, and other commercial details of the contract opportunity are not provided in this technical specification document. However, the large number of jurisdictions involved across the state suggests this is a significant statewide contract for public library data collection services.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Sample Contract Main Section.pdf | ||
| FY 2023 PLS Users Guide_508C.pdf | ||
| RFP 24-09 - Amendment No. 2.pdf | ||
| Sample Contract Exhibit C Debarment.pdf | ||
| PLS FY 2023 Import and Edit File Memo_Final.pdf | ||
| RFP 24-09 Final.pdf | ||
| Sample Contract Exhibit A GT@C.pdf | ||
| WAPublicLibrariesSurveyRFP_Appendix(Demo).docx | DOCX document | |
| Exhibit D_Trafficking.pdf | ||
| FY 2023 PLS Edit Check Changes_Final.xlsx | XLSX spreadsheet | |
| RFP 24-09 - Amendment No. 1.docx | DOCX document | |
| Sample Contract Exhibit B SOW.pdf |
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Admin entity
| Administrative Entity Import File Specifications | ||||||
| Variable Name | Data Element Name | Width | ASCII Position | Excel / .csv Column | Type/ Decimals | Item Number |
| FSCSKEY | IMLS Identification number | 6 | 1 | A | Character | 150 |
| STATSTRU | Status of AE record current to prior year | 2 | 7 | B | Character | 150a |
| STATNAME | Status of LIBNAME current to prior year | 2 | 9 | C | Character | 152a |
| STATADDR | Status of ADDRESS current to prior year | 2 | 11 | D | Character | 153a |
| LINKID | User Defined, used to link two or more AE together. | 20 | 13 | E | Character | |
| OLDID | Old FSCSKEY | 6 | 33 | F | Character | |
| LIBID | State assigned identification number MUST BE UNIQUE | 20 | 39 | G | Character | 151 |
| LIBNAME | Legal Name | 60 | 59 | H | Character | 152 |
| ADDRESS | Physical Street Address | 35 | 119 | I | Character | 153 |
| CITY | City | 20 | 154 | J | Character | 154 |
| ZIP | ZIP Code | 5 | 174 | K | Character | 155 |
| ADDRES_M | Mailing Address | 35 | 179 | L | Character | 157 |
| CITY_M | Mailing City | 20 | 214 | M | Character | 158 |
| ZIP_M | Mailing Zip Code | 5 | 234 | N | Character | 159 |
| CNTY | County | 20 | 239 | O | Character | 161 |
| PHONE | Phone | 10 | 259 | P | Character | 162 |
| C_RELATN | Interlibrary Relationship Code | 2 | 269 | Q | Character | 200 |
| C_LEGBAS | Legal Basis Code | 2 | 271 | R | Character | 201 |
| C_ADMIN | Administrative Structure Code | 2 | 273 | S | Character | 202 |
| C_FSCS | FSCS Public Library Definition | 1 | 275 | T | Character | 203 |
| GEOCODE | Geographic Code | 3 | 276 | U | Character | 204 |
| LSABOUND | Legal Service Area Boundary Change | 1 | 279 | V | Character | 205 |
| STARTDAT | Reporting Period Start Date (mm/dd/yyyy) | 10 | 280 | W | Character | 206 |
| ENDDATE | Reporting Period End Date (mm/dd/yyyy) | 10 | 290 | X | Character | 207 |
| POPU_LSA | Population of the Legal Service Area | 9 | 300 | Y | Numeric/0 | 208 |
| CENTLIB | Number of Central Libraries | 3 | 309 | Z | Numeric/0 | 209 |
| BRANLIB | Number of Branch Libraries | 3 | 312 | AA | Numeric/0 | 210 |
| BKMOB | Number of Bookmobiles | 3 | 315 | AB | Numeric/0 | 211 |
| MASTER | ALA-MLS | 9 | 318 | AC | Numeric/2 | 250 |
| LIBRARIA | Total Librarians | 9 | 327 | AD | Numeric/2 | 251 |
| OTHPAID | All Other Paid Employees | 9 | 336 | AE | Numeric/2 | 252 |
| TOTSTAFF | Total Paid Employees | 10 | 345 | AF | Numeric/2 | 253 |
| LOCGVT | Local Government Revenue | 9 | 355 | AG | Numeric/0 | 300 |
| STGVT | State Government Revenue | 9 | 364 | AH | Numeric/0 | 301 |
| FEDGVT | Federal Government Revenue | 9 | 373 | AI | Numeric/0 | 302 |
| OTHINCM | Other Operating Revenue | 9 | 382 | AJ | Numeric/0 | 303 |
| TOTINCM | Total Operating Revenue | 10 | 391 | AK | Numeric/0 | 304 |
| SALARIES | Salaries & Wages Expenditures | 9 | 401 | AL | Numeric/0 | 350 |
| BENEFIT | Employee Benefits Expenditures | 9 | 410 | AM | Numeric/0 | 351 |
| STAFFEXP | Total Staff Expenditures | 9 | 419 | AN | Numeric/0 | 352 |
| PRMATEXP | Print Materials Expenditures | 9 | 428 | AO | Numeric/0 | 353 |
| ELMATEXP | Electronic Materials Expenditures | 9 | 437 | AP | Numeric/0 | 354 |
| OTHMATEX | Other Materials Expenditures | 9 | 446 | AQ | Numeric/0 | 355 |
| TOTEXPCO | Total Collection Expenditures | 9 | 455 | AR | Numeric/0 | 356 |
| OTHOPEXP | Other Operating Expenditures | 9 | 464 | AS | Numeric/0 | 357 |
| TOTOPEXP | Total Operating Expenditures | 10 | 473 | AT | Numeric/0 | 358 |
| LCAP_REV | Local Government Capital Revenue | 9 | 483 | AU | Numeric/0 | 400 |
| SCAP_REV | State Government Capital Revenue | 9 | 492 | AV | Numeric/0 | 401 |
| FCAP_REV | Federal Government Capital Revenue | 9 | 501 | AW | Numeric/0 | 402 |
| OCAP_REV | Other Capital Revenue | 9 | 510 | AX | Numeric/0 | 403 |
| CAP_REV | Total Capital Revenue | 9 | 519 | AY | Numeric/0 | 404 |
| CAPITAL | Total Capital Expenditures | 9 | 528 | AZ | Numeric/0 | 405 |
| BKVOL | Print Materials | 9 | 537 | BA | Numeric/0 | 450 |
| EBOOK | Electronic Books | 9 | 546 | BB | Numeric/0 | 451 |
| AUDIO_PH | Audio - Physical Units | 9 | 555 | BC | Numeric/0 | 452 |
| AUDIO_DL | Audio - Downloadable Units | 9 | 564 | BD | Numeric/0 | 453 |
| VIDEO_PH | Video - Physical Units | 9 | 573 | BE | Numeric/0 | 454 |
| VIDEO_DL | Video - Downloadable Units | 9 | 582 | BF | Numeric/0 | 455 |
| EC_LO_OT | Local/Other Cooperative Agreements | 9 | 591 | BG | Numeric/0 | 456 |
| EC_ST | State (state government or state library) | 9 | 600 | BH | Numeric/0 | 457 |
| ELECCOLL | Total Electronic Collections | 9 | 609 | BI | Numeric/0 | 458 |
| TOTPHYS | Total Physical Items in Collection | 9 | 618 | BJ | Numeric/0 | 461 |
| OTHPHYS | Other Circulating Physical Items | 9 | 627 | BK | Numeric/0 | 462 |
| VISITS | Library Visits | 9 | 636 | BL | Numeric/0 | 501 |
| VISITRPT | Library Visits Reporting Method | 2 | 645 | BM | Character | 501a |
| REFERENC | Reference Transactions | 9 | 647 | BN | Numeric/0 | 502 |
| REFERRPT | Reference Transactions Reporting Method | 2 | 656 | BO | Character | 502a |
| REGBOR | Number of Registered Users | 9 | 658 | BP | Numeric/0 | 503 |
| ODFINE | Overdue Fine Policy | 1 | 667 | BQ | Character | 504 |
| C19CLOSE | Closed Outlets Due to COVID-19 | 1 | 668 | BR | Character | 510 |
| C19PUBSV | Public Services During COVID-19 | 1 | 669 | BS | Character | 511 |
| C19ECRD2 | Electronic Library Cards Issued During COVID-19 | 1 | 670 | BT | Character | 514 |
| C19REFER | Reference Service During COVID-19 | 1 | 671 | BU | Character | 515 |
| C19OUTSD | Outside Service During COVID-19 | 1 | 672 | BV | Character | 516 |
| C19XWIF2 | External WiFi Access Added During COVID-19 | 1 | 673 | BW | Character | 520 |
| C19XWIF3 | External WiFi Access Increased During COVID-19 | 1 | 674 | BX | Character | 521 |
| C19STOTH | Staff Re-Assigned During COVID-19 | 1 | 675 | BY | Character | 522 |
| TOTCIR | Total Circulation of Materials | 9 | 668 | BR | Numeric/0 | 550 |
| KIDCIRCL | Circulation of Children's Materials | 9 | 677 | BS | Numeric/0 | 551 |
| ELMATCIR | Use of Electronic Material | 9 | 686 | BT | Numeric/0 | 552 |
| PHYSCIR | Physical Item Circulation | 9 | 695 | BU | Numeric/0 | 553 |
| ELINFO | Successful Retrieval of Electronic Information | 9 | 704 | BV | Numeric/0 | 554 |
| ELCONT | Electronic Content Use | 10 | 713 | BW | Numeric/0 | 555 |
| TOTCOLL | Total Collection Use | 10 | 723 | BX | Numeric/0 | 556 |
| OTHPHCIR | Circulation of Other Physical Items | 9 | 733 | BY | Numeric/0 | 561 |
| LOANTO | Interlibrary Loans Provided To | 9 | 742 | BZ | Numeric/0 | 575 |
| LOANFM | Interlibrary Loans Received From | 9 | 751 | CA | Numeric/0 | 576 |
| TOTPRO | Total Number of Synchronous Program Sessions | 9 | 760 | CB | Numeric/0 | 600 |
| K0_5PRO | Number of Synchronous Program Sessions Targeted at Children Ages 0-5 | 9 | 769 | CC | Numeric/0 | 601 |
| K6_11PRO | Number of Synchronous Program Sessions Targeted at Children Ages 6-11 | 9 | 778 | CD | Numeric/0 | 602 |
| YAPRO | Number of Synchronous Program Sessions Targeted at Young Adults Ages 12-18 | 9 | 787 | CE | Numeric/0 | 603 |
| ADULTPRO | Number of Synchronous Program Sessions Targeted at Adults Age 19 or Older | 9 | 796 | CF | Numeric/0 | 604 |
| GENPRO | Number of Synchronous General Interest Program Sessions | 9 | 805 | CG | Numeric/0 | 605 |
| ONPRO | Number of Synchronous In-Person Onsite Program Sessions | 9 | 814 | CH | Numeric/0 | 606 |
| OFFPRO | Number of Synchronous In-Person Offsite Program Sessions | 9 | 823 | CI | Numeric/0 | 607 |
| VIRPRO | Number of Synchronous Virtual Program Sessions | 9 | 832 | CJ | Numeric/0 | 608 |
| TOTATTEN | Total Attendance at Synchronous Programs | 9 | 841 | CK | Numeric/0 | 610 |
| K0_5ATTEN | Attendance at Synchronous Programs Targeted at Children Ages 0-5 | 9 | 850 | CL | Numeric/0 | 611 |
| K6_11ATTEN | Attendance at Synchronous Programs Targeted at Children Ages 6-11 | 9 | 859 | CM | Numeric/0 | 612 |
| YAATTEN | Attendance at Synchronous Programs Targeted at Young Adults Ages 12-18 | 9 | 868 | CN | Numeric/0 | 613 |
| ADULTATTEN | Attendance at Synchronous Programs Targeted at Adults Age 19 or Older | 9 | 877 | CO | Numeric/0 | 614 |
| GENATTEN | Attendance at Synchronous General Interest Programs | 9 | 886 | CP | Numeric/0 | 615 |
| ONATTEN | Synchronous In-Person Onsite Program Attendance | 9 | 895 | CQ | Numeric/0 | 616 |
| OFFATTEN | Synchronous In-Person Offsite Program Attendance | 9 | 904 | CR | Numeric/0 | 617 |
| VIRATTEN | Synchronous Virtual Program Attendance | 9 | 913 | CS | Numeric/0 | 618 |
| TOTPRES | Total Number of Asynchronous Program Presentations | 9 | 922 | CT | Numeric/0 | 620 |
| TOTVIEWS | Total Views of Asynchronous Program Presentations within 30 Days | 9 | 931 | CU | Numeric/0 | 630 |
| GPTERMS | Number of Internet Computers Used by General Public | 6 | 940 | CV | Numeric/0 | 650 |
| PITUSR | Number of Uses (Sessions) of Public Internet Computers Per Year | 9 | 946 | CW | Numeric/0 | 651 |
| PITUSRRPT | Reporting Method for Number of Uses of Public Internet Computers Per Year | 2 | 955 | CX | Character | 651a |
| WIFISESS | Wireless Sessions | 10 | 957 | CY | Numeric/0 | 652 |
| WIFISRPT | Reporting Method for Wireless Sessions | 2 | 967 | CZ | Character | 652a |
| WEBVISIT | Website Visits | 10 | 969 | DA | Numeric/0 | 653 |
Outlet
| Outlet Import File Specifications | ||||||
| Variable Name | Data Element Name | Width | ASCII Position | Excel / .csv Column | Type/ Decimals | Item Number |
| FSCSKEY | IMLS assigned identification number | 6 | 1 | A | Character | 700 |
| FSCS_SEQ | IMLS assigned identification number suffix | 3 | 7 | B | Character | 700 |
| STATSTRU | Status of Outlet record current to prior year | 2 | 10 | C | Character | 700a |
| STATNAME | Status of LIBNAME current to prior year | 2 | 12 | D | Character | 702a |
| STATADDR | Status of ADDRESS current to prior year | 2 | 14 | E | Character | 703a |
| LINKID | User Defined, used to link two or more outlets together | 20 | 16 | F | Character | |
| PARENTID | LIBID of parent AE | 20 | 36 | G | Character | |
| OLDID | Old FSCSKEY – FSCS_SEQ | 10 | 56 | H | Character | |
| LIBID | State assigned identification number | 20 | 66 | I | Character | 701 |
| LIBNAME | Legal Name | 60 | 86 | J | Character | 702 |
| ADDRESS | Physical Street Address | 35 | 146 | K | Character | 703 |
| CITY | City | 20 | 181 | L | Character | 704 |
| ZIP | ZIP Code | 5 | 201 | M | Character | 705 |
| CNTY | County of the Outlet | 20 | 206 | N | Character | 707 |
| PHONE | Phone | 10 | 226 | O | Character | 708 |
| C_ OUT_TY | Outlet Type Code | 2 | 236 | P | Character | 709 |
| SQ_FEET | Square Footage of Outlet | 8 | 238 | Q | Numeric/0 | 711 |
| L_NUM_BM | Number of Bookmobiles in the Bookmobile Outlet Record | 2 | 246 | R | Numeric/0 | 712 |
| HOURS | Public Service Hours Per Year (actual hours) | 4 | 248 | S | Numeric/0 | 713 |
| WKS_OPEN | Number of Weeks Open (actual weeks) | 2 | 252 | T | Numeric/0 | 714 |
| C19WKSCL | Number of Weeks an Outlet Closed Due to COVID-19 | 2 | 254 | U | Numeric/0 | 715 |
| C19WKSLO | Number of Weeks an Outlet Had Limited Occupancy Due to COVID-19 | 2 | 256 | V | Numeric/0 | 716 |
Annotation
| Annotation Import File Specifications | |||||
| Column | Description | Width | ASCII Position | Excel / .csv Column | Type |
| RECORD TYPE | Must always be 'ANNO' | 4 | 1 | A | Text |
| FSCSKEY-FSCS_SEQ | IMLS assigned identification number with suffix for outlets | 10 | 5 | B | Text |
| EDITID | Edit number | 5 | 15 | C | Text |
| COMMENT | Respondent annotation | Max | 20 | D | Text |
File details come from the government source that posted it. Updated .