Chapter 2: Conversion Specification from Faster Postsecondary P07 Format to SPEEDE Format
  FASTER P07 - Degree Segment Format
Contains the degree information tied to a particular term		   SPEEDE Conversion Specifics
Segment Name, Position and Data Elements Populated
(See SPEEDE/ExPRESS Manual)
  P07 - Item 1
Record Type = P07		    
  P07 - Item 2
Social Security Number -- ignored		  
  P07 - Items 3-4
Term Designator and Term Tag

P07 Term Designator and Tag determine whether to generate a PCL (Previous College) segment and NTE segments in Table 1 or a DEG (Degree) loop.
 

  
 
0000000 = P07 records prior to first P02 record
 
PCL segment at position 1/070
NTE segment at position 1/080
 
9999990 = P07 records following the last P03 record
 
PCL segment at position 1/070
NTE segment at position 1/080
 
other P07 records inside a P02 loop
 
DEG segment at position 2/310
FOS segment at position 2/330
N1 segment at position 2/335
NTE segment at position 2/340
  P07 - Item 5
Degree Level		   SST segment at position 1/220
ATV segment at position 1/265
-OR-
PCL segment at position 1/070
-OR-
DEG segment at position 2/310 and possibly
FOS segment at position 2/330 (see Item 8)
 
  HIGH SCHOOL
 
G = GED
 
NTE Segment
 
H = High School Diploma
 
 
U = College Ready Diploma
 
  POSTSECONDARY UNDERGRADUATE   PCL05 or DEG01 - Academic Degree Code
DEG04 - title of Degree = degree literal
 
 
K =

Certificate, AS
3 =   Postsecondary certificate or diploma (less than one year)
7 =   Certificate of Professional Preparation 		 
2.1 - Postsecondary certificate or diploma (less than one year)
 
 
Q = Other (Undergraduate)
 
 
2.2 - Postsecondary Certificate or Diploma (one year or more, but less than four years)
 
 
5 = Educator Preparation Institute
 
 
2.2 - Educator Preparation Institute (one year or more, but less than four years)
 
 
A = Associate in Arts, AA and
C = Associate in Science, AS and
J = Associate Degree, AA/AS unknown and
Y = Associate in Applied Science
1 = Associate in Science, Statewide Articulated AS
8 = Specialized Associate in Arts Transfer
 
 
2.3 - Associate Degree (e.g., Associate in Arts, Associate in Science, Associate in Applied Science)
 
B = Baccalaureate
 
 
2.4 - Baccalaureate Degree
 
I =

Advanced Technical Certificate
2 =

Advanced Technology Diploma
4 =

Postsecondary certificate or diploma (one year or more but less than two years
 
2.6 - Postsecondary certificate or diploma (one year or more but less than two years)
 
 
F = Dentistry, DDS or DMD
L = Law, LLB or JD
V = Veterinary Medicine, DVM
W = Pharmacy (Pharmd)
X = Medicine, MD
P = First Professional (other than F, L, V, W or X)
 
 
3.1 - First Professional Degree
  POSTSECONDARY GRADUATE   PCL05 or DEG01 - Academic Degree Code
DEG04 - title of Degree = degree literal
 
 
O = Other (Postsecondary Graduate)
 
2.6 - Postsecondary certificate or diploma (one year or more but less than two years)
 
 
T = Certificate
 
 
4.1 - Graduate Certificate
 
 
M = Master's and
E = Advanced Master's
 
 
4.2 - Master's Degree
 
S = Specialist
R = Engineer
 
 
4.3 - Intermediate Graduate Degree
 
D = Doctorate
 
 
4.4 - Doctoral Degree
  Not mapped
N = No Degree
Z = Not Reported
  Not used
2.5 = Baccalaureate (Honours) Degree
2.7 = Postsecondary certificate or diploma (two years or more but less than four years)
3.2 = Post-Professional Degree
4.5 = Post-Doctoral Degree
 
Additional Codes needed from SP/Ex
??? = Post Masters
  P07 - Item 5a
Institution Code Qualifier		  
73 = FICE Code
OP = OPEID Code
ZZ = Unknown
  PCL segment at position 1/070
-OR-
N1 segment at position 2/335
   
  P07 - Item 6
Number of Institution (FICE)		   PCL segment at position 1/070
-OR-
N1 segment at position 2/335
 
= 9999999 - The FICE code of the institution does not exist or is not known
 
  Ignored
  If creating PCL segment  
PCL01 = 73 - Federal Interagency Commission on Education (FICE) number
PCL02 = actual value sent
 
  If creating DEG Loop within SES  
N101 = OS - Override Institution
N102 = blank
N103 = 73 - Federal Interagency Commission on Education (FICE) number
N104 = actual value sent
  P07 - Item 7
Degree Date
Format: MMDDYYYY or YYYY		   PCL segment at position 1/070
-OR-
DEG segment at position 2/310
 
 
 
PCL06: date reformatted to CCYY
-OR-
DEG02 = D8 - CCYYMMD
-OR-
DEG02 = CY - CCYY
DEG03 = date reformatted
  P07 - Item 8
Program Code		   FOS segment at position 2/330 or
NTE segment at position 2/340
 
 
= blank
 
Ignored (no segments written)
 
 
= nonblank AND Degree Level (item 5) is A, C, J, Y, or 1
 
FOS01 = M - Major
FOS02 = 81 - Classification of Instructional Programs (CIP) coding structure
FOS03 = actual value sent (no decimal)
 
 
= nonblank AND Degree Level (item 5) is NOT A, C, J, Y, or 1
 
NTE02 = 'CIP Code: ' followed by actual value sent formatted 99.9999 (includes decimal)
  P07 - Items 9-31
Comments Fields 1-24
Format: A/N 40		   NTE segments at position 1/080 following PCL
-OR-
NTE segments at position 2/340 in DEG loop
NTE02 - Description, Format: A/N 80
  P07 - Item 32
Honors Level of Degree		   DEG segment at position 2/310
 
DEG05 - Honors Level of Degree
 
B35 = Awarded with highest honors available
 
B35 - Highest Honors
 
B36 = Awarded with the second highest honors available
 
B36 - Second Highest Honors
 
B37 = Awarded with the third highest honors available
 
B37 - Third Highest Honors
  P07 - Item 33
Student Teaching Program		   Ignore
 
 
Y = Student has completed a Student Teaching Program
 
 
 
N = Student has not completed a Student Teaching Program
 
 
 
U = Unavailable
 
 
  P07 - Item 34
Teaching Ed Program		   Ignore
 
 
Y = Student has completed a State Approved Teacher Education Program
 
 
 
N = Student has not completed a State Approved Teacher Education Program
 
 
 
U = Unavailable
 
 
  P07 - Items 35-36
Filler		  

More...