Penn Computing

University of Pennsylvania
Penn Computing << go backback

Back to Clickable Table Diagram

SRS_Degree_Pursual Table - Data Element Index

The SRS_Degree_Pursual table contains degree information for students. A maximum of four degree pursual records per student can be held in this table. The priority is open, future and past.

Select a data element to view its definition and its indexed, format, and null values.


 

top

Data element Definition
AFFILIATION_CODE

Indexed - no
Format - varchar2 (4)
May be null? yes

Code used to identify an affiliation of a member of Penn Community.  Affiliations are a form of association to the university.  Certain affiliations are assigned only by specific sources; for instance, a student affiliation is only added by a load process from the Student Record System (SRS). The only affiliation that currently displays here is 'STU.'

DEGREE

Indexed - no
Format - varchar2 (3)
May be null? yes

The degree that the student is pursuing. A student may pursue more than one degree at a time. A degree is an academic title pursued through a division of a school. For example, students can pursue a Bachelor of Arts degree through the division of The College of Arts and Sciences; students can pursue a PhD through the Graduate division of Arts and Sciences. Both divisions are within the same school, but the College does not grant PhDs and GAS does not grant BAs.

top

DISP_PENN_FLAG

Indexed - no
Format - varchar2 (1)
May be null? yes

Flag that determines if the student record is available in the Directory Penn (Authenticated) View.

 

top

DISP_PUB_FLAG

Indexed - no
Format -varchar2 (1)
May be null? yes

Flag that determines if the student record is available in the Directory Public View.

 

top

DIVISION

Indexed - no
Format - varchar2 (3)
May be null? yes

The division code associated with this degree record. A division is an administrative sub-unit of a school in the University in which students pursue degrees. Each degree program and the courses and other requirements particular to that degree are associated with a distinct division. There can be several divisions in any school. For example: in the Wharton school, full-time day undergraduate students are in the WH (Wharton Undergraduate) division, whereas part-time evening undergraduate students are in the EVE (Wharton Evening) division.

top

ENTRY_ACTION_CODE

Indexed - yes
Format - varchar2 (2)
May be null? yes

Indicates the type of action that caused this Degree_Pursual to be opened for this student. In some cases, RA (Readmit) and RI(Reinstate) may appear.

Values:

AD Regular Admit
AE Admit - Exchange Student
AJ ADMIT TO JOINT DEGREE PROGRAM
AS Submatric Admit
AT Transfer Admit
AV Visiting Student Admit
DD Admit to Dual Degree
DT Degree Transfer within Division (used in the warehouse only*)
RA Readmitted
RI Reinstated (for judicial suspensions only)
RL Return from Leave
TR Internal Transfer

top

ENTRY_TERM

Indexed - no
Format - varchar2 (5)
May be null? yes

The term the student first enrolled in classes for this division and degree. This may not be the student's first term at Penn.

Penn divides the academic year into 3 terms or semesters: Fall, Spring, and Summer. Terms are designated by the 4-digit calendar year, followed by a term code. The Spring term code is A, the Summer term code is B, and the Fall term code is C.


For example: 1995C means Fall 1995, 1996A means Spring 1996, 1996B means Summer 1996.

top

EXIT_ACTION_CODE

Indexed - no
Format - varchar2 (2)
May be null? yes










The action that concludes this Degree_Pursual for this student. This field is null until the degree pursual is completed.

Values:

AW Withdrawn by Division
CP Completed Certification Program
DF Deferred admissions
DR Dropped by Division
DT Degree Transfer within Division (used in the warehouse only)
ED Withdrew from Dual Degree Program
EP End of program
FL Family Leave
GD Graduated
GF An indication that this degree record has been deleted from SRS.
JE Judicial expulsion (on transcript)
JS Judicial suspension (on transcript)
JX Judicial suspension (not on transcript)
LV Leave
PD Dropped from program
PW Withdrew from program
TR Internal transfer
WD Withdrew
WT Withdrew to transfer

top

EXIT_REASON_CODE

Indexed - no
Format - varchar2 (2)
May be null? yes

The code for the reason given for the exit action that concludes this Degree Pursual for this student. Not every exit action has a reason. For example, the Exit Action "GD" (graduation) does not have any corresponding reason. This field is held only for downstream systems - this field will not display in Penn Community.

See also Exit_Action in the DEGREE_PURSUAL_ALL_V Table.

top

EXIT_TERM

Indexed - no
Format - varchar2 (3)
May be null? yes

The last term the student pursued this degree in this division. The value may be null if the student has not exited the degree program.

top

EXPECTED_DEGREE_DATE

Indexed - no
Format - varchar2 (4)
May be null? yes

The term in which the division or department responsible for this student expects this student to receive the his or her degree. If the student is no longer expected to receive the degree, this value may no longer be accurate. 

top

FT_PT_CODE

Indexed - no
Format - varchar2 (1)
May be null? yes

Indicates the time status of the student, based on the number of courses for which a student is registered, and the rules established for the student's Division.  This field's population is dependent upon the TIME_STATUS_OVERRIDE_FLAG in SRS.

top

ID

Indexed - yes
Format - number (12)
May be null? no

The unique sequential number for the record in the srs_degree_pursual table.

top

MAJOR_CODE

Indexed - no
Format - varchar2 (4)
May be null? yes

The code for a major. A major is the academic area which makes up a major component of a student's work. For graduate programs, this is the graduate group. For example: a student may have a major in ENGL (English). 

 

top

MATRIC_DATE

Indexed - no
Format - varchar2 (4)
May be null? yes

The date of the student's entry term in YYMM format.  This date is specific to the student's primary school Academic Program Segment. 

top

PENN_ID

Indexed - yes
Format - number (8)
May be null? no

A unique 8-digit number, sequentially generated in the Penn Community database whenever a new member of the Penn Community is identified.  PENN encourages the use of the Penn ID instead of SSN whenever possible.

top

PRIMARY_FLAG

Indexed - no
Format - varchar2 (1)
May be null? yes

Indicates the primary degree pursual for a student. This is the affiliation found in the affiliation table.

Values:

P PRIMARY
S SECONDARY
A PRIMARY IS NOT DESIGNATED

top

PURSUAL_SEQ

Indexed - yes
Format - number (2)
May be null? no

A 1-digit number that distinguishes one degree pursual record from another for the student. The primary degree pursual equals a '0' pursual_seq.

top

ROW_CREATED_BY_ID

Indexed - no
Format - varchar2 (8)
May be null? yes

The Penn ID or Oracle name responsible for creating this row.


top

ROW_CREATED_BY_PGM

Indexed - no
Format - varchar2 (30)
May be null? yes

The name of the software object responsible for creation of the row.

top

ROW_CREATED_DATE_TIME

Indexed - no
Format - DATE
May be null? yes

Date/time of row creation.

 

top

ROW_LAST_UPD_BY_ID

Indexed - no
Format - varchar2 (8)
May be null? yes

The Penn ID or Oracle name responsible for updating this row.

top

ROW_LAST_UPD_BY_PGM

Indexed - no
Format - varchar2 (30)
May be null? yes

The name of the software object responsible for updating the row.

 

top

ROW_LAST_UPD_DATE_TIME

Indexed - no
Format - DATE
May be null? yes

Date/time of this row's last update.

 

top

STATUS_CODE

Indexed - no
Format - varchar2 (30)
May be null? yes

Code that indicates the status of this degree pursual. To determine whether a person has an active student affiiation, see affiliation.active_code.

Values:

O OPEN (Current)
C CLOSED (Not Current)
F FUTURE

top

STUDENT_CLASS

Indexed - no
Format - varchar2 (4)
May be null? yes

The student's classification in this program. 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. Example:      FR means Freshman. 

Values

FR Freshman
G Graduate
GC Graduate, PhD candidate
GM Graduate, Master's candidate
JR Junior
L1 Law, first year
L1A Law, first year (SECTION A)
L1B Law, first year (SECTION B)
L2 Law, second year
L3 Law, third year
ND Undergraduate, non-degree
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
PBA Post-Bacclaureate (CGS)
PRB Pre-Baccalaureate (CGS)
SA Senior Associate
SO Sophomore
SR Senior

top

Back to Clickable Table Diagram

 


Documentation Contact: penncommunity@isc.upenn.edu

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