SAH Deprecated Fields
- Saparnell
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:
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.
ITS-BIA will allow a transition period for report developers to repoint their reports at the new fields / views.
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.
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 Field | Old 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 IDs | Class Section IDs | 2022-05-19 | 2022-05-19 | 2022-05-19 | 2022-05-26 | ||
| General Campus Term End Date | Course Term End Date | 2022-04-21 | 2022-04-21 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| General Campus Term Start Date | Course Term Start Date | 2022-04-21 | 2022-04-21 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| Education Abroad Program (EAP) Passed Units Current Cumulative | Education Abroad Program (EAP) Completed Units | 2021-08-19 | 2021-08-26 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
Removed from SAH-EnrollmentCensus-View as this field is no longer applicable. Can still be found in EAH-Enrollment-View. | Transfer Entity ID | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| Removed from SAH-EnrollmentCensus-View as this field is no longer applicable. Can still be found in EAH-Enrollment-View. | Transfer Entity Name | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-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 Flag | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-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 Count | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| Removed from SAH-EnrollmentCensus-View as this field is no longer applicable. Can still be found in EAH-Enrollment-View. | Waitlist DateTime Current | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| Removed from SAH-EnrollmentCensus-View as this field is no longer applicable. Can still be found in EAH-Enrollment-View. | Waitlist Flag Current | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| Removed from SAH-EnrollmentCensus-View as this field is no longer applicable. Can still be found in EAH-Enrollment-View. | Waitlist Count Current | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| Removed from SAH-EnrollmentCensus-View as this field is no longer applicable. Can still be found in EAH-Enrollment-View. | Waitlist Position Current | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| Enrolled At Census Date Count | Enrolled At Census Date Count Term | 2022-03-24 | 2022-03-31 | 2022-04-21 | 2022-04-28 | 2022-05-19 | 2022-05-26 |
| General Campus Term Instruction Start Date | Term Start Date | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 | 2022-05-19 | 2022-05-26 |
| General Campus Term Instruction End Date | Term End Date | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 | 2022-05-19 | 2022-05-26 |
Enrolled At End of Term Flag Enrolled At Census Date Flag | Class Section Enrollment Flag | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 | 2022-05-19 | 2022-05-26 |
Enrolled At End of Term Count Enrolled At Census Date Count | Class Section Enrollment Count | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 | 2022-05-19 | 2022-05-26 |
| Permanent Address Country Zip Current | Permanent Address Zip | 2022-01-20 | 2022-01-27 | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 |
| Permanent Address Country State Current | Permanent Address State | 2022-01-20 | 2022-01-27 | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 |
| Permanent Address Country Name Current | Permanent Address Country Name | 2022-01-20 | 2022-01-27 | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 |
| Permanent Address Country Code Current | Permanent Address Country Code | 2022-01-20 | 2022-01-27 | 2022-02-17 | 2022-02-24 | 2022-03-24 | 2022-03-31 |
IPEDS Pell Recipient Flag | 2021-05-20 | 2021-05-20 | 2021-05-20 | 2021-05-27 | 2021-06-17 | 2021-06-24 | |
IPEDS Pell Recipient Count | 2021-05-20 | 2021-05-20 | 2021-05-20 | 2021-05-27 | 2021-06-17 | 2021-06-24 | |
Enrollment Record Count | Enrollment Count | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Class Section Enrollment Count | Class Section Enrollment | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Permanent Address Country Code Current | Permanent Address Country Code | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Permanent Address Country Name Current | Permanent Address Country Name | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Permanent Address State Current | Permanent Address State | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Permanent Address Zip Current | Permanent Address Zip | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Education Abroad Program (EAP) Passed Units Current Cumulative | Education Abroad Program (EAP) Completed Units | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Opportunities Abroad Program (OAP) Passed Units Current Cumulative | Opportunities Abroad Program (OAP) Completed Units | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| International Bacccalaureate (IB) Passed Units Current Cumulative | International Bacccalaureate (IB) Completed Units | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Advanced Placement (AP) Passed Units Current Cumulative | Earned Advanced Placement (AP) Units | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| UG UC Transfer Passed Units Current Cumulative | UG UC Transfer Units | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| UG UC Transfer PNP Passed Units Current Cumulative | UC Transfer PNP Units Earned | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Grad UC Transfer Passed Units Current Cumulative | Grad UC Transfer Units | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |
| Course Subject Code | Subject Code | 2021-08-19 | 2021-08-26 | 2021-09-23 | 2021-09-30 | 2021-10-21 | 2021-10-28 |