Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAGRDISTEP


                            PAGRDISTEP FILE

Contains follow up step information for grievance or disciplinary actions.
This file is maintained primarily by PA69.2 (Grievance, Disciplinary Action
Step).

REFERENCED BY

HR170     HR70.1    PA259

UPDATED BY

PA59.1    PA59.2    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PGI-COMPANY            Numeric 4                                 PA59.2
Element: Company Hr

PGI-EMPLOYEE           Numeric 9                                 PA59.2
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PGI-TYPE               Alpha 2                                   PA59.2
Element: Type          Indicates whether the action concerns a
                       grievance or disciplinary issue.
                       1 = Grievance
                       2 = Discplinary

PGI-GRIEV-DIS-NBR      Numeric 4                                 PA59.2
Element: Griev Dis Nbr Contains the grievance or disciplinary
                       action number.

PGI-SEQ-NBR            Numeric 4                                 PA59.2
Element: Seq Nbr       An automatically assigned sequence
                       number.

PGI-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PA59.2
Element: Effect Date   Contains the date for the grievance or
                       disciplinary action follow up step.

PGI-STATUS             Numeric 1                                 PA59.2
Element: Status        Contains the grievance, disciplinary
                       action follow up status.
                       1 = Open
                       2 = In Process
                       3 = Completed

PGI-FOLLOW-CAT         Alpha 10                                  PA59.2
Element: Follow Cat    Contains the user-defined grievance,
                       disciplinary action step category.

PGI-FOLLOW-TYPE        Alpha 10                                  PA59.2
Element: Follow Type   Contains a user-defined grievance,
                       disciplinary action step type.

PGI-OUTCOME            Alpha 10                                  PA59.2
Element: Outcome       Contains a user-defined grievance,
                       disciplinary action step outcome.

PGI-PERFORMED-BY       Numeric 9                                 PA59.2
Element: Performed By  Contains the employee who performed the
                       grievance, disciplinary action follow up
                       step.

PGI-COMMENT            Alpha 40  (Lower Case)                    PA59.2
Element: Comment       This field contains the comment
                       narrative.

PGI-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA59.2
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PGI-TIME-STAMP         Numeric 6  (hhmmss)                       PA59.2
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PGI-USER-ID            Alpha 10  (Lower Case)                    PA59.2
Element: User

                         PAGRDISTEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGISET1   COMPANY                                                HR11.1  PA115
          EMPLOYEE                                               PA59.1  PA59.2
          TYPE
          GRIEV-DIS-NBR
          SEQ-NBR

PGISET2   COMPANY       KeyChange                                HR170   HR70.1
          EMPLOYEE                                               PA259   PA59.2
          TYPE
          GRIEV-DIS-NBR*
          EFFECT-DATE*
          SEQ-NBR*

                         PAGRDISTEP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Act Step Cat   PCODES       Required
                            When PGI-FOLLOW-CAT != Spaces

                            "GA"                 -> PCO-TYPE
                            PGI-FOLLOW-CAT       -> PCO-CODE

Act Step Outc  PCODES       Required
                            When PGI-OUTCOME != Spaces

                            "GT"                 -> PCO-TYPE
                            PGI-OUTCOME          -> PCO-CODE

Act Step Type  PCODES       Required
                            When PGI-FOLLOW-TYPE != Spaces

                            "GP"                 -> PCO-TYPE
                            PGI-FOLLOW-TYPE      -> PCO-CODE

Company        PRSYSTEM     Required

                            PGI-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Employee       EMPLOYEE     Required

                            PGI-COMPANY          -> EMP-COMPANY
                            PGI-EMPLOYEE         -> EMP-EMPLOYEE

Griev Dis Act  PAGRDI       Required

                            PGI-COMPANY          -> PAG-COMPANY
                            PGI-EMPLOYEE         -> PAG-EMPLOYEE
                            PGI-TYPE             -> PAG-TYPE
                            PGI-GRIEV-DIS-NBR    -> PAG-GRIEV-DIS-NBR

Paemployee     PAEMPLOYEE   Required

                            PGI-COMPANY          -> PEM-COMPANY
                            PGI-EMPLOYEE         -> PEM-EMPLOYEE

Performed By   EMPLOYEE     Required
                            When PGI-PERFORMED-BY != Zeroes

                            PGI-COMPANY          -> EMP-COMPANY
                            PGI-PERFORMED-BY     -> EMP-EMPLOYEE