1. Confirm that the EMPLIDs belong to the same person. When a college identifies multiple EMPLIDs that appear to belong to the same individual, the college is responsible for verifying that the EMPLIDs belong to the same person before reporting to SBCTC Support.
   • Many individuals in ctcLink have the same name and date of birth. Multiple data points should be reviewed to ensure that the EMPLIDs belong to the same person (especially if the individual has a common name). Data to review includes names (first, middle, and last), DOB, SSN, addresses, contact information, and student records.
   • Unmerging data that should not have been merged is a complicated and time-consuming process. It usually results in creating brand new EMPLIDs for all impacted records. Do not submit a ticket if you are unsure if all EMPLIDs belong to the same individual.

1. Submit a Support ticket to report the individual's multiple EMPLIDs. Submit one ticket per student and include all of the individual's EMPLIDs under the following request type: ctcLink Support > Campus Solutions > Duplicate CS ID.  

• If the ticket resolution is time-sensitive, please update the ticket to let the Support team know instead of attempting to move data yourself.
• Some colleges identify EMPLIDs submitted to SBCTC Support with a service indicator. This service indicator can prevent students from enrolling under any of their multiple EMPLIDs. At the same time, the EMPLIDs are being reviewed and can also assist the college in tracking which EMPLIDs have already been submitted to the Support team.
• Do not report more than one person's records per ticket. If multiple individuals are included in a single ticket, the ticket will be closed, and the college will be asked to reopen one ticket per person.
• Do not submit multiple tickets to report the same individual. The college is responsible for tracking which EMPLIDs have already been reported to SBCTC Support.

2. SBCTC will determine which EMPLID will be retained and which EMPLID(s) will be retired. In our multi-college system, data can exist for multiple colleges on a single EMPLID. The Support teams review the quantity and type of data associated with each EMPLID (including student records, financial information, financial aid records, and employment data) and determine which EMPLID will be maintained. The ticket will be updated to indicate which EMPLID will be maintained.

3. Data will be moved from the retired EMPLID(s) to the retained EMPLID. Data is "moved" by manually recreating the record on the retained EMPLID. Each Support team (HCM, FA, SF, and CS Core) moves its associated data. A ticket may be routed to several teams before all data is transferred.
   • To prevent changes to the student's record as data is being moved, the SDI service indicator will be assigned to the student's duplicate EMPLID. This service indicator prevents enrollment, student financial activity, and financial aid disbursement. This SDI service indicator is assigned and removed by Support staff; college users should not assign or remove the SDI service indicator.
   • A Support team member may instruct the college to move certain data, such as Canvas records or student financial information.
   • The college may be asked to provide additional information or verify a record when there is a discrepancy in the data being moved. Examples include differences between bio demo data (i.e., differing SSNs, names, etc.) or conflicting data (i.e., term activation or residency differences between EMPLIDs).
   • To make it easier to visually differentiate the record of a retired duplicate EMPLID from that of a standard EMPLID, the name on the retired EMPLID is updated to contain words like "Do Not Use" and "Duplicate." However, please note that the name change may not occur until the final stages of the merge process.

4. Duplicate EMPLIDs are retired or deleted. Once all data has been moved to the retained EMPLID, most data from the duplicate EMPLID(s) is deleted.
   • EMPLIDs that do not contain employment, financial, or financial aid data are entirely deleted from ctcLink.
   • EMPLIDs that contain employment, financial, or financial aid data are not deleted. All data unrelated to employment, finances, or financial aid is deleted. The EMPLID is changed to begin with, "X."

5. The ticket is resolved when data movement is complete, and duplicate EMPLIDs are retired or deleted. The ticket will be updated when the work on resolving the duplicate is complete. At this point, the ticket will be resolved by the CS Core Support team.
   • The CS Core Support team does not work with students. It is the college's responsibility to inform students of which EMPLID has been retained for their records.
   • The college should reopen the ticket if there are any questions about the duplicate resolution.

Approximately three weeks prior to the term’s Enrollment Snapshot, the CS Pillar Support teams will not work on new Duplicate EMPLID tickets for currently enrolled students.

Duplicate EMPLID tickets for currently enrolled students received prior to the freeze (that are already in progress) will continue to be worked on. This work must be completed before the term’s enrollment snapshot. 

As SBCTC’s CS Pillar Support teams work with colleges to move certain data from the retired EMPLID to the kept EMPLID, it is imperative that college staff also prioritize this work so that all data is moved before the snapshot to ensure accurate reporting for that term.

We want to help make sure your data is being reported accurately! As you may know, resolving Duplicate EMPLID tickets often requires colleges, CS Core, FA, and SF to work together and coordinate the movement of data from the “retired” EMPLD to the “kept” EMPLID.

The Duplicate EMPLID Ticket Freeze only applies to currently enrolled students; meaning, students enrolled during the same term when the ticket is submitted to SBCTC.

This work is central to reporting, which is reflected on the Data Warehouse Snapshot Schedule. (https://www.sbctc.edu/colleges-staff/data-services/data-warehouse-documentation)

Colleges can still file Duplicate EMPLID tickets to SBCTC during the Duplicate EMPLID Ticket Freeze. We will reply to the ticket stating the freeze start/end date and let you know the ticket is on hold until the freeze ends. However, tickets filed within this time for currently enrolled students will not be worked on until after the freeze ends.

If a Duplicate EMPLID ticket involving a currently enrolled student cannot wait until the freeze ends, colleges should include a detailed explanation of the situation in the ticket. We will consider the request. Please note that this may delay the Data Services’ snapshot, so please ensure this is truly a critical/urgent situation.