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
- 2 SAH Schedule*
- 2.1 January 2026
- 2.2 Now until February 27, 2026
- 2.3 February 27, 2026 TSS Test data UAT has started
- 2.4 February Test Data in Hana QA pay attention uat has started
- 2.5 March 25, 2026 tss prod data
- 2.6 End of April 2026
- 2.7 End of May 2026 tss prod data
- 2.8 End of June 2026
- 2.9 End of July 2026 tss prod data
- 3 Resources
- 4 SAH Impacts
- 5 Q&A
- 5.1 Q. When will TSS Student Number be available in SAH?
- 5.2 Q. What will the TSS Student Number look like in SAH?
- 5.3 Q: When are the FA26 incoming students available in SAH?
- 5.4 Q: When will new Course ID’s be available in SAH?
- 5.5 Q: When will the FA26 Course information be available in SAH?
- 5.6 Q: When will Instructor IDs (UCPath IDs) be available in SAH?
- 5.7 Q: For February, do we need to request the Column Groups be updated with the metadata fields?
- 5.8 Q: When will we see the TSS Student Number in other Activity Hubs?
- 5.9 Q: Clinical Residents are not in ISIS but are in SAH. Will they be in TSS?
- 5.10 Q: What if TSS doesn’t match ISIS?
- 5.11 Q: What will the new Term ID values look like?
- 5.12 Q: Can we still filter Term ID for > 2024?
- 5.13 Q: The Test data in Hana QA is showing a 10-digit TSS Student Number. Is that expected?
- 5.14 Q: I see “SIS Data Source”, “Legacy Student PID” and “TSS Student Number” in UAT for SAH-StudentStatsPerTerm and SAH-Enrollment. Does that mean there is TSS data in those views?
- 5.15 Q: What will the TSS Major Codes look like?
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
Watch the “SAH-TSS_What to Expect” videos found in SAH-TSS 2026 Presentations
Prioritize which reports or data integrations you need to check based on when TSS data will appear for that view in SAH: View Impact Per Release.xlsx*
Add SAH-TSS Office Hours to your calendar: SAH from TSS Office Hours
February 27, 2026 TSS Test data UAT has started
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
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 |
|---|---|---|
BIA | OneDrive folder with presentation recordings and PPTs. | |
BIA | PPT presentations of how TSS data will be displayed in SAH | |
BIA | Demo example of what a continuing student will look like in SAH with TSS data | |
BIA | Demo example of what a new summer Grad student will look like in SAH with TSS data | |
BIA | Per SAH view, when and where should you expect to see TSS rows of data
| |
BIA | How to access the data dictionary for SAH (and all other Activity Hubs). | |
TSS | TSS timeline, demonstrations and more. | |
TSS | https://ucsdcollab.atlassian.net/wiki/spaces/SISCORE/pages/300777528 | TSS communications deck and other informational resources |
BIA | Analogy about test data vs production data | |
BIA | 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) |
|---|---|---|---|---|
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) |
|---|---|---|---|---|
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 |
|---|---|---|---|---|
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 |