This column is defined in the Degree Definition window and is used to associate each of your awards (Degrees, Certificates, etc.) with the appropriate PESC Award Level code.
The default table values below (Column Name of pesc_acad_award_lvl) are provided for you by Jenzabar.
· The TBL_VALUE_ALT1 values are used by the standard XML Transcript.
· The TBL_VALUE_ALT2 values are used by the standard EDI Transcript.
· If you will be sending both XML and EDI transcripts, choose codes that have values in both the TBL_VALUE_ALT1 and TBL_VALUE_ALT2 columns.
· If you define additional table values, be sure to map them to the default Alternate 1 values and/or default Alternate 2 values.
COLUMN_NAME |
TABLE_VALUE |
TABLE_DESC |
TBL_VALUE_ALT1 |
TBL_VALUE_ALT2 |
PESC_ACAD_AWARD_LVL |
1.1 |
Certificate of completion |
1.1 |
|
PESC_ACAD_AWARD_LVL |
1.2 |
Certificate of proficiency |
1.2 |
|
PESC_ACAD_AWARD_LVL |
2.0 |
Certificate |
2.0 |
|
PESC_ACAD_AWARD_LVL |
2.1 |
Postsec Cert or Diploma (<1 yr) |
2.1 |
2.1 |
PESC_ACAD_AWARD_LVL |
2.2 |
Postsec Cert or Diploma (>=1 yr but <4 yrs) |
2.2 |
2.2 |
PESC_ACAD_AWARD_LVL |
2.3 |
Associate Degree |
2.3 |
2.3 |
PESC_ACAD_AWARD_LVL |
2.4 |
Baccalaureate Degree |
2.4 |
2.4 |
PESC_ACAD_AWARD_LVL |
2.5 |
Baccalaureate (Honors) Degree |
2.5 |
2.5 |
PESC_ACAD_AWARD_LVL |
2.6 |
Postsec Cert or Dipl (>=1 yr but <2 yrs) |
2.6 |
2.6 |
PESC_ACAD_AWARD_LVL |
2.7 |
Postsec Cert or Dipl (>=2 yrs but <4 yrs) |
2.7 |
2.7 |
PESC_ACAD_AWARD_LVL |
3.1 |
First Professional Degree |
3.1 |
3.1 |
PESC_ACAD_AWARD_LVL |
3.2 |
Post-Professional Degree |
3.2 |
3.2 |
PESC_ACAD_AWARD_LVL |
4.1 |
Graduate Certificate |
4.1 |
4.1 |
PESC_ACAD_AWARD_LVL |
4.2 |
Masters Degree |
4.2 |
4.2 |
PESC_ACAD_AWARD_LVL |
4.3 |
Intermediate Graduate Degree |
4.3 |
4.3 |
PESC_ACAD_AWARD_LVL |
4.4 |
Doctoral Degree |
4.4 |
4.4 |
PESC_ACAD_AWARD_LVL |
4.5 |
Post-doctoral Award |
4.5 |
4.5 |
For more information about these Alternate 1 values, see the PESC XML Standards Format for the College Academic Record (Transcript) document available on the Postsecondary Electronic Standards Council (PESC) website (http://www.PESC.org).
For more information about these Alternate 2 values, see the SPEEDE/EXPRESS TS 130 - Student Educational Record (Transcript) document available on the Postsecondary Electronic Standards Council (PESC) website (http://www.PESC.org).