Penn Computing

University of Pennsylvania
Penn Computing << go backback
ST_NAME_OTHER Table . Pennant Student Records Home . Data Warehouse Home

ST_NAME_OTHER Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

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.

ST_NAME_OTHER Table . Pennant Student Records Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania