SAH Deprecated Fields

SAH Deprecated Fields

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 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