Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Hello SAH Developers - The below enhancements are available for you in Hana Production now. 

Keep up with our future enhancements here: SAH Bugs and Enhancements In Progress. 

For access to the Student Activity Hub (SAH) you must be pre-approved by the registrar's office.  Please reach out to them directly.

Table of Contents


P4 - High Security Level Fields

UpdateUpon further testing, BIA has determined that the Tableau column based security implementation does not meet our security standards. Therefore, BIA will be not be releasing the P4 fields via Tableau until a new security implementation can be determined.  The Cognos column based security implementation both meets our security standards and meets our customer needs, therefore it P4 fields will be released in Cognos DEV (now), Cognos QA (starting Jan 27) and Cognos Production (starting Jan 27).

Each Activity Hub Field has a security level associated with it.  Security levels are defined by the University Of California Office of the President (UCOP) and assigned Data Stewards.  For more information visit the Policies section under System Information Security on the UCOP webpage, ucop.edu. Security Levels can be found under Protection Level Classification.  A full list of P4 fields can be found below in the SAH-Demographics-View and SAH-StudentStatsPerTerm-View.

To access P4 fields as a report developer or report consumer you must be a member of a P4 Active Directory Group for that Activity Hub and/or data source.  As P4 fields are added to Activity Hubs new Service Now request forms will be created to request access.  This access is separate from access to run reports, view reports or build reports.

Report developers are responsible for the content they add to their reports and the audience they share the report with.  Active Directory (AD) Groups are used at multiple levels: (1) at the SAH data source / package level, (2) at the report folder and (3) at the P4 field.  The table below show the expectations of what reports developers and report consumers should expect to see. 

UserCognosTableau
Report Consumer in a P4 AD GroupWill see the P4 fields and values in the reports they can run.Will see no P4 fields.
Report Consumer outside a P4 AD GroupWill see an error message.Will see no P4 fields.
Report Developer in a P4 AD GroupWill see the P4 fields and values.Will see no P4 fields.
Report Developer outside a P4 AD GroupWill not see any P4 fields.Will see no P4 fields.

More information can be found in the Analytics Community of Practice collab.

Renaming and Deprecating

As we've adapted the SAH views to your needs, we have found changing field names is painful for both report developers and our team due to the name change breaking reports, data integrations and packages / data sources.  In an effort to avoid this pain, we are going to introduce a new name change strategy. 

  1. ITS-BIA will release new fields with the revised field name in the views that contain the field to be renamed, or where a view is to be renamed ITS-BIA will release as a new view the view with the revised name.

  2. ITS-BIA will allow a transition period for report developers to repoint their reports at the new fields / views.

  3. ITS-BIA will remove the data from the old fields / views and allow a second transition period.  This will not break the report but will highlight where the fields / views are still in use as they will become blank.

  4. ITS-BIA will deprecate the fields / views.  Any reports the have not transitioned by this point will break.

We'll be using this new strategy on the following items that require name changes.  In a previous release we set the old fields to null, this release we will be deleting the out-going fields.

  • Permanent Address Country Code

  • Permanent Address Country Name

  • Permanent Address State

  • Permanent Address Zip

  • Pell Awarded Date

  • Pell This Term Count

  • Pell This Term Flag

  • Pell This Term or Past Term Count

  • Pell This Term or Past Term Flag


Your Requested Enhancements!

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.


Ui expand
titleSAH-Admission-View

SAH-Admission-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2403

Added the following fields:

  • Gender Identity Application

  • Gender Identity Code Application

  • Sexual Orientation Application

  • Sexual Orientation Code Application

  • Sexual Orientation Free Text Application

  • UG Application Counselor Release Restriction

  • UG Application Family Release Restriction

  • UG Application Other UC Release Restriction

  • UG Application Scholarship Release Restriction

  • UG Application UC Org Release Restriction


Ui expand
titleSAH-Demographics-View et al

SAH-Demographics-View & SAH-Demographics-IR-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2399

