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

HR170     HR70.1    PA259

UPDATED BY

PA59.1    HR11.1    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PAG-COMPANY            Numeric 4                                 PA59.1
Element: Company Hr

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 Lev HrContains 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: Locat Code    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: Bargain Unit  Contains 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
Element: Phone Country Contains the telephone country code for
                       the union or bargaining unit contact.

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

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

PAG-COMMENT            Alpha 40  (Lower Case)                    PA59.1
Element: Comment       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
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


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

PAG-BASE-ND            Numeric 1                                 PA59.1
Element: Base Nd       The number of decimal positions defined
                       for the company base currency.

PAG-BASE-AMOUNT        Signed 15.2                               PA59.1
Element: Base 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  HR170
          EMPLOYEE                                               HR70.1  PA115
          TYPE                                                   PA259   PA59.1
          GRIEV-DIS-NBR                                          PA59.2

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

PAGSET3   COMPANY       KeyChange                                HR170   HR70.1
          EMPLOYEE                                               PA259
          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

Employee       EMPLOYEE     Required

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

Griev Dis Cat  PCODES       Required
                            When PAG-GRIEV-DIS-CAT != Spaces

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

Griev Dis Stat PCODES       Required
                            When PAG-GRIEV-DIS-STAT != Spaces

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

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

Paemployee     PAEMPLOYEE   Not Required

                            PAG-COMPANY           -> PEM-COMPANY
                            PAG-EMPLOYEE          -> PEM-EMPLOYEE

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-REPORTS-BY        -> 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