Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_THESIS_DISSERTATION Table . Pennant Student Records Home . Data Warehouse Home

ST_THESIS_DISSERTATION Table - Data Element Index

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

Data element Definition
Acceptance_Date

Indexed - no
Format - Date
May be Null? Y

Acceptance date for qualifying paper (masters' thesis or dissertation). Source field: SHRQPNM_ACCP_DATE

Activity_Date

Indexed - no
Format - Date
May be Null? Y

The last date any part of this record was updated in the source. Source field: SHRQPNM_ACTIVITY_DATE.

Application_Date

Indexed - no
Format - Date
May be Null? Y

Application date for qualifying paper (masters' thesis or dissertation). Source field: SHRQPNM_APPL_DATE.

Penn_Id

Indexed - no
Format - Varchar2(9)
May be Null? Y

Penn's identity management system identification number. Source fieldL SPRIDEN_ID.

Pidm

Indexed - no
Format - Number
May be Null? Y

Banner internal identification number. Source field: SHRQPNM_PIDM

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The last date the table was refreshed in the warehouse

Sequence_Num

Indexed - no
Format - Varchar2(3)
May be Null? Y

Internal sequence number, used when the student has more than one qualifying paper record. Source field: SHRQPNM_SEQ_NO

St_Thesis_Disertation_Pk

Indexed - yes
Format - Varchar2(11)
May be Null? N

internal warehouse primary key: based on PIDM and SEQ_NO

Title

Indexed - no
Format - Varchar2(240)
May be Null? Y

Complete title of the qualifying paper.

Title_Line1

Indexed - no
Format - Varchar2(60)
May be Null? Y

First line of qualifying paper. Source field: SHRQPNM_TITLE_LINE1.

Title_Line2

Indexed - no
Format - Varchar2(60)
May be Null? Y

Second line of qualifying paper. Source field: SHRQPNM_TITLE_LINE2.

Title_Line3

Indexed - no
Format - Varchar2(60)
May be Null? Y

Third line of qualifying paper. Source field: SHRQPNM_TITLE_LINE3.

Title_Line4

Indexed - no
Format - Varchar2(60)
May be Null? Y

Fourth line of qualifying paper. Source field: SHRQPNM_TITLE_LINE4.

Qualifying_Paper_Type

Indexed - no
Format - Varchar2(1)
May be Null? Y

Qualifying paper type code (M for Masters Thesis, D for Dissertation). Derived from the source field: SHRQPNM_QPTP_CODE

Qualifying_Paper_Desc

Indexed - no
Format - Varchar2(1)
May be Null? Y

Description of the qualifying paper. Source field: STVQPTP_DESC

ST_THESIS_DISSERTATION Table . Pennant Student Records 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