| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | This field identifies the last date the source record was updated. Source field: SARADAP_ACTIVITY_DATE. |
| Adm_Admit_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | Code for the admit type. Source field: SARADAP_ADMT_CODE. Source validation table: STVADMT. Data warehouse validation table: V_ADMIT_TYPE. |
| Adm_Concen_1 Indexed - no
Format - Varchar2(16)
May be Null? Y | The concentration of the primary major, if any, on the curriculum to which the student applied. Source field: SARADAP_MAJR_CODE_CONC_1. Source validation table: STVMAJR. Data warehouse validation table: V_MAJOR. |
| Adm_Concen_2 Indexed - no
Format - Varchar2(4)
May be Null? Y | The concentration of the primary major on the secondary curriculum to which the student applied, if any. Typically admissions records will only have a secondary curriculum if the student applied to a coordinated multi-degree program. . Source field: SARADAP_MAJR_CODE_CONC_2. Source validation table: STVMAJR. Data warehouse validation table: V_MAJOR. |
| Adm_Degree_1 Indexed - no
Format - Varchar2(6)
May be Null? Y | The degree code on the curriculum to which the student applied. Source field: SARADAP_DEGC_CODE_1. Source validation table: STVDEGC. Data Warehouse validation table: V_DEGREE. |
| Adm_Degree_2 Indexed - no
Format - Varchar2(6)
May be Null? Y | The degree code on the secondary curriculum to which the student applied, if any. Typically admissions records will only have a secondary curriculum if the student applied to a coordinated multi-degree program. Source field: SARADAP_DEGC_CODE_2. Source validation table: STVDEGC. Data Warehouse validation table: V_DEGREE. |
| Adm_Division_1 Indexed - no
Format - Varchar2(2)
May be Null? Y | The division on the curriculum to which the student applied. Source field: SARADAP_COLL_CODE_1. Source validation table: STVCOLL. Data Warehouse validation table: V_DIVISION. |
| Adm_Division_2 Indexed - no
Format - Varchar2(2)
May be Null? Y | The division on the secondary curriculum to which the student applied, if any. Typically admissions records will only have a secondary curriculum if the student applied to a coordinated multi-degree program. Source field: SARADAP_COLL_CODE_2. Source validation table: STVCOLL. Data Warehouse validation table: V_DIVISION. |
| Adm_Decision_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | The nost-recent decision code. Source field: SARAPPD_APDC_CODE. Source validation table: STVAPDC. |
| Adm_Decision_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | The description for the most-recent decision code. Source field: STVAPDC_DESC. Source validation table: STVAPDC. |
| Adm_Decision_Date Indexed - no
Format - Date
May be Null? Y | The date that the most-recent decision was recorded. Note - If most-recent admissions record is a 'MT' decision, then the Adm_Decision_Date and Adm_Matric_Decision_date will be the same. Source field: SARAPPD_APDC_DATE. |
| Adm_Level_1 Indexed - no
Format - Varchar2(2)
May be Null? Y | The level on the curriculum to which the student applied. Source field: SARADAP_LEVL_CODE. Source validation table: STVLEVL. Data Warehouse validation table: V_STDNT_LEVL. |
| Adm_Level_2 Indexed - no
Format - Varchar2(2)
May be Null? Y | The level on the secondary curriculum to which the student applied, if any. Typically admissions records will only have a secondary curriculum if the student applied to a coordinated multi-degree program. Source field: SARADAP_LEVL_CODE_2. Source validation table: STVLEVL. Data Warehouse validation table: V_STDNT_LEVL. |
| Adm_Major_1 Indexed - no
Format - Varchar2(4)
May be Null? Y | The primary major on the curriculum to which the student applied. Source field: SARADAP_MAJR_CODE_1. Source validation table: STVMAJR. Data warehouse validation table: V_MAJOR. |
| Adm_Major_2 Indexed - no
Format - Varchar2(4)
May be Null? Y | The primary major on the secondary curriculum to which the student applied, if any. Typically admissions records will only have a secondary curriculum if the student applied to a coordinated multi-degree program. Source field: SARADAP_MAJR_CODE_2. Source validation table: STVMAJR. Data warehouse validation table: V_MAJOR. |
| Adm_Matric_Decision_Date Indexed - no
Format - Date
May be Null? Y | Date the application matriculation decision was effective. Source field: SARAPPD_APDC_DATE. |
| Adm_Program_1 Indexed - no
Format - Varchar2(12)
May be Null? Y | The program code of the curriculum to which the student applied. Source field: SARADAP_PROGRAM_1. Source validation table: SMRPRLE. Data warehouse validation table: V_PROGRAM. |
| Adm_Program_2 Indexed - no
Format - Varchar2(12)
May be Null? Y | The program code on the secondary curriculum to which the student applied, if any. Typically admissions records will only have a secondary curriculum if the student applied to a coordinated multi-degree program. Source field: SARADAP_PROGRAM_2. Source validation table: SMRPRLE. Data warehouse validation table: V_PROGRAM. |
| Adm_Student_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | Code for the student type. Source field: SARADAP_STYP_CODE. Source validation table: STVTYPE. Data warehouse validation table: V_STDNT_TYPE |
| Alumni_Affiliation Indexed - no
Format - Varchar2(1)
May be Null? Y | Code for the relationship of the student to an alum (if any). Source field: SPBPERS_LGCY_CODE. Source validation table: STVLECY. Data warehouse validation table: V_LEGACY. |
| App_Entry_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term the student applied to start at Penn. Source field: SARADAP_TERM_CODE_ENTRY. |
| App_Fin_Aid Indexed - no
Format - Varchar2(20)
May be Null? Y | Indicates whether the student applied for financial aid. Values are 'Y' or null. Source field: ROBNYUD_7 |
| App_Seq_No Indexed - no
Format - Number
May be Null? Y | Application sequence number from the source. A student can apply to more than one program in a term; each application in a term will have a sequence number for the entry term. SARADAP_APPL_NO. |
| App_Source Indexed - no
Format - Varchar2(3)
May be Null? Y
| The code used to identify the source admissions system for the application. Note: App_Source will be 'CV' for records created via the Banner conversion process in March 2022. Source field: SARADAP_RECR_CODE. Source validation table: STVRECR. Data warehouse validation table: V_APP_SOURCE. |
| Application_Id Indexed - yes
Format - Varchar2(30)
May be Null? Y | The ID used in the source admissions system for the application. Source field: SARADAP_WEB_CASHIER_USER.
Note 1: Application_Id will be 'CONV' concatenated with the Penn_ID for records created during the Banner conversion process in March 2022.
Note2: This is not the same as the Applicant's id. For that, please see ST_ADDL_ID. |
| Athletic_Sport Indexed - no
Format - Varchar2(25)
May be Null? Y | NCAA Sport code, for undergraduate students who were recruited athletes. Source is the Penn custom table UP_FA_ADM_APPL_ADDTL_DATA.ATHLETIC_SPORT |
| Faculty_Staff Indexed - no
Format - Varchar2(20)
May be Null? Y | Indicates if the student is also Penn faculty/staff, or if they are related to a person who is a Penn faculty/staff. Values are 'Y' or null. Source field: ROBNYUD_4 |
| High_School_Language Indexed - no
Format - Varchar2(50)
May be Null? Y | The language subject or subjects the admitted student successfully demonstrated proficiency in prior to coming to Penn. If more than one language was on the student's application, the codes will be stored together in a string in this field, separated by commas. Source field: SORHSBJ_SUBJ_CODE. Warehouse validation table: V_SUBJECT. |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn identify management system unique identifier. Source field: SPRIDEN_ID. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number. Source field: SARADAP_PIDM |
| Recruited_Athlete_Support
Indexed - no
Format - Varchar2(25)
May be Null? Y | For undergraduate students this field will have a value of 'AR6'. Not currently used for grad students. Source is the Penn custom table UP_FA_ADM_APPL_ADDTL_DATA.RECRUITED_ATHLETE_SUPPORT |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this table was refreshed in the warehouse. |
| St_Adm_Info_Pk Indexed - yes
Format - Varchar2(86)
May be Null? N | Data warehouse primary key for this table, based on PIDM, TERM_CODE_ENTRY and APPL_NO |
