| Top of SSF | Index | Table of Contents | Feedback | |
Student Unit Set Attempt Enrolment
This function allows students to:
This section includes:
Application Data information is as follows:
Table or View Name |
Alias |
Data Diagram |
|---|---|---|
PERSON |
PE |
PE - PERSON |
STUDENT_COURSE_ATTEMPT |
ENR – STUDENT COURSE ATTEMPT |
|
STUDENT_UNIT_SET_ ATTEMPT |
SUSA |
CRS-ENR – UNIT SETS |
COURSE_OFFERING_UNIT_SET |
COUS |
CRS – COURSE OFFERING |
CRS_OFF_UNIT_SET_RELATIONSHIP |
COUSR |
CRS – COURSE OFFERING |
S_UNIT_SET_CONF |
SUSC |
SSF - SELF MANAGEMENT OF UNIT SETS |
COURSE_VERSION |
CRV |
CRS- COURSE DETAILS |
UNIT_SET |
US |
CRS-ENR – UNIT SETS |
UNIT_SET_CAT |
USC |
CRS-ENR – UNIT SETS |
COHORT_ PROCESS_WINDOW |
CPW |
GEN – ACCESS WINDOWS |
S_PROCESS_TYPE_APPLICATION |
SPTA |
SSF – SELF SERVICE APPLICATION |
S_PROCESS_TYPE |
SPTYP |
GEN – ACCESS WINDOWS |
CAL_ INSTANCE |
CI |
CAL – CALENDAR |
CAL_STATUS |
CS |
CAL – CALENDAR |
COHORT |
CHRT |
GEN – ACCESS WINDOWS |
S_SELF_SERVE_APPLICATION_SR |
SSSASR |
SEC – SYSTEM DATA RESTRICTIONS |
CPW_SELF_ SERVE_APPL_RSTRCTN |
CSSAR |
GEN – ACCESS WINDOWS |
SELF_SERVE_APPLICATION |
SSAP |
SSF – SELF SERVE APPLICATION |
S_SELF_SERVE_ACTIVITY_LOG |
SSSAL |
SSF – ACTIVITY LOGGING |
SUSA_ENR_CACHE |
SUSAEC |
SSF – STUDENT UNIT SET ATTEMPT ENR |
SUSA_ENR_CACHE_ITEM |
SUSAECI |
SSF – STUDENT UNIT SET ATTEMPT ENR |
| SSF_SEARCH | SSFS | SSF - STUDENT UNIT SET ATTEMPT ENROLMENT |
| SSF_SEARCH_RESULTS | SSFSR | SSF - STUDENT UNIT SET ATTEMPT ENROLMENT |
The Reference Cursor should return:
Person ID
Course Code
Course Title
Unit Set Code
Unit Set Version Number
Unit Set Title
Administrative Unit Set indicator
Authorisation Required indicator
Self Enrolment indicator
Voluntarily ended indicator
Qualification Reference Code
Qualification Title
Unit Set Status
Used as Parent indicator
Parent Unit Set Code
Parent Unit Set Sequence Number
Rank
Highest Ranked indicator
Lower Primary indicator
Selection Date
Unit Set Category
End Date
Primary indicator
Action
Rule Breach Text
One Parent indicator
Ordering of records. The records in the ref cursor should be:
Examples of Internet Screen Layouts Are:
| Student ID: | 98876711 |
| Name: | JENNIFER KATE BEE |
| Course: | M300 - BACHELOR OF COMMERCE |
| Status: | ENROLLED |
Maximum number of enrolled unit sets allowed is 5.
Maximum number of enrolled primary unit sets allowed is 3.
| Unit Set Code | Version | Title | Category | Selection Date | End Date | Rank | Status | Parent Unit Set | Primary | Action | |
| CLMJ001 | 1 | COMMERCIAL LAW | MAJOR | 02/02/2005 | 1 | ENROLLED | ECON101 | END | |||
| ECON101 | 1 | ECONOMICS | MAJOR | 2 | UNCONFIRM | CONFIRM | |||||
| ELEC100 | 1 | ELECTRONIC COMMERCE | MAJOR | 01/02/2005 | 03/03/2005 | 1 | ENDED | REINSTATE | |||
| FLYE587 | 1 | FLYING | MAJOR | 2 | UNCONFIRM | ||||||
| MMKK100 | 2 | MARKETING | MAJOR | 04/02/2005 | 01/07/2005 | 2 | COMPLETED | ELEC100 | |||
| OWNT544 | 3 | RUN YOUR OWN BUSINESS | MAJOR | 06/01/2005 | 07/01/2005 | 2 | ENDED | ||||
| SEWF141 | 1 | SEWING | MAJOR | 05/01/2005 | 2 | ENROLLED | MMKK100 | ||||
| TAXF210 | 1 | TAXATION | CORE | 02/02/2005 | 2 | ENROLLED | END | ||||
| ACCT101 | 1 | ACCOUNTING | MAJOR | 1 | REMOVE | ||||||
| JOUR310 | 1 | JOURNALISM | MAJOR | 3 | REMOVE |
| Student ID: | 98876711 |
| Name: | JENNIFER KATE BEE |
| Course: | M300 - BACHELOR OF COMMERCE |
| Status: | ENROLLED |
Maximum number of enrolled unit sets allowed is 5.
Maximum number of enrolled primary unit sets allowed is 3.
| Unit Set Code | Version | Title | Category | Selection Date | End Date | Rank | Status | Parent Unit Set | Primary | Action | |
| CLMJ001 | 1 | COMMERCIAL LAW | MAJOR | 02/02/2005 | 1 | ENROLLED | ECON101 | END | |||
| ECON101 | 1 | ECONOMICS | MAJOR | 2 | UNCONFIRM | CONFIRM | |||||
| ELEC100 | 1 | ELECTRONIC COMMERCE | MAJOR | 01/02/2005 | 03/03/2005 | 1 | ENDED | REINSTATE | |||
| FLYE587 | 1 | FLYING | MAJOR | 2 | UNCONFIRM | ||||||
| MMKK100 | 2 | MARKETING | MAJOR | 04/02/2005 | 01/07/2005 | 2 | COMPLETED | ELEC100 | |||
| OWNT544 | 3 | RUN YOUR OWN BUSINESS | MAJOR | 06/01/2005 | 07/01/2005 | 2 | ENDED | ||||
| SEWF141 | 1 | SEWING | MAJOR | 05/01/2005 | 2 | ENROLLED | MMKK100 | ||||
| TAXF210 | 1 | TAXATION | CORE | 02/02/2005 | 2 | ENROLLED | END | ||||
| ACCT101 | 1 | ACCOUNTING | MAJOR | 1 | REMOVE | ||||||
| JOUR310 | 1 | JOURNALISM | MAJOR | 3 | REMOVE |
Re-enrolment Navigation (back to all Self-enrolment steps)
Previous Step: Profile
Prompt |
Field Source |
Field Type |
Null |
Data Type, Length and Format Mask |
Default |
Comments |
Student ID: |
PE.PERSON |
Display Field
|
N |
NUMBER(10) 9999999999 |
null |
. |
Name: |
ssfp_get_person_name |
Display Field |
N |
VARCHAR(71) |
null |
Person full name (Given Names and/or Surname) |
Course: |
SUSA.COURSE_CD || ‘-‘ || CRV.TITLE |
Display Field |
N |
VARCHAR(123) |
null |
|
Status: |
SCA.COURSE_ATTEMPT_STATUS |
Link |
N |
VARCHAR(10) |
null |
Link to Course Attempt Status application (see SUSA-CENR for example) |
Qualification: |
COURSE_REFERENCE_CD. REFERENCE_CD || ‘-‘ || COURSE_REFERENCE_CD. .DESCRIPTION |
Display Field |
N |
VARCHAR(123) |
null |
Will display for VET only. |
Unit Set Code |
SUSA.UNIT_SET_CD |
Display Field |
N |
VARCHAR(10) |
null |
. |
Version |
SUSA.US_VERSION_NUMBER |
Display Field |
N |
NUMBER |
null |
. |
Title |
enrp_get_us_title |
Display Field |
N |
VARCHAR(90) |
null |
Either: SUSA.OVERRIDE_TITLE COUS.OVERRIDE_TITLE US.TITLE |
Category |
US.UNIT_SET_CAT |
Display Field |
N |
VARCHAR(10) |
null |
. |
Selection Date |
SUSA.SELECTION_DT |
Display Field |
DATE DD/MM/YYYY |
null |
. |
|
End Date |
SUSA.END_DT |
Display Field |
Date DD/MM/YYYY |
null |
. |
|
Rank |
UNIT_SET_CAT.RANK |
Display Field |
N |
NUMBER(3) |
null |
Display only |
Status |
enrp_get_susa_status |
Link |
N |
VARCHAR(10) |
null |
Link to Student Unit Set Attempt Status application (see SUSA-CENR for example) Status values can be: UNCONFIRM (student_confirmed_ind = ‘N’ or selection_dt is null) ENROLLED (end_dt is null and rqrmnts_complete_ind = ‘N’) COMPLETED (end_dt is not null and rqrmnts_complete_ind = ‘Y’) ENDED (end_dt is not null) |
Parent Unit Set |
SUSA.PARENT_UNIT_SET_CD |
Display Field (can have Add button or be a link) |
. |
VARCHAR(10) |
null |
SUSA.PARENT_SEQUENCE_NUMBER as hidden field |
Primary |
SUSA.PRIMARY_SET_IND |
Checkbox
|
N |
VARCHAR(1) |
null |
. |
Action |
Derived Actions can be: END CONFIRM REMOVE REINSTATE |
Checkbox with Action |
. |
VARCHAR(10) |
null |
END susa.voluntary_end_ind = ‘N’ and susa.end_dt is null and susa.rqrmnts_complete_ind = ‘N’ and susa.student_confirmed_ind = ‘Y’ CONFIRM susa.selection_dt is null and susa.student_confirmed_ind = ‘N’ REMOVE not in SUSA, but in susa_enr_cache_item REINSTATE susa.end_dt is not null and voluntary_end_ind = ‘Y’ Could be new function. |
Breach |
Use rulk_val_uset_rule.rulp_val_enrol_uset |
Tooltip |
. |
. |
null |
When there is a unit set rule breach, the tool tip will appear. The user will need to click on the Breach link to find out the details. Close window using the close text. Caption will be ‘Unit Set Rule Breach’. |
Validations include:
Activity |
Data To Be Included In Activity Log |
1. Student course attempt not available for self enrolment |
Person ID: Person_ID Message: Message_number Key includes: p_person_id|p_course_cd|p_enr_cal_type|p_enr_ci_sequence_number|p_course_level_ind|p_log_activity_ind URL: NULL Delivery Type: WEB Override Message: NULL Authenticated Message: Y Create Trans Ind: N |
2. Insufficient information to process maintenance of the student unit set attempt. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: NULL Authenticated Message: Y Create Trans Ind: N |
3. Student must have the unit set enrolment step to be able to maintain student unit set attempts via the self serve facility. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: NULL Authenticated Message: Y Create Trans Ind: N |
4. Student unit set attempt already exists. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: NULL Authenticated Message: Y Create Trans Ind: N |
5. Student unit set attempt does not exist. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: NULL Authenticated Message: Y Create Trans Ind: N |
6. Unable to process the student unit attempt details due to a record locking conflict. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: SQLERRM Authenticated Message: Y Create Trans Ind: N |
7. All Student Unit Set Attempt validations. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: NULL Authenticated Message: Y Create Trans Ind: N |
8. Maximum number of unit sets has been exceeded. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: Message Text Authenticated Message: Y Create Trans Ind: N |
9. Maximum number of primary unit sets has been exceeded. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: Message Text Authenticated Message: Y Create Trans Ind: N |
10. Unit Set rules have been breached. |
Person ID: Person_ID Message: Message_number Key includes: User_Person_ID || ‘|’ || Person_ID || ‘|’ || Course_Cd || ‘|’ || Enr_Cal_Type (if available) || ‘|’ || Enr_Ci_Sequence_Number (if available) || ‘|’ || S_Process_Type || ‘|’ || Action Data URL: NULL Delivery Type: WEB Override Message: Message Text Authenticated Message: Y Create Trans Ind: N |
It calls a function that checks if the application Log Transaction check box selected 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, as well as send 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 receipt sent when an application is made:
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 |
Name |
^v_full_name |
^v_full_name |
3 |
Course |
^v_crv_title |
^v_crv_title |
* |
Qualification |
^v_qual_reference_cd |
^v_qual_reference_cd |
* |
Status |
^v_course_attempt_status |
^v_course_attempt_status |
* |
###CURRENT_UNIT_SETS### |
NULL |
NULL |
** |
Unit set Code |
^rv_unit_set_cd |
^rv_unit_set_cd |
** |
Version |
^rv_us_version_number |
^rv_us_version_number |
** |
Title |
^rv_title |
^rv_title |
** |
Category |
^rv_unit_set_cat |
^rv_unit_set_cat |
** |
Selection Date |
^rv_selection_dt |
^rv_selection_dt |
** |
End Date |
^rv_end_dt |
^rv_end_dt |
** |
Rank |
^rv_rank |
^rv_rank |
** |
Status |
^rv_status |
^rv_status |
** |
Parent Unit Set |
^rv_parent_unit_set_cd |
^rv_parent_unit_set_cd |
** |
Primary |
^rv_primary_set_ind |
^rv_primary_set_ind |
The orange field is specific to VET sector and will not be logged for HE sector.
^ Denotes fields that need to be retrieved from the database prior to logging.
* The sequence of this record is unknown due to conditional logging.
** The sequence of this record is unknown due to conditional logging. These fields will be repeated for each Student Unit Set Attempt that the student is enrolled in.
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 |
Name |
3 |
Course |
N/A |
Qualification |
N/A |
Status |
N/A |
###CURRENT_UNIT_SETS### |
N/A |
Unit set Code |
N/A |
Version |
N/A |
Title |
N/A |
Category |
N/A |
Selection Date |
N/A |
End Date |
N/A |
Rank |
N/A |
Status |
N/A |
Parent Unit Set |
N/A |
Primary |
Last Modified on 2 May, 2007 3:39 PM
History Information
| Release Version | Project | Change to Document |
| 10.0.0.0.0.0 | 1225 - Connect Transaction Management | Added 'Transactions' section |