Previous Education and Agency/3rd Party Relationships

Previous Education and Agency/3rd Party Relationships

Relationship Type Name	Relationship Name to Account	Relationship Name to Contact	Anthology Student Properties (Data Source Columns)	CampusNexus CRM Relationship Properties	Data Type	Contact Property ID	Account Property ID
Previous Education	Students	Previous Education	CRMStudentID	ContactID	FK
			CRMHighSchoolID	AccountID	FK
			CRMCollegeID	AccountID	FK
			GraduationDate	Graduation Date	Date	6010001	6010007
			Graduated	Graduated	Text/Enum  Values->Yes/No	6010002	6010008
			LastDateAttended	Last Date Attended	Date	6010003	6010009
			GPA	GPA	Decimal (2 decimal places)	6010004	6010010
			StudentRank	Rank	Text	6010005	6010011
			SchoolSize	Rank Of	Text	6010006	6010012
			AmGradeLevelID	Grade Level	Text/Enum	6010032	6010026
			DateOfEnrollment	Date of Enrollment	Date	6010031	6010025
			TranscriptType	Transcript Type	Text	6010033	6010027
			Previous Education	Education Level	Text	6010034	6010028
			Major	Major	Text	6010035	6010029
			DegreeID	Degree	Text	6010036	6010030
Agency/3rd Party	Student Agency/3rd Party	Agency/3rd Party	CRMStudentID	ContactID	FK
			CRMAgencyBranchID	AccountID	FK
			Title	Title	Text	6010019	6010013
			Location	Location	Text	6010020	6010014
			StartDate	Start Date	Date	6010021	6010015
			EndDate	End Date	Date	6010022	6010016
			StudentFunction	Function	Text	6010023	6010017
			Comments	Comments	Text	6010024	6010018