Global Site Navigation (use tab and down arrow)

NB-IRDT

CAFÉ Data

Holding Name: CAFÉ Data
Year(s): 1987-2022
Dataset Number: PTL06
Data Provider: Post-Secondary Education, Training and Labour
Category(s): Labour

Data Description

The CAFÉ database is used to track information on student financial assistance applications. The eight program data files for CAFÉ contain information on a student’s application, any assistance (may be referred to as awards in the data files) they receive, as well as applicable information from dependents, parents, and spouses.

  • The CAFÉ_student_table table contains a record for each student applicant with their demographic and high school info.
  • The CAFÉ_application_table table contains records for each application of each applicant and lists their application info.
  • The CAFÉ_NAR_Awards table contains a record for each award and for each modification to an award record. It gives details on the financial assistance awarded to students, as well as additional records which detail how a final award amount was calculated.
  • The CAFÉ_dependents table contains demographic information for dependents of applicants, when the applicant has one or more dependents.
  • The CAFÉ_parent_table contains demographic information for parents of applicants, when the applicant is a dependent.
  • The CAFÉ_parent_application contains mainly income information from applicable parents for each application.
  • The CAFÉ_spouse_table table contains demographic information for spouse/common-law partner of applicants, where the applicant has a spouse/common-law partner. 
  • The CAFÉ_spouse_application table contains mainly income information from applicable spouses for each application.