Link Students in Bulk to Persons Involved in Activities {SSCHRP-8}


Link students in bulk to persons involved and activities.


Student's should be registered for qualifcation and subjects.

Steps should be entered for qualifications and subjects on {SSCHRP-3}.

For "Indicator Type" on {SSCHRP-3} is A - Activity for Student Persons then data for student should be entered on {SREGB-14}.

For "Indicator Type" on {SSCHRP-3} is C - Academic Contact Type then data for student should be entered on {SACAD-9}.


 
User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
  Enter the Academic Year YYYY   
  Enter Qualifcation Code or ALL A6  
  Enter Qualifcation Block Code or ALL A2  
  Enter Qualification Offering Type or ALL A2  
  Enter Subject Code or ALL A7   
  Enter Subject Block Code or ALL A2  
  Enter Subject Offering Type or ALL A2  
  Enter Student Type or ALL A1  
  Enter the Event Period N9  
  Enter the Reporting Period A3  
  Trail or Update A1  
 

Sort Order Per Comments
  Student Number, Qualification Code  


System Select  
  Use "User Selection" to get student's qualification and subject information.


Example
:

Example of Link Students in Bulk to Persons Involved in Activities T172425




Processing
Rules
 
  For each Student Registration for the Academic Year, Block Code, Offering Type, Student Type and Qualification Code as in the User Selection Parameters, excluding students cancelled before the System Date.
  For the Student’s Qualification Registration (iagenr), go through the active Steps {SSCHRP-3} for the Reporting Period and Process Code (STUDENTREP) where Auto Link (iipind) = (Y)es and create records in Steps per Student {SSCHRP-6}, Events per Person. {SSCHRP-5} and Events per Student {SSCHRP-4} as in the rules below.

Do the same for the Student’s Subject Registrations (iahsub) that belongs to the Qualification Registration used. (iahqualno = iagqualno)
 
  • If Indicatior Type  = (A)ctivity for Student Persons {SSCHRP-3}
    • Use records from Student Persons {SREGB-14} for the Student where:
      • Academic Year equal to the "User Selection Parameters"
      • Block Code equal to the "User Selection Parameters"
      • Event equal to (Q)ualification for Qualifications or (S)ubject for Subjects
      • Code equal to the Student’s Qualification Code or Subject Code
      • Activity Code equal to Type Code {SSCHRP-3}
      • Person. Type equal to (P)ersonnel Member
      • Start Date is before System Date
      • End Date is After System Date or End Date is null
 
  • If Indicator Type (iipindtype) = (C) Academic Contact Type
    • Use records from Academic Contact Persons {SACAD-9} where:
      • Year equal to the "User Selection Parameters"
      • Subject/Qualification Indicator equal to Q or S, depending on whether it is a Qualification- or Subject Registration
      • Subject/Qual Code equal to the Qualification Code or the Subject Code of the Student (iagqual)
      • The Academic Contact Type is linked to Role Indicator A, F or M in Academic Contact Types on {SCODE3-24}
  In the case where no records in Student Persons {SREGB-14} with the combinations as above were found for a Student’s Qualification Registration, ignore (do not insert anything)
  In the case where no records in Student Persons {SREGB-14} with the combinations as above were found for a Student’s Subject Registration, ignore (do not insert anything)
  In the case where no records in Academic Contact Persons {SACAD-9} with the combinations as above were found for a Student’s Subject Registration, ignore (do not insert anything)
  Records are created in Steps per Student {SSCHRP-6} as follows:
  • System = i
  • Process Code = STUDENTREP
  • Event Number as in the User Selection Parameters
  • Step as from the current step {SSCHRP-3}
  • Personnel Number as from Student Persons {SREGB-14} or Academic Contact Persons {SACAD-9}
  • Ind is (S)ubject or (Q)ualification
  • Code is the Subject- or Qualification Code
  • Student Number
  • Reporting Period as in the User Selection Parameters

If record already exist and continue processing

  Records are inserted in Events per Person. {SSCHRP-5} as follows:
  • System = i
  • Process Code = STUDENTREP
  • Event Number as in the User Selection Parameters
  • Step as from the current step {SSCHRP-3} 
  • Personnel Number as from Student Persons {SREGB-14} or Academic Contact Persons {SACAD-9} 
  • Ind (S)ubject or (Q)ualification
  • Code is the Subject- or the Qualification Code
  • Reporting Period as in the User Selection Parameters

If a record already exists, continue processing (ignore)
  Records are inserted into Events per Student {SSCHRP-4} as follows:
  • System = i
  • Process Code = STUDENTREP
  • Event Number as in the User Selection Parameters
  • Student Number
  • Reporting Period as in the User Selection Parameters

If a record for the student already exists, continue processing (ignore)

See Also:



History of Changes

Date System Version By Whom Job Description
25-Feb-2011 v02.0.0.0 Bea Swart
t172425 New manual.