Penn Computing

University of Pennsylvania
Penn Computing << go backback

CEN STDT ACADEMIC PROGRAM Table .Tables and Data Elements . Student Term Census Extract Data Home . Data Warehouse Home

CEN_STDT_ACADEMIC_PROGRAM Table - Data Element Index

Career

A portion of a student's academic history at Penn. A career usually corresponds to the part of a student's academic record that appears on a single transcript. A student can have several careers, for example an undergraduate (U) career, a law (L) career and a PHD (PG) career.

        
Values:

U0 - PRE-BACCALAUREATE
U - UNDERGRADUATE
U2 - UNDERGRADUATE, SECOND DEGREE
UP - POST-BACCALAUREATE
SA - SENIOR ASSOCIATES
SS - SUMMER SESSIONS CF - CERTIFICATE PROGRAM, FELS
MA - MASTER'S LEVEL, ANNENBERG
MB - MASTER'S LEVEL, BIOMEDICAL GRADUATE STUDIES
MC - MASTER'S LEVEL, LPS MAL DEGREE
MD - MASTER'S LEVEL, LPS MCE DEGREE
ME - MASTER'S LEVEL, EDUCATION
MG - MASTER'S LEVEL, ARTS & SCIENCES MGA DEGREE
MI - MASTER'S LEVEL, ENGINEERING INFO TECHNOLOGY
ML - MASTER'S LEVEL, SOCIAL POLICY & PRAC NONPROFIT LDRSHP
MM - MASTER'S LEVEL, ARTS & SCIENCES MMP DEGREE
MN - MASTER'S LEVEL, NURSING
M2 - MASTER'S LEVEL, NURSING - 2ND MASTERS DEGREE
M3 - MASTER'S LEVEL, NURSING - 3RD MASTERS DEGREE
MO - MASTER'S LEVEL, ARTS & SCIENCES MSO DEGREE
MP - MASTER'S LEVEL, PHILOSOPHY
MS - MASTER'S LEVEL, ENGINEERING
MT - MASTER'S LEVEL, ENGINEERING BIOTECHNOLOGY
MV - MASTER'S LEVEL, LPS MES DEGREE
MW - MASTER'S LEVEL, LPS MSG DEGREE
MX - MASTER'S LEVEL, LPS MAP DEGREE MY - MASTER'S LEVEL, LPS MUS DEGREE
MZ - MASTER'S LEVEL, LPS MIS DEGREE
FA - MASTER'S LEVEL, SCHOOL OF DESIGN
FH - MASTER'S LEVEL, FINE ARTS, HARRISBURG
FN - POST-GRADUATE LEVEL, SCH OF DESIGN
NC - POST-GRADUATE LEVEL, LPS
ND - POST-GRADUATE LEVEL, GRAD ARTS & SCI.
NM - POST-MASTER'S PROGRAM, NURSING
N2 - POST-MASTER'S PROGRAM, 2ND NURSING PROGRAM
N3 - POST-MASTER'S PROGRAM, 3RD NURSING PROGRAM
NW - NON-DEGREE PROGRAM, WHARTON GRADUATE
WG - MASTER'S LEVEL, WHARTON
GX - EXECUTIVE MSE PROGRAM
D1 - CERT. PROGRAM - DYNM ORG LEADERSHIP STUDIES
D2 - CERT. PROGRAM - DYNM ORG COACHING STUDIES
D3 - CERT. PROGRAM - DYNM ORG DEVEL & CHANGE STUDIES
D4 - CERT. PROGRAM - DYNM ORG PROJECT MGMT STUDIES
D5 - CERT. PROGRAM - DYNM ORG GLOBAL ORGANZTN STUDIES
D6 - CERT. PROGRAM - DYNM ORGANIZATIONAL DYNAMICS STUDIES
PG - PHD, GAS PA - PHD, ANNENBERG
PE - PHD, EDUCATION
PS - PHD, ENGINEERING
PF - PHD, SCHOOL OF DESIGN
PB - PHD, BIOMEDICAL
PN - PHD, NURSING
PP - PHD, SOCIAL POLICY & PRACTICE
PW - PHD, WHARTON
PM - PHD/MD, WHILE IN ARTS & SCIENCES
PD - PHD/MD, WHILE IN SEAS
PV - PHD/VMD, WHILE IN ARTS & SCIENCES
DE - DOCTORATE, EDUCATION
DN - DOCTORATE, NURSING
SP - MASTER'S LEVEL, SOCIAL POLICY
SW - SOCIAL POLICY & PRACTICE
D - DENTAL MEDICINE
L - LAW
V - VETERINARY MEDICINE
M - MEDICINE
1 - DUAL DEGREE DSW/AM
2 - DUAL DEGREE MSN/AM
3 - DUAL DEGREE MSE/MBA
10 - JOINT DEGREE GAS/ASP
11 - JOINT DEGREE GAS/BMP
12 - JOINT DEGREE GAS/EDP
13 - JOINT DEGREE GAS/GEP
14 - JOINT DEGREE GAS/GFP
15 - JOINT DEGREE GAS/NUP
16 - JOINT DEGREE GAS/SWP
17 - JOINT DEGREE GAS/WHP
18 - JOINT DEGREE GAS/LWP
19 - JOINT DEGREE ASP/BMP
20 - JOINT DEGREE ASP/EDP
21 - JOINT DEGREE ASP/GEP
22 - JOINT DEGREE ASP/GFP
23 - JOINT DEGREE ASP/NUP
24 - JOINT DEGREE ASP/SWP
25 - JOINT DEGREE ASP/WHP
26 - JOINT DEGREE ASP/LWP
27 - JOINT DEGREE BMP/EDP 28 - JOINT DEGREE BMP/GEP
29 - JOINT DEGREE BMP/GFP
30 - JOINT DEGREE BMP/NUP
31 - JOINT DEGREE BMP/SWP
32 - JOINT DEGREE BMP/WHP
33 - JOINT DEGREE BMP/LWP
34 - JOINT DEGREE EDP/GEP
35 - JOINT DEGREE EDP/GFP
36 - JOINT DEGREE EDP/NUP
37 - JOINT DEGREE EDP/SWP
38 - JOINT DEGREE EDP/WHP
39 - JOINT DEGREE EDP/LWP
40 - JOINT DEGREE GEP/GFP
41 - JOINT DEGREE GEP/NUP
42 - JOINT DEGREE GEP/SWP
43 - JOINT DEGREE GEP/WHP
44 - JOINT DEGREE GEP/LWP
45 - JOINT DEGREE GFP/NUP
46 - JOINT DEGREE GFP/SWP
47 - JOINT DEGREE GFP/WHP 48 - JOINT DEGREE GFP/LWP
49 - JOINT DEGREE NUP/SWP
50 - JOINT DEGREE NUP/WHP
51 - JOINT DEGREE NUP/LWP
52 - JOINT DEGREE SWP/WHP
53 - JOINT DEGREE SWP/LWP
54 - JOINT DEGREE WHP/LWP
Classification_Credit Total number of Registered_Credits for ungraded courses, Earned_Credits and Transfer_Credits for all prior terms for this academic program. The data for this data element is generated by the system (SRS), and is used in the calculation of classification for undergraduates. For example: a student may have 18.0 Registered_Credits.

