Penn Computing

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

ST_ATTRIBUTE 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

The last date any part of this record was updated in the source. Source field: SGRSATT_ACTIVITY_DATE.

Attribute

Indexed - no
Format - Varchar2(4)
May be Null? Y

The code for the attribute associated with the student. Student attributes frequently change from one term to the next. Examples of student attributes: the code for Penn Classification in the term, the PhD term, various term-based honors, term-based clinical fee attributes, etc.
Source field: SGRSATT_ATTS_CODE. Source validation table: STVATTS. Warehouse validation table: V_STDNT_ATTR.

Attribute_Desc

Indexed - no
Format - Varchar2(30)
May be Null? Y

Text desciption of the student Attribute code. Source field: STVATTS_DESC.

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

Banner internal identification number. Source field: SGRSATT_PIDM.

Refresh_Date

Indexed - no
Format - Date
May be Null? Y

The last date the table was refreshed in the warehouse

St_Attribute_Pk

Indexed - yes
Format - Varchar2(32)
May be Null? N

internal warehouse primary key, based on PIDM, TERM, ATTS_CODE

Term

Indexed - no
Format - Varchar2(6)
May be Null? Y

In Banner, the attribute is in effect from the effective term and going forward. In the warehouse, we store a record in ST_ATTRIBUTE for every term in which the student has any academic activity.

Term_Effective

Indexed - no
Format - Varchar2(6)
May be Null? Y

Effective Term: The term in which this attribute was put on the student's record. Source field: SGRSATT_TERM_CODE_EFF

ST_ATTRIBUTE 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