This article provides background information regarding the student job counts that appear on the "Student Jobs by Department" page on the website:
https://www.cedarville.edu/cf/finaid/studentjobs.cfm
Based on disabled code remaining (without comments) in the source program file, it appears the primary logic used in presenting these counts was revised at some point prior to July 2014. The current state of the process focuses primarily on the Display On Web field, and on the Fall-Spring Openings and Summer Openings fields, which are in the Jobs file within the MS SQL Server database (i.e. CED_Misc.dbo.StudentEmploymentJobs). Two other fields in this file, Number Of Openings and Number Hired, appear to be largely deprecated at this time.
Job counts are processed only for records having the Display On Web field set to 1 (true). Other jobs that may be present for a department are ignored in this process. For each job, the count for Number Offered is captured from the Fall-Spring Openings or the Summer Openings field in the job record, depending on the term specified by the viewer of the page. Note that these are static numbers for each job, as maintained by the hiring supervisor for the department (in the Student Employment Administrative System (SEAS), at https://www.cedarville.edu/cf/finaid/admin/jobslist.cfm), so they do not vary from year to year: the same number will be obtained as a starting point, for example, whether the page viewer selects Summer 2018 or Summer 2019 from the dropdown list.
Then the number of students assigned to the job, in the Hired Students file, are counted based on the term specified by the page viewer. All hiring records with no termination date are counted, so these may be records with several different status settings, including "Payroll" (hiring completed), "New Hire" (pending processing by the Payroll Office, and "No Authorization" (typically assigned to records that have an issue needing to be addressed). In cases where the count of students hired at a position exceeds the current value for number offered, according to the Jobs file record, the value in the Jobs file is ignored, and number offered and number hired for that job are both set to this hired count. The number offered and number hired are each added to a corresponding total count for the department. When all counts for the department are accumulated, the total available is shown on the page as the difference between total offered and total hired.
Note: Evidently it is possible to hire a student for a particular department while using a job/position that "belongs" to another department. In practice, this has not caused problems; however, the practice can occasionally negatively affect the output seen on the Student Jobs page. If the number of jobs count for a department is not at all close to being accurate (i.e. way too high), check the hired students records in the Student Employment database, and update, as necessary (in SQL Server or in Easy Query), the department IDs that do not match the department ID in the job/position record.