PAGRDISTEP FILE

                      Griev. & Disc. Action Steps

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

REFERENCED BY

PA259

UPDATED BY

PA59.1    PA59.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PGI-COMPANY          Numeric 4                                   PA59.2
Company              The company number represents an
                     established company and is entered on
                     all function codes.

PGI-EMPLOYEE         Numeric 9                                   PA59.2
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
Type                 Indicates whether the action concerns a
                     grievance or disciplinary issue.
                     1 = Grievance
                     2 = Discplinary

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

PGI-SEQ-NBR          Numeric 4                                   PA59.2
Sequence Number      An automatically assigned sequence
                     number.

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

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

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

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

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

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

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

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

PGI-TIME-STAMP       Numeric 6  (hhmmss)                         PA59.2
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
User ID Name         Contains the user ID of the person who
                     last changed this record.

                         PAGRDISTEP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PGISET2   COMPANY       KeyChange                                PA259   PA59.2
          EMPLOYEE
          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

                            "GT"                 -> 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

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

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