| 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 |
