Student Unit Attempt Activity Update

 

The SUAAO-UPD application allows students to select the version of activities pertaining to their course that they wish to attend.

 

Transactions

It calls 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 (SSFF1100) 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, the transaction log is updated to include that an email and or receipt was issued and the email Address that it was issued to.

An example of a screen before a transaction:

SUA transaction before

 

An example of a screen after a transaction:

SCA transaction after

 

Template Processing

This CCEMBED statement is also responsible for displaying the receipt body on the screen.

In the RECEIPT template it should be noted that the two tables (previous selections and current selections) are repeated for each unit within each course.

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

Logging Sequence

Prompt Name

Old Value

New Value

1

Student ID

p_person_id

p_person_id

2

Full Name

^v_full_name

^v_full_name

3

Receipt Number

p_receipt_num

p_receipt_num

**

###PREVIOUS_SELECTIONS###

NULL

NULL

**

###PREVIOUS_COURSE_UNIT###

NULL

NULL

*

Course Code

^rv_course_cd

^rv_course_cd

*

Course

^rv_crv_title

^rv_crv_title

*

Unit Code

^rv_unit_cd

^rv_unit_cd

*

Unit

^rv_uv_title

^rv_uv_title

*

Activity Group

^rv_activity_group_cd

NULL

*

Activity

^rv_activity_cd

NULL

*

Day

^rv_day

NULL

*

Start

^rv_start_time

NULL

*

End

^rv_end_time

NULL

*

Venue

^rv_venues

NULL

*

Lecturer/Tutor

^rv_staff

NULL

*

Week

^rv_weeks

NULL

**

###CURRENT_SELECTIONS###

NULL

NULL

**

###CURRENT_COURSE_UNIT###

NULL

NULL

*

Course Code

NULL

^rv_course_cd

*

Course

NULL

^rv_crv_title

*

Unit Code

NULL

^rv_unit_cd

*

Unit

NULL

^rv_uv_title

*

Activity Group

NULL

^rv_activity_group_cd

*

Activity

NULL

^rv_activity_cd

*

Day

NULL

^rv_day

*

Start

NULL

^rv_start_time

*

End

NULL

^rv_end_time

*

Venue

NULL

^rv_venues

*

Lecturer/Tutor

NULL

^rv_staff

*

Week

NULL

^rv_weeks

* These fields are repeated for each Course and Unit pair that the student is enrolled in.

** These fields are not actual logged values, instead they represent headings for sections of the logging and are there to allow easier identification of different logging sections. They repeat for each section, as indicated.

^ Denotes fields that need to be retrieved from the database prior to logging.

Note: If there is no previous/current  selection then log the prompt ‘NO_PREVIOUS_SELECTION’ / ‘NO_CURRENT_SELECTION’.

Note: Logging of the transaction parameters for this function actually logs the parameters with the same old and new value in every case. This is because there are many old values and new values, so to capture the old and new status we instead log each value on its own line, to give a complete context.

These parameters are logged into the SELF_SERVE_TRANSACTION_DETAIL table, however the old value and new value columns will always contain the same value, this data is included in the log as contextual reference for administrators reviewing the log.

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

Logging Sequence

Prompt Name

1

Student ID

2

Full Name

3

Receipt Number

N/A

###COURSE_UNIT_START###

N/A

Course Code

N/A

Course

N/A

Unit Code

N/A

Unit

N/A

###PREVIOUS_SELECTIONS###

N/A

Activity Group

N/A

Activity

N/A

Day

N/A

Start

N/A

End

N/A

Venue

N/A

Lecturer/Tutor

N/A

Week

N/A

###CURRENT_SELECTIONS###

N/A

Activity Group

N/A

Activity

N/A

Day

N/A

Start

N/A

End

N/A

Venue

N/A

Lecturer/Tutor

N/A

Week

 

 

Last Modified on 16 May, 2007 3:33 PM

History Information

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