Functions called from package i22pkg.sql - No Menu Option


This package contains functions that primarily do checks and validations on subject level

The same functions that are use during the entering of planned subject in {SNAPPA-11}/{SNAPPA-1/3} are also used when the subjects are registered in {SDREGA-1}


Function Name Function Description Comments
CalcNumofModules This Function will return number of Modules for a Main/Mother subject. User then will know how many Modules are linked to Main/Mother Subject When Main/Mother Subject is Cancelled or un-Uncancell.

Values for x_source:
  • C - Cancel
  • U - Uncancel
  • D - same day delete
  • R - cancreason only
INPUTS
  • x_cyr        academic year
  • x_subj      subject
  • x_ot         offering type
  • x_qual      qualification
  • x_source   C / U / R / D
  • x_reason   Reason
OUTPUTS
  • NUMBER of Modules;
checkSourceOfFund The function will check if additional sources of funding(SOF) is available for a specific subject on {SACAD-16} *
chkPrevEnrolled In the iEnabler if the subject had iakactive = P we did not check for wasprevenrolled - rationale was that if W3=Y the student can choose another ot down the line which might not be iakactive = P and which is valid. The problem is, even if there is no other
valid ot for the subject OR even if W3=N and you cannot choose another ot, the program still did not check for previous enrolments.
Also, when W3=Y, and we get to the select that populates all the possible offering types, it did not actually check if this ot had an open cycle - so the student could still register for eitehr a subject without a previous enrollment or for an ot for which the cycle is closed!
Created the new function that will check for open cycles and take W3 into consideration and will only give subjects with a valid option somewhere.

INPUTS
  • x_stno      student number
  • x_cyr        academic year
  • x_subj       subject
  • x_ot          offering type
  • x_qual       qualification
  • x_appreg   
  • x_bc      IN VARCHAR2
  • x_inst    IN NUMBER
  • x_w3      IN VARCHAR2

OUTPUTS
  • Y or N
contractMainSubj The function will do contract/subject validations

* This is used in both the 'Planned Subject' and 'Subject Registration' programs.  		  
getContractCode This function will return the contract code for the corresponding
  • Qualification application record - see {SNAPPA-1/3} from the planned subjects program
  • Qualification registration record - see {SDREGA-1} from the subjects registration program
  
getPeriodOfStudy  This function will return the period of study for the corresponding
  • Qualification application record - see {SNAPPA-1/3} from the planned subjects program
  • Qualification registration record - see {SDREGA-1} from the subjects registration program
 
getStudentMain This function will return the main subject of the standard if the student is registered for it.
Rules: Involved subject of the current standard record passed and 'tree' of student enrolments is investigated. When highest recor5d in the tree identified (iah record without subjet involved) subject is passed to i22pkg.isMain function to identify if this is defined as Main subject in the structure.		 Used in {SSTUDY-22}
getStudentModule Check if student enrolled for 'Subject Involved'

INPUTS
  • x_stno      student number
  • x_cyr        academic year
  • x_subjinv   involved subject
OUTPUTS
  • Number of records with the same main subject (involved subject)
hasN2Status This function will determine if a student has the non-engagement status for the subject in {SREGL-2} . The non-engagement status is determined by SOD N2, subs BI. Used in the TES by the LOV on subjects for the ASAUTO process,
hasPassedSubj  The function will determine if a 'previous' record exists for the applicant or student where the student has a 'Pass' result. The result is defined as a pass result in {SCODE-23}. *
isMain This function will determine is this subject is a Main subject.
isModule The function will determine if the subject entered is defined as a 'module' subject in {SACAD-10} in the field 'Subj Inv'. This is used in {SSTUD4-21} *
isMother The function will determine if the subject entered is defined as a 'main/composite' subject in {SACAD-10} in the field 'Subj'. This is used in {SSTUD4-4} and {SSTUD4-23} *
wasPrevEnrolled  This function will determine if the student was previously enrolled for the subject, offering type and qualification.  This is closely related to the setting of the 'Active' field in the curriculum to the value of 'P'. Refer to Curriculum {SACADO-17}
wasQPrevEnrolled Use the SOD PR, and only check if the student was prev enrol for qual. This is used in {SREGAR-1},{SNAPPA-1}, {SREGC-1}, {SDREGA-1}, {SCOUR-3}, {SCAOM-7} and {FSAO-7}

INPUTS
  • x_stno   student number
  • x_qual   qualification
OUTPUTS
  • Y or N


   
 
History of Changes

Date System Version By Whom Job Description
17-May-2007 v01.0.0.0 Charlene van der Schyff t137175 New manual format.
31-Jul-2007 v01.0.0.0 Melanie Zeelie t133613 Add Source of funding detail
22-Aug-2007 v01.0.0.0 Melanie Zeelie t137000 Add  detail on which options use this package
14-Oct-2008 v01.0.0.1 Bea Swart t153513 Add {SSTUD4-21} to isModule
25-Mar-2010 v02.0.0.0 Bea Swart t160923 Add isMain function to manual
13-Jan-2011 v02.0.0.1 Bea Swart t161598 Add getStudentMain to manual
21-Feb-2011 v02.0.0.2 Bea Swart t174945 Add CalcNumofModules, chkPrevEnrolled, getStudentModule, wasQPrevEnrolled in manual
17-Oct-2014 v02.0.0.3 Magda van der Schyff t203913 Add hasN2Status to manual.
26-Jun-2019
 v04.1.0.0
 Frans Pelser
 t237245
 Update Academic Structure References