Data File Overview

Your campus's data populates within Pharos 360 via a set of CSV files, each corresponding to a different table in our database.

General Format:

• All files are .csv
• The delimiter for all files is the pipe character (|).
• It is recommended to surround all fields with quotes (in case any outputs contain pipes).
• Data files should be encoded in UTF-8.
• The filenames should be exactly as indicated in the documentation (capitalization included). Please check individual file documentation for header row specifications.
• The following characters are allowed in header rows: #:(),0-9a-zA-Z_-/`

 

Types of Files:

Foundational Files

Foundational Data Files are required for successful authentication and basic system use. These files have set header rows and specific formatting.

• Employee_Data.csv
  • Extended_Data_Alternative_Ids.csv - This file is only required if your authentication solution does not return the same ID format as provided in your Employee_Data.csv or `Student_Data.csv` data files.
• Student_Data.csv
• Class_Information.csv
• Class_List.csv

Extended Files

• Extended_Student_Data_*.csv - Ability to display student-specific data such as Major, Classification, etc. Data is privacy rights-protected.
• Enrollment_Data_*.csv - Ability to show information associated with courses such as current grades, midterm grades, final grades, the number of absences, the last absence date per class, last LMS login, and more.
• Extended_Data_Relationships_*.csv - Ability to connect your students to their advisors, coaches, RAs, RDs, etc. Relationship files allow us to map person-to-person connections within your site.

Example files are attached here and are available on each individual article as well.