Access Keys:
Skip to content (Access Key - 0)

MITSIS Backfill Documentation

Please note that this page and related pages are being developed as part of the CIM Courses Project and are subject to change.

This article describes the backfill of data from the Container/Template Subject Structure to MITSIS. The MITSIS Backfill was implemented as part of the CIM Courses project.

Purpose

The MITSIS Backfill was implemented because the scope of the CIM Courses Project did not include repointing systems from MITSIS to the new
Container/Template Subject Structure. Since the Container/Template Subject Structure would become the source for all subject data,
there was a need to backfill that source data to MITSIS.

Backfill Details

  • Subjects with Arranged units must have a value of "1" in the Lab Units field. 

MITSIS Backfill Data Flow Diagram

Assignment of Master Subject for EQSRs (current implementation as of 11/7/2018)

  • For edits to existing EQSRs
    • If the previous master is undergraduate, it will be retained as the master of the cluster
    • If the previous master is graduate and there are no undergraduate subjects in the cluster, then the previous master will be retained
    • If the previous master is graduate and there are one or more undergraduate subjects already in or added to the cluster, an undergraduate subject will become the master for previous and new data (lowest alphanumeric undergraduate subjects will be assigned as master)
  • For new EQSRs between  undergraduate and graduate subjects, the undergraduate will be assigned as the master
  • For new EQSRs between two or more undergraduate subjects, the subject with the lowest alphanumeric subject number will be assigned as the master

LAB/LAB2/LB Attribute Mapping

Due to the new Lab Institute Requirement, the "LAB" attributes are mapped as follows.

CIS (SCRCI_PROPOSAL) MITSIS (SCRATTR) NSS (SUBJECT_TMPL_ATTRIBUTE) NSS (SUBJECT_TEMPLATE)
GIR_ATTR ATTRIBUTE_CODE ATTRIBUTE_CODE UG_DEGREE_AUDIT_LAB_UNITS
LAB2 LB1
1
LAB2 LB2
2
LAB2 LB3
3
LAB2 LB4
4
LAB2 LB5
5
LAB2 LAB2
6
LAB2 LB7
7
LAB2 LB8
8
LAB2 LB9
9
LAB2 LB10
10
LAB2 LB11
11
LAB LAB
12

HASS Attribute Mapping

CIM Proposal CIS
(SCRCI_PROPOSAL)
CIS
(SCRCI_PROPOSAL)
MITSIS
(SCRATTR)
NSS
(SUBJECT_TMPL_ATTRIBUTE)
Notes
HASS Category
WRITE_ATTR GIR_ATTR ATTRIBUTE_CODE ATTRIBUTE_CODE -
HASS Arts
HA -
HA, HE
HA, HE
-
HASS Humanities
HH -
HH, HE
HH, HE
-
HASS Social Science
HS -
HS,  HE
HS, HE
-
HASS Elective
HE
- HE
HE
-
(HA, HH, or HS) + HE
(HA, HH, or HS)
- (HA, HH, or HS), HE (HA, HH, or HS), HE Only two attributes in the (HA, HH, or HS) set should be present at any time.
This restriction is not enforced in CIM courses, but is enforced by CIS.

5-Year MITSIS Equivalency Rules

Applicable System Rules:

  1. If Subject A is EQ with Subject B - and Subject B is deactivated, the two numbers will stay equivalent to each other for 5 years in MITSIS.
    This rule also applies to the removal of cross-lists and SWEs.
    1. Example: Subject A and Subject B had an EQ that began in 2010FA. Subject B was then deactivated - last active term was 2013SU.
      So the EQ persists in MITSIS for 2014, 2015, 2016, 2017 & 2018. The equivalency should not be place for 2019FA.
  2. Subject A is EQ to Subject B - and Subject B is deactivated. In a subsequent proposal year, Subject C is added as an EQ to Subject A.
    In this case, Subject C will also get Subject B as an EQ in MITSIS until Subject B has been inactive for 5 years. This rule also applies
    to the removal of cross-lists and SWEs.
    1. Example: Subject A and Subject B had an EQ that began in 2010FA. Subject B was then deactivated - last active term was 2013SU.
      Subject C was then added as an EQ to Subject A in 2015FA. Subject C would then be equivalent to Subject B for 2015, 2016, 2017, 2018.
  3. If a Subject is renumbered, the previous number and the current number will stay equivalent to each other for 5 years in MITSIS.
    1. Example: Subject 1.88 is renumbered to 1.702, effective 2014FA. The EQ persists in MITSIS for 2014, 2015, 2016, 2017, and 2018.
      The equivalency should not be place for 2019FA.

SCRSU_VAR Cross-Registration Master Mapping

Institution Description Subj_Code* Master_Subj_Code Subj_Num Master_Subj_Num
Harvard Subject Code  and Master Subject Code should be the same value.
Master Subject Number should be “0000”.
HAB HAB 1234 0000
Wellesley Subject Code and Master Subject Code should be the same value. 
Subject Number and Master Subject Number should be the same value.
WED WED 325 325
Mass College of Art Master Subject Code should be “ MC”.
Master Subject Number should be “0000”
MCA MC 207 0000
Brandeis Subject Code and Master Subject Code should be the same value.
Subject Number and Master Subject Number should be the same value.
BR0 BR0 S12 S12

*Please note these are only example Subject Codes. Subject Codes for these institutions can vary.

FAQ

I was testing the MITSIS backfill and my test subject is not being processed (it remains in subject_backfill_queue). Why won't it backfill?
The effective term of the change may be greater than the SUBJECT_MGMT_CONFIG.mitsisBackfillAllowedUptoYear value. For example, if your test subject has an effective term of 2019FA but MITSIS may only be expecting subject changes for AY2018.

I was testing the MITSIS backfill and my test subject edit processed but I'm not seeing a new record in SCRSU_VAR. What gives?
Unless your test contains a change specific to one of the SCRSU_VAR fields, the backfill will not create a new SCRSU_VAR record. For example, if your test is only adding the UROP attribute to a subject, no SCRSU_VAR fields would have changed - and therefore there is no need to create a new record in that table. Only SCRATTR will get the new record(s).

Subject Management Documentation Index

The Subject Management Documentation Index is the central listing for documentation pertaining to Subject Management.

IS&T Contributions

Documentation and information provided by IS&T staff members


Last Modified:

November 07, 2018

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
c-scasubji c-scasubji Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki