SQL Tables to Campus Solutions SOLA Pages

Flow:

1. The applicant signs into institution's Admissions Application home page and accesses the SOLA component.

2. Assuming that this is not the first time the applicant is visiting the Admissions Application page, SOLA invokes the SAD_GETAPPLS web service operation. The SAD_GETAPPLS_RESP XML message contains all the key values for the applicant's applications.

3. This key information is presented in a grid format for the applicant to choose from, the applicant also has the option to create an entirely new application.

4. The applicant clicks the View button or the Edit button for an existing application and SOLA passes the key values for that specific application to the SAD_GET_APPL web service operation.

5. The SAD_GETAPPL_RESP XML response message contains all the data (both constituent and academic) associated with that specific application.

6. SOLA deconstructs the XML response message node by node and moves this deconstructed message to the corresponding SQL Views within the application page(s) in SOLA.

7. Once the XML response has been deconstructed, SOLA displays the page(s) to the applicant.