| 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
|
