| Data element |
Definition |
| Conv_Long_Title Indexed - no
Format - Varchar2(100)
May be Null? Y | The initial long coures title in Banner |
| Conv_Title Indexed - no
Format - Varchar2(30)
May be Null? Y | The initial course title in Banner |
| Conv_Topics_Ind Indexed - no
Format - Varchar2(5)
May be Null? Y | indicates this will be a topics course in Banner |
| Created_On_Date Indexed - no
Format - Date
May be Null? Y | The date the course number crosswalk table was populated in the warehouse |
| Data_Origin Indexed - no
Format - Varchar2(20)
May be Null? Y | The source system or process that populated this table |
| NGSS_Course_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | Pennant subject and course number stored together, with no spaces in-between the subject and number. |
| NGSS_Course_Number Indexed - no
Format - Varchar2(5)
May be Null? Y | Pennant course number; the second part of the NGSS_Course_ID. Typically 4 integers in length, but can contain a trailing letter, making the length 5. |
| NGSS_Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Pennant code for the subject area of the course; the first part of the NGSS_Course_ID |
| SRS_Course_Id Indexed - no
Format - Varchar2(8)
May be Null? Y | SRS subject and course number stored together, respecting SRS format of 4 + 3 (the first 4 positions of the field are for the SRS subject area, the last 3 positions of the field are for the SRS course number). |
| SRS_Course_Number Indexed - no
Format - Varchar2(4)
May be Null? Y | SRS course number |
| SRS_Subj_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | SRS subject area code; may be 2, 3 or 4 characters in length |
| SRS_Topics_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | A 'Y' in this field indicates this was a topics course in SRS |
| Xwalk_Crse_Number_Pk Indexed - yes
Format - Varchar2(15)
May be Null? N | internal warehouse table primary key, based on SRS_COURSE_ID and NGSS_SUBJECT and NGSS_COURSE_NUMBER |
