TEACH System
Approved Teacher Preparation Program-Bulk Recommendation File Format
How to create a comma delimited flat file that contains Approved Program participants to add college recommendations.
This file description applies to files sent to the New York State Education Department by Colleges/Universities
File name: "…" contains primary data
| Field Name | Max # Characters | Format | Description |
|---|---|---|---|
| SSN | 9 | ALPHANUMERIC | 9 digit ssn (no dashes) |
| LAST-NAME | 30 | ALPHANUMERIC | Last name |
| FIRST-NAME | 15 | ALPHANUMERIC | First name |
| MI | 1 | ALPHANUMERIC | Middle initial |
| DOB | 10 | ALPHANUMERIC | Date of birth (mm/dd/yyyy) |
| PROGRAM-DT | 10 | ALPHANUMERIC | Program date (mm/dd/yyyy) |
| PROGRAM-CODE | 5 | NUMBER | Program code |
| AWARD-CODE | 4 | NUMBER | Award code |
| INSTITUTION-ID | 6 | NUMBER | Institution id |
| CERTIFICATE-TYPE | 3 | NUMBER | Certificate type |
| TITLE-CODE | 4 | NUMBER | Subject-level code |
Last Updated:
April 11, 2013