SAH from TSS

SAH from TSS

Here is what we know as of 03/05/2026.

This page will be updated frequently, please add yourself as a watcher to get update notifications.

SAH from TSS page overview video

SAH Schedule*

*note: exact dates are subject to change

January 2026

SAH will receive sample TSS data into Hana DEV. (No, you can’t see it - we’re updating the piping so you don’t have to).

BIA will validate the data received, test the new SAH data loads and ensure the new ‘piping’ works.

BIA will document the views and fields that will be impacted due to business changes related to TSS. BIA will compile a list of impacted Cognos reports and share that list with SAH report developers, unfortunately Tableau does not provide a way for us to do that. UPDATE = BIA has found that all SAH views and fields will be impacted by business changes related to TSS. All reports and data integrations will also be impacted. To reduce the amount of impacts, BIA will not be changing field names in SAH.

Now until February 27, 2026

Report Developers and data integration developers can


February 27, 2026 TSS Test data UAT has started

2026-02 SAH Release Notes

BIA has released the TSS data and new SAH metadata fields via Cognos/Tableau (Hana QA) for SAH Report Developers and data integration developers to test. This new data will remain in UAT (Hana QA) until the end of March.

New Fields

  • SIS Data Source = Student information system used as the source of the data in the row. SAH only field.

    • When SIS Data Source = ISIS the data is coming from ISIS Prod.

    • When SIS Data Source = TSS the data is coming from a TSS test environment - it will not match TSS Production.

  • Legacy Student PID = Student person identification number from legacy student information system. Will be null for students who started at UCSD FA26 or later.

  • TSS Student Number = Student identification number from TSS. Not available in ISIS. Will be null for students with records not loaded to TSS. AKA: TSN.

BIA Support

BIA will provide testing guidance and working sessions to support SAH report developers and SAH data integration developers. See SAH from TSS Office Hours for dates, times and zoom links.

Report Developers / Data Integration Developers Actions

If you use a Cognos package, Tableau data source or Column Group that comes from any view in the February list you will need to touch your report / data integration call.

SAH Report Developers can begin to modify their reports to accommodate the TSS data.

Data integration developers can being to modify their column groups queries to accommodate the TSS data.

Source of Data

  • In Cognos select Hana QA

  • When SIS Data Source = ISIS the data is coming from ISIS Prod.

  • When SIS Data Source = TSS the data is coming from a TSS test environment - it will not match TSS Production.

Data from TSS

  • TSS Student Number will not match TSS Production

  • Most Application fields

  • Most Applicant fields

  • Some Student Master fields

  • See View Impact Per Release.xlsx* > ‘FebMar Populated Fields’ tab for more details

Impacted Views

SAH-APP-ApplicationNarrow-View and related column groups
SAH-APP-CourseNarrow-View
SAH-APP-EducationHistoryDetail-View
SAH-APP-TestScores-View
SAH-Demographics-View and related column groups

SAH_FCV_STUDENT_DEMOGRAPHICS_DELTA = TSS rows added but no new fields
SAH_FCV_STUDENT_DEMOGRAPHICS_INTEGRATIONS = TSS rows added but no new fields
SAH_FCV_STUDENT_IDENTITY_ACCESS_MANAGEMENT = TSS rows added but no new fields

SAH_FCV_STUDENT_DEMOGRAPHICS_RESTRICTED_DELTA = not in use
SAH_FCV_STUDENT_IDENTITY_ACCESS_MANAGEMENT_DELTA = not in use

If you use a Cognos package, Tableau data source or Column Group that comes from any view in the above list you will need to touch your report / data integration call.

February Test Data in Hana QA pay attention uat has started

2026-02 SAH Release Notes

At this time TSS has not yet gone live. There are a lot of moving pieces required to launch TSS successfully.

In order to provide SAH with a set of sample data, a separate TSS Test environment has been created away from TSS production. This TSS Test environment has been loaded with:

  • Example TSS Student Number - will not be the same in TSS Production

  • Hana QA is loaded after Hana Prod - so do your UAT in the afternoons.

  • A limited number of students of all levels.

  • A limited number of records (mainly 2024) per student for the students that have been loaded.

  • A limited set of populated fields.

  • Example values that match the format of TSS.

  • Test records entered by UCSD staff to test different processes, these will not match ISIS or TSS.

  • Details can be found here: View Impact Per Release.xlsx*

  • Reminder: Views with the word ‘Demographics’ in the name only show student application data after the student has enrolled.

See SAH from TSS Restaurant Analogy as another way to understand why the February data will be TSS Test data.

Scroll down for new resources added to help with UAT.

March 25, 2026 tss prod data

BIA will push TSS related enhancements to Hana Production the evening of Tuesday, March 24, 2026.

SAH Report Developers with updated reports should also request a migration to Cognos production or publish their updated workbooks to Tableau Prod.

Hana PROD will show TSS Production records in only the following SAH views:

SAH-APP-ApplicationNarrow-View and related column groups
SAH-APP-CourseNarrow-View
SAH-APP-EducationHistoryDetail-View
SAH-APP-TestScores-View
SAH-Demographics-View and related column groups

SAH_FCV_STUDENT_DEMOGRAPHICS_DELTA = TSS rows added but no new fields
SAH_FCV_STUDENT_DEMOGRAPHICS_INTEGRATIONS = TSS rows added but no new fields
SAH_FCV_STUDENT_IDENTITY_ACCESS_MANAGEMENT = TSS rows added but no new fields


End of April 2026

A number of fields loaded to TSS were not ready for incorporation into the SAH Feb/March release. BIA is going to add those fields and make them available for a month of UAT from Hana QA starting in April.

Use Hana QA

Expect to see TSS data in remaining Applicant fields, remaining Application fields and more Student Profile fields

Expect to see TSS data in Course/Class Section related fields and views

End of May 2026 tss prod data

BIA will push TSS related enhancements to Hana Production.

Hana PROD will show TSS Production records

End of June 2026

SAH will wait until the Academic History has been added to TSS before we make that same data from TSS available in SAH. Until July, student Academic History in SAH will only come from ISIS.

Use Hana QA

Expect to see Fall enrollments from TSS

Expect to see TSS data in Academic History related fields

End of July 2026 tss prod data

SAH will wait until the Academic History has been added to TSS before we make that same data from TSS available in SAH. Until July, student Academic History in SAH will only come from ISIS.

Hana PROD will show TSS Production records in all SAH views

 


Resources

*resources are updated as new information is learned, check back often

From

Link

Description

From

Link

Description

BIA

SAH-TSS 2026 Presentations

OneDrive folder with presentation recordings and PPTs.

BIA

SAH-TSS_What to Expect Pt1_20250123

PPT presentations of how TSS data will be displayed in SAH

BIA

SAH-TSS_What to Expect Pt2_20260128

Demo example of what a continuing student will look like in SAH with TSS data

BIA

SAH-TSS_What to Expect Pt3_20260204

Demo example of what a new summer Grad student will look like in SAH with TSS data

BIA

View Impact Per Release.xlsx*

Per SAH view, when and where should you expect to see TSS rows of data

  • Which SAH views are impacted per SAH release

  • Feb/March impacted fields

  • Apl/May impacted fields

  • June/July impacted fields

BIA

Data Dictionary

How to access the data dictionary for SAH (and all other Activity Hubs).

TSS

Triton Student System (TSS)

TSS timeline, demonstrations and more.

TSS

https://ucsdcollab.atlassian.net/wiki/spaces/SISCORE/pages/300777528

TSS communications deck and other informational resources

BIA

SAH from TSS Restaurant Analogy

Analogy about test data vs production data

BIA

Column Group Views with TSS Data

UAT tips for data integration developers new

BIA

https://ucsdcollab.atlassian.net/wiki/spaces/AH/pages/3310813764

New for data integration developers new

BIA

https://ucsdcollab.atlassian.net/wiki/spaces/ACP/pages/3337617584

UAT Instruction for report developers and data integration developers new

 


SAH Impacts

Data Moving into TSS

Students enrolled during the last 10 years will be moved into TSS, along with all of the data about them. Additional exceptions will also be moved.

New Students Reminder

Students do not appear in the SAH Core views (like SAH-Demographics-View and SAH-StudentStatusPerTerm-View) until they accept their admissions offer for the current or future term.

