| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The latest date the source table was updated. Source: SCREQIV |
| Course_Id Indexed - no
Format - Varchar2(9)
May be Null? Y | The Subject area and Course number, stored together (no spaces). |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | The number of the course. Source: SCREQIV_CRSE_NUMB |
| Crse_Equiv_Pk Indexed - yes
Format - Varchar2(30)
May be Null? N | Internal warehouse primary key for this table |
| Course_ID_Equiv Indexed - no
Format - Varchar2(5)
May be Null? Y | The course ID (Subject+Course number) of the equivalent course. |
| Crse_Num_Equiv Indexed - no
Format - Varchar2(5)
May be Null? Y | The course number of the equivalent course. Source: SCREQIV_CRSE_NUMB_EQIV |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term the latest record for this equivalency became effective. Source: SCREQIV_EFF_TERM |
| End_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The end term of this equivalency. Source: SCREQIV_END_TERM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The date this warehouse table was last refreshed. |
| Start_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The first term of this equivalency. Source: SCREQIV_START_TERM |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | The subject code of the course. Source: SCREQIV_SUBJ_CODE |
| Subj_Equiv Indexed - no
Format - Varchar2(4)
May be Null? Y | The subject code of the equivalent course. Source: SCREQIV_SUBJ_CODE_EQIV |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Reference term. Equivalencies are stored as term-effective in the Banner source tables; in the warehouse, the data are stored term-by-term, to facilitate reporting. There will be one row for every possible term in which the equivalency was in effect. This term can be used to join to other course tables, to get all of the relevant data in effect during the same term. |
| Legacy_Equiv_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | A calculated field, with values of 'Y' or null. A 'Y' in this field indicates the equivalency is to a legacy SRS course. |