See also Classification in the CEN_STDT_ACADEMIC_PROGRAM Table.

Classification

The student's classification in this program; for example, FR means Freshman. For undergraduates, classification is system-maintained, based on accumulation of earned credit; for graduate and professional students, it is maintained by the student's division.

	  Values:
	       PBA - POST-BACCALAUREATE (CGS)
        PRB - PRE-BACCALAUREATE (CGS)
        FR - FRESHMAN
        SO - SOPHOMORE
        JR - JUNIOR
        SR - SENIOR
        ND - UNDERGRADUATE, NON-DEGREE
        G - GRADUATE
        GM - GRADUATE, MASTER'S CANDIDATE
        GC - GRADUATE, PHD CANDIDATE
        P - PROFESSIONAL
        P1 - PROFESSIONAL, FIRST LEVEL
        P2 - PROFESSIONAL, SECOND LEVEL
        P3 - PROFESSIONAL, THIRD LEVEL
        P4 - PROFESSIONAL, FOURTH LEVEL
        P5 - PROFESSIONAL, FIFTH LEVEL
        P6 - PROFESSIONAL, SIXTH LEVEL
        L1 - LAW, FIRST YEAR
        L1A - LAW, FIRST YEAR (SECTION A)
        L1B - LAW, FIRST YEAR (SECTION B)
        L2 - LAW, SECOND YEAR
        L3 - LAW, THIRD YEAR
      
Cohort_Group

The Cohort flag provides a way (in addition to classification) for divisions to group students within an academic program.

Note that there is no standard definition for the use of any cohort value: the schools and divisions use this data element internally, and each has their own definition of what it means to them.

Values:
- NO COHORT IDENTIFICATION
A - COHORT GROUP A
B - COHORT GROUP B
C - COHORT GROUP C
D - COHORT GROUP D
E - COHORT GROUP E
F - COHORT GROUP F
G - COHORT GROUP G
H - COHORT GROUP H
I - COHORT GROUP I
J - COHORT GROUP J
K - COHORT GROUP K
S - SCHOOL DISTRICT
X - NOT SCHOOL DISTRICT
1 - DINAR
2 - DOLLAR
3 - EURO
4 - PESO
5 - RAND
6 - RUPEE 7 - SHEKEL
8 - YEN
9 - YUAN

Degree_Awarded

The degree awarded by the University of Pennsylvania. A degree is an academic title pursued through a division of a school, and awarded by the University of Pennsylvania. It is possible for the degree awarded to be one other than the degree pursued. For example: a student pursuing a PHD may be awarded an AM and then possibly continue pursuit of the PHD.

Values:

Refer to the DEGREE table.

Degree_Expected_Term The term in which the division or department responsible for this student expects this student to receive this degree. If the student is no longer expected to receive the degree, this value may no longer be accurate. For example: a department expects this student to receive this degree in 2001A (Spring 2001).

See also Exit_Action in the CEN_STDT_ACADEMIC_PROGRAM Table.

Degree_Level The academic level of this degree.

Values:

U     Undergraduate
M     Masters Level
D     Doctorate
P     Professional
Degree

The degree pursued by this student during this term. A student may pursue more than one degree during the same term. A degree is an academic title pursued through a division or a school, and awarded by the University of Pennsylvania. For example: BA (Bachelor of Arts).

Values:

Refer to the DEGREE table.

Division Identifies the particular division associated with this student's academic program. A division is an administrative sub-unit of a school. Schools at Penn can be composed of one or more divisions. A division oversees students as they pursue degrees within that division.

Examples of Division code include COL (College of Arts and Sciences), NUR (Nursing Undergraduate), GFP (Fine Arts Graduate) and GEX (Engineering and Applied Science Executive).

Values:

Refer to the DIVISION table.

Dual_Degree_Type For students pursuing two degrees, this indicates the relationship between the primary and secondary degrees. A Dual Degree student is pursuing two degrees: both at either the undergraduate level or the non-undergraduate level. A Sub-Matric student is pursuing two degrees: one at the undergraduate level and one at the non-undergraduate level. For example: a Dual Degree student can pursue a Bachelor of Science in Engineering from the Engineering School and a Bachelor of Science from the Wharton School.

Values:

[Null]     Only pursuing one degree
D          Dual Degree
J          Joint Degree
S          Sub-Matric
Entry_Action How a student was admitted to this academic program. For example: RA (Readmitted) or AD (Regular Admit).

Values:

AD - REGULAR ADMIT
AE - ADMIT - EXCHANGE STUDENT AJ - ADMIT TO JOINT DEGREE PROGRAM
AS - SUBMATRIC ADMIT
AT - TRANSFER ADMIT AV - ADMIT-VISITING STUDENT AX - ADMIT-EXTERNAL SUBMATRIC CP - CONTINUING PHD
DD - ADMIT TO DUAL PROGRAM
RA - READMITTED
RI - REINSTATED
- SHOULD BE USED ONLY WITH JUDICIAL
- SUSPENSIONS; PRINTS ON TRANSCRIPT
RL - RETURN FROM LEAVE
TR - INTERNAL TRANSFER
CO*- CONTINUING REGISTRATION
Entry_Term The term the student first enrolled in classes for this division and degree. For example: 1993C (Fall 1993). This may not be the student's first term at Penn.
Exit_Action_Date The date of the Exit_Action that concludes this academic program for this student. Note that because the Census snapshot is taken in the middle of the term, most exit information will be preliminary, and may not reflect the actual exits for that term.
Exit_Action_Reason The reason for the Exit_Action that terminated this academic program. Note that because the Census snapshot is taken in the middle of the term, most exit information will be preliminary, and may not reflect the actual exits for that term.
	  Values:
        AC - ACADEMIC
        AI - ACADEMIC INTEGRITY
        CU - CURRICULAR
        CR - CAREER/WORK RELATED
        DE - DECEASED
        EN - ENVIRONMENT, DISLIKES
        FI - FINANCIAL
        IA - INACTIVITY
        MB - MISBEHAVIOR
        MD - MEDICAL
        MS - MILITARY SERVICE
        NC - NON-CORRESPONDENCE
        ND - NO REASON FROM DIVISION
        NS - NO REASON FROM STUDENT
        NL - NOT RETURNED FROM LEAVE
        PA - PER ADMISSIONS OFFICE
        PE - PERSONAL
        PG - PENDING GRADUATION
        PR - NO REASON (CONVERSION)
        SA - STUDY ABROAD
        SD - STUDY DOMESTIC
        ST - STRESS/MOTIVATIONAL
        TR - TRAVEL
        VE - VISA EXPIRATION<
      
Exit_Action How a student concludes this academic program. For example: EG (Expected Graduation) or GD (Graduation). This data element is null until the degree pursual is completed unless the student is on leave (for example, AL). Note that student leaves do not necessarily end an academic program. Also, because the Census snapshot is taken in the middle of the term, most exit information will be preliminary.This use of Exit_Action differs from the use of Exit_Action in the DEGREE_PURSUAL_ALL_V Table.

See also Exit_Action in the DEGREE_PURSUAL_ALL_V Table.

See also the LEAVE Table.

	  VALUES:
	       AL - ADMINISTRATIVE LEAVE OF ABSENCE
        AW - WITHDRAWN BY DIVISION
        CA - CANCELLED BY ADMITTING OFFICE
        CP - COMPLETED CERTIFICATION PROGRAM
        DF - DEFERRED ADMISSION
        DR - DROPPED BY DIVISION
        ED - WITHDREW FROM DUAL DEGREE PROGRAM
        EG - EXPECTED GRADUATION
        EP - END OF PROGRAM
        FL - FOR LIBRARY
        JE - JUDICIAL EXPULSION (ON TRANS)
        JS - JUDICIAL SUSP (ON TRANS)
        JX - JUDICIAL SUSP (NO TRANS)
        LV - LEAVE OF ABSENCE
        NS - NO SHOW
        PD - DROPPED FROM PROGRAM
        PW - WITHDREW FROM PROGRAM
        TR - INTERNAL TRANSFER
        WD - WITHDREW
        WT - WITHDREW TO TRANSFER
        GD*- GRADUATION
        CD*- GRADUATION (CONVERSION)
      
