Generate Payments per Activity {SREGB-15}

This program can be used to generate payments to Student Supervisors.

 

Before this program can be used, the following must be in place

Payment records will be created in the Payment File {FCTO-12} where it can be maintained and from where payments can be created in the ITS Counter System {FRM-1}

 

Note that Payments to Personnel Members generated by this program is not automatically handled through the ITS Payroll System with the result that it is not taken into account for income tax calculations. To include these transactions in income tax calculations, use Copy Counter System Payments {FPRI-30}. This program will, for each involved personnel member, create an earning (to be included in the tax calculation) and a deduction (to contra the earning, but excluded from the tax calculation) that will be taken into account when salaries are calculated. It is also possible to manually advise the earnings and deductions through Individual Earnings/Deductions {FPRI-2}

User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
  Payment Cycle Year N4   

Payment Cycle N3  

Block Code or ALL A3  

Person Type or ALL A3 Person Type (S)tudent, (P)ersonnel, (O)ther Or ALL

Person Number or ALL A9  

Payment Type or ALL A3  

Print records for Supervisors that will Not be Generated Y/[N]
A1
This will be for active Supervisors for whom payment records will not be created for the different reasons outlined in the system select section below.

Run in (T)rial or (U)pdate mode A1  
 

Sort Order Per Comments

Person Type  

Person Number  

Payment Type  

Student Number  


System Select  

Records from Student Persons {SREGB-14} with
  • Start Date before or on the End Date of the Payment Cycle as in the Supervisor Payment Cycle - tab of the Supervisor Payment Structure {SCODE-38}
  • No End Date or the End Date is after the End Date of the Payment Cycle as in the Supervisor Payment Cycle - tab of the Supervisor Payment Structure {SCODE-38}
Note that records that are active during the cycle, but not on the cycle end date will be excluded
 

Activity Code is the same as is specified in the System Operation Definition Parameter "PA - Default Supervisor Activity" for Subsystem "BI" in System Operational Definitions {SMNT-12}
 

Exclude Canceled Students
 

Active Supervisor Payment Structure {SCODE-38} records for the Academic Year and Payment Cycle
 


Supervisors will be excluded from receiving a payment for the following reasons:

1. The supervisor is not active on the Cycle end date.
  • For the payment functionality the Supervisor is active when:
    1. the end date is not blank or if it has a value then it is later or equal to the cycle end date
    2. If the Supervisor end date is blank then the student's qualification end date is used
    3. The Supervisor start date must be less than the end date of the cycle
Report error message: No message is printed for this scenario
 

2. The Supervisor does not live in the country
  1. The person's postal code is used to determine if the Supervisor lives outside the country.
  2. If the postal code of any address of the person is equal to the numeric value of the SOD 'OC' for subsystem 'WZ' then the person will be excluded from receiving a payment.
 Report error message: Supervisor lives outside the country.


3. The Supervisor is younger than 16 years.
  1. The age is calculated for the date on which the program is executed.
  2. If the person type is:
    1. P - Personnel; the program uses the Date of birth in {PBOB-1}
    2. O - Other; the program uses the Date of birth in {GOPS-3}
    3. S - Student; the program uses the Date of birth in {SREGB-1}
 Report error message:
  • If there is no birth date entered for the supervisor: Supervisor's birth date missing.
  • Supervisor younger than 16 years
 

4. The student is not enrolled as a full time student
  1. The student's combination of qualification offering type and student type is used to determine if he/she is full time
  2. Students with an offering type equal to the Internal Code and Student Type equal to the External Code will be excluded
  3. These combinations are defined in {GOPS-21} External Conversion Codes for the combination of
    1. External Body = SUP
    2. External Code Type = SP2
Report error message: The program prints the text entered by the user in the "Description" field in {GOPS-21}. See the example below.

Example of OT and ST exclusion and message set-up
 

5. The student is enrolled for a qualification offering type that must be excluded:
  1. Students with an offering type equal to the Internal Code will be excluded
  2. These combinations are defined in {GOPS-21} External Conversion Codes for the combination of
    1. External Body = SUP
    2. External Code Type = XOT
Report error message: The program prints the text entered by the user in the "Description" field in {GOPS-21}.


6. The student has a Supervisor that is paid by an Agency or Group.
  1. To determine if the Supervisor is paid by an Agency or Group, the Supervisor is linked to the student with a special relationship code in {SREGB-13}.
  2. The relationship code must be entered in {GOPS-21} in the internal code field for the combination of
    1. External Body = SUP
    2. External Code Type = SP1
Report error message: The program prints the text entered by the user in the "Description" field in {GOPS-21}.  
 

