Fields are placeholders for data in the database. Within Advanced Find, fields are grouped by field categories. Field names also include the field’s category name. For instance, a facility’s name is stored in the Facility.Name field (field category = Facility and field = Name). A patron’s last name is stored in the Patron.Last Name field (field category = Patron and field = Last Name).
The following tables lists the categories and fields found in patron Advanced Find.
Field Category |
Description |
Contact Mgt |
Use the fields in this category to select patrons based on contact management information. |
Contract |
Use the fields in this category to select patrons using contract-specific attributes such as contract start and end dates, charge code, and deposit code. |
Emergency Contact |
Use the fields in this category to select patrons using their emergency contact information. |
Facility |
Use the fields in this category to select patrons using core and site-defined facility attributes for a patron's assigned facility. Only attributes that are set to Show in the Setup module are displayed. See the FacilityAll category for more options. It is not possible to combine fields from the Facility and FacilityAll categories in a search. Special Field: Facility.Open_Spaces_Roommate - Returns the number of open spaces for a facility based on the facility’s Roommate_Level facility. |
Facility Address |
Use the fields in this category to retrieve the address information for a patron's assigned facility. This may be useful when finding or exporting information for assignment letters. |
Facility All |
Use the fields in this category instead of those in the Facility category to build a logical OR search. For example, a user can find patrons assigned to a facility or that have a particular attribute value. It is not possible to combine fields from the FacilityAll and Facility categories in your search. Special Field: Facility.Open_Spaces_Roommate - Returns the number of open spaces for a facility based on the facility’s Roommate_Level facility. |
Facility Parent |
Use the fields in this category to select facility types above where the patron is assigned. Using this category also allows users to select multiple patron-assigned facilities in your find. |
Family |
Use the fields in this category to find Odyssey family members or hosts. Special Fields: Family.Age_Relative - Returns the computed age of a family member calculated by subtracting the family member’s birth date from the display date. |
FT Account |
Use the fields in this category to select patrons based on their financial transaction accounts. |
FT Journal |
Use the fields in this category to retrieve patrons based on financial transaction detail. |
Judicial Incident |
Use the fields in this category to find judicial incidents. |
Judicial Patron Incident |
Use the fields in this category to find patrons by their incident details. Special Field: JudicialPatronIncident.Has_Incident - Use this Yes/No field to find patrons who have incidents. Special Field: JudicialPatronIncident.Has_Sanction - Use this Yes/No field to find patrons who have sanctions. Special Field: JudicialPatronIncident.Has_Violation - Use this Yes/No field to find patrons who have violations. |
Judicial Patron Incident Event |
Use the fields in this category to find patrons by the events associated with their judicial incident. |
Judicial Patron Sanction |
Use the fields in this category to find patrons with judicial sanctions. |
Judicial Patron Violation |
Use the fields in this category to find patrons with judicial violations. |
Patron |
Use the fields in this category to select patrons by core and site-defined patron attributes. Only attributes that are set to Show in the Setup module are displayed. Special Field: Patron.Age_Relative - Returns the computed age of a patron calculated by subtracting the patron’s birth date from the display date. Special Field: Patron.Assigned - Use this field to find patrons who are either assigned or not assigned using the field’s Yes/No value. Special Field: Patron.PCS_Plan_ID and Patron.PCS_Plan_Name - These fields are only relevant if Odyssey PCS is also installed. If so, using these fields will allow users to find patrons who are assigned to particular PCS meal plans. |
Patron Access List |
Use the fields in this category to select patrons by their access to MyResCenter Web’s room selection function. |
Patron Address |
Use the fields in this category to select patrons by their address types. |
Patron Application |
Use the fields in this category to select patrons by their application types. |
Patron Attachments |
Use the fields in this category to select patrons by their profile attachments information. |
Patron Note |
Use the fields in this category to select patrons using patron note fields such as note date and type. |
Preference |
Use the fields in this category to select patrons by their preferences. |
Proxy/Agent Activity |
Use the fields in this category to select patrons by their general proxy or agent activity. |
Proxy/Agent Activity Application |
Use the fields in this category to select patrons by their proxy or agent activity related to applications. |
Proxy/Agent Activity Contract |
Use the fields in this category to select patrons by their general proxy or agent activity related to contracts. |
Proxy/ Designation |
Use the fields in this category to select patrons by their proxy designation information. |
RCFamily |
Use the fields in this category to find ResCenter family members or hosts. |
Roommate |
Use the fields in this category to select patrons based on their roommate's information including the roommate's name and address. |
Suitemate |
Use the fields in this category to find suitemates. |
Term |
Use the fields in this category to select patrons by the term name. |
WaitingList |
Use the fields in this category to find patrons who are on a waiting list. |