2006-2007 FASTER Accessing NWRDC Code Files

FLORIDA AUTOMATED SYSTEM FOR TRANSFERRING EDUCATIONAL RECORDS
FLORIDA DEPARTMENT OF EDUCATION
OFFICE OF APPLICATION SUPPORT (OAS)

Effective: November 20, 2006
Revised:

Accessing Code Files Available at Northwest Regional Data Center

For your convenience, the code tables listed in this appendix are maintained at the Northwest Regional Data Center (NWRDC) by either OAS or the Division of Public Schools (DPS). When the dataset name for the file contains the letters 'Yyear' replace the 'year' with the current school year. For example, in item 1 below, DPS.DISTRICT.G4.F25031.Y9495 would be the 1994-1995 file while DPS.DISTRICT.G4.F25031.Y9596 would contain data for 1995-1996.

As explained in Chapter 12, the format for this dataset and other DOE datasets can be downloaded from partitioned dataset DPS.DISTRICT.FORMAT.Yyear(member name F25031), stored at NWRDC. Alternately, the format and the data may be downloaded using Internet FTP as documented in Chapter X.

1. Division of Public Schools Files: Master School ID (MSID) File, Course File, Vocational Course File and Private Schools File

The Division of Public Schools (DPS) Files: Master School ID (MSID) File contains names, numbers, and other useful information on Florida PK-12 public schools. A sequential copy of this file has been made available as dataset DPS.DISTRICT.G4.F25031.Yyear. Note that the unique identifier for a school consists of two fields: District Number and School Number. Thus, the unique identifier for a school is 6 characters in length.

The MSID file format can be found in DPS.DISTRICT.FORMAT.Y0506(F25031).

Private School Numbers can be found on the sequential file DPS.DISTRICT.GH.F70119.Yyear. Like the Public School MSID file, the unique identifier consists of the two fields District Number and School Number. The format for this file can be found in DPS.DISTRICT.FORMAT.Y0506(F70119).

Other available files are:
the Course file - DPS.DISTRICT.K9.F62806.Y9999 (where 9999 is the four-digit school year) for odd years and DPS.DISTRICT.K9.F62597.Y9999 for even years;
the Vocational Courses file - DPS.DISTRICT.GQ.F60922.Y9999;
and the Private Schools File - DPS.DISTRICT.GH.F70119.Y9999.

2. OPEID Codes

A table of OPEID codes is stored at NWRDC as a dataset named DPS.DISTRICT.GU.F61444.Yyear. This dataset has a record length of 80 characters and can be downloaded in the same way that programs are retrieved from FRN.DISTRICT.SOURCE. The format for this dataset is also stored on partitioned dataset DPS.DISTRICT.FORMAT.Yyear (member name F61444), at NWRDC.

3. U.S. State Codes

A table of state codes is stored at NWRDC as a dataset named FRN.DISTRICT.STATE. Like the OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. State codes are 2-byte fields that begin in column 1. State names are stored in 20-byte fields beginning in column 6.

4. Foreign Country and U.S. Territory Codes

A table of foreign country and United States territory codes is stored at NWRDC as a dataset named FRN.DISTRICT.COUNTRY. These codes are used in the interdistrict and secondary to postsecondary record formats. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. Foreign country and territory codes are 2-byte fields that begin in column 1. Country and territory names are stored in 30-byte fields beginning in column 6.

5. Code List for Florida Postsecondary Public and Non-Public Institutions

This table of codes is stored at NWRDC as a dataset named FRN.DISTRICT.POSTSEC. Each record is 80 characters long and can be downloaded in the same way that programs are retrieved from FRN.DISTRICT.SOURCE. The institution code is a 4-byte field beginning in column 1. A 25-byte short name is found in columns 6-30. The long name for the institution is 40 bytes beginning in column 32 and going through column 71. In-state community college codes range from C901 through C928, in-state university codes range from U970 through U979 and in-state private postsecondary institutions range from P001 through P999.

6. International Standards Organization (ISO) Country Codes

A table of country codes used in the postsecondary transcript formats is stored at NWRDC as a dataset named FRN.DISTRICT.POSTSEC.COUNTRY. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. The country codes are 2-byte fields that begin in column 1. Country names are stored in 30-byte fields beginning in column 11.

7. Postsecondary Campus Codes

A table of campus codes used in referring to Florida postsecondary public institutions is stored at NWRDC as a dataset named FRN.DISTRICT.CAMPUS. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. Columns 1 through 6 contain the institution's OPEID Code followed by a 4-byte Campus Code in columns 7 through 10. The institution name is a 35-character field in columns 11 through 45. The campus name is also a 35-character field in columns 46 through 80. Codes are numeric, right-justified and zero-filled while names are left-justified, blank filled and in upper/lower case.

8. International Standards Organization (ISO) and National Information Standards Organization (NISO) Language Codes

The table of language codes used in the postsecondary transcript formats has been expanded to include the 3 character ISO and NISO codes. It is stored at NWRDC as a dataset named FRN.DISTRICT.POSTSEC.LANGUAGE. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. The 2 character ISO language codes are 2-byte fields that begin in column 1. Language names are stored in 30-byte fields beginning in column 11, and 3 character ISO/NISO codes are stored in fields beginning in column 45. The old file containing only ISO codes is still available and is named FRN.DISTRICT.POSTSEC.LANGUAGE.ISO.

9. International Classification of Diseases (ICD) Codes

The complete list of ICD codes is quite voluminous. This file, however, contains the subset of the ICD codes used in the G99HC, G99HS, and G99IMM record formats. It is stored at NWRDC as dataset FRN.DISTRICT.ICD. This file has a record length of 80 characters with the ICD code in bytes 1 through 6 and the name in 30-byte fields beginning in column 11.

10. Physician's Current Procedural Terminology (CPT) Codes

The complete list of CPT codes is quite voluminous. This file, however, contains the subset of the CPT codes used in the G99HC, G99HS, and G99IMM record formats. It is stored at NWRDC as dataset FRN.DISTRICT.CPT. This file has a record length of 80 characters with the CPT code in bytes 1 through 6 and the name in 30-byte fields beginning in column 11.

11. SPEEDE/ExPRESS Academic Grade Qualifier Codes

The SPEEDE/ExPRESS Academic Grade Qualifier Codes are a superset of the codes used by the Association of American Medical Colleges Application Service (AAMCAS). This code file is stored at NWRDC as dataset FRN.DISTRICT.ACADEMIC.GRADE.QUAL. This file has a record length of 80 characters with the Qualifier Code in bytes 1 through 3, the Grade Assigned in bytes 4 through 6, Grade Weight, if applicable, in bytes 7 through 9, and a 30-byte description field beginning in column 11. Both the Qualifier Code and the Grade Assigned are needed for uniqueness.

12. High School Educational Testing Service (ETS) Codes

The Educational Testing Service identifies high schools using a 6-byte code. These codes are available in dataset BOR.XREF.HIGHSCHL. This file contains data for public and private high schools. Florida school codes begin with '10' in the first two digits.

13. Office of Postsecondary Education Codes

The Office of Postsecondary Education Identification (OPEID) file is available at NWRDC as dataset BOR.XREF.LASTINST.OPEID. The format for this file is available at the Division of Colleges and Universities website. This file contains accredited institutions only. If you are interested in obtaining a file that contains both accredited and non-accredited institutions, visit the U.S. Department of Education website.

1.	Division of Public Schools Files: Master School ID (MSID) File, Course File, Vocational Course File and Private Schools File
	The Division of Public Schools (DPS) Files: Master School ID (MSID) File contains names, numbers, and other useful information on Florida PK-12 public schools. A sequential copy of this file has been made available as dataset DPS.DISTRICT.G4.F25031.Yyear. Note that the unique identifier for a school consists of two fields: District Number and School Number. Thus, the unique identifier for a school is 6 characters in length.
	The MSID file format can be found in DPS.DISTRICT.FORMAT.Y0506(F25031).
	Private School Numbers can be found on the sequential file DPS.DISTRICT.GH.F70119.Yyear. Like the Public School MSID file, the unique identifier consists of the two fields District Number and School Number. The format for this file can be found in DPS.DISTRICT.FORMAT.Y0506(F70119).
	Other available files are: the Course file - DPS.DISTRICT.K9.F62806.Y9999 (where 9999 is the four-digit school year) for odd years and DPS.DISTRICT.K9.F62597.Y9999 for even years; the Vocational Courses file - DPS.DISTRICT.GQ.F60922.Y9999; and the Private Schools File - DPS.DISTRICT.GH.F70119.Y9999.
2.	OPEID Codes
	A table of OPEID codes is stored at NWRDC as a dataset named DPS.DISTRICT.GU.F61444.Yyear. This dataset has a record length of 80 characters and can be downloaded in the same way that programs are retrieved from FRN.DISTRICT.SOURCE. The format for this dataset is also stored on partitioned dataset DPS.DISTRICT.FORMAT.Yyear (member name F61444), at NWRDC.
3.	U.S. State Codes
	A table of state codes is stored at NWRDC as a dataset named FRN.DISTRICT.STATE. Like the OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. State codes are 2-byte fields that begin in column 1. State names are stored in 20-byte fields beginning in column 6.
4.	Foreign Country and U.S. Territory Codes
	A table of foreign country and United States territory codes is stored at NWRDC as a dataset named FRN.DISTRICT.COUNTRY. These codes are used in the interdistrict and secondary to postsecondary record formats. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. Foreign country and territory codes are 2-byte fields that begin in column 1. Country and territory names are stored in 30-byte fields beginning in column 6.
5.	Code List for Florida Postsecondary Public and Non-Public Institutions
	This table of codes is stored at NWRDC as a dataset named FRN.DISTRICT.POSTSEC. Each record is 80 characters long and can be downloaded in the same way that programs are retrieved from FRN.DISTRICT.SOURCE. The institution code is a 4-byte field beginning in column 1. A 25-byte short name is found in columns 6-30. The long name for the institution is 40 bytes beginning in column 32 and going through column 71. In-state community college codes range from C901 through C928, in-state university codes range from U970 through U979 and in-state private postsecondary institutions range from P001 through P999.
6.	International Standards Organization (ISO) Country Codes
	A table of country codes used in the postsecondary transcript formats is stored at NWRDC as a dataset named FRN.DISTRICT.POSTSEC.COUNTRY. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. The country codes are 2-byte fields that begin in column 1. Country names are stored in 30-byte fields beginning in column 11.
7.	Postsecondary Campus Codes
	A table of campus codes used in referring to Florida postsecondary public institutions is stored at NWRDC as a dataset named FRN.DISTRICT.CAMPUS. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. Columns 1 through 6 contain the institution's OPEID Code followed by a 4-byte Campus Code in columns 7 through 10. The institution name is a 35-character field in columns 11 through 45. The campus name is also a 35-character field in columns 46 through 80. Codes are numeric, right-justified and zero-filled while names are left-justified, blank filled and in upper/lower case.
8.	International Standards Organization (ISO) and National Information Standards Organization (NISO) Language Codes
	The table of language codes used in the postsecondary transcript formats has been expanded to include the 3 character ISO and NISO codes. It is stored at NWRDC as a dataset named FRN.DISTRICT.POSTSEC.LANGUAGE. Like the state and OPEID code datasets above, this file has a record length of 80 characters, and can be downloaded in the same way. The 2 character ISO language codes are 2-byte fields that begin in column 1. Language names are stored in 30-byte fields beginning in column 11, and 3 character ISO/NISO codes are stored in fields beginning in column 45. The old file containing only ISO codes is still available and is named FRN.DISTRICT.POSTSEC.LANGUAGE.ISO.
9.	International Classification of Diseases (ICD) Codes
	The complete list of ICD codes is quite voluminous. This file, however, contains the subset of the ICD codes used in the G99HC, G99HS, and G99IMM record formats. It is stored at NWRDC as dataset FRN.DISTRICT.ICD. This file has a record length of 80 characters with the ICD code in bytes 1 through 6 and the name in 30-byte fields beginning in column 11.
10.	Physician's Current Procedural Terminology (CPT) Codes
	The complete list of CPT codes is quite voluminous. This file, however, contains the subset of the CPT codes used in the G99HC, G99HS, and G99IMM record formats. It is stored at NWRDC as dataset FRN.DISTRICT.CPT. This file has a record length of 80 characters with the CPT code in bytes 1 through 6 and the name in 30-byte fields beginning in column 11.
11.	SPEEDE/ExPRESS Academic Grade Qualifier Codes
	The SPEEDE/ExPRESS Academic Grade Qualifier Codes are a superset of the codes used by the Association of American Medical Colleges Application Service (AAMCAS). This code file is stored at NWRDC as dataset FRN.DISTRICT.ACADEMIC.GRADE.QUAL. This file has a record length of 80 characters with the Qualifier Code in bytes 1 through 3, the Grade Assigned in bytes 4 through 6, Grade Weight, if applicable, in bytes 7 through 9, and a 30-byte description field beginning in column 11. Both the Qualifier Code and the Grade Assigned are needed for uniqueness.
12.	High School Educational Testing Service (ETS) Codes
	The Educational Testing Service identifies high schools using a 6-byte code. These codes are available in dataset BOR.XREF.HIGHSCHL. This file contains data for public and private high schools. Florida school codes begin with '10' in the first two digits.
13.	Office of Postsecondary Education Codes
	The Office of Postsecondary Education Identification (OPEID) file is available at NWRDC as dataset BOR.XREF.LASTINST.OPEID. The format for this file is available at the *Division of Colleges and Universities* website. This file contains accredited institutions only. If you are interested in obtaining a file that contains both accredited and non-accredited institutions, visit the U.S. Department of Education website.