# PEPS Weekly School File -- Header Record Layout (September 1, 2006)

**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 (September 1, 2006)

**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 (September 1, 2006)

**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 (September 1, 2006)

**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 (September 1, 2006)

**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 (September 1, 2006)

**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 (September 1, 2006)

**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
(September 1, 2006)**

**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 (September 1, 2006)

**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 (September 1, 2006)

**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.

Certification.

181-181; 1 FSEOG APPROV SPT current approval indicator for VARCHAR2 Y or
N Main Institutions only.

IND FSEOG Certification.

182-189; 8 FWS PRIV SEC SPT current start date for FWS PRIV DATE
YYYYMMDD Main Institutions only.

EMPL START DT SEC EMP Certification.

190-197; 8 FWS PRIV SEC SPT current end date for FWS PRIV DATE YYYYMMDD
Main Institutions only.

EMPL END DT SEC EMPL Certification.

198-198; 1 FWS PRIV SEC SPT current approval indicator for FWS VARCHAR2
Y or N Main Institutions only.

EMPL APPROV IND PRIV SEC EMPL Certification.

199-206; 8 FWS JOB LOC DEV SPT current start date for FWS JOB DATE
YYYYMMDD Main Institutions only.

START DT LOC DEV Certification.

# PEPS Weekly School File -- School Program Information Record Layout (September 1, 2006)

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

207-214; 8 FWS JOB LOC DEV SPT current end date for FWS JOB DATE
YYYYMMDD Main Institutions only.

END DT LOC DEV Certification.

215-215; 1 FWS JOB LOC DEV SPT current approval indicator for FWS
VARCHAR2 Y or N Main Institutions only.

APPROV IND JOB LOC DEV Certification.

216-223; 8 FWS COM SERV SPT current start date for FWS COM DATE YYYYMMDD
Main Institutions only.

START DT SERV Certification.

224-231; 8 FWS COM SERV SPT current end date for FWS COM DATE YYYYMMDD
Main Institutions only.

END DT SERV Certification.

232-232; 1 FWS COM SERV SPT current approval indicator for FWS VARCHAR2
Y or N Main Institutions only.

APPROV IND COM SERV Certification.

# 

# 233-550; 318 FILLER Blanks to complete the record length VARCHAR2 Spaces

# PEPS Weekly School File -- School Identifier Information Record Layout (September 1, 2006)

**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 04
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.

a location of an institution.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main and Additional Locations.

Previous extract.

12-20; 9 TIN CURRENT The Schools current Tax Identification VARCHAR2 All
Additional Locations will populate

number assigned to the school by the IRS with the same data as the Main
School.

21-29; 9 TIN PREVIOUS The Schools previous Tax Identification VARCHAR2
All Additional Locations will populate

number assigned to the school by the IRS with the same data as the Main
School.

30-39; 10 CMO GDUNS NBR The current Grantee Duns Number as VARCHAR2 Main
and Additional Locations.

CURRENT recognized by SPT.

40-49; 10 CMO GDUNS NBR The former Grantee Duns Number as VARCHAR2 Main
and Additional Locations.

PREVIOUS recognized by SPT

50-59; 10 PELL GDUNS NBR Field no longer utilized, refer to the VARCHAR2
Main and Additional Locations.

CURRENT SPT GDUNS NBR CURRENT field.

# 

# 60-69; 10 PELL GDUNS NBR Field no longer utilized, refer to the VARCHAR2 Main and Additional Locations.

PREVIOUS SPT GDUNS NBR PREVIOUS field.

70-89; 20 FILLER Blanks for future use. VARCHAR2 Main and Additional
Locations.

90-99; 10 FDSLP GDUNS NBR Field no longer utilized, refer to the
VARCHAR2 Main and Additional Locations.

CURRENT SPT GDUNS NBR CURRENT field.

100-109; 10 FDSLP GDUNS NBR Field no longer utilized, refer to the
VARCHAR2 Main and Additional Locations.

