| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | ACTIVITY DATE: Date that the record was created or updated. |
| Course_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Course section number. Source field: SCTMEXC_CRSE_NUMB |
| Crse_Ref_Num Indexed - yes
Format - Varchar2(5)
May be Null? Y | Internal Course Reference Number. Source field: SCTMEXC_CRN |
| Mutual_Excl_Crse_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | Course number associated with the course that is considered mutually exclusive. Source field: SCTMEXC_CRSE NUMB MEXC. |
| Mutual_Excl_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates if a mutual exclusion was found for course combination. Valid values are Y-Yes or N-No. Source field: SCTMEXC_MEXC_IND. |
| Mutual_Excl_Source Indexed - no
Format - Varchar2(1)
May be Null? Y | Indicates where the mutually exclusive course was found in processing mutual exclusions. (T)ransfer, (I)nprogress, (H)istory, (C)urrent course, Current course (G)raded. Source field: SCTMEXC_SOURCE IND. |
| Mutual_Excl_Source_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | |
| Mutual_Excl_Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Course subject code associated with the course that is considered mutually exclusive. Source field: SCTMEXC_SUBJ CODE MEXC. |
| Penn_Id Indexed - yes
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identifier. |
| Pidm Indexed - yes
Format - Number
May be Null? Y | Banner internal identification number of the person. Source field: SCRMEXC_PIDM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The latest date this warehouse table was refreshed. |
| St_Enrlmnt_Mutual_Excl_Pk Indexed - yes
Format - Varchar2(51)
May be Null? N | internal primary key based on PIDM, TERM_CODE and CRN |
| Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | Course section subject code. Source field: SCTMEXC_SUBJ_CODE. Source validation table: STVSUBJ. Warehouse validation table: V_SUBJECT |
| Term Indexed - yes
Format - Varchar2(6)
May be Null? Y | Term code for the registration activities. Source field: SCTMEXC_TERM_CODE. |
