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