Lookup Table Detail {FPRG-5}


This option is used to maintain the detail of a lookup table.


Lookup tables are used by the following Calculation Methods {FPRG-25} in the Calculation of Salaries:

When detail is loaded for Medical Aid, Group Insurance and Pension Tables, consideration should be given as to whether the total contribution applicable to an employee should be loaded, or whether only that portion for which he / she would be responsible (the institution contributing the rest) should be loaded.  This could influence the reports to the Fund Administrator.

The system is supplied with the following Table details, which are valid at the date of installation and are applicable to the country of the client. These tables cannot be updated by users. 


Fields in this option:

Block 1:  Lookup Table Detail.

If the user attempts to delete a table, the system will investigate all ED codes in Individuals {FPRI-2} as well as Globals {FPRG-7}; if an ED code exists which is still active, or where the end date is < 1 year from the current system date on which the table should be deleted, the system will not allow the table to be deleted. All ED codes on Globals and Individuals are date effective.


Field Type
&
Length
Description
Table N4 When the code of an existing table is entered, the name of the table is displayed.  Code 0001 is reserved for the PAYE Tax Table, which is supplied with the system, and which cannot be updated by the user.
Dependants N1 The only tables for which a person's dependants must be specified, are those that refer to Medical Fund Contributions.  For all other tables, the default value of zero is used.  If a medical aid fund contribution stays constant - from (say) five dependants - records must still be created for 6, 7, 8, and 9 dependants.
Status A1 This indicator has different meanings, depending on the type of table being defined: it could refer to Tax Status, Marital Status or Gender.  If a table does not refer to a status at all, the default value of zero must be used.

           RSA PAYE Table:    Tax Status :
                                                          “A”  =  Married Person.
                                                          “B”  =  Single Person.
                                                          “C”  =  Married Woman.

           (For other countries, this status could have different meanings).

            Group Insurance:       “M” = Male, “F” = Female, “0” = non-applicable.
            Pension Table:          “M” = Male, “F” = Female, “0” = non-applicable.
            Medical Tables:         Marital Status : 
                                                                    “0” = non-applicable  (usual case).
                                                                    “M” = Married.
                                                                    “S” = Single.

(The calculation program will treat marital status “W”idow(er) as “M”arried; “D”ivorced is treated as “S”ingle, if number of dependants is zero, or otherwise  as “M”arried).
Pay Frequency A1 Indicate whether the table is (W)eekly, (M)onthly or (Y)early.
Cycle YYYYMM or YYYYWW Supply the year and week / month from when this table is applicable.
Low Amount N15.2 Specify the low value of a range.  An amount must be entered, e.g. 0.00.
High Amount N15.2 Specify the high value of a range; it must be larger than the low amount.  An amount must be entered, e.g. 999999.99.

Note: for PAYE tables, the above amounts represent taxable annual earnings; for other tables, which refer to earnings they represent monthly earnings.
Range Amount N15.2 The calculation of an earning or deduction is always based on a fixed amount or a percentage or both. The fixed amount applicable to the above range is specified here.  If only a percentage is applicable, this field must be left blank.
Range Percentage N4.3 If only a percentage is specified, the deduction will be calculated as a percentage of the taxable amount (in the case of PAYE) and of the relevant salary level total in other cases.  If only a range amount is applicable, this field must be left blank.

If both a range amount and a percentage are specified, the deduction is calculated, in the case of PAYE, as the sum of: the range amount and the specified percentage of the excess of taxable annual income above the low level of the range.  In all other cases, the deduction is calculated as the sum of: the range amount and the specified percentage of the relevant salary level total.

Example:

its_man_img/fprg-5b1p1i1.jpg



Processing
Rules
 
  No special processing rules.


See Also:


History of Changes

Date System Version By Whom Job Description
23-Jan-2007 v01.0.0.0 Anelia Terblanche t134066 New manual format.
20-Aug-2008 v01.0.0.0 Magda van der Westhuizen t152258 Update manual:  Language Editing - Juliet Gillies.
09-Dec-2015 v03.0.0.0 Sakhile Ntimane t209237 Adding Table Codes
18-Oct-2016 v03.0.0.1 Sakhile Ntimane t216733 Adding Retirement Funding pre-tax limits
31-Jan-2017 v04.0.0.0 Sakhile Ntimane t219225 Change image to Integrator4.