ODE posts an updated file named issued_credentials.txt on their site, https://public.education.ohio.gov/misc/, every Monday at approximately 1 AM. The file holds the active (or 'issued') credential information for all educators in the state.
The following table lists the positions, field names, descriptions, and where the data is loaded for the issued_credentials.txt file.
|
Position |
Field Name |
Description |
Loaded To |
|---|---|---|---|
|
1 |
educ_cred_key |
The unique identifier for the certification. |
emp_certificate.number |
|
2 |
staff_id |
State Staff ID (Certification ID) |
Used for employee matching. |
|
3 |
f_name |
First Name |
Display/reporting only |
|
4 |
m_name |
Middle Name |
Display/reporting only |
|
5 |
l_name |
Last Name |
Display/reporting only |
|
6 |
c_term |
Credential Term |
Combined into a certification type. |
|
7 |
c_class |
Credential Class |
Combined into a certification type. |
|
8 |
c_categ |
Credential Category |
Combined into a certification type. |
|
9 |
c_type |
Credential Type |
emp_certificate.c_area |
|
10 |
action |
Action Code |
Not loaded |
|
11 |
valid_IRN |
Valid In Organization IRN |
Used for filtering |
|
12 |
c_status |
Credential Status |
Not loaded |
|
13 |
iss_date |
Issue Date (YYYYMMDD) |
emp_certificate.iss_date |
|
14 |
exp_date |
Expiration Date (YYYYMMDD) |
emp_certificate.exp_date |
|
15 |
eff_year |
Effective Year |
emp_certificate.reg_date (July 1 of the year) |
|
16-51 |
teach_id1-18, teach_name1-18 |
Teaching Field IDs and Names (18 pairs) |
ohcert_teach |
|
52-63 |
endorse_id1-6, endorse_name1-6 |
Endorsement IDs and Names (6 pairs) |
ohcert_endorse |
|
64-75 |
limit_id1-6, limit_name1-6 |
Limitation IDs and Names (6 pairs) |
ohcert_limit |
|
76-135 |
dist_irn1-15, rpt_irn1-15, pos_cd1-15, pos_desc1-15 |
District IRNs, Reporting IRNs, Position Codes/Descriptions (15 sets) |
Used for filtering (dist_irn); pos_cd/pos_desc not loaded |