Added the following fields:

  • Advanced Placement (AP) Passed Units Current Cumulative
  • Education Abroad Program (EAP) Passed Units Current Cumulative
  • Ethnicity Afghan Count Current P4
  • Ethnicity Afghan Flag Current P4
  • Ethnicity African American Count Current P4
  • Ethnicity African American Flag Current P4
  • Ethnicity African Count Current P4
  • Ethnicity African Flag Current P4
  • Ethnicity Algerian Count Current P4
  • Ethnicity Algerian Flag Current P4
  • Ethnicity American Indian/Alaskan Native Count Current P4
  • Ethnicity American Indian/Alaskan Native Flag Current P4
  • Ethnicity Armenian Count Current P4
  • Ethnicity Armenian Flag Current P4
  • Ethnicity Asian Indian/East Indian/Pakistani Count Current P4
  • Ethnicity Asian Indian/East Indian/Pakistani Flag Current P4
  • Ethnicity Assyrian/Chaldean Count Current P4
  • Ethnicity Assyrian/Chaldean Flag Current P4
  • Ethnicity Azerbaijani Count Current P4
  • Ethnicity Azerbaijani Flag Current P4
  • Ethnicity Bahraini Count Current P4
  • Ethnicity Bahraini Flag Current P4
  • Ethnicity Bangladeshi Count Current P4
  • Ethnicity Bangladeshi Flag Current P4
  • Ethnicity Berber Count Current P4
  • Ethnicity Berber Flag Current P4
  • Ethnicity Cambodian Count Current P4
  • Ethnicity Cambodian Flag Current P4
  • Ethnicity Caribbean Count Current P4
  • Ethnicity Caribbean Flag Current P4
  • Ethnicity Chinese/Chinese American Count Current P4
  • Ethnicity Chinese/Chinese American Flag Current P4
  • Ethnicity Circassian Count Current P4
  • Ethnicity Circassian Flag Current P4
  • Ethnicity Cuban/Cuban American Count Current P4
  • Ethnicity Cuban/Cuban American Flag Current P4
  • Ethnicity Djiboutian Count Current P4
  • Ethnicity Djiboutian Flag Current P4
  • Ethnicity Egyptian Count Current P4
  • Ethnicity Egyptian Flag Current P4
  • Ethnicity Emirati Count Current P4
  • Ethnicity Emirati Flag Current P4
  • Ethnicity Fijian Count Current P4
  • Ethnicity Fijian Flag Current P4
  • Ethnicity Filipino/Filipino American Count Current P4
  • Ethnicity Filipino/Filipino American Flag Current P4
  • Ethnicity Georgian Count Current P4
  • Ethnicity Georgian Flag Current P4
  • Ethnicity Guamanian Count Current P4
  • Ethnicity Guamanian Flag Current P4
  • Ethnicity Hawaiian Count Current P4
  • Ethnicity Hawaiian Flag Current P4
  • Ethnicity Hmong Count Current P4
  • Ethnicity Hmong Flag Current P4
  • Ethnicity Indonesian Count Current P4
  • Ethnicity Indonesian Flag Current P4
  • Ethnicity IPEDS Derived Code Current P4
  • Ethnicity IPEDS Derived Current P4
  • Ethnicity Iranian Count Current P4
  • Ethnicity Iranian Flag Current P4
  • Ethnicity Iraqi Count Current P4
  • Ethnicity Iraqi Flag Current P4
  • Ethnicity Israeli Count Current P4
  • Ethnicity Israeli Flag Current P4
  • Ethnicity Japanese/Japanese American Count Current P4
  • Ethnicity Japanese/Japanese American Flag Current P4
  • Ethnicity Jordanian Count Current P4
  • Ethnicity Jordanian Flag Current P4
  • Ethnicity Korean/Korean American Count Current P4
  • Ethnicity Korean/Korean American Flag Current P4
  • Ethnicity Kurdish Count Current P4
  • Ethnicity Kurdish Flag Current P4
  • Ethnicity Kuwaiti Count Current P4
  • Ethnicity Kuwaiti Flag Current P4
  • Ethnicity Laotian Count Current P4
  • Ethnicity Laotian Flag Current P4
  • Ethnicity Latin American Count Current P4
  • Ethnicity Latin American Flag Current P4
  • Ethnicity Lebanese Count Current P4
  • Ethnicity Lebanese Flag Current P4
  • Ethnicity Libyan Count Current P4
  • Ethnicity Libyan Flag Current P4
  • Ethnicity Malaysian Count Current P4
  • Ethnicity Malaysian Flag Current P4
  • Ethnicity Mauritanian Count Current P4
  • Ethnicity Mauritanian Flag Current P4
  • Ethnicity Mexican/Mexican American/Chicano Count Current P4
  • Ethnicity Mexican/Mexican American/Chicano Flag Current P4
  • Ethnicity Middle Eastern/Middle Eastern Descent Count Current P4
  • Ethnicity Middle Eastern/Middle Eastern Descent Flag Current P4
  • Ethnicity Moroccan Count Current P4
  • Ethnicity Moroccan Flag Current P4
  • Ethnicity North African Count Current P4
  • Ethnicity North African Flag Current P4
  • Ethnicity Omani Count Current P4
  • Ethnicity Omani Flag Current P4
  • Ethnicity Other Asian/Asian American Count Current P4
  • Ethnicity Other Asian/Asian American Flag Current P4
  • Ethnicity Other Black Count Current P4
  • Ethnicity Other Black Flag Current P4
  • Ethnicity Other Count Current P4
  • Ethnicity Other Flag Current P4
  • Ethnicity Other Hispanic/Latino Count Current P4
  • Ethnicity Other Hispanic/Latino Flag Current P4
  • Ethnicity Other North African Count Current P4
  • Ethnicity Other North African Flag Current P4
  • Ethnicity Other Pacific Islander Count Current P4
  • Ethnicity Other Pacific Islander Flag Current P4
  • Ethnicity Other Southwest Asian Count Current P4
  • Ethnicity Other Southwest Asian Flag Current P4
  • Ethnicity Other White Count Current P4
  • Ethnicity Other White Flag Current P4
  • Ethnicity Pakistani Count Current P4
  • Ethnicity Pakistani Flag Current P4
  • Ethnicity Palestinian Count Current P4
  • Ethnicity Palestinian Flag Current P4
  • Ethnicity Puerto Rican Count Current P4
  • Ethnicity Puerto Rican Flag Current P4
  • Ethnicity Qatari Count Current P4
  • Ethnicity Qatari Flag Current P4
  • Ethnicity Samoan Count Current P4
  • Ethnicity Samoan Flag Current P4
  • Ethnicity Saudi Arabian Count Current P4
  • Ethnicity Saudi Arabian Flag Current P4
  • Ethnicity Somali Count Current P4
  • Ethnicity Somali Flag Current P4
  • Ethnicity Sri Lankan Count Current P4
  • Ethnicity Sri Lankan Flag Current P4
  • Ethnicity Sudanese Count Current P4
  • Ethnicity Sudanese Flag Current P4
  • Ethnicity Syrian Count Current P4
  • Ethnicity Syrian Flag Current P4
  • Ethnicity Taiwanese/Taiwanese American Count Current P4
  • Ethnicity Taiwanese/Taiwanese American Flag Current P4
  • Ethnicity Thai Count Current P4
  • Ethnicity Thai Flag Current P4
  • Ethnicity Tongan Count Current P4
  • Ethnicity Tongan Flag Current P4
  • Ethnicity Tunisian Count Current P4
  • Ethnicity Tunisian Flag Current P4
  • Ethnicity Turkish Count Current P4
  • Ethnicity Turkish Flag Current P4
  • Ethnicity UC Narrow Code Current P4
  • Ethnicity UC Narrow Current P4
  • Ethnicity Vietnamese/Vietnamese American Count Current P4
  • Ethnicity Vietnamese/Vietnamese American Flag Current P4
  • Ethnicity White/Caucasian Count Current P4
  • Ethnicity White/Caucasian Flag Current P4
  • Ethnicity Yemeni Count Current P4
  • Ethnicity Yemeni Flag Current P4
  • Gender Expression Code Current P4
  • Gender Expression Current P4
  • Gender Identity Code Current P4
  • Gender Identity Current P4
  • Grad UC Transfer Passed Units Current Cumulative
  • Graduate GPA Current Cumulative
  • International Bacccalaureate (IB) Passed Units Current Cumulative
  • Opportunities Abroad Program (OAP) Passed Units Current Cumulative
  • Photo URL Current
  • Sexual Orientation Code Current P4
  • Sexual Orientation Current P4
  • Student Active Hold Codes Current
  • UG GPA Current Cumulative
  • UG UC Transfer Passed Units Current Cumulative
  • UG UC Transfer PNP Passed Units Current Cumulative




