Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROGPAY


                              PROGPAY FILE

This file contains the table name, effective dates, and rules for eligibility.

REFERENCED BY

PA50.1    UK102     UK110     UK210     UK52.1

UPDATED BY

UK02.1    UK10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PGP-COMPANY            Numeric 4                                 UK02.1  UK10.1
Element: Company Hr

PGP-REC-TYPE           Alpha 1                                   UK02.1  UK10.1
Element: Rec Type      Defines whether this is a progressive
                       pay rate record or a bonus accrual
                       record.
                       B = Bonus Pay

PGP-TABLE              Alpha 10                                  UK02.1  UK10.1
Element: Table         User defined table definition.

PGP-DESCRIPTION        Alpha 30  (Lower Case)                    UK02.1  UK10.1
Element: Description   Contains a further description of the
                       table.

PGP-EFFECT-DATE        Numeric 8  (yyyymmdd)                     UK02.1  UK10.1
Element: Effect Date   Contains the date this table is
                       effective.

PGP-END-DATE           Numeric 8  (yyyymmdd)                     UK02.1  UK10.1
Element: End Date      The end date for this effort period.

PGP-ACTION-CODE        Alpha 10                                  UK10.1
Element: Action Code   This field contains the personnel
                       action code.

PGP-GROUP-NAME         Alpha 10                                  UK02.1  UK10.1
Element: Group Name    Defines which group of employees is
                       eligible for this table.

PGP-SALARY-CLASS       Alpha 1                                   UK10.1
Element: Salary Class  Further defines which employees are
                       eligible for this table. Also defines if
                       the rates entered are hourly or salary
                       amounts.
                       H = Hourly
                       S = Salaried

PGP-ENT-FROM-DATE      Alpha 2                                   UK10.1
Element: Ent From Date Defines the date or the starting point
                       from which other eligibility criteria
                       may be used to determine if the employee
                       is eligible for this table.
                       HI = Hire Date
                       AJ = Adjusted Hire Date
                       AN = Anniversary Date
                       SN = Seniority Date
                       X = Custom Calculation

PGP-ENT-UNITS          Numeric 5                                 UK10.1
Element: Ent Units     Contains the number of units.

PGP-ENT-UNITS-TYPE     Alpha 1                                   UK10.1
Element: Ent Units TypeContains the type of units entered.
                       H = Hours
                       D = Days
                       M = Months

PGP-ENT-PAY-CLASS      Alpha 3                                   UK10.1
Element: Ent Pay Class Contains the pay class entered to
                       select specific types of hours to be
                       used in determining eligibility.

PGP-ENT-POINT-TYPE     Numeric 1                                 UK10.1
Element: Ent Point TypeDefines which entry point is used to
                       determine eligibility.
                       0 = None
                       1 = Prior entry point
                       2 = Next entry point
                       3 = Prior pay period
                       4 = Next pay period
                       5 = Prior work period
                       6 = Next work period

PGP-END-FROM-DATE      Alpha 2                                   UK10.1
Element: End From Date Defines the starting point from which
                       other criteria may be used to determine
                       when the eligibility for this table
                       ends.
                       HI = Hire Date
                       AJ = Adjusted Hire Date
                       AN = Anniversary Date
                       SN = Seniority Date
                       X = Custom Calculation

PGP-END-UNITS          Numeric 5                                 UK10.1
Element: End Units     Contains the number of units.

PGP-END-UNITS-TYPE     Alpha 1                                   UK10.1
Element: End Units TypeDefines the type of units entered.
                       H = Hours
                       D = Days
                       M = Months

PGP-END-PAY-CLASS      Alpha 3                                   UK10.1
Element: End Pay Class Contains the pay class entered to
                       select specific types of hours to be
                       used in
                       determining eligibility.

PGP-END-POINT-TYPE     Numeric 1                                 UK10.1
Element: End Point TypeDefines which entry point is used to
                       determines eligibility.
                       0 = None
                       1 = Prior entry point
                       2 = Next entry point
                       3 = Prior pay period
                       4 = Next pay period
                       5 = Prior work period
                       6 = Next work period

                         PROGPAY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGPSET1   COMPANY                                                PA50.1  UK02.1
          REC-TYPE                                               UK10.1  UK10.4
          TABLE                                                  UK102   UK110
          EFFECT-DATE                                            UK210   UK52.1

PGPSET2   COMPANY       KeyChange
          GROUP-NAME
          REC-TYPE
          TABLE
          EFFECT-DATE
          END-DATE

                         PROGPAY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Action         PERSACTYPE   Required

                            PGP-COMPANY          -> PAT-COMPANY  (PATSET1)
                            PGP-ACTION-CODE      -> PAT-ACTION-CODE

Company        PRSYSTEM     Required

                            PGP-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Employee Group PERSGROUP    Required

                            PGP-COMPANY          -> PRG-COMPANY
                            PGP-GROUP-NAME       -> PRG-GROUP-NAME

End Pay Class  PAYCLASS     Required

                            PGP-COMPANY          -> PCL-COMPANY
                            PGP-END-PAY-CLASS    -> PCL-PAY-CLASS

Ent Pay Class  PAYCLASS     Required

                            PGP-COMPANY          -> PCL-COMPANY
                            PGP-ENT-PAY-CLASS    -> PCL-PAY-CLASS

                         PROGPAY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Progpayend     PROGPAYEND   Delete Cascades

                            PGP-COMPANY          -> PED-COMPANY
                            PGP-TABLE            -> PED-TABLE
                            PGP-EFFECT-DATE      -> PED-EFFECT-DATE
                                                    PED-ENDING-DATE

Progpayent     PROGPAYENT   Delete Cascades

                            PGP-COMPANY          -> PET-COMPANY
                            PGP-TABLE            -> PET-TABLE
                            PGP-EFFECT-DATE      -> PET-EFFECT-DATE
                                                    PET-ENTRY-DATE

Prograte       PROGRATE

                            PGP-COMPANY          -> PGA-COMPANY
                            PGP-REC-TYPE         -> PGA-REC-TYPE
                            PGP-TABLE            -> PGA-TABLE
                            PGP-EFFECT-DATE      -> PGA-EFFECT-DATE
                                                    PGA-PAY-GROUP-NAME
                                                    PGA-FROM-UNITS