KPI Export

1. KPI Export Admin Tool

   1. To access the “KPI Export” admin tool click the “Students” tab at the top of the page. Then click the “Settings” sub tab. Then select the “Administration” option.

   2. On the “Administration” page, select the tab called “KPI Export”

   3. Once there you will be able to enter the following fields that are required on the export:

      1. OrganizationID

      2. PCCID

      3. OperatingName

      4. LegalName

      5. OsapInstitutionCode

   4. Any programs that are setup as Non-Vocational will not be included in the export. This can be done from the “Programs” admin tool, in the “Schedule” section using the field called “Program Delivery”

2. Lead/Student Profile

   1. The following fields are needed in order to use this export. You need to ensure that these fields are active on your lead/student profile.

   2. Any fields that are not active will appear in the “Inactive Fields” list, and can be added to your lead/student profile in the desired location.

   3. In order to access the “Profile” tool mouseover your name on the top of the page. Then click the “School Settings” option in the dropdown. Then select the “Profiles” admin tool.

   4. Here is the list of fields that need to be active for the report to be completely automated:

      1. StudyVisa

      2. Gender

      3. LanguageSpoken

      4. AccomodationRequired

      5. OSAPFunding

      6. FundingStatus

      7. Employer

3. KPI Enrollment Export

   1. To access the “KPI Enrollment Export” click the “Students” tab, select “Settings” sub-tab, and then select the “KPI Export” admin tool

   2. Select the Campus (if applicable), Year, and Period that you would like to view the export for and click the “Submit” button

   3. You will then see a heading called “Students” with a list of all students that fall into the period you selected

   4. Below the Students” list, you will see a heading called “Grace Period”. There you will see all of the students who fell into the grade period, and who do not have to be included in the report. These students will automatically be removed from the export file. The grace period is defined “The calendar period of time during which an entrant can withdraw from a vocational program and not be considered to have started that program. The Grace Period will be defined as the lesser of 25% of program duration (i.e., one week for every month), to a maximum of eight weeks.”. CampusLogin uses your program length settings, and the students program status date, to determine which students fall into the grace period. You are able to correct any bad data and re-run your export if you feel a student should not be included in the grade period

   5. When you are ready to export your student file click the “Download Excel File” link beside the “Students” heading. This will generate the Enrollment KPI export spreadsheet in the required format

   6. This file contains the following columns/fields, here is where the data is drawn for each field:

      1. OrganizationID = This field is draw form the KPI Export Admin tool

      2. PCCID = This field is draw form the KPI Export Admin tool

      3. OperatingName = This field is draw form the KPI Export Admin tool

      4. LegalName = This field is draw form the KPI Export Admin tool

      5. OsapInstitutionCode = This field is draw form the KPI Export Admin tool

      6. StudentID = StudentNumber

      7. FamilyName = Lastname

      8. GivenName = Firstname

      9. PermAptNumber = Address2

      10. PermStreetAddress = Address1

      11. PermCity = City

      12. PermProvince = ProvinceStateID

      13. PermPostalCode = PostalZipCode

      14. PermCountry = CountryID

      15. LocalAptNumber = blank

      16. LocalStreetAddress = blank

      17. LocalCity = blank

      18. LocalProvince = blank

      19. LocalPostalCode = blank

      20. LocalCountry = blank

      21. PermPhone = Telephone

      22. LocalPhone = AdditionalPhone

      23. OtherPhone = blank

      24. CellPhone = alternatephone

      25. BirthDate = DOB

      26. StudyVisa = StudyVisa

      27. Gender = Gender

      28. LanguageSpoken = LangCode

      29. AccomodationRequired = AccomodationRequired

      30. OSAPFunding = OSAPFunding

      31. FundingStatus = FundingStatus

      32. ProgramStartYear = Student’s Start Date Year

      33. ProgramStartTerm = Based on Start Date Month

      34. ProgramStart = Student’s Start Date Month Day

      35. ApprovedProgramName = Program Name:

      36. ProgramDurationHH = Program Length (Hours):

      37. ProgramDurationWK = Program Length (Weeks):

      38. ProgramFormat = Program Type:

      39. WorkIntLearn = From Course Type xl. CampusPostalCode = PostalZipCode

          xli. ApprovedCollegeProgramName = Program Name: xlii. CollegeProgramCode = Program Code:

          xliii. CollegeDivision = blank

          xliv. CampusLocationCode = Campus City Name (from Campus admin tool) xlv. ExternalEmail = Email

          xlvi. InternalEmail = AdditionalEmail xlvii. TransferStatus = blank

          xlviii. ProgramTransferredFrom = blank

