PEPS Weekly School File – Header Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
1-2; 2 RECORD TYPE A two-digit code identifying the type of VARCHAR2 00
record in the flat file.
3-10; 8 SORT SCHOOL CODE Positional sort field used for sorting the VARCHAR2 ‘00000000’
Header record to the top of the file.
11-11; 1 DATA PROVIDER Indicator identifying that this file was VARCHAR2 'P'
CODE created and submitted by PEPS
12-19; 8 CREATE DATE Date the file was created. DATE YYYYMMDD
20-29; 10 VERSION Version number for the extract. VARCHAR2 YYYY.00001
30-550; 521 FILLER Blanks to complete the record length VARCHAR2 Spaces
PEPS Weekly School File – School Detail Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
1-2; 2 RECORD TYPE A two-digit code identifying the type of VARCHAR2 01 Main and Additional Locations.
record in the flat file.
3-10; 8 OPE ID Unique 8-digit OPE code used to identify VARCHAR2 Main and Additional Locations. Format will be
a location of an institution. 0#####00 for the Main Campus.
11-11; 1 CHANGE INDICATOR Indicates if data has changed from the VARCHAR2 Y or N Main and Additional Locations.
Previous extract.
12-81; 70 SCHOOL NAME The name of the Main Institution VARCHAR2 Main and Additional Location.
82-151; 70 LOC NAME The name of the Additional Location VARCHAR2 Main and Additional Locations. Official Name for each
Location.
152-186; 35 LINE1 ADR First line of the official address VARCHAR2 Main and Additional Locations.
187-221; 35 LINE2 ADR Second line of the official address VARCHAR2 Main and Additional Locations.
222-246; 25 CITY The city of the official address VARCHAR2 Main and Additional Locations.
247-248; 2 STATE The state of the official address VARCHAR2 See Table Main and Additional Locations. Null if school is foreign.
249-251; 3 COUNTY County Code VARCHAR2 See Table Main Institution only.
252-276; 25 COUNTRY The country of the official address VARCHAR2 See Table Main and Additional Locations. Null if school is domestic.
277-290; 14 ZIP The Zip+4 or the foreign mail code of the VARCHAR2 Main and Additional Locations. May contain characters official address. for foreign schools.
291-315; 25 FOREIGN PROVINCE Foreign province name VARCHAR2 Main and Additional Locations.
NAME
316-316; 1 ELIG STATUS IND The indicator specifying whether the VARCHAR2 Y or N Additional Locations will populate with
institution is eligible to participate in the same data as the Main if the Additional Location
U.S. Department of Education programs. is approved. If the Location is not approved the field
will default to “N”.
PEPS Weekly School File – School Detail Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
317-317; 1 CERT TYPE CD The certification status of the institution VARCHAR2 (C if the schl Additional Locations will populate with
is certified, P if the same data as the Main if the Additional Location
the school is is approved. If the Location is not approved the field
provisionally will default to “N”.
certified and N
if the school is
not certified. )
318-318; 1 APPROV IND The indicator specifying whether the VARCHAR2 Y or N Main and Additional Locations.
location is approved for eligibility and/or
certification
319-320; 2 ACTN CD Overall Eligibility action code for the VARCHAR2 See Table Main Institution only.
Main Institution.
321-322; 2 ACTN REASON CD Overall Eligibility reason code for the VARCHAR2 See Table Main Institution only.
Main Institution.
323-330; 8 ACTN DT Overall Eligibility action date for the DATE YYYYMMDD Main Institution only.
Main Institution.
331-338; 8 PPA SENT DT SPT Program Participation Agreement DATE YYYYMMDD Main Institution only.
sent date.
339-346; 8 PPA EXECUTION DT SPT Program Participation Agreement DATE YYYYMMDD Main Institution only.
execution date. (date that SPT
countersigns the PPA)
347-354; 8 PPA EXPIRATION DT SPT Program Participation Agreement DATE YYYYMMDD Main Institution only.
expiration date. (date that the PPA is
to expire)
355-356; 2 PGM LENGTH The length of the longest program offered VARCHAR2 See Table All Additional Locations will populate
by the institution. with the same data as the Main School.
PEPS Weekly School File – School Detail Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
357-357; 1 SCH TYPE The code identifying the ownership control VARCHAR2 See Table All Additional Locations will populate
type of the institution. with the same data as the Main School.
358-359; 2 ACAD CAL The academic calendar of the institution. VARCHAR2 See Table All Additional Locations will populate
with the same data as the Main School.
360-360; 1 ETHNIC CD The code classifying the ethnic affiliation VARCHAR2 See Table All Additional Locations will populate
of the institution. with the same data as the Main School.
361-361; 1 SURETY Derived by Surety Posted Date VARCHAR2 Y or N Main School only. Was Surety posted for this
School?
362-363; 2 REGION CD The Main Institutions region code. VARCHAR2 See Table All Additional Locations will populate
with the same data as the Main School.
364-371; 8 CONG DIST The congressional district(s) of the VARCHAR2 Main School only. Additional locations will be null.
Main institution.
372-379; 8 SIC CD SIC Code VARCHAR2 Main School only. Additional locations will be null.
380-381; 2 FAADS CD FAADS Code VARCHAR2 Main School only. Additional locations will be null.
382-389; 8 CLOSE DT The date a Main/Location closes on. DATE YYYYMMDD Main and Additional Locations.
390-397; 8 INIT APPR DT The date the main/location was initially DATE YYYYMMDD Main and Additional Locations.
Approved for Title IV eligibility.
398-405; 8 DISAPPROVAL DT The date the main/location was DATE YYYYMMDD Main and Additional Locations.
Disapproved for Title IV eligibility.
406-407; 2 LOCATION REASON The main/location reason for loss of VARCHAR2 See Table Main and Additional Locations.
Title IV eligibility.
408-408; 1 SYSTEM FUNDED The indicator specifying whether the VARCHAR2 Y or N Main and Additional Locations.
OFFICE IND School is a System Office
PEPS Weekly School File – School Detail Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
409-409; 1 BRANCH IND The indicator specifying whether the VARCHAR2 Y or N Additional Locations only.
location is a branch
410-411; 2 CASE TEAM CD SPT Case Team Code for the school. VARCHAR2 Main and Additional Locations.
412-419; 8 REINSTATE DT The date the main/location was DATE YYYYMMDD Main and Additional Locations.
reinstated.
420-469; 50 WEB PAGE Web Address for the Main School. VARCHAR2 Main Institutions only.
470-550; 81 FILLER Blanks to complete the record length VARCHAR2 Spaces
PEPS Weekly School File – School Contact Information Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
1-2; 2 RECORD TYPE A two-digit code identifying the type of VARCHAR2 02 Main Institutions only.
record in the flat file.
3-10; 8 OPE ID Unique 8-digit OPE code used to identify VARCHAR2 Main Institutions only.
a location of an institution.
11-11; 1 CHANGE INDICATOR Indicates if data has changed from the VARCHAR2 Y or N Main Institutions only.
previous extract.
12-13; 2 CONT TYPE Two digit code to associate the type of VARCHAR2 See Table Main Institutions only.
contact (i.e. President, Trustee, etc)
14-48; 35 CONT STREET1 First line of the Contacts official address. VARCHAR2 Main Institutions only.
49-83; 35 CONT STREET2 Second line of the Contacts official VARCHAR2 Main Institutions only.
address.
84-108; 25 CONT CITY The city of the Contacts official address. VARCHAR2 Main Institutions only.
109-110; 2 CONT STATE The state of the Contacts official address. VARCHAR2 See Table Main Institutions only. Null if school is foreign.
111-124; 14 ZIP The Zip+4 or the foreign mail code of the VARCHAR2 Main Institutions only.
Contacts official address.
125-149; 25 CONT PROVINCE The foreign province name for the VARCHAR2 Main Institutions only.
Contacts official address.
150-174; 25 CONT COUNTRY The foreign country name for the VARCHAR2 See Table Main Institutions only. Null if school is domestic.
Contacts official address.
175-176; 2 CONT SALUTATION The salutation for the Contacts official VARCHAR2 See Table Main Institutions only.
address.
177-191; 15 CONT FIRST NAME The first name for the Contact VARCHAR2 Main Institutions only.
PEPS Weekly School File – School Contact Information Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
192-192; 1 CONT MI The middle initial for the Contact VARCHAR2 Main Institutions only.
193-222; 30 CONT LAST NAME The last name for the Contact VARCHAR2 Main Institutions only.
223-225; 3 CONT SUFFIX The suffix for the Contact VARCHAR2 Main Institutions only.
226-228; 3 CONT AREA CODE The area code for the Contact VARCHAR2 Main Institutions only.
229-231; 3 CONT EXCHANGE The exchange for the Contact VARCHAR2 Main Institutions only.
232-235; 4 CONT EXT The phone number for the Contact VARCHAR2 Main Institutions only.
236-240; 5 CONT EXT2 The extension for the Contact VARCHAR2 Main Institutions only.
241-254; 14 CONT FOREIGN The foreign phone number for the VARCHAR2 Main Institutions only.
PHONE Contact
255-268; 14 CONT FAX The fax number for the Contact VARCHAR2 Main Institutions only.
(either domestic or foreign).
269-318; 50 CONT INTERNET ADD The internet address for the Contact VARCHAR2 Main Institutions only.
319-326; 8 CONT EFFECT DTE The date the Contact became effective. DATE YYYYMMDD Main Institutions only.
(Start Date)
327-334; 8 CONT END DTE The date the Contact ended. DATE Main Institutions only.
335-394; 60 SCHOOLS JOB TITLE The Schools Job Title for the Contact VARCHAR2 Main Institutions only.
at the school.
395-402; 8 CONT SYS ID A unique system generated Identifier for VARCHAR2 Main Institutions only.
Contacts.
403-550; 148 FILLER Blanks to complete the record length VARCHAR2 Spaces
PEPS Weekly School File – School Program Information Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
1-2; 2 RECORD TYPE A two-digit code identifying the type of VARCHAR2 03 Main Institutions only.
record in the flat file.
3-10; 8 OPE ID Unique 8-digit OPE code used to identify VARCHAR2 Main Institutions only.
a location of an institution.
11-11; 1 CHANGE INDICATOR Indicates if data has changed from the VARCHAR2 Y or N Main Institutions only.
Previous extract.
12-19; 8 FPELL START DT SPT current start date for FPELL DATE YYYYMMDD Main Institutions only.
Certification.
20-27; 8 FPELL END DT SPT current end date for FPELL DATE YYYYMMDD Main Institutions only.
Certification.
28-28; 1 FPELL APPROV IND SPT current approval indicator for FPELL VARCHAR2 Y or N Main Institutions only.
Certification.
29-36; 8 FFEL STAF START SPT current start date for FFEL STAF DATE YYYYMMDD Main Institutions only.
DT Certification.
37-44; 8 FFEL STAF END DT SPT current end date for FFEL STAF DATE YYYYMMDD Main Institutions only.
Certification.
45-45; 1 FFEL STAF APPROV SPT current approval indicator for FFEL VARCHAR2 Y or N Main Institutions only.
IND STAF Certification.
46-53; 8 FFEL STAF UNSUB SPT current start date for FFEL STAF DATE YYYYMMDD Main Institutions only.
START DT UNSUB Certification.
54-61; 8 FFEL STAF UNSUB SPT current end date for FFEL STAF DATE YYYYMMDD Main Institutions only.
END DT UNSUB Certification.
62-62; 1 FFEL STAF UNSUB SPT current approval indicator for FFEL VARCHAR2 Y or N Main Institutions only.
APPROV IND STAF UNSUB Certification.
63-70; 8 FFEL PLUS START SPT current start date for FFEL PLUS DATE YYYYMMDD Main Institutions only.
DT Certification.
PEPS Weekly School File – School Program Information Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
71-78; 8 FFEL PLUS END DT SPT current end date for FFEL PLUS DATE YYYYMMDD Main Institutions only.
Certification.
79-79; 1 FFEL PLUS APPROV SPT current approval indicator for FFEL VARCHAR2 Y or N Main Institutions only.
IND PLUS Certification.
80-87; 8 FFEL SLS START DT SPT current start date for FFEL SLS DATE YYYYMMDD Main Institutions only.
Certification.
88-95; 8 FFEL SLS END DT SPT current end date for FFEL SLS DATE YYYYMMDD Main Institutions only.
Certification.
96-96; 1 FFEL SLS APPROV SPT current approval indicator for FFEL VARCHAR2 Y or N Main Institutions only.
IND SLS Certification.
97-104; 8 FDSLP STAF START SPT current start date for FDSLP STAF DATE YYYYMMDD Main Institutions only.
DT Certification.
105-112; 8 FDSLP STAF END SPT current end date for FDSLP STAF DATE YYYYMMDD Main Institutions only.
DT Certification.
113-113; 1 FDSLP STAF SPT current approval indicator for FDSLP VARCHAR2 Y or N Main Institutions only.
APPROV IND STAF Certification.
114-121; 8 FDSLP STAF UNSUB SPT current start date for FDSLP STAF DATE YYYYMMDD Main Institutions only.
START DT UNSUB Certification.
122-129; 8 FDSLP STAF UNSUB SPT current end date for FDSLP STAF DATE YYYYMMDD Main Institutions only.
END DT UNSUB Certification.
130-130; 1 FDSLP STAF UNSUB SPT current approval indicator for FDSLP VARCHAR2 Y or N Main Institutions only.
APPROV IND STAF UNSUB Certification.
131-138; 8 FDSLP PLUS START SPT current start date for FDSLP PLUS DATE YYYYMMDD Main Institutions only.
DT Certification.
PEPS Weekly School File – School Program Information Record Layout (May 3, 2010)
Position/
Length Flat File Field Description Data Type Data Value Comments
139-146; 8 FDSLP PLUS END SPT current end date for FDSLP PLUS DATE YYYYMMDD Main Institutions only.
DT Certification.
147-147; 1 FDSLP PLUS SPT current approval indicator for FDSLP VARCHAR2 Y or N Main Institutions only.
APPROV IND PLUS Certification.
148-155; 8 FPERKINS START SPT current start date for FPERKINS DATE YYYYMMDD Main Institutions only.
DT Certification.
156-163; 8 FPERKINS END SPT current end date for FPERKINS DATE YYYYMMDD Main Institutions only.
DT Certification.
164-164; 1 FPERKINS SPT current approval indicator for VARCHAR2 Y or N Main Institutions only.
APPROV IND FPERKINS Certification.
165-172; 8 FSEOG START DT SPT current start date for FSEOG DATE YYYYMMDD Main Institutions only.
Certification.
173-180; 8 FSEOG END DT SPT current end date for FSEOG DATE YYYYMMDD Main Institutions only.