PREVIOUS SPT GDUNS NBR PREVIOUS field.

**PEPS Weekly School File -- School Identifier Information Record Layout
(September 1, 2006)**

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

110-129; 20 FILLER Blanks for future use. VARCHAR2 Main and Additional
Locations.

130-139; 10 CAMPUS BASED Field no longer utilized, refer to the VARCHAR2
Main and Additional Locations.

GDUNS NBR SPT GDUNS NBR CURRENT field.

CURRENT

140-149; 10 CAMPUS BASED Field no longer utilized, refer to the VARCHAR2
Main and Additional Locations.

GDUNS NBR SPT GDUNS NBR PREVIOUS field.

PREVIOUS

150-155; 6 PELL ID CURRENT The current number used to identify the
VARCHAR2 Main and Additional Locations.

Institution for Pell Grant disbursement.

156-161; 6 PELL ID PREVIOUS The former number used to identify the
VARCHAR2 Main and Additional Locations.

institution for Pell Grant disbursement.

162-167; 6 FFEL ID CURRENT The current number used to identify the
VARCHAR2 Main Institution only.

Institution in the FFEL system.

168-173; 6 FFEL ID PREVIOUS The former number used to identify the
VARCHAR2 Main Institution only.

institution in the FFEL system.

174-179; 6 FDSLP ID CURRENT The Main/Locations number used to VARCHAR2
Main and Additional Locations.

identify the Institution for Direct Loans.

180-185; 6 FDSLP ID PREVIOUS The former Main/Locations number used
VARCHAR2 Main and Additional Locations.

to identify the Institution for Direct Loans.

186-191; 6 CAMPUS BASED ID The number used to identify the institution
VARCHAR2 Main Institution only.

CURRENT in the Campus Based System.

192-197; 6 CAMPUS BASED ID The former number used to identify the
VARCHAR2 Main Institution only.

PREVIOUS institution in the Campus Based System.

198-203; 6 FED SCHL CD The current Main Institutions Federal VARCHAR2
Main and Additional Locations.

CURRENT School Code.

#  

# PEPS Weekly School File -- School Identifier Information Record Layout (September 1, 2006)

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

204-209; 6 FED SCHL CD The previous Main/Locations Federal VARCHAR2 Main
and Additional Locations

PREVIOUS School Code.

# 

# 210-213; 4 FDSLP SEQ NBR The current Main/Locations Direct Loan VARCHAR2 Main and Additional Locations

#  CURRENT Sequence Number.

214-217; 4 FDSLP SEQ NBR The previous Main/Locations Direct Loan
VARCHAR2 Main and Additional Locations

PREVIOUS Sequence Number.

# 218-550; 333 FILLER Blanks to complete the record length VARCHAR2 Spaces 

# PEPS Weekly School File -- School Direct Loan Information Record Layout (September 1, 2006)

**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 05
Main Institution only.

record in the flat file.

3-10; 8 OPE ID Unique 8-digit OPE code used to identify VARCHAR2 Main
Institution only.

a location of an institution.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main Institution only.

Previous extract.

12-19; 8 FDSLP START DT The program participation agreement begin DATE
YYYYMMDD Main Institution only.

date for Direct Loans.

20-27; 8 FDSLP END DT The program participation agreement end DATE
YYYYMMDD Main Institution only.

date for Direct Loans.

28-29; 2 FDSLP END REASON The reason the school ended participation
VARCHAR2 See Table Main Institution only.

with Direct Loans

30-30; 1 FDSLP ORIG LEVEL The origination level for Direct Loans
VARCHAR2 See Table Main Institution only.

31-34; 4 FDSLP ORIG LEVEL The most recent origination award year. DATE
YYYY Main Institution only.

AWARD YR

35-42; 8 FDSLP ORIG START The origination level start date. DATE
YYYYMMDD Main Institution only.