4. KPI Graduate Export

   1. To access the “KPI Graduate Export” click the “Students” tab, select “Settings” sub-tab, and then select the “KPI Export” admin tool

   2. Select the Campus (if applicable), Year, and Period that you would like to view the export for and click the “Submit” button

   3. You will then see a heading called “Graduates” with a list of all graduates that fall into the period you selected

   4. You can then export this report into excel by clicking the “Download Excel File” button beside the “Graduates” heading

   5. This file contains the following columns/fields, here is where the data is drawn for each field:

      1. OrganizationID = This field is draw form the KPI Export Admin tool

      2. PCCID = This field is draw form the KPI Export Admin tool

      3. OperatingName = This field is draw form the KPI Export Admin tool

      4. LegalName = This field is draw form the KPI Export Admin tool

      5. OsapInstitutionCode = This field is draw form the KPI Export Admin tool

      6. StudentID = StudentNumber

      7. FamilyName = Lastname

      8. GivenName = Firstname

      9. PermAptNumber = Address2

      10. PermStreetAddress = Address1

      11. PermCity = City

      12. PermProvince = ProvinceStateID

      13. PermPostalCode = PostalZipCode

      14. PermCountry = CountryID

      15. LocalAptNumber = blank

      16. LocalStreetAddress = blank

      17. LocalCity = blank

      18. LocalProvince = blank

      19. LocalPostalCode = blank

      20. LocalCountry = blank

      21. PermPhone = Telephone

      22. LocalPhone = AdditionalPhone

      23. OtherPhone = blank

      24. CellPhone = alternatephone

      25. BirthDate = DOB

      26. StudyVisa = StudyVisa

      27. Gender = Gender

      28. LanguageSpoken = LangCode

      29. AccomodationRequired = AccomodationRequired

      30. OSAPFunding = OSAPFunding

      31. FundingStatus = FundingStatus

      32. GraduationYear = Program Status Date Year

      33. GraduationTerm = Based on Program Status Date Month

      34. GraduationMMDD = Program Status Date Month Day

      35. ExternalEmail = Email

      36. InternalEmail = AdditionalEmail

      37. EmployerOrganizationName = Employer Associated to Alumni Company Name

      38. EmployerSuiteNumber = Employer Associated to Alumni Company Address 2

      39. EmployerStreetAddress = Employer Associated to Alumni Company Address 1 xl. EmployerCity = Employer Associated to Alumni Company City

xli. EmployerProvince = Employer Associated to Alumni Company ProvinceStateID xlii. EmployerPostalCode = Employer Associated to Alumni Company PostalZipCode xliii. EmployerCountry = Employer Associated to Alumni Company CountryName xliv. SupervisorFamilyName = Contact Associated to Employer/Alumni Last Name xlv. SupervisorGivenName = Contact Associated to Employer/Alumni First Name xlvi. SupervisorTitle = Contact Associated to Employer/Alumni Title

xlvii. SupervisorPhoneNumber = Contact Associated to Employer/Alumni Telephone xlviii. SupervisorPhoneExt = Contact Associated to Employer/Alumni Telephone Ext. xlix. ApprovedProgramName = Program Name: