| Data element |
Definition |
| Ccon_Activity_Date Indexed - no
Format - Date
May be Null? N | Last date the concentration record was entered or updated in the source. Source field: SORCCON_ACTIVITY_DATE |
| Cmjr_Activity_Date Indexed - no
Format - Date
May be Null? N | Last date the major-concentration record was entered or updated in the source. Source field: SORCMJR_ACTIVITY_DATE |
| Concentration_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the concentration. Source field: SORCCON_MAJR_CODE_CONC |
| Concentration_Pk Indexed - yes
Format - Varchar2(50)
May be Null? N | etl-assigned primary key: concatenate SORCCON_CCON_RULE, SORCCON_CMJR_RULE, SORCCON_CURR_RULE |
| Curr_Activity_Date Indexed - no
Format - Date
May be Null? N | Last date the curriculum record was entered or updated in the source. Source field: SOBCURR_ACTIVITY_DATE |
| Degree_Code Indexed - no
Format - Varchar2(6)
May be Null? Y | Degree code for the curriculum to which the concentration is attached. Source field: SOBCURR_DEGC_CODE |
| Division_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Division code for the curriculum to which the concentration is attached. Source field: SOBCURR_COLL_CODE |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Effective term for the major/concentration relationship. Source field: SORCCON_TERM_CODE_EFF |
| Level_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Level code for the curriculum to which the concentration is attached. Source field: SOBCURR_LEVL_CODE |
| Major_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | Code for the major to which a concentration is attached. Source field: SORCMJR_MAJR_CODE |
| Program_Code Indexed - no
Format - Varchar2(12)
May be Null? Y | Program code for the curriculum to which the concentration is attached. Source field: SOBCURR_PROGRAM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date this table in the warehouse was last refreshed. |
