Knowledgebase:
Student Meal Plans
Posted by David Hui on 08/07/2020 6:30 PM

At the start of each semester, we pull a list of student information from PowerCampus and give to Pioneer Caterers.

The SQL confirms the student's academic status and residency information. Meal plan information is based off the student's residency package.

 

SQL: \\fs2\DATA\Technology Services\SQL Scripts\Curt\Pioneer Caterers

 

Residents:

Meal Plan Data - 2018.sql

  • Update academic year and term.
  • Run script
  • Save results in an CSV to  K:\Pioneer\MEAL TICKET LOG\2016\Fall 2016-X from TS.csv
    • "X" denotes the amount of times this list has been pulled. For first pull X = 1.
  • Send a copy to Scott DeLair -- currently the imap computer needs a local admin account to run the program. He cannot access the network drive from the imap local admin.

 

Commuters:

Commuter Debit Card Data - 2018.sql

  • Update academic year and term.
  • Run script
  • Save results in an CSV to  K:\Pioneer\MEAL TICKET LOG\2016\Fall 2016-X Commuters from TS.csv
    • "X" denotes the amount of times this list has been pulled. For first pull X = 1.
  • Send a copy to Scott DeLair -- currently the imap computer needs a local admin account to run the program. He cannot access the network drive from the imap local admin.

 

$25.00 for students:

Meal Plan E - Bar Codes 2019.sql

  • Includes student barcodes instead of card number
  • Add "25" to CashBal field after export
  • Make sure barcode field holds text instead of shortening the string.
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: