| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date the instructor assignment to this section was updated in the source. Source field: SIRASGN_ACTIVITY_DATE. |
| Assignment_Category Indexed - no
Format - Varchar2(1)
May be Null? Y | Internal assignment number - part of the source table primary key. Source field: SIRASGN_CATEGORY. |
| Assignment_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | Faculty Assignment Type Code. Source field: SIRASGN_ASTY_CODE. Source validation table: STVASTY. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Number that, along with the Subject code, identifies a course. Source field: SSBSECT_CRSE_NUMB. |
| Course_ID
Indexed - no
Format - Varchar2(9)
May be Null? Y | The Subject area and the Course number concatenated into one field. This column, along with the term, can be used to join to the COURSE table when needed. Source fields: SSBSECT_SUBJ_CODE+SSBSECT_CRSE_NUMB. |
| Course_Ref_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | The internal Banner Course Reference Number (CRN). Source field: SIRASGN_CRN. |
| Crse_Sect_Instructor_Pk Indexed - yes
Format - Varchar2(21)
May be Null? N | internal warehouse primary key: based on TERM_CODE, CRN and PIDM |
| Instructor_First_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Instructor's first name, as imported into Pennant Records from the IAM preferred name. Source field: SPRIDEN_FIRST_NAME. |
| Instructor_Last_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Instructor's last name, as imported into Pennant Records from the IAM preferred name. Source field: SPRIDEN_LAST_NAME. |
| Instructor_Mi Indexed - no
Format - Varchar2(60)
May be Null? Y | Instructor's middle initial or name, as imported into Pennant Records from the IAM preferred name. Source field: SPRIDEN_MI. |
| Instructor_Email Indexed - no
Format - Varchar2(128)
May be Null? Y | Instructor's email address, as stored in Banner. Note that this can potentially be different from the person's email in other Penn systems. Source field: GOREMAL_EMAIL_ADDRESS. |
| Instructor_Penn_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Instructor's Penn_ID. Source field: SPRIDEN_ID. |
| Instructor_Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal identifier for the instructor. Source field: SIRASGN_PIDM. |
| Primary_Instructor Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates the instructor in this record is the primary instructor of the course. Source field: SIRASGN_PRIMARY_IND. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date of the latest refresh of this warehouse table |
| Responsibility_Percent Indexed - no
Format - Number
May be Null? Y | Faculty members percentage of responsibility to the assignment. Source field: SIRASGN_PERCENT_RESPONSE |
| Section_Id Indexed - no
Format - Varchar2(12)
May be Null? Y | Subject, Course Number, and Sequence number together uniquely identify a course section. |
| Section_Num Indexed - no
Format - Varchar2(3)
May be Null? Y | Number that identifies the section of a course, associated with the Subject/Course Num. Source field: SSBSECT_SEQ_NUMB. |
| Session_Percent Indexed - no
Format - Number
May be Null? Y | Faculty session percentage of responsibility of instructional assignment. Source field: SIRASGN_PERCENT_SESS. |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the Subject Area associated with the course section. Source field: SSBSECT_SUBJ_CODE. |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term code for the course section to which the instructor is assigned. Source field: SIRASGN_TERM_CODE. |
| Workload_Adjust Indexed - no
Format - Number
May be Null? Y | Faculty Adjustied Workload for instructional assignment. Source field: SIRASGN_WORKLOAD_ADJUST |