Ui expand
titleSAH-Enrollment-View and SAH-EnrollmentCensus-View

SAH-Enrollment-View and SAH-EnrollmentCensus-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2416

Added the following fields:

  • Course End Term Code
  • Course Start Term Code
  • Grade Point Units
  • Grade Points = repurposed to Grade Value * Grade Point Units
  • Grade Value


Ui expand
titleSAH-StudentSchedule-View

SAH-StudentSchedule-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2431

Added the following fields:

  • Course End Term Code
  • Course Start Term Code


Ui expand
titleSAH-StudentStatsPerTerm-View and SAH-StudentStatsPerTermCensus-View et al

SAH-StudentStatsPerTerm-View & SAH-StudentStatsPerTermCensus-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2397

Added the following fields:

Ethnicity Afghan Count P4
Ethnicity Afghan Flag P4
Ethnicity African American Count P4
Ethnicity African American Flag P4
Ethnicity African Count P4
Ethnicity African Flag P4
Ethnicity Algerian Count P4
Ethnicity Algerian Flag P4
Ethnicity American Indian/Alaskan Native Count P4
Ethnicity American Indian/Alaskan Native Flag P4
Ethnicity Armenian Count P4
Ethnicity Armenian Flag P4
Ethnicity Asian Indian/East Indian/Pakistani Count P4
Ethnicity Asian Indian/East Indian/Pakistani Flag P4
Ethnicity Assyrian/Chaldean Count P4
Ethnicity Assyrian/Chaldean Flag P4
Ethnicity Azerbaijani Count P4
Ethnicity Azerbaijani Flag P4
Ethnicity Bahraini Count P4
Ethnicity Bahraini Flag P4
Ethnicity Bangladeshi Count P4
Ethnicity Bangladeshi Flag P4
Ethnicity Berber Count P4
Ethnicity Berber Flag P4
Ethnicity Cambodian Count P4
Ethnicity Cambodian Flag P4
Ethnicity Caribbean Count P4
Ethnicity Caribbean Flag P4
Ethnicity Chinese/Chinese American Count P4
Ethnicity Chinese/Chinese American Flag P4
Ethnicity Circassian Count P4
Ethnicity Circassian Flag P4
Ethnicity Cuban/Cuban American Count P4
Ethnicity Cuban/Cuban American Flag P4
Ethnicity Djiboutian Count P4
Ethnicity Djiboutian Flag P4
Ethnicity Egyptian Count P4
Ethnicity Egyptian Flag P4
Ethnicity Emirati Count P4
Ethnicity Emirati Flag P4
Ethnicity Fijian Count P4
Ethnicity Fijian Flag P4
Ethnicity Filipino/Filipino American Count P4
Ethnicity Filipino/Filipino American Flag P4
Ethnicity Georgian Count P4
Ethnicity Georgian Flag P4
Ethnicity Guamanian Count P4
Ethnicity Guamanian Flag P4
Ethnicity Hawaiian Count P4
Ethnicity Hawaiian Flag P4
Ethnicity Hmong Count P4
Ethnicity Hmong Flag P4
Ethnicity Indonesian Count P4
Ethnicity Indonesian Flag P4
Ethnicity IPEDS Derived Code P4
Ethnicity IPEDS Derived P4
Ethnicity Iranian Count P4
Ethnicity Iranian Flag P4
Ethnicity Iraqi Count P4
Ethnicity Iraqi Flag P4
Ethnicity Israeli Count P4
Ethnicity Israeli Flag P4
Ethnicity Japanese/Japanese American Count P4
Ethnicity Japanese/Japanese American Flag P4
Ethnicity Jordanian Count P4
Ethnicity Jordanian Flag P4
Ethnicity Korean/Korean American Count P4
Ethnicity Korean/Korean American Flag P4
Ethnicity Kurdish Count P4
Ethnicity Kurdish Flag P4
Ethnicity Kuwaiti Count P4
Ethnicity Kuwaiti Flag P4
Ethnicity Laotian Count P4
Ethnicity Laotian Flag P4
Ethnicity Latin American Count P4
Ethnicity Latin American Flag P4
Ethnicity Lebanese Count P4
Ethnicity Lebanese Flag P4
Ethnicity Libyan Count P4
Ethnicity Libyan Flag P4
Ethnicity Malaysian Count P4
Ethnicity Malaysian Flag P4
Ethnicity Mauritanian Count P4
Ethnicity Mauritanian Flag P4
Ethnicity Mexican/Mexican American/Chicano Count P4
Ethnicity Mexican/Mexican American/Chicano Flag P4
Ethnicity Middle Eastern/Middle Eastern Descent Count P4
Ethnicity Middle Eastern/Middle Eastern Descent Flag P4
Ethnicity Moroccan Count P4
Ethnicity Moroccan Flag P4
Ethnicity North African Count P4
Ethnicity North African Flag P4
Ethnicity Omani Count P4
Ethnicity Omani Flag P4
Ethnicity Other Asian/Asian American Count P4
Ethnicity Other Asian/Asian American Flag P4
Ethnicity Other Black Count P4
Ethnicity Other Black Flag P4
Ethnicity Other Count P4
Ethnicity Other Flag P4
Ethnicity Other Hispanic/Latino Count P4
Ethnicity Other Hispanic/Latino Flag P4
Ethnicity Other North African Count P4
Ethnicity Other North African Flag P4
Ethnicity Other Pacific Islander Count P4
Ethnicity Other Pacific Islander Flag P4
Ethnicity Other Southwest Asian Count P4
Ethnicity Other Southwest Asian Flag P4
Ethnicity Other White Count P4
Ethnicity Other White Flag P4
Ethnicity Pakistani Count P4
Ethnicity Pakistani Flag P4
Ethnicity Palestinian Count P4
Ethnicity Palestinian Flag P4
Ethnicity Puerto Rican Count P4
Ethnicity Puerto Rican Flag P4
Ethnicity Qatari Count P4
Ethnicity Qatari Flag P4
Ethnicity Samoan Count P4
Ethnicity Samoan Flag P4
Ethnicity Saudi Arabian Count P4
Ethnicity Saudi Arabian Flag P4
Ethnicity Somali Count P4
Ethnicity Somali Flag P4
Ethnicity Sri Lankan Count P4
Ethnicity Sri Lankan Flag P4
Ethnicity Sudanese Count P4
Ethnicity Sudanese Flag P4
Ethnicity Syrian Count P4
Ethnicity Syrian Flag P4
Ethnicity Taiwanese/Taiwanese American Count P4
Ethnicity Taiwanese/Taiwanese American Flag P4
Ethnicity Thai Count P4
Ethnicity Thai Flag P4
Ethnicity Tongan Count P4
Ethnicity Tongan Flag P4
Ethnicity Tunisian Count P4
Ethnicity Tunisian Flag P4
Ethnicity Turkish Count P4
Ethnicity Turkish Flag P4
Ethnicity UC Narrow Code P4
Ethnicity UC Narrow P4
Ethnicity Vietnamese/Vietnamese American Count P4
Ethnicity Vietnamese/Vietnamese American Flag P4
Ethnicity White/Caucasian Count P4
Ethnicity White/Caucasian Flag P4
Ethnicity Yemeni Count P4
Ethnicity Yemeni Flag P4
Gender Expression Code P4
Gender Expression P4
Gender Identity Code P4
Gender Identity P4
Sexual Orientation Code P4
Sexual Orientation P4


Ui expand
titleSAH-LMS-CB-StudentCourseStatsPerTerm-View

SAH-LMS-CB-StudentCourseStatsPerTerm-View

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keySAHMAINT-2442

Added the following fields:

  • Grade Point Units Current Cumulative