DT

43-50; 8 FDSLP ORIG END The origination level end date. DATE YYYYMMDD
Main Institution only.

DT

51-52; 2 FDSLP ORIG END The origination level end reason. VARCHAR2 See
Table Main Institution only.

REASON

# 

# 53-550; 498 FILLER Blanks to complete the record length VARCHAR2 Spaces

# PEPS Weekly School File -- School Change of Affiliation Information Record Layout (September 1, 2006)

**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 06
Main and Additional Locations.

record in the flat file.

3-10; 8 NEW OPE ID The new OPE ID of the location after a VARCHAR2 Main
and Additional Locations.

change of affiliation.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main and Additional Locations.

Previous extract.

12-19; 8 PREVIOUS OPE ID Unique 8-digit OPE code used to identify
VARCHAR2 Main and Additional Locations.

a location of an institution.

20-20; 1 COA ACTN CD Change of Affiliation action code. VARCHAR2 See
Table Main and Additional Locations.

21-28; 8 COA EFFT DT Change of Affiliation effective date. DATE YYYYMMDD
Main and Additional Locations.

# 

# 29-29; 1 DEFAULT COA CD Default Management Change of VARCHAR2 See Table Main and Additional Locations.

Affiliation code.

# 30-550; 521 FILLER Blanks to complete the record length VARCHAR2 Spaces

#  

# PEPS Weekly School File -- School Accreditation Information Record Layout (September 1, 2006)

**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 07
Main Institution only.

record in the flat file.

3-10; 8 OPE ID Unique 8-digit OPE code used to identify VARCHAR2 Main
Institution only.

a location of an institution.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main Institution only.

Previous extract.

12-17; 6 ACCRED AGENCY An Institutions Accrediting Agency. VARCHAR2 See
Table Main Institution only.

18-21; 4 DESIGNATION Primary or Secondary Accreditation VARCHAR2 See
Table Main Institution only.

22-24; 3 ACCRED TYPE Institutional or Programmatic VARCHAR2 See Table
Main Institution only.

25-32; 8 ACCRED END DT End date for accreditation. DATE YYYYMMDD Main
Institution only.

33-33; 1 ACCRED ACT IND Indicates if the Accreditation is still VARCHAR2
Y or N Main Institution only.

active.

# 

# 34-550; 517 FILLER Blanks to complete the record length VARCHAR2 Spaces 

# PEPS Weekly School File -- School Default Management Information Record Layout (September 1, 2006)

**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 08
Main Institution where a rate was published on the

record in the flat file. Official Press Package only.

3-10; 8 OPE ID Unique 8-digit OPE code used to identify VARCHAR2 Main
Institution only.

a location of an institution.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main Institution only.

previous extract.

12-15; 4 COHORT YEAR Three most recent Cohort Years. VARCHAR2 YYYY Main
Institution only.

16-20; 5 OFFICIAL RATE% The Current Default Rate (Numerator/ NUMERIC
###.# Main Institution only. Numeric field with a one

CURRENT Denominator) as a percentage. point decimal.

21-25; 5 OFFICIAL RATE% The Previous Default Rate (Numerator/ NUMERIC
###.# Main Institution only. Numeric field with a one

PREVIOUS Denominator) as a percentage. point decimal.

26-27; 2 PROGRAM Indicates the schools program participation. VARCHAR2
See table Main Institution only.

28-28; 1 SUB CODE Denotes rate as combined, combo, VARCHAR2 See table
Main Institution only.

substituted, actual or average.

29-36; 8 TOTAL DFLT \# Current sum of unduplicated loans in NUMERIC Main
Institution only.

CURRENT default.

37-44; 8 TOTAL DFLT \# Previous sum of unduplicated loans in NUMERIC
Main Institution only.

PREVIOUS default.

45-52; 8 TOTAL REPAY \# Current sum of unduplicated loans in NUMERIC
Main Institution only.

