Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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
Company              The company number represents an
                     established company and is entered on
                     all function codes.


PGP-REC-TYPE         Alpha 1                                     UK02.1  UK10.1
Record 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
Table                User defined table definition.

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


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


PGP-END-DATE         Numeric 8  (yyyymmdd)                       UK02.1  UK10.1
Ending Date          The ending date in a range of dates.

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

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


PGP-SALARY-CLASS     Alpha 1                                     UK10.1
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
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
Ent Units            Contains the number of units.

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

PGP-ENT-PAY-CLASS    Alpha 3                                     UK10.1
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
Ent Point Type       Defines 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
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
End Units            Contains the number of units.

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

PGP-END-PAY-CLASS    Alpha 3                                     UK10.1
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
End Point Type       Defines 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