Data dictionary
The data dictionary explains each column present in the provided database.
| Order | Data | Field name | Type | Description |
|---|---|---|---|---|
| 1 | Enrollment Code | cod_matricula | Alphanumeric | Anonymized code that uniquely identifies each student enrollment. |
| 2 | Enrollment Date | dt_matricula | Datetime | Date and time when the student completed their enrollment. |
| 3 | Course Code | cod_curso | Alphanumeric | Anonymized code that identifies the course. |
| 4 | Course Name | nome_curso | Alphanumeric | Course name as registered. |
| 5 | Class/Offer Code | cod_turma | Alphanumeric | Anonymized code that uniquely identifies the class/offering of a course. |
| 6 | Class/Offer Name | nome_turma | Alphanumeric | Name of the class/offering of a course. |
| 7 | Class/Offer Modality | modalidade_turma | Alphanumeric | Modality of the class offering (Distance Learning, In-Person, Blended Learning). |
| 8 | Course Workload | carga_horaria | Numeric | Course workload. |
| 9 | Enrollment Start Date | dt_inicio_insc | Date | Start date of the enrollment period. |
| 10 | Enrollment End Date | dt_fim_insc | Date | End date of the enrollment period. |
| 11 | Classes Start Date | dt_inicio | Datetime | Start date of the course for the student. |
| 12 | Classes End Date | dt_fim | Datetime | End date of the course for the student. |
| 13 | Course Author | conteudista | Alphanumeric | Course author who developed the course. |
| 14 | Course Theme | tematica | Alphanumeric | Course theme. |
| 15 | Student's Enrollment Status | sit_matricula | Alphanumeric |
Completed = successfully finished the course; Not Completed = is still taking the course; Withdrawn = did not finish the course; Suspended = requested suspension without completing; Failed = did not obtain the grade required to issue the certificate. |
| 16 | Person Code | codigo_pessoa | Alphanumeric | Anonymized code that uniquely identifies each person |
| 17 | Student Gender | sexo | Alphanumeric | Student's gender as indicated in their registration. |
| 18 | Student's Age | idade | Numeric | Student's age calculated from the date of birth indicated in their registration |
| 19 | Student's Disability | deficiencia | Alphanumeric | Student's disability(ies) as indicated in their registration. When there are multiple, they are separated by comma. Value 'Nenhuma' (None) when no disability is reported |
| 20 | Student's Race | raca | Alphanumeric | Student's race/color as indicated in their registration |
| 21 | Student's Country of Origin | nacionalidade | Alphanumeric | Student's country of birth as indicated in their registration. |
| 22 | User's State/UF | uf_pessoa | Alphanumeric | User's state/UF of residence. |
| 23 | User's Municipality | municipio_pessoa | Alphanumeric | Student's municipality of residence. |
| 24 | instituicao | Alphanumeric | ||
| 25 | Branch of Government in Professional Experience | poder | Alphanumeric | Branch of government in their most recent professional experience, as indicated in their registration. |
| 26 | esfera | Alphanumeric | ||
| 27 | Work State/UF | uf_servidor | Alphanumeric | State/UF where the student works. |
| 28 | Work Municipality | municipio_servidor | Alphanumeric | Municipality where the student works. |