The following shows the tables and fields from the Ed-Fi ODS v5.3, which comes with EPDM-Core, that were used to build the visualizations above to answers questions related to Educator Preparation Program Persistence and Diversity.
We have created a Google Sheets workbook for mapping data specifically for the Diversity and Persistence Starter Kit, which can be found here
| Fields | EPDM Description | EPDM DataType | Other Comment |
|---|---|---|---|
| Candidate - All fields required | |||
| CandidateIdentifier | A unique identifier for each candidate record. | String (60) | Identifiers can be determined by SI if they don't already exist |
| FirstName | Candidate first name. | String (75) | |
| LastName | Candidate last name. | String (75) | |
| Sex | A person's gender. | DesciptorDataType (enumeration) | Female, Male, Non-Binary, Not Selected |
| BirthDate | The month, day, and year on which an individual was born. | Date | |
| Person | Relates the candidate to a generic person. | Person reference | If institution uses a person ID system, will use that info, otherwise created by SI |
| Race | The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies. The data model allows for multiple entries so that each individual can specify all appropriate races. | DescriptorDataType (enumeration) | American Indian - Alaska Native, Asian, Black - African American, Choose Not to Respond, Hispanic/Latino, Native Hawaiian - Pacific Islander, Other, White |
| Credential - All fields required | |||
| CredentialIdentifier | A unique identifier assigned to each record in the Credential Extension table. | String (60) | |
| CredentialField | The field of certification for the certificate (e.g., Mathematics, Music). | DesciptorDataType (enumeration) | See DescriptorValues tab for possible values |
| IssuanceDate | The month, day, and year on which an active credential was issued to an individual. | Date | |
| CredentialType | An indication of the category of credential an individual holds. | DesciptorDataType (enumeration) | See DescriptorValues tab for possible values |
| GradeLevel | The grade level(s) certified for teaching. | DesciptorDataType (enumeration) collection | See DescriptorValues tab for possible values |
| StateAbbreviation | The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which a license/credential was issued. | DesciptorDataType (enumeration) | Standard two character abreviation for State of issueance - See DescriptorValues tab for possible values |
| TeachingCredential | An indication of the category of a legal document giving authorization to perform teaching assignment services. | DesciptorDataType (enumeration) | |
| Namespace | Namespace for the Credential. | String (255) | string of the form 'uri:://www.your_instiution.edu' will be determined by SI |
| Person | The person who obtained and is holding the credential. | Person reference | created by SI |
| EducatorPreparationProgram - All fields required | |||
| EducationOrganization | Relates the program to an EducationOrganization. | EducationOrganization reference | education organizations will be created by SI |
| ProgramName | The name of the Educator Preparation Program. | String (255) | |
| ProgramType | The type of program. | DesciptorDataType (enumeration) | See DescriptorValues tab for possible values |
| CandidateEducatorPreparationProgramAssociation - All fields required | |||
| Candidate | Candidate for the association. | Candidate reference | |
| EducatorPreparationProgram | The Program associated to the Candidate. | EducatorPreparationProgram reference | |
| BeginDate | The begin date for the association. | Date | |
| ReasonExited | The reason the candidate exited the program. | For determining program completion for the starter kit, the descriptor value must be set to 'Completed' | |
| CohortYear.SchoolYear | The value for the school year for the cohort | enumeration | four-digit year |
| CohortYear.CohortYearType | The type of the cohort year | DescriptorDataType (enumeration) | |
| CohortYear.Term | The term for the cohort | DescriptorDataType (enumeration) | |
| FinancialAid - All fields required | |||
| BeginDate | The date the aid took effect | Date | |
| AidType | The classification of financial aid awarded to a person for the academic term/year. | DescriptorDataType (enumeration) | |
| Student | Student for the association | Student reference | A student entity must be created to use financial aid, in most cases the student identifier will be the candidate identifier. If you are using a SI, this will be handled by the SI |