Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PAGRDI


                              PAGRDI FILE

Contains grievance and disciplinary action information.

Maintained primarily by PA59.1 (Grievance,Disciplinary Actions).

REFERENCED BY

PA259

UPDATED BY

PA59.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAG-COMPANY            Numeric 4                                 PA59.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PAG-EMPLOYEE           Numeric 9                                 PA59.1
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.

PAG-TYPE               Alpha 2                                   PA59.1
Element: Type          Indicates whether the action is
                       tracking a grievance or disciplinary
                       issue.
                       1 = Grievance
                       2 = Disciplinary

PAG-GRIEV-DIS-NBR      Numeric 4                                 PA59.1
Element: Griev Dis Nbr Contains the action number. The numbers
                       are assigned by the Personnel
                       Administration system. The numbers start
                       at one for each employee and type.

PAG-DESCRIPTION        Alpha 30  (Lower Case)                    PA59.1
Element: Description   This field displays the description.

PAG-DATE               Numeric 8  (yyyymmdd)                     PA59.1
Element: Date          Contains the date the grievance or
                       disciplinary action was created.

PAG-GRIEV-DIS-CAT      Alpha 10                                  PA59.1
Element: Griev Dis Cat Contains the user-defined grievance or
                       disciplinary action category.

PAG-REPORT-DATE        Numeric 8  (yyyymmdd)                     PA59.1
Element: Report Date   Contains the date the grievance or
                       disciplinary action was reported.

PAG-REPORTS-BY         Numeric 9                                 PA59.1
Element: Reports By    Contains the name of the employee who
                       reported the action.

PAG-REPORT-BY-NAME     Alpha 30  (Lower Case)                    PA59.1
Element: Report By NameContains the name of the employee who
                       reported the action.

PAG-GRIEV-DIS-STAT     Alpha 10                                  PA59.1
Element: Griev Dis StatContains the user-defined grievance,
                       disciplinary action status.

PAG-OUTCOME            Alpha 10                                  PA59.1
Element: Outcome       Contains the user-defined
                       grievance,disciplinary action outcome.

PAG-OUTCOME-DATE       Numeric 8  (yyyymmdd)                     PA59.1
Element: Outcome Date  Contains the date of the grievance,
                       disciplinary action outcome.

PAG-DAYS-OUT           Numeric 3                                 PA59.1
Element: Days Out      Contains the number of days the
                       employee is away from work due to the
                       grievance, disciplinary action.

PAG-COST               Signed 11.2                               PA59.1
Element: Cost          Contains the cost for the
                       grievance,disciplinary action.

PAG-PROCESS-LEVEL      Alpha 5                                   PA59.1
Element: Process Level Contains the process level where the
                       grievance or disciplinary action
                       occurred.

PAG-DEPARTMENT         Alpha 5                                   PA59.1
Element: Department    Contains the department where the
                       grievance or disciplinary action
                       occurred.

PAG-LOCAT-CODE         Alpha 10                                  PA59.1
Element: Location      Contains the location where the
                       grievance or disciplinary action
                       occurred.

PAG-JOB-CODE           Alpha 9                                   PA59.1
Element: Job Code      Contains the employee's job code when
                       the grievance or disciplinary action
                       occurred.

PAG-SHIFT              Numeric 1                                 PA59.1
Element: Shift         Contains the shift where the grievance
                       or disciplinary action occurred.
                       1 = Shift 1
                       2 = Shift 2
                       3 = Shift 3
                       4 = Shift 4
                       5 = Shift 5
                       6 = Shift 6
                       7 = Shift 7
                       8 = Shift 8
                       9 = Shift 9

PAG-SUPERVISOR-EMP     Numeric 9                                 PA59.1
Element: Supervisor EmpContains the supervisory where the
                       grievance or disciplinary action
                       occurred.

PAG-UNION-CODE         Alpha 10                                  PA59.1
Element: Union Code    Contains the union with which the
                       employee was associated when the
                       grievance or disciplinary action
                       occurred.

PAG-BARGAIN-UNIT       Alpha 10                                  PA59.1
Element: Bargaining UniContains the bargaining unit with which
                       the employee was associated when the
                       grievance or disciplinary action
                       occurred.

PAG-CONTACT-NBR        Numeric 9                                 PA59.1
Element: Contact Nbr   Contains the contact for the union or
                       bargaining unit.

PAG-CONTACT-NAME       Alpha 30  (Lower Case)                    PA59.1
Element: Contact Name  Contains the employee contact of the
                       union or bargaining unit.

PAG-PHONE-COUNTRY      Alpha 6                                   PA59.1
Telephone Country      Contains the telephone country code for
Code                   the union or bargaining unit contact.

PAG-PHONE              Alpha 15                                  PA59.1
Element: Telephone NumbContains the telephone number for the
                       unit or bargaining unit contact.