7. The student does not live in the designated country e.g. New Zealand

  1. The student's Country of Residence (COR) as captured in {SREGB-1} is used.
  2. The COR is compared with the numeric value of the SOD 'AB' for subsystem 'SR'
  3. If the student's COR is not equal to the numeric value, the student is excluded for payment.
Report error message:
  • If there is no COR code for the student: Missing Country Code.
  • Student resides outside the country.
 

8. Student does not have the correct residency status.

  1. The student's "Non Residence Indicator" and "Study Permit Category" are used.
  2. If
    1. the students Non Residence Indicator = 'Y' and
    2. The student's Study Permit Category = The internal code on {GOPS-21} for the combination of SUP and SP3
  3. Then the student will be excluded for payment

Report error message:
  • If there is no Study Permit Category: Study Permit not found.
  • The program prints the text entered by the user in the "Description" field in {GOPS-21}.
 

9. Student not enrolled for 10 consecutive weeks.

  1. The student's qualification "Start Date" is compared to the "End Date" of the payment cycle and not the execution date i.e. when the program is run.
  2. The rational for this is as follows:
    1. The user can run the program multiple times during a payment cycle in Trial mode to ensure correctness of data. In Trial mode no payment records are created
    2. The final run in Update mode should happen on the last day of the payment cycle.
  3. If the student's consecutive enrolment is less than 10 weeks, the stundent will be excluded for payment.

Report error message: No message is printed for this scenario
 

10. Student not the correct age

  1. If the student is an ORRS stundent and the student's age is not between 5 and 21 years, the student will be excluded from payment.
  2. If the student is not an ORRS student and the student's age is not between 5 and 19

Report error message: Student not the correct age
 

11. Student did not engage with Te Kura

  1. This test  is based on the student being linked in {SREGL-2} to one or both of the statuses in the SOD's 'N1' (Status 1) or 'N1' (Status 2) for subsystem 'BI'.
  2. If the student is linked to Status 1 (and not to Status 2) and the status is active:
    1. If the start date of the status is larger than the end of the payment cycle plus one month, the student will be excluded from payment
  3. If the student is linked to Status 2
    1. If the end of payment cycle is between the start and end date of the status, the student will be excluded from payment.

Report error message: Student did not engage.
 


Example
:

Example of {SREGB-15}



Processing
Rules
 
1 For each Person Type, Person Number and Payment Type combination (Refer to Maintain Student Persons {SREGB-14}), calculate the amounts as follows
  • For the first student, use the amount from the active records in the Payment Structure - tab of the Supervisor Payment Structure {SCODE-38} for the Payment Type where the  Sequence is 1
  • For the next student, use the amount from the active records in the Payment Structure for the Payment Type where Sequence is 2
  • Follow the same logic for the next students.
When the details for the nth student is processed, and an active record exists for the (n-1)th student in the Supervisor Payment Structure, but no active sequence for the nth student exist in the Supervisor Payment Structure, use the amount for the (n-1)th student. (Or use the amount for the highest previous student sequence)
 
2 If there is not a record for the first student sequence in the Supervisor Payment Structure,  an error message will be printed.
 
3 In each case, multiply the amount by the Factor in Maintain Student Persons {SREGB-14}.
 
4 If a payment was already generated for the Supervisor for the Student in the Payment Cycle, an error message will be printed.
 
5 If run in (U)pdate mode, a record for each student will be created in the Payment File {FCTO-12} as follows:

Field in Payment File Value
 
Process Date  System Date
Creditor Type  Person Type
Creditor Number  Person Number
Person Type  S
Person Number  Student Number
Reference 1  Activity Code and Description
Reference 2  Year and Cycle (YYYYCCC)
Reference 3  Sequence
Reference 4  Factor
Payment Method
  • For Person Type (P)ersonnel Member, if Method of Payment as in {FPRI-1} is (T)ape or (M) Bank Transfer, use “A” otherwise use “Q”
  • For Person Type (S)tudent, if Default Payment Method {FSAO-4} is (A)CB, use A, otherwise use “Q”
  • For Person Type “O”ther, use “A” if Payment Method = (A)CB, otherwise use “Q” as entered in {FACO-28}
Amount The amount
Original User The user code of the user
Note Payment Type Description
Status On (H)old
Type S (For Supervisor Payment)
 


See Also:
History of Changes


Date System Version By Whom Job Description
11-Aug-2010 v02.0.0.0 Frans Pelser
T160935 New manual
12-June-2012 v02.0.0.1 Hermien Hartman F183325 Corrected SOD in System Select nr.2 to PA/BI.
16-Nov-2012
v02.0.0.2 Phlip Pretorius
F187078
Add new rules for supervisor payment eligibility.