| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | Latest date the identity record was updated in the source. Source field: SPRIDEN_ACTIVITY_DATE |
| Change_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates a change was made to the name. For names other than the converted Long Name, the change indicator is part of the record key.
Source field: SPRIDEN_CHANGE_IND |
| First_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Student's first name. For long names converted from the legacy system, this column will be null and the entire long name will be in the Long_Name column.
Source field: SPRIDEN_FIRST_NAME |
| Last_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Student's last name. For long names converted from the legacy system, this column will be null and the entire long name will be in the Long_Name column.
Source field: SPRIDEN_LAST_NAME. |
| Long_Name Indexed - no
Format - Varchar2(500)
May be Null? Y | The name formatted in first, middle, last, to be used on the student's diploma. Source field: SPRIDEN_LAST_NAME where name type is DIPL. |
| Middle_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Student's middle initial or middle name. For long names converted from the legacy system, this column will be null and the entire long name will be in the Long_Name column.
Source field: SPRIDEN_MI. |
| Name_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Text description of the Name Type code. Source field: GTVNTYP_DESC |
| Name_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | Name Type code. The names type of 'prev' is a calculated type, indicating it was a student's previous name, superceded by the name in the STUDENT table. The names of type 'LEGL' use a warehouse-assigned name type, indicating it comes from the full SPRIDEN name, which at Penn is the student's legal name. See the Cautions and Notes for this table.
Source field: SPRIDEN_NTYP_CODE. Source validation table: GTVNTYP. Warehouse validation table: V_NAME_TYPE. |
| Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number. Source field: SPRIDEN_ID. |
| Pidm Indexed - no
Format - Number
May be Null? Y | Internal identification number. Source field: SPRIDEN_PIDM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Latest date this warehouse table was refreshed |
| St_Name_Other_Pk Indexed - yes
Format - Varchar2(512)
May be Null? N | internal warehouse primary key, based on SPRIDEN_PIDM
SPRIDEN_ID
SPRIDEN_LAST_NAME
SPRIDEN_FIRST_NAME
SPRIDEN_MI
SPRIDEN_SURNAME_PREFIX
SPRIDEN_CHANGE_IND
SPRIDEN_NTYP_CODE |
| Surname_Prefix Indexed - no
Format - Varchar2(60)
May be Null? Y | Student's name prefix. Source field: SPRIDEN_SURNAME_PREFIX. |