New Fields in TSS

New data fields added to TSS will mainly be released as part of a future release in SAH, but exceptions will be made based on campus need and resource availability.

ISIS and TSS Data in SAH

Currently SAH includes all student data from the beginning of time from ISIS. New data from TSS will be added to SAH as TSS is loaded.

ISIS data is being loaded into TSS over a number of months. BIA requires at least 1 month of validation and testing between when the data is loaded to TSS and when that same data is available in SAH production. Therefore, data you see in TSS will not be available in SAH immediately.

Once all mapped data from TSS is available in SAH our nightly data loads will begin and you will see data in SAH the day after it is entered into TSS.

Data Changes between ISIS and TSS

BIA is working closely with the TSS development team to identify what SAH fields will be impacted by business process changes between ISIS and TSS. As we get further into the project the BIA team will make available the list of fields that will be impacted, what the ISIS values in that field are and what the TSS values will be so that report developers / data integration developers using the impacted fields in their filters can adjust their reports / column group calls.

At this time we are aware of value changes related to:

  • Subject Code and Course Name = Link to cross-walk coming soon

  • Major Code, Major Name = Link to cross-walk coming soon

  • Term ID = Will not exist in TSS, will be formatted in SAH as YYYY-###-AAA representing the AcademicYear-TermSession-AcademicCalendarCode

  • (SAH-APP views only) Applicant Type Code = will be formatted as a 2 digit string in TSS, currently is is up to 4 digits

Field Names

There is no intent to change field names. Only the content that the field displays will be changing.

Student PID

The current plan is to display the TSS Student Number in the field named “Student PID” when the student enrolls in TSS. There will be two new fields in SAH to provide the TSS Student Number and the ISIS Student PID.

Student Name

SIS Data Source

Student PID

(depends on SIS Data Source)

Legacy Student PID

(from ISIS)

TSS Student Number

(from TSS)

Student Name

SIS Data Source

Student PID

(depends on SIS Data Source)

Legacy Student PID

(from ISIS)

TSS Student Number

(from TSS)

Mouse, Mickey

ISIS

A45678901

A45678901

200030123

Mouse, Mickey

TSS

200030123

A45678901

200030123

Waitlist Data

Currently live waitlist data is available in SAH. With the move to TSS, live waitlist data will only be available in TSS. SAH will capture a nightly status of the wait list per class section, which will correspond to the nightly enrollment update. Anyone looking for live, up to the minute waitlist information will need to go to TSS directly.

Data Warehouse and Querylink

The Data Warehouse will remain available with historical information but no new data will flow into the DW.

Querylink reports will be retired. Those reports will be moved to bah.ucsd.edu prior to Querylink being retired. Some are there already. For more information go to Report Development .

Data Integration

Data integration developers should expect column group specific updates to be shared via the Data Integration Developers google mail list.

The addition of new fields to SAH views in order to support column groups is in a freeze for 2026. Data integration developers who need fields not available from SAH should open a SNOW ticket to request support from ITS-ADIS.

To find out if your fields are in a SAH column group please use https://ucsdcollab.atlassian.net/wiki/spaces/AH/pages/12487881 .


Q&A

Q. When will TSS Student Number be available in SAH?

A. In end-February BIA will release sample data from TSS into Hana QA for SAH UAT. SAH users will be able to see the new format of the TSS Student Number. This data will remain in SAH UAT for a month. At the end of March we will migrate our enhancements to SAH Production on Hana Prod, at this time TSS production data will flow into SAH Prod.

Q. What will the TSS Student Number look like in SAH?

A. New fields will be added to SAH to help identify data from TSS. Students that exist in both ISIS and TSS will have one row per tool.

See SAH-TSS_What to Expect Pt1_20250123 for more information.

Student Name

SIS Data Source

Student PID

(depends on SIS Data Source)

Legacy Student PID

(from ISIS)

TSS Student Number

(from TSS)

Student Name

SIS Data Source

Student PID

(depends on SIS Data Source)

Legacy Student PID

(from ISIS)

TSS Student Number

(from TSS)

Mouse, Mickey

ISIS

A45678901

A45678901

200030123

Mouse, Mickey

TSS

200030123

A45678901

200030123

Q: When are the FA26 incoming students available in SAH?

A. FA26 incoming student’s who have accepted their offer to UCSD will be available in SAH after the end of March 2026 as they appear in TSS.

Q: When will new Course ID’s be available in SAH?

A: In the April UAT / May Prod release.

Q: When will the FA26 Course information be available in SAH?

A: In the April UAT / May Prod release.

Q: When will Instructor IDs (UCPath IDs) be available in SAH?

A: UCPath IDs for Instructors is currently available in SAH. The field name and contents are not expected to change at this time. If TSS creates a new ID/Number for the Instructor then SAH will be enhanced with a new field to match.

Q: For February, do we need to request the Column Groups be updated with the metadata fields?

A: No, the column groups impacted by the Views listed in the February release above will automatically be updated with the metadata fields: SIS Data Source, Legacy Student PID and TSS Student Number. Just like the Cognos packages and Tableau data sources.

Q: When will we see the TSS Student Number in other Activity Hubs?

A: That depends on the Activity Hub and the source of the data.

In EAH and FACAH the Identity Student PID comes from the Affiliates table, which is a cross-walk for a variety of ID's for persons across campus. The Affiliates table will be adding a TSS Student Number, which will allow us to add an Identity TSS Student Number to EAH and FACAH. In EAH-PersonTraining-View we do display the Student PID from ISIS, BIA will convert that field to the TSS Student Number once we get a chance to repoint it - the exact timeing is TBD for now.

In FINAH we are displaying the value seen in Oracle and will continue to do so. When Oracle displays the TSS Student Number in the Student PID field in FINAH the day after.

Q: Clinical Residents are not in ISIS but are in SAH. Will they be in TSS?

A: No. At this time Clinical Residents will not be loaded into TSS. SAH will continue to display Clinical Resident information include populating the same value into Student PID, Legacy Student PID and TSS Student Number for each Clinical Resident.

Q: What if TSS doesn’t match ISIS?

A: That depends, is it supposed to? Email esr-student@ucsd.edu with specific questions, but there are multiple reasons why TSS doesn’t match ISIS.

  • ISIS data hasn’t been migrated yet or will not be migrated to TSS.

  • ISIS data was migrated as a new value or format.

  • Student or UCSD staff have updated the data in TSS. Updates in TSS will not be duplicated in ISIS.

Q: What will the new Term ID values look like?

A: Term ID does not exist in TSS so SAH will be creating this value based on AcademicYear-TermSession-AcademicCalendarCode.

Term ID from ISIS will remain the same four digit code.

SIS Data Source

Term Year (YYYY)

Term ID

Term Code

Term

SIS Data Source

Term Year (YYYY)

Term ID

Term Code

Term

TSS

2024

2024-002-GR

FA24

Fall Quarter 2024

TSS

2024

2024-002-SOM

FA24

Fall Quarter 2024

TSS

2024

2024-002-SSPPS

FA24

Fall Quarter 2024

TSS

2024

2024-002-UN

FA24

Fall Quarter 2024

TSS

2024

2024-003-GR

WI25

Winter Quarter 2025

TSS

2024

2024-003-SSPPS

WI25

Winter Quarter 2025

TSS

2024

2024-003-UN

WI25

Winter Quarter 2025

TSS

2024

2024-004-GR

SP25

Spring Quarter 2025

TSS

2024

2024-004-SOM

SP25

Spring Quarter 2025

TSS

2024

2024-004-SSPPS

SP25

Spring Quarter 2025

TSS

2024

2024-004-UN

SP25

Spring Quarter 2025

TSS

2024

2024-008-SOM

SU25

Summer Health Sci 2025

TSS

2024

2024-008-SSPPS

SU25

Summer Health Sci 2025

TSS

2024

2024-009-GR

SU25

Summer Session 2025

TSS

2025

2025-002-GR

FA25

Fall Quarter 2025

TSS

2025

2025-002-SOM

FA25

Fall Quarter 2025

TSS

2025

2025-002-SSPPS

FA25

Fall Quarter 2025

TSS

2025

2025-002-UN

FA25