Columns in the Student Profile Report

Columns in the Student Profile Report#

The student profile report includes a row for each enrolled learner or course team member and the following columns.

Column	Description
id	The user account ID number that the system assigns to each registrant.
username	The public username entered by the learner. Usernames are required and cannot be changed.
name	The full name entered by the learner. A name is required. Learners can update this value on the Account Settings page.
email	The email address entered by the learner. An email address is required. Learners can update this value on the Account Settings page.
language	This column is included for backward compatibility only. This data is no longer collected during account creation. The selection that a learner makes for language on the Account Settings page is not included in this report.
location	This column is included for backward compatibility only. The selection that a learner makes for Country during registration or for Country or Region on the Account Settings page is displayed in the “country” column of this report.
year_of_birth	This value is optional and can be updated on the Account Settings page.
gender	This value is optional and can be updated on the Account Settings page.
level_of_education	This value is optional and can be updated on the Account Settings page. For a list of the possible values, see the description of the auth_userprofile table’s level_of_education column in the EdX Research Guide.
mailing_address	No longer collected during registration. Previously, this value was optional and was supplied only at registration.
goals	This value is optional and is supplied only at registration.
enrollment_mode	Indicates the enrollment track that the learner is enrolled in, such as “audit” or “verified”.
verification_status	Indicates whether learners who are enrolled in course tracks that require ID verification have successfully verified their identities to edX by submitting an official photo ID via webcam. The value in this column is “N/A” for learners enrolled in course tracks that do not require ID verification. A value of “Not ID Verified” in this column indicates that the learner is enrolled in a course track that requires ID verification (such as “verified”) but she has not attempted ID verification, or the ID verification has failed or expired. A value of “ID Verified” indicates that the learner is enrolled in a course track that requires ID verification, and her ID verification is current and valid.
cohort	This column is included only if the course has cohorts enabled. For courses that include learner cohorts, shows the name of the cohort group that is assigned to the learner. If a learner is not assigned to a cohort, the value is `[unassigned]`.
team	This column is included only if the course has teams enabled. For courses that include teams, shows the name of the team that the learner belongs to. If a learner has not joined a team, the value is `[unavailable]`.
city	Data for this column is not currently collected on edx.org.
country	Learners are required to specify Country during registration, and can update this value on the Account Settings page.