Days Closed Table (Admin>Parameters>Circulation - Sierra)

Owned by Tammy Poquette, created
Last updated: Apr 15, 2024
3 min read

This documentation explains the functionality and data elements of the Days Closed table.

Table of Contents

Days Closed Table Overview

You can contact the Marmot Help Desk for help if you cannot view this table.

View the Days Closed Table by going to Admin, Parameters, Circulation, and Days Closed in Sierra

The Days Closed table specifies the days of the week or year when your library is closed, or when a specific library branch or location is closed. Unless you specify a date and location in the Days Closed table, the system assumes that the location is open on that day.

Sierra uses the Days Closed table in the following ways:

  • The system prevents items from falling due on days the library is closed.

  • The system excludes closed days when calculating the number of days an item can remain on the hold shelf. For more information, see Managing Holds.

Functionality Information

When viewing the Days Closed table, note the following:

  • Calendar Limited to 365 Days Before or After the Current Date

    • The system retains a one-year calendar of closed days. The system cannot determine whether a given date is a closed day if it falls more than 365 days before or after the current date.

      • For example, you can specify that a location is closed every Sunday or on July 4th of every year, but you cannot indicate that a branch is closed on January 16, 2024 but not January 16, 2025.

  • Updating the Days Closed Table

    • If your library has non-standard circulation policies regarding closed days, you might need to have the Marmot staff change the Days Closed table (and possibly also the Hours Open table) to obtain the results you want.

      • For example, if your library's Music Library is open Monday through Saturday, but you want to allow patrons who check out items on Friday night to keep those items until Monday morning, you must add an entry indicating that the Music Library is closed on Saturday. The Days Closed table does not control when you can check material out and in; the table only determines the due dates of items and the fine schedule.

Marmot maintains the table for the entire consortium. Your Days Closed contacts will be sent information on how to submit the Days Closed for your library.

Data Elements Days Closed

Entries in the Days Closed table contain the following data elements:

Element

Description

Element

Description

Location

The library branch or location that is closed.

Possible values are:

  • a location from the Branches table

  • a wildcard code of five question marks (?????) to represent all locations

  • a partial location code followed by an asterisk (for example ai* to represent any location code that starts with "ai")

Day Closed

The day of the week or year that the location is closed. Possible values are a calendar date or a day of the week.

Calendar dates will be entered into the MM/DD format.

If you library is closed the same days each week, they will be entered in the following three-character codes in lowercase: mon tue wed thu fri sat sun

Data Elements Hours Open

Entries in the Hours Open table contain the following data elements:

Element

Description

Element

Description

Location

The library branch or location to which the entry pertains. Possible values are a location from the Branches table, a wildcard code ????? (exactly five question marks) to represent all locations, or a partial location code followed by an asterisk (for example, mpm* to represent any location code that starts with "mpm").

Day

The day of the week or year that the location is closed. Possible values are a calendar date, a day of the week, or a wildcard code to signify every day.

Calendar dates must be in MM/DD or DD/MM format, depending on the date format used by your system. The month and day may be one or two digits each and may be separated by a slash '/' or a hyphen '-'. For example, an entry could appear as 02/23 or 02-23.

Days of the week must be one of the following three-character codes in UPPERCASE or lowercase: mon tue wed thu fri sat sun

The wildcard code must be entered as ??? (exactly three question marks).

Open

The time the location opens, expressed in 24-hour "military" time (e.g., 0800 = 8:00 A.M.). Enter '0' for locations that are open 24 hours per day.

Closed

The time the location closes, expressed in 24-hour "military" time (e.g., 2000 = 8:00 P.M.). Enter "2400" for locations that are open 24 hours per day. If the location closes after midnight (e.g., 1:00 A.M.), indicate this as the time plus 2400. The maximum time you can specify is 2800 (i.e., 4:00 A.M. the following day).

Top of page