Versions Compared

Key

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

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 use the following 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.


Please note that report developers have from the *New Field Released to UAT (Hana QA) date until the **Old Field Deleted from Prod (Hana Prod) date to remediate their reports or data integrations without affecting their customers.

Roll-back after a field is deleted will not be possible.

New FieldOld Field*New Field Released to UAT (Hana QA)New Field Released to Prod (Hana Prod)Old Field Set to Null in UAT (Hana QA)Old Field Set to Null in PROD (Hana Prod)Old Field Deleted from UAT (Hana QA)**Old Field Deleted from Prod (Hana Prod)
Ever Enrolled Class Section IDsClass Section IDs2022-05-192022-05-192022-05-192022-05-26

General Campus Term End DateCourse Term End Date2022-04-212022-04-212022-04-212022-04-282022-05-192022-05-26
General Campus Term Start DateCourse Term Start Date2022-04-212022-04-212022-04-212022-04-282022-05-192022-05-26
Education Abroad Program (EAP) Passed Units Current CumulativeEducation Abroad Program (EAP) Completed Units2021-08-192021-08-262022-04-212022-04-282022-05-192022-05-26

Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Transfer Entity IDn/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Transfer Entity Namen/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Transfer Class Section Flagn/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Transfer Class Section Countn/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Waitlist DateTime Currentn/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Waitlist Flag Currentn/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Waitlist Count Currentn/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable.

Can still be found in EAH-Enrollment-View.

Waitlist Position Currentn/an/a2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
Enrolled At Census Date CountEnrolled At Census Date Count Term2022-03-242022-03-312022-04-212022-04-282022-05-192022-05-26
General Campus Term Instruction Start DateTerm Start Date2022-02-172022-02-242022-03-242022-03-312022-05-192022-05-26
General Campus Term Instruction End DateTerm End Date 2022-02-172022-02-242022-03-242022-03-312022-05-192022-05-26

Enrolled At End of Term Flag

Enrolled At Census Date Flag

Class Section Enrollment Flag2022-02-172022-02-242022-03-242022-03-312022-05-192022-05-26

Enrolled At End of Term Count

Enrolled At Census Date Count 

Class Section Enrollment Count2022-02-172022-02-242022-03-242022-03-312022-05-192022-05-26
Permanent Address Country Zip CurrentPermanent Address Zip2022-01-202022-01-272022-02-172022-02-242022-03-07242022-03-1131
Permanent Address Country State CurrentPermanent Address State2022-01-202022-01-272022-02-172022-02-242022-03-07242022-03-1131
Permanent Address Country Name CurrentPermanent Address Country Name2022-01-202022-01-272022-02-172022-02-242022-03-07242022-03-1131
Permanent Address Country Code CurrentPermanent Address Country Code2022-01-202022-01-272022-02-172022-02-242022-03-07242022-03-1131

IPEDS Pell Recipient Flag

2021-05-202021-05-202021-05-202021-05-272021-06-172021-06-24

IPEDS Pell Recipient Count

2021-05-202021-05-202021-05-202021-05-272021-06-172021-06-24

Enrollment Record Count

Enrollment Count2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Class Section Enrollment CountClass Section Enrollment2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Permanent Address Country Code CurrentPermanent Address Country Code2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Permanent Address Country Name CurrentPermanent Address Country Name2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Permanent Address State CurrentPermanent Address State2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Permanent Address Zip CurrentPermanent Address Zip2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Education Abroad Program (EAP) Passed Units Current CumulativeEducation Abroad Program (EAP) Completed Units2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Opportunities Abroad Program (OAP) Passed Units Current CumulativeOpportunities Abroad Program (OAP) Completed Units2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
International Bacccalaureate (IB) Passed Units Current CumulativeInternational Bacccalaureate (IB) Completed Units2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Advanced Placement (AP) Passed Units Current CumulativeEarned Advanced Placement (AP) Units2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
UG UC Transfer Passed Units Current CumulativeUG UC Transfer Units2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
UG UC Transfer PNP Passed Units Current CumulativeUC Transfer PNP Units Earned2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Grad UC Transfer Passed Units Current CumulativeGrad UC Transfer Units2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28
Course Subject CodeSubject Code2021-08-192021-08-262021-09-232021-09-302021-10-212021-10-28