PCS Export

Modified on Thu, Jun 29, 2023 at 10:03 AM

PCS Export

Overview

This export will create two comma-seperated values files (.csv). The included files are students.csv and staff.csv.

Options

Transmission and School Selection Options
  • The files can be saved to a path on the local machine, sent as an email attachment, or sent out via FTP (active, passive, or secure FTP).
  • When saved locally or saved as an email attachment the files will first be zipped (and given the name PCSLunch.zip).
  • When sent via FTP, the files will not be zipped.
  • Schools can be selected by checking the box next to their names.
General Options

Option 

Notes 

Remove headers from output file

 

Use homeroom description instead of homeroom number

 

Output

staff.csv

Column 

Notes 

STAFF_ID

 

LAST_NAME

 

FIRST_NAME

 

SCHOOL_CODE

 

students.csv

Column 

Examples 

Notes 

STUDENT_ID

 

 

LAST_NAME

 

 

FIRST_NAME

 

 

GRADE

 

 

SCHOOL_CODE

 

 

MIDDLE_INITIAL

 

 

SSN

 

 

ELIGIBILITY_CODE

 

 

HOMEROOM

 

 

HOMEROOM_SECTION

 

 

BIRTH_MONTH

 

 

BIRTH_DAY

 

 

BIRTH_YEAR

 

 

ETHNICITY

 

 

SEX

 

 

FOSTER

 

 

STREET_ADDRESS

 

 

APT

 

 

CITY

 

 

STATE

 

 

ZIP

 

 

ZIP2

 

 

HOME_PHONE_NUMBER

 

 

WORK_NUMBER

 

 

WORK_EXTENSION

 

 

GUARDIAN_LAST_NAME

 

 

GUARDIAN_FIRST_NAME

 

 

GUARDIAN_MIDDLE_NAME

 

 

GUARDIAN_SSN

 

 

NOTE

 

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article