Relationship Files

Let's say that you want your Pharos 360 users to know your students' advisors, coaches, RAs, RDs, etc., and be able to implement some sort of logic based upon that knowledge. Relationship files allow us to map person-to-person connections within your site. In order to create those mappings you would send the following:

Extended_Data_Relationships_Advisors.csv

"Heading"|"Category"|"Member ID"|"Role"|"Owner ID"|"Owner Role"
"Advising"|"Math - Computer Science"|"0001010"|"Advisee"|"0002234"|"Primary Advisor"
"Advising"|"Math - Computer Science"|"0001011"|"Advisee"|"0002234"|"Primary Advisor"
"Advising"|"Math - Computer Science"|"0001012"|"Advisee"|"0002234"|"Primary Advisor"
"Advising"|"Math - Computer Science"|"0001015"|"Advisee"|"0002234"|"Primary Advisor" 
"Advising"|"Math - Computer Science"|"0001010"|"Advisee"|"0002237"|"Secondary Advisor" 
"Advising"|"Math - Computer Science"|"0001011"|"Advisee"|"0002237"|"Secondary Advisor"
...

There are a couple of things to note about the format of these files:

1. The header row should always be included. Because you send us a header row, the order of the columns does not matter. If it is more convenient to swap the order, please feel free to do so.
   
   
2. The Heading and Category are used to display groups of students to the owner (see "Groups" screenshot to the right for an example). In the example to the right, "Advising" is the Heading and "Math - Computer Science" is the Category.
   
   
3. Member ID is always the Student ID and Role is the student's role (e.g. Advisee, Athlete, etc.).
   
   
4. The Owner ID should be populated with the relationship owner's ID (employee or student ID).
   
   
5. Owner Role is the title that will display to your users (e.g. Advisor, Primary Advisor, Secondary Advisor, RA or Resident Assistant, Baseball Head Coach, Mentor, etc.). See screenshot to the right for an example.
   
   
6. The file names should all be Extended_Data_Relationships_*.csv where you can replace the * with anything you want. You may define all relationships in one file or in multiple files.

As always, if you have any questions regarding the format of these files, please contact [e-mail].

(This is an extended and customizable file.)