Exit_Term The last term the student is eligible to register for courses for this academic program. If the student graduates, Exit_Term is set by the system (SRS) to the student's enrolled term. For example: 2000A (Spring 2000). Note that because the Census snapshot is taken in the middle of the term, most exit information will be preliminary, and may not reflect the actual exits for that term.
Final_Action If an exit action is entered while a student is on leave of absence, it will appear here. Note that because the Census snapshot is taken in the middle of the term, most exit information will be preliminary, and may not reflect the actual exits for that term.
Final_Action_date The date of the Final Action, if any. Note that because the Census snapshot is taken in the middle of the term, most exit information will be preliminary, and may not reflect the actual exits for that term.
Expected_Return_Term The term that the student is expected to return to this academic program, if appropriate. For example: the student may have taken a leave of absence, and be planning to return in a future term, 2000C (Fall 2000).
Graduation_Checkout_Status Indicates a student's progress through graduation checkout for this academic program. For example: 3 (the student has paid the diploma fee and has applied for graduation).

Values:

[Null]     Not Applied
1          Paid Diploma Fee
2          Applied For Graduation
3          Paid Diploma Fee & Applied For Graduation
4          Cleared Academically Not Financially
5          Cleared For Graduation
A          Applied For Degree Audit
C          Degree Audit Completed
Graduation_Checkout_Term If the student has been cleared for graduation, this field will have the term that is effective, in SRS Term format (YYYYT).
Max_Load The maxiumun credit units this student was allowed to register for, in the specified term.

Penn_Id
The 8-digit identification number assigned to the student by the PENNcard system. No two persons have the same Penn_ID. Only persons affiliated with the University will be assigned a Penn_ID.

Previous_institution

The code for the school, college or university where the student attended prior to coming to Penn. . May be null.

See the INSTITUTION table for decoded balues

Program_order

The number that indicates the order of the degree program. It is used to distinguish two degrees, for those students who are pursuing multiple degrees at the same time.

1 = Primary program
2 = Secondary program

School
The school that administers the academic program. An academic program is a specific combination of division, degree sought, and major.

Values:

Refer to the SCHOOL table.

Special_Program Further specifies academic programs that cannot be defined solely by the combination of division, degree, major and concentration.

Values beginning with "A" refer to penn students on study abroad programs at other institutions and, if used, will keep the students from being billed.

Values beginning with "B" refer to penn students on Office of International Programs study abroad programs at other institutions and, if used, will bill the student based on tables in the student financial services system.

Values beginning with "C" refer to CGS non-degree programs.

Values beginning with "E" refer to School of Education divisions.

Values beginning with "F" refer to foreign students from other institutions on study abroad programs at penn. By using this code the students will not be billed, will appear on the CER/RCR report under the non-billable column, and will not be included in the tuition distribution process. They will continue to be included in the headcount enrollment reports, degree and course enrollment reports.

Values beginning with "L" refer to Law School/Wharton gradraduate certitification programs.

Values beginning with "T" refer to special program codes that need to have exceptions made for them in the tuition calc program.

Values beginning with "W" refer to study away from penn that are not study abroad programs and the WEMBA East and West programs.

Values beginning with "X" refer to the Bryn Mawr, Swarthmore and Haverford consortium programs and will be used only for students who have spent an entire semester at one of these schools.

For a list of Values, decode descriptions, and the "active/inactive"flag for Special Programs: see the SPECIAL_PROGRAM table.

Ssn
The student's Social Security number; currently used by Penn as the student's identification number. A Social Security number is a unique number assigned to an individual by the federal Social Security Administration. This is a 9-digit numeric character without dashes, for example, 777777777. For foreign students and students who have requested not to use their Social Security number, this number is assigned by Penn.
Term The term, as of the Census Date, for which these data are valid. Penn divides the academic year into 3 terms: Fall, Spring, and Summer. Terms are designated by the 4-digit calendar year, followed by a term code. The Spring term code is C, the Summer term code is B, and the Fall term code is C. For example: the information is valid for 1995C (the 1995 Fall term).

 

Term_entry_action For students starting a program in this term, this will be that same as Entry_Action. For continuing student, the value in this field will be CO (Continuing).

 

CEN STDT ACADEMIC PROGRAM Table .Tables and Data Elements . Student Term Census Extract Data Home . Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania