Student Course Attempt Exam Location Update

The Student Course Attempt Exam Location Update Application (SCA-EX-UPD) allows students to update their nominated examination location for their course attempts..

The Student Course Attempt Exam Location Update Application can be controlled through the use of cohort process windows. A cohort process window created for the Process Type SCA-EX-UPD defines the type of students that can access the exam update and application and when access is allowed.

For further information on Examination Applications see SSF-EXAM.

This application can call a function that checks if the application Log Transaction check box in Maintain Self Serve Applications (SSFF1100) is set, and when it is, log the details of successful transactions.

The application page displays a receipt after each transaction has been successfully run if the Issue Receipt check box is set in the SELF_SERVE_APPLICATION table. It also sends an email to the user whose data is being modified if the Issue Email check box is set for the application on the SELF_SERVE_APPLICATION table (SSFF1100).

After the emails and receipt are successfully issued then the Transaction Log is updated to include that an email, and or receipt, was issued and the Email Address that it was issued to.

This application shares its working package with the SCA-UPD application, which means that much of the changes required to enable logging have already been made to the package.

Before an update of exam location:

sca-ex-upd before

 

After an update of exam location

sca-ex-upd after

 

After an update with no changes made:

sca-ex-upd no change

 

The fields to log and the sequence to log them in are:

Logging Sequence

Prompt Name

Old Value

New Value

1

Exam Location Code

v_sca_exam_location_cd

p_exam_location_cd

2

Exam Location Description

^v_old_sca_exam_loc_desc

^v_new_sca_exam_loc_desc

3

Student ID

p_person_id

p_person_id

4

Name

^v_full_name

^v_full_name

5

Course

^v_crv_title

^v_crv_title

6

Status

^v_course_attempt_status

^v_course_attempt_status

7

Campus

^v_location_desc

^v_location_desc

            ^ This value will need to be retrieved from the database during runtime.

Note: The logging of the transaction parameters for this function actually logs the parameters with the same old and new value for all but the first two parameters.

These parameters are logged into the SELF_SERVE_TRANSACTION_DETAIL table, however the old_value and new_value columns always contain the same value for all but the first two parameters. This data is included in the log as contextual reference for administrators reviewing the log. The first two parameters include the existing value (old value) and the newly updated value, whether they have changed or not.

The complete list of parameters that are logged and the order in which they are logged is:

Logging Sequence

Prompt Name

1

Exam Location Code

2

Exam Location Description

3

Student ID

4

Name

5

Course

6

Status

7

Campus

 

 

Last Modified on 11 October, 2010 10:45 AM

History Information

Release Information Project Changes to Document
10.0.0.0.0.0 1225 - Connect Transaction Management New Document