| Data element |
Definition |
| Active_Duty_Sepr_Date Indexed - no
Format - Date (7)
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 (7)
May be Null? Y | The student's date of birth. Source field: SPBPERS_BIRTH_DATE. |
| Citizen_Code Indexed - no
Format - Varchar2 (8)
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. Warehouse validation table: V_CITIZENSHIP_TYPE |
| Citizen_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Description of the citizenship category. Source field: STVCITZ_DESC. |
| Confid_Ind Indexed - no
Format - Varchar2 (4)
May be Null? Y | 'Y' in this field indicates the student has flagged their Directory Information as Confidential, using a link from Path@Penn to Opt-Out. If the student has never used Path@Penn, this field will be Null. If they unchecked the Directory Information Opt-Out option via Path@Penn, the value will be 'N'. Source: SPBPERS_CONFID_IND.
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."
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 (4)
May be Null? Y | Flag indicating if the student has died. Source field: SPBPERS_DEAD_IND. |
| Deceased_Date Indexed - no
Format - Date (7)
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 (4)
May be Null? Y | Indicator to identify an individual as a special disabled veteran. Source field: SPBPERS_SDVET_IND. |
| Ethnicity Indexed - no
Format - Varchar2 (4)
May be Null? Y | The ethnic code, per Federal reporting definitions. Source field: SPBPERS_ETHN_CDE. The valid values are 1 - Not Hispanic or Latino, 2 - Hispanic or Latino, or null. 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. |
| Ethnicity_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Description of the Ethnicity code. This is hard-coded in the ETL to match Federal reporting definitions: 'Not Hispanic or Latino', 'Hispanic or Latino', or Null. |
| First_Name Indexed - no
Format - Varchar2 (240)
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 (16)
May be Null? Y | Gender identity of the person. Source field: SPBPERS_GNDR_CODE. |
| Gender_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Description of the gender code. Source field: GTVGNDR_GNDR_DESC. |
| Id_Activity_Date Indexed - no
Format - Date (7)
May be Null? Y | The last date the identity record in the source was updated. Source field: SPRIDEN_ACTIVITY_DATE. |
| Last_Name Indexed - yes
Format - Varchar2 (240)
May be Null? Y | The student's surname. Source field: SPRIDEN_LAST_NAME |
| Marital_Status Indexed - no
Format - Varchar2 (4)
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. |
| Marital_Status_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Description of the marital status code. Source field: STVMRTL_DESC |
| Middle_Name Indexed - no
Format - Varchar2 (240)
May be Null? Y | The student's middle initial or middle name. Source field: SPRIDEN_MI. |
| Name Indexed - no
Format - Varchar2 (720)
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 (80)
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 (80)
May be Null? Y | If available, the student's desired name suffix, for example: JR., III, etc. Source field: SPRPERS_NAME_SUFFIX. |
| Pennkey Indexed - yes
Format - Varchar2 (200)
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 - yes
Format - Varchar2 (36)
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 (7)
May be Null? Y | The last date the person record in the source was updated. Source field: SPBPERS_ACTIVITY_DATE. |
| Pidm Indexed - yes
Format - Number (22)
May be Null? Y | Banner internal Identification Number of Person. Source field: SPRIDEN_PIDM |
| Preferred_Pronoun Indexed - no
Format - Varchar2 (16)
May be Null? Y | Preferred personal pronoun of the person. Source field: SPBPERS_PPRN_CODE. |
| Preferred_Pronoun_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Description of the preferred personal pronoun. Source field: GTVPPRN_PPRN_DESC |
| Pref_First_Name Indexed - no
Format - Varchar2 (240)
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 (7)
May be Null? Y | Date time the record in the data warehouse table was last refreshed. |
| Religion Indexed - no
Format - Varchar2 (8)
May be Null? Y | Code for the student's self-reported religion category. Source field: SPBPERS_RELG_CODE. Warehouse validation table: V_RELIGION. |
| Religion_Desc Indexed - no
Format - Varchar2 (240)
May be Null? Y | Description for the religion code. Source field: STVRELG_DESC. |
| Rollup_Race Indexed - no
Format - Varchar2 (60)
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. |
| Rollup_Race_Desc Indexed - no
Format - Varchar2 (4000)
May be Null? Y | Descriptions corresponding to the Rollup_Race. The descriptions are a Listagg separated by a semicolon. Source field: GTVRRAC_DESC. |
| Sex Indexed - no
Format - Varchar2 (4)
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 (22)
May be Null? N | internal warehouse primary key |
| Veteran_Category Indexed - no
Format - Varchar2 (4)
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 (40)
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 (4)
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. |
