What's new in Customer Journeys?

Connect and learn more!
What is the SFP OAS SQL for the ISIR used by student enrollment / package version / award year? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What is the SFP OAS SQL for the ISIR used by student enrollment / package version / award year?

Accepted answer
64
Views
6
Comments

Summary:

How do I use SQL in SFP OAS to get ISIR fields for the ISIR that was used for a student enrollment's package version and award year?

Content (required):

How do I use SQL in SFP OAS to get ISIR fields for the ISIR that was used for a student enrollment's package version and award year? This is not necessarily the same as the currently active ISIR. ISIR_FIELDS_ALL_VW has the fields but I cannot see how to find the CPS Transaction Number for the ISIR that was used for a student enrollment's package version and award year. I tried to look in the SFP Reporting View Documentation PDF report output to find the answer, but it's an over-600 page alphabetical listing of views with one or two sentences per

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!