| 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: SCBSUPP_ACTIVITY_DATE. |
| Course_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | Subject and course number displayed together (no spaces added). |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Banner course number of the course or the also-offered-as course. Source field: SCBSUPP_CRSE_NUMB. |
| Crse_Xlist_Pk Indexed - yes
Format - Varchar2(15)
May be Null? N | internal warehouse primary key: based on SCBSUPP_SUBJ_CODE, SCBSUPP_CRSE_NUMB, TERM |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Start term of the also-offered-as relationship. Source field: SCBSUPP_EFF_TERM |
| Pri_Sec_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates whether the course is the primary (P) or the secondary (S) of the also-offered-as relationship. Derived from source field: SCBSUPP_PERM_DIST_IND. (just the first character in that field) |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date of the latest refresh of this warehouse table |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Banner subject code of the course or the also-offered-as course. Source field: SCBSUPP_SUBJ_CODE. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT. |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | A term in which this also-offered-as version is in effect. The source stores crosslist information as term-effective. The extract to the Warehouse transforms the data to term-by-term. |
| Xlist_Family Indexed - no
Format - Varchar2(10)
May be Null? Y | Code shared by all courses that are offered together (fka cross-listed with each other). Derived from source field: SCBSUPP_PERM_DIST_IND (The first character in the source field defines the primary or secondary, and the remaining characters are the "family" ID.) |
| Xlist_Pri_Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Banner course number of the primary partner for the also-offered-as family. SCBSUPP_CRSE_NUMB where the xlist family indicator from SBBSUPP_PERM_DIST_IND match, and the Primary indicator from SBPSUPP_PERM_DIST_IND = 'P' |
| Xlist_Pri_Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Banner subject code of the primary partner for the also-offered-as family. Source: SCBSUPP_SUBJ_CODE where the xlist family indicator from SBBSUPP_PERM_DIST_IND match, and the Primary indicator from SBPSUPP_PERM_DIST_IND = 'P' |
