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. 
  • When choosing masters for Equivalents with Scheduling Relationships (EQSR - formerly known a "Meets With"), if the relationship is between an undergrad and graduate subject, the undergraduate will be selected as the master. After that, master subjects are assigned at random. 

MITSIS Backfill Data Flow Diagram

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 Art
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.

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.
BEH BEH 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:

March 15, 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