| Data element |
Definition |
| Active_Duty_Sepr_Date Indexed - no
Format - Date
May be Null? Y | The date that the person was separated from active military duty. Source field: SPBPERS_ACTIVE_DUTY_SEPT_DATE. |
| Birth_Date Indexed - no
Format - Date
May be Null? Y | The student's date of birth. Source field: SPBPERS_BIRTH_DATE. |
| Citizen_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the citizenship category of the student. Values are
PR Permanent Resident
US US Citizen
NO Non US Citizen
DC US/Dual Citizen
Source field: SPBPERS_CITZ_CODE. Source validation table: STVCITZ. Warehouse validation table: V_CITIZENSHIP_TYPE |
| Confid_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | In general, student data is protected under the Federal Educational Rights and Privacy Act (FERPA). Per FERPA and university guidelines:
"Directory Information is generally regarded to be less sensitive than other types of information in a student's education record. The University designates as directory information, which may be disclosed from records relating to a student without his or her consent if the student has not opted out of allowing such disclosure, the following categories of information: a student's name, address (local, home or electronic mail), telephone number, date and place of birth, Penn ID number, major field of study, participation in officially recognized activities (including social and honorary fraternities) and sports, weight and height if a member of an athletic team, dates of attendance, degrees and awards received, and previous educational institutions attended. " A null in the Confid_ind field indicates the directory information is not flagged as confidential. A 'Y' in this field indicates the student has flagged their directory information as confidential. Source: SPBPERS_CONFID_IND
Note that all other student information not categorized as "directory" information is, by default, protected by FERPA and is not to be disclosed or used in any way other than as specified by University Policy and federal law. Furthermore, when a student has flagged their directory information as confidential, that information must be treated the same as all other protected student information. |
| Deceased Indexed - no
Format - Varchar2(1)
May be Null? Y | Flag indicating if the student has died. Values are 'Y' (the student is deceased) or null. Source field: SPBPERS_DEAD_IND. |
| Deceased_Date Indexed - no
Format - Date
May be Null? Y | Date of the student's death. If the DECEASED column is not null, this column must also be not null. Note: in the Legacy system, this date was not stored, so the date of death converted to the new system was an approximation. Source field: SPBPERS_DEAD_DATE. |
| Disabled_Veteran Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicator to identify an individual as a special disabled veteran. Source field: SPBPERS_SDVET_IND. |
| Ethnicity Indexed - no
Format - Varchar2(1)
May be Null? Y | The ethnic code, per Federal reporting definitions. The valid values are 1 - Not Hispanic or Latino, 2 - Hispanic or Latino, or null. Source field: SPBPERS_ETHN_CDE. Note that at Penn, a student's ethnicity details are also stored along with racial grouping details, even though ethnicity is different from race. See also the ST_RACE and V_RACE tables. |
| First_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | The first name of the student's full name. This is the student's preferred first name, when the student has provided one. Otherwise, it is first name from the source SPRIDEN table.
See explanation in the NAME field.
Source field: SPBPERS_PREF_FIRST_NAME if available, else SPRIDEN_FIRST_NAME
|
| Gender Indexed - no
Format - Varchar2(4)
May be Null? Y | Gender identity of the person. Source field: SPBPERS_GNDR_CODE. |
| Id_Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date the identity record in the source was updated. Source field: SPRIDEN_ACTIVITY_DATE. |
| Last_Name Indexed - no
Format - Varchar(60)
May be Null? Y | The surname of the student's legal name. See explanation in the NAME field. Source field: SPRIDEN_LAST_NAME |
| Marital_Status Indexed - no
Format - Varchar2(1)
May be Null? Y | Code for the marital status of the student. Source field: SPBPERS_MRTL_CODE. Source validation table: STVMRTL. Warehouse validation table: V_MARITAL. |
| Middle_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | The middle initial or middle name of the student's legal name. See explanation in the NAME field. Source field: SPRIDEN_MI. |
| Name Indexed - no
Format - Varchar2(180)
May be Null? Y | Full name of the student, formatted as last,first middle. (last name||comma||first name||space||middle name)
This Name -- or the specific separate First_Name, Middle_Name, Last_Name from this table --are the name fields that should be used for most reporting at Penn.
The first name in the Name column comes from the student's Preferred First Name, when available. Otherwise, it comes from the first name in SPRIDEN, along with the middle and last names in SPRIDEN, where the SPRIDEN_CHANGE_IND is null. Legal Name, previous names and other name types can be found in the ST_NAME_OTHER table. |
| Name_Prefix Indexed - no
Format - Varchar2(20)
May be Null? Y | If available, the student's desired name prefix, for example: MS, DR, etc. Source field: SPBPERS_NAME_PREFIX. |
| Name_Suffix Indexed - no
Format - Varchar2(20)
May be Null? Y | If available, the student's desired name suffix, for example: JR., III, etc. Source field: SPRPERS_NAME_SUFFIX. |
| Pennkey Indexed - no
Format - Varchar2(50)
May be Null? Y | The Pennkey username used by students and alumni to authenticate to Penn's online systems.
Source field: GORADID_ADDITIONAL_ID |
| Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number for the person.
Note that this field can contain 9 characters. In Pennant Student Records, this field will always have a valid 8-character Penn_ID, but for other data collections that use Banner data, this might not always be the case. See the Cautions and Notes for the STUDENT Table
Source field: SPRIDEN_ID. |
| Pers_Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date the person record in the source was updated. Source field: SPBPERS_ACTIVITY_DATE. |
| Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal Identification Number of Person. Source field: SPRIDEN_PIDM |
| Preferred_Pronoun Indexed - no
Format - Varchar2(4)
May be Null? Y | Preferred personal pronoun of the person. Source field: SPBPERS_PPRN_CODE. |
| Pref_First_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | If available, the student's self-reported preferred first name. At Penn, this is sometimes referred to as the "Lived Name."
Source field: SPBPERS_PREF_FIRST_NAME.
Note: when a preferred first name is available, that is what is stored in the First_Name field in the warehouse Student table, as well as what is used in the concatenated Name field. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The date the record was last refreshed in the Data Warehouse. |
| Religion Indexed - no
Format - Varchar2(2)
May be Null? Y | Code for the student's self-reported religion category. Source field: SPBPERS_RELG_CODE. Source validation table: STVRELG. Warehouse validation table: V_RELIGION. |
| Rollup_Race Indexed - no
Format - Varchar2(15)
May be Null? Y | For internal reporting only; this is derived from the federal reporting race code. When a student is in more than one racial category, the codes for all categories will be concatenated in this field. |
| Sex Indexed - no
Format - Varchar2(1)
May be Null? Y | The sex of the student, as collected for Federal reporting purposes. Valid values are: M - Male, F - Female, N - Unknown or unreported. Source field: SPBPERS_SEX. See also GENDER. |
| Student_Pk Indexed - yes
Format - Number
May be Null? N | Internal warehouse primary key for this table. |
| Veteran_Category Indexed - no
Format - Varchar2(1)
May be Null? Y | Veteran Category. (NULL) Not a Veteran, (B) Protected veteran choosing not to self-identify the classification, (O) Active Wartime or Campaign Badge Veteran, (V) Not a Protected Veteran.
Source field: SPBPERS_VERA_IND. |
| Veteran_Id_Num Indexed - no
Format - Varchar2(10)
May be Null? Y | This field maintains veteran identification number associated with person. Source field: SPBPERS_VETC_FILE_NUMBER. |
| Veteran_Medal_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Armed Forces Service Medal Indicator. Valid values are (Y)es, (N)o. Default value is N. Source field: SPBPERS_ARMED_SERV_MED_VET_IND. |
