Penn Computing

University of Pennsylvania
Penn Computing << go backback

PHD_DISSERTATION Table . Tables and Data Elements . Student Data Home . Data Warehouse Home

PHD_DISSERTATION - Data Element Index

Adv_to_Cand_Date

RQ46J ADVANCE CANDIDCY DT

NATURALALIAS: ADVCAND-DT-RQ

Appears on SRS screen 144

The date the student advanced to doctoral candidacy.

 

Dissertation_Title

RQ527 DISSERTATION TITLE

NATURAL ALIAS: DISS-TITLE-RQ

Appears on SRS screen 146

The title of the PhD candidate's dissertation.

 

Masters_Final_Exam_Date

RQ4FD AM/MS EXAM DATE

NATURAL ALIAS: AMMS-DT-RQ

Appears on SRS screen 144

The date the AM/MS candidate passed the final exam.

See also Masters_Final_Exam_Date in the MASTERS_THESIS table.

Oral_Exam_Date

RQ44E ORAL EXAM DATE

NATURAL ALIAS: ORL-EXM-DT-RQ

Appears on SRS screen 144

The date the PhD candidate passed the oral PhD exam.

 

Dissertation Defense Date

RQ46L ORAL DEFENSE DATE

NATURAL ALIAS: ORAL-DEF-DT-RQ

appears on screen 144

NOTE: this column is called Dissertation Defense Date in the STDTCANQ universe, and the label on SRS screen 144 is Dissertation Defense Date. However in ADABAS this is called ORAL DEFENSE DATE, and in Oracle, the column is named oral_defense_date.

 

Penn_ID
 
appears on SRS screen 103

The 8-digit identification number assigned to the student when their record was created in the PennCommunity database. No two persons have the same Penn_ID. Only persons affiliated with the University will be assigned a Penn_ID.

Penn_ID is not stored in SRS, but can be used on screen 103 to look up a student. It is populated in the Data Warehouse from a extract from PennCommunity.

Note that because the SSN is still the record key in SRS, it is possible for two records to accidentally get created in SRS with different SSNs, for the same person. When this happens, there will be two different records in the Data Warehouse with the same PennID. Please report all PennID duplicates to either Data Administration, or the Office of the University Registrar.

Prelim_Exam_Date

RQ44D PRELIM EXAM DATE

NATURAL ALIAS: PREXM-DT-RQ

Appears on SRS screen 144

The date the PhD candidate passed the preliminary qualifying exam.
Defense of Proposal

RQ45B PRELIM2 EXAM DATE

NATURAL ALIAS: PREXM2-DT-RQ

Appears on SRS screen 144

The date the PhD candidate passed the preliminary qualifying exam. (NOTE: this column is called "Defense of Proposal" in the Business Objects STDTCANQ universe. It also appears as "Defense of Proposal" on SRS screen 144. However, in ADABAS this is called Prelim2 Exam Date, and in Oracle, the column is named prelim_exam_date2.)
Qualifications_Exam_Date

RQ4FB PHD QUAL EVAL DATE

NATURAL ALIAS: EVAL-DT-RQ

Appears on SRS screen 144

 

The date the PhD candidate passed the qualifications exam.
Research_Required

RQ46H RESEARCH NOT REQUIRD

NATURAL ALIAS: RESREQ-NOREQ-RQ

Appears on SRS screen 144

Indicates whether or not there is a Research Requirement for this PhD candidate.

Values:

  - NONE SPECIFIED
N - RESEARCH REQ NOT REQUIRED
       
Research_Req_Satisfied_Date

RQ46F RESEARCH REQMT DATE

NATURAL ALIAS: RESREQ-DT-RQ

Appears on SRS screen 144

 

The date the Research Requirement was satisfied.
Research_Req_Waived

RQ46G RESEARCH REQMT WAIVE

NATURAL ALIAS: RESREQ-WV-RQ

Appears on SRS screen 144

Indicates whether or not the Research Requirement was waived for this PhD candidate.

Values:

  - NONE SPECIFIED
Y - RESEARCH REQUIREMENT WAIVED

SSN

AA005 STUDENT ID

NATURAL ALIAS: SID-AA

the record key for all student data in SRS; appears in the context line of all student-related screens

For students who are United States citizens or permanent residents, the Student ID number in SRS is generally the Social Security number of this student. A Social Security number is a unique number assigned to an individual by the federal Social Security Administration.

For foreign students and a few other exceptions, the value in this column may be a Penn-assigned ssn.

Note: Never release a student's Social Security number to anyone without the student's permission. Whenever possible, do not include SSN in your query results, and if you must do so, you do so with the full knowlege that you will be held responsibile for the careful maintenance of any datafiles, reports or other stored data containing SSNs.

Please see http://www.upenn.edu/privacy/ for more about the University's policies and general cautions regarding the use of SSNs.

Teaching_Required

RQ46B TEACHING NOT REQUIRD

NATURAL ALIAS: TEACHING-NO-REQ-RQ

Appears on SRS screen 144

Indicates whether or not there is a Teaching Requirement for this PhD candidate.

Values:

  - NONE SPECIFIED
N - TEACHING REQ NOT REQUIRED
Teaching_Req_Satisfied

RQ46C TEACH REQM SATISFIED

NATURAL ALIAS: TCH-REQSAT-RQ

Appears on SRS screen 144

Indicates whether or not the Teaching Requirement has been satisfied by this graduate student.

Values:

  - NONE SPECIFIED
Y - TEACHING REQUIREMENT SATISFIED
       
Teaching_Req_Waived

RQ4F5 TEACHING REQMT WAIVE

NATURAL ALIAS: TEACH-WVD-RQ

Appears on SRS screen 144

Indicates whether or not the Teaching Requirement was waived for this graduate student.

Values:

  - NONE SPECIFIED
Y - TEACHING REQUIREMENT WAIVED
Teaching_Terms_Waived

RQ46D TEACH NUM TERMS WAIV

NATURAL ALIAS: TCH-TRMS-WV-RQ

Appears on SRS screen 144

Indicates the number of terms of teaching requirement, if any, that were waived for this graduate student.

Values:

  - NONE SPECIFIED
1 - ONE TERM WAIVED
2 - TWO TERMS WAIVED
3 - THREE TERMS WAIVED
     
Transcript_Print

RQ523 DISSRTN TRANS PRINT

NATURAL ALIAS: DISS-TRANSP-RQ

Appears on SRS screen 146

Indicates whether or not the thesis information can be printed on the transcript.

Values:

   - No, do not print to transcript
 Y - Yes, print to transcript

PHD_DISSERTATION Table . Tables and Data Elements . Student 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