CURRENT repayment.

53-60; 8 TOTAL REPAY \# Previous sum of unduplicated loans in NUMERIC
Main Institution only.

PREVIOUS repayment.

61-550; 490 FILLER Blanks to complete the record length. VARCHAR2 Spaces

PEPS Weekly School File -- School Other Addresses Information Record
Layout (September 1, 2006)

**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 09
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.

a location of an institution.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main and Additional Locations.

previous extract.

12-13; 2 ADDRESS TYPE A two-digit code identifying the type of VARCHAR2
See Table Main and Additional Locations.

address.

14-48; 35 LINE1 ADR First line of the other address. VARCHAR2 Main and
Additional Locations.

49-83; 35 LINE2 ADR Second line of the other address. VARCHAR2 Main and
Additional Locations.

84-108; 25 CITY The city of the other address. VARCHAR2 Main and
Additional Locations.

109-110; 2 STATE The state of the other address. VARCHAR2 See Table Main
and Additional Locations.

111-135; 25 COUNTRY The country of the other address. VARCHAR2 See Table
Main and Additional Locations.

136-149; 14 ZIP The Zip+4 or the foreign mail code of the VARCHAR2 Main
and Additional Locations.

other address.

150-174; 25 FOREIGN PROVINCE Foreign province name for the other
VARCHAR2 Main and Additional Locations.

NAME address.

175-177; 3 OTHER AREA CODE The area code for the other address. VARCHAR2
Main and Additional Locations.

178-180; 3 OTHER EXCHANGE The exchange for the other address. VARCHAR2
Main and Additional Locations.

181-184; 4 OTHER EXT The phone number for the other address. VARCHAR2
Main and Additional Locations.

185-189; 5 OTHER EXT2 The extension for the other address. VARCHAR2 Main
and Additional Locations.

190-203; 14 OTHER FOREIGN The foreign phone number for the other
VARCHAR2 Main and Additional Locations.

PHONE address.

# PEPS Weekly School File -- School Other Addresses Information Record Layout (September 1, 2006)

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

204-217; 14 OTHER FAX The fax number for the other address. VARCHAR2
Main and Additional Locations.

(either domestic or foreign)

218-267; 50 OTHER INTERNET The internet address for the other address.
VARCHAR2 Main and Additional Locations.

ADR

268-337; 70 FSC LOC NAME The Federal School Code Location Name. VARCHAR2
Main and Additional Locations.

338-352; 15 FSC CONT FIRST The first name for the Federal School Code
VARCHAR2 Main and Additional Locations.

NAME contact.

353-382; 30 FSC CONT LAST The last name for the Federal School Code
VARCHAR2 Main and Additional Locations.

NAME contact.

383-550; 168 FILLER Blanks to complete the record length. VARCHAR2
Spaces

# PEPS Weekly School File -- School Experimental Site Information Record Layout (September 1, 2006)

**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 10
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 EXPERIMENT TYPE A two digit code identifying the type of
VARCHAR2 See Table Main Institutions only.

CODE

14-21; 8 EXPERIMENT TYPE Start date for this Experimental Type. DATE
YYYYMMDD Main Institutions only.

START DT

22-29; 8 EXPERIMENT TYPE End date for this Experimental Type. DATE
YYYYMMDD Main Institutions only.

END DT

30-550; 521 FILLER Blanks to complete the record length. VARCHAR2 Spaces

**PEPS Weekly School File -- School Closure Information Record Layout
(September 1, 2006)**

**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 11
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.

a location of an institution.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main and Additional Locations.

previous extract.

12-19; 8 CLOSURE DT Current School Closure Date DATE YYYYMMDD Main and
Additional Locations.

CURRENT

20-27; 8 CLOSURE DT Previous School Closure Date DATE YYYYMMDD Main and
Additional Locations.

PREVIOUS

28-28; 1 HISTORY CD A digit code that identifies the type of VARCHAR2
See Table Main and Additional Locations.

history.

29-29; 1 UNAUTHORIZED Indicates if the Location is Unauthorized VARCHAR2
Y or N Main and Additional Locations.

LOCATION IND

30-30; 1 TUITION RECOVERY Indicates if there is a Recovery VARCHAR2 Y or
N Main and Additional Locations.

FUND Amount.

31-31; 1 PERKINS IND Indicates if there is a Perkins VARCHAR2 Y or N
Main and Additional Locations.

Portfolio.

32-40; 9 KNOWN AMOUNT Value of the TRF Recovered Amount NUMERIC Main and
Additional Locations.

41-41; 1 STATE BOND IND Indicates if there is a State Bond. VARCHAR2 Y
or N Main and Additional Locations.

42-50; 9 SCHOOL BOND Value of the School Bond Amount NUMERIC Main and
Additional Locations.

AMOUNT

# PEPS Weekly School File -- School Closure Information Record Layout (September 1, 2006)

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

51-100; 50 RECORD HOLDER Name of the Organization that holds VARCHAR2
Main and Additional Locations.

DESCRIPTION the Closed School Record

101-170; 70 VERIFIED BY Name of the Organization that Verified VARCHAR2
Main and Additional Locations.

The School Closure

171-178; 8 CREATED ON DT Date of record creation DATE YYYYMMDD Main and
Additional Locations.

179-186; 8 MODIFIED DT Date of last modification of the DATE YYYYMMDD
Main and Additional Locations.

record

187-550; 364 FILLER Blanks to complete the record length. VARCHAR2
Spaces

# PEPS Daily School File -- Federal School Code Information Record Layout (September 1, 2006)

**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 97
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.

a location of an institution.

11-11; 1 CHANGE INDICATOR Indicates if data has changed from the
VARCHAR2 Y or N Main and Additional Locations.

previous extract.

12-51; 40 FED SCHL CD NAME School Name to be used for Federal VARCHAR2
Main and Additional Locations.

School Code purposes only!

52-81; 30 FILLER Blanks to complete the record length. VARCHAR2 Spaces

82-116; 35 FED SCHL CD ADDR 1 First line Street Address for Federal
VARCHAR2 Main and Additional Locations.

School Code purposes only!

117-151; 35 FED SCHL CD ADDR 2 Second line Street Address for Federal
VARCHAR2 Main and Additional Locations.

School Code purposes only!

152-174; 23 FED SCHL CD CITY City for Federal School Code purposes
VARCHAR2 Main and Additional Locations.

Only!

175-176; 2 FED SCHL CD STATE State for Federal School Code purposes
VARCHAR2 See Table Main and Additional Locations.

Only!

177-181; 5 FED SCHL CD ZIP Zip Code for Federal School Code VARCHAR2
Main and Additional Locations.

Purposes Only!

182-185; 4 FED SCHL CD ZIP+4 +4 Code for Federal School Code VARCHAR2
Main and Additional Locations.

Purposes Only!

186-210; 25 FED SCHL CD PROV Foreign Province for Federal School Code
VARCHAR2 Main and Additional Locations.

Purposes only!

211-235; 25 FED SCHL CD Foreign Country for Federal School Code VARCHAR2
See Table Main and Additional Locations.

COUNTRY Purposes only!

# PEPS Daily School File -- Federal School Code Information Record Layout (September 1, 2006)

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

236-249; 14 FED SCHL CD Foreign Mail Code for Federal School VARCHAR2
Main and Additional Locations.

MAIL CD Code purposes only! Null if school is domestic.

250-279; 30 FED SCHL CD Federal School Code Contact Person VARCHAR2 Main
and Additional Locations.

CONTACT FIRST Name.

NAME

280-294; 15 FED SCHL CD Phone Number for Federal School Code VARCHAR2
Main and Additional Locations.

CONTACT PHONE Contact Person.

295-344; 50 FED SCHL CD Email Address for Federal School Code VARCHAR2
Main and Additional Locations.

CONTACT EMAIL Contact Person.

345-350; 6 FED SCHL CD Federal School Code used for FAFSFA. VARCHAR2
Main and Additional Locations.

351-351; 1 FED SCHL CD CYCLE Federal School Code Cycle. VARCHAR2 See
Table Main and Additional Locations.

352-357; 6 FPELL ID The current number used to identify the VARCHAR2
Main and Additional Locations.

Institution for Pell Grant disbursement.

358-363; 6 FFEL ID The current number used to identify the VARCHAR2 Main
Institutions Only.

Institution in the FFEL system.

364-369; 6 FDSLP ID The current number used to identify the VARCHAR2
Main and Additional Locations.

Institution for Direct Loans

370-375; 6 CAMPUS BASED ID The current number used to identify the
VARCHAR2 Main Institutions Only.

Institution in the Campus Based System.

376-376; 1 FDSLP APPROVAL IND Indicates if the School is Approved to
VARCHAR2 Y or N Main and Additional Locations.

participate in Direct Loans.

377-377; 1 FDSLP SCHL CD Direct Loan Code Cycle VARCHAR2 See Table Main
and Additional Locations.

> CYCLE

378-383; 6 FED SCHL CD XREF Cross Reference for Federal School Code.
VARCHAR2 Main and Additional Locations.

# PEPS Daily School File -- Federal School Code Information Record Layout (September 1, 2006)

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

384-385; 2 REGION CD The Main Institutions region code. VARCHAR2 See
Table All Additional Locations will populate

with the same data as the Main School.

386-387; 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.

388-388; 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.

389-550; 162 FILLER Blanks to complete the record length. VARCHAR2
Spaces

**PEPS Weekly School File -- Trailer Record Layout (September 1, 2006)**

**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 99

record in the flat file.

3-10; 8 SORT OPE ID Positional sort field used for sorting NUMBER
99999999

the trailer record to the end of the file.

11-16; 6 TOTAL RECORD The total number of records in the NUMBER

COUNT extract file.

17-22; 6 SCHOOL DETAIL The number of "School Detail" NUMBER

> RECORD COUNT records in the extract file.

23-28; 6 SCHOOL CONTACT The number of "School Contact" NUMBER

RECORD COUNT records in the extract file.

29-34; 6 SCHOOL PROGRAM The number of "School Program" NUMBER

RECORD COUNT records in the extract file.

35-40; 6 SCHOOL IDENTIFIER The number of "School Identifier" NUMBER

RECORD COUNT records in the extract file.

41-46; 6 DIRECT LOAN The number of "School Direct Loan" NUMBER

RECORD COUNT records in the extract file.

47-52; 6 CHANGE OF The number of "School Change of NUMBER

AFFILIATION Affiliation" records in the extract file.

RECORD COUNT

53-58; 6 ACCREDITATION The number of "School Accreditation" NUMBER

RECORD COUNT records in the extract file.

59-64; 6 DEFAULT MGMT The number of "Default Management" NUMBER

RECORD COUNT records in the extract file.

65-70; 6 OTHER ADDRESSES The number of "Other Addresses" NUMBER

RECORD COUNT records in the extract file.

**PEPS Weekly School File -- Trailer Record Layout (September 1, 2006)**

**Position/**

# Length Flat File Field Description Data Type Data Value Comments

71-76; 6 EXPERIMENTAL SITE The number of "Experimental Site" NUMBER

RECORD COUNT records in the extract file.

77-82; 6 SCHOOL CLOSURE The number of "School Closure" NUMBER

RECORD COUNT records in the extract file.

83-88; 6 FEDERAL SCHOOL The number of "Federal School Code" NUMBER

CODE RECORD records in the extract file.

COUNT

89-550; 461 FILLER Blank to complete the record length. VARCHAR2 Spaces