PAG-PHONE-EXT          Alpha 5                                   PA59.1
Element: Telephone ExteContains the telephone extension for
                       the union or bargaining unit contact.

PAG-COMMENT            Alpha 40  (Lower Case)                    PA59.1
Element: Comment Line  This field contains the comment
                       narrative.

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

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

PAG-USER-ID            Alpha 10  (Lower Case)                    PA59.1
Element: User

PAG-CURRENCY-CODE      Alpha 5                                   PA59.1
Element: Currency Code Contains the currency in which the
                       grievance or disciplinary action cost is
                       recorded.

PAG-CURR-ND            Numeric 1                                 PA59.1
Account Currency
Code

PAG-BASE-CURRENCY      Alpha 5                                   PA59.1
To Company Base        Contains the company's base currency.
Currency

PAG-BASE-ND            Numeric 1                                 PA59.1
Account Currency
Code

PAG-BASE-AMOUNT        Signed 15.2                               PA59.1
Element: Adj Amt       Contains the costs in the company's
                       base currency.

                         PAGRDI FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PAGSET1   COMPANY                                                HR11.1  PA115
          EMPLOYEE                                               PA259   PA59.1
          TYPE                                                   PA59.2
          GRIEV-DIS-NBR

PAGSET2   COMPANY                                                PA59.1
          EMPLOYEE
          TYPE
          GRIEV-DIS-NBR*

PAGSET3   COMPANY       KeyChange                                PA259
          EMPLOYEE
          TYPE
          DATE*
          GRIEV-DIS-NBR*

                         PAGRDI FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bargain Unit   PCODES       Required
                            When PAG-BARGAIN-UNIT != Spaces

                            "BU"                  -> PCO-TYPE
                            PAG-BARGAIN-UNIT      -> PCO-CODE

Base Currency  CUCODES      Required
                            When (PAG-CURRENCY-CODE != Spaces )

                            PAG-BASE-CURRENCY     -> CUC-CURRENCY-CODE

Category       PCODES       Required
                            When PAG-GRIEV-DIS-CAT != Spaces

                            "GC"                  -> PCO-TYPE
                            PAG-GRIEV-DIS-CAT     -> PCO-CODE

Company        PRSYSTEM     Required

                            PAG-COMPANY           -> PRS-COMPANY
                            Spaces                -> PRS-PROCESS-LEVEL

Contact        EMPLOYEE     Required
                            When PAG-CONTACT-NBR != Zeroes

                            PAG-COMPANY           -> EMP-COMPANY
                            PAG-CONTACT-NBR       -> EMP-EMPLOYEE

Currency       CUCODES      Required
                            When (PAG-CURRENCY-CODE != Spaces )

                            PAG-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Department     DEPTCODE     Required
                            When PAG-DEPARTMENT != Spaces

                            PAG-COMPANY           -> DPT-COMPANY
                            PAG-PROCESS-LEVEL     -> DPT-PROCESS-LEVEL
                            PAG-DEPARTMENT        -> DPT-DEPARTMENT

Job Code       JOBCODE      Required
                            When PAG-JOB-CODE != Spaces

                            PAG-COMPANY           -> JBC-COMPANY
                            PAG-JOB-CODE          -> JBC-JOB-CODE

Location       PCODES       Required
                            When PAG-LOCAT-CODE != Spaces

                            "LO"                  -> PCO-TYPE
                            PAG-LOCAT-CODE        -> PCO-CODE

Outcome        PCODES       Required
                            When PAG-OUTCOME != Spaces

                            "GO"                  -> PCO-TYPE
                            PAG-OUTCOME           -> PCO-CODE

Process Level  PRSYSTEM     Required
                            When PAG-PROCESS-LEVEL != Spaces

                            PAG-COMPANY           -> PRS-COMPANY
                            PAG-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

Report By      EMPLOYEE     Required
                            When PAG-REPORTS-BY != Zeroes

                            PAG-COMPANY           -> EMP-COMPANY
                            PAG-EMPLOYEE          -> EMP-EMPLOYEE

Status         PCODES       Required
                            When PAG-GRIEV-DIS-STAT != Spaces

                            "GS"                  -> PCO-TYPE
                            PAG-GRIEV-DIS-STAT    -> PCO-CODE

Super Emp      EMPLOYEE     Required
                            When (PAG-SUPERVISOR-EMP != Zeroes )

                            PAG-COMPANY           -> EMP-COMPANY
                            PAG-SUPERVISOR-EMP    -> EMP-EMPLOYEE

Union          PCODES       Required
                            When PAG-UNION-CODE != Spaces

                            "UN"                  -> PCO-TYPE
                            PAG-UNION-CODE        -> PCO-CODE

                         PAGRDI FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Action Steps   PAGRDISTEP   Delete Cascades

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