PAGRDISTEP – Contains follow up step information for grievance or disciplinary actions.

System
Personnel (PA)
Prefix
PGI
Primary key
COMPANY, EMPLOYEE, TYPE, GRIEV-DIS-NBR, SEQ-NBR
Fields
15
Updated by
4 programs
Referenced by
3 programs

PAGRDISTEP is the Contains follow up step information for grievance or disciplinary actions. table in Lawson Personnel (prefix PGI). It is indexed by COMPANY, EMPLOYEE, TYPE, GRIEV-DIS-NBR, SEQ-NBR (PGISET1); alternate indexes: PGISET2. It is related 1:1 to PCODES, PRSYSTEM, EMPLOYEE, PAGRDI and PAEMPLOYEE. It is updated by HR11.1, PA115, PA59.1 and PA59.2 and referenced by HR170, HR70.1 and PA259. The table has 15 fields, 2 indexes and 8 documented relations.

About PAGRDISTEP

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

Fields (15)

Column = COBOL field name without the PGI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PGI-COMPANY PK
COMPANY		Numeric 4—PA59.2
PGI-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.PA59.2
PGI-TYPE PK
TYPE		Alpha 2Indicates whether the action concerns a grievance or disciplinary issue.
  • 1 Grievance
  • 2 Discplinary
PA59.2
PGI-GRIEV-DIS-NBR PK
GRIEV_DIS_NBR		Numeric 4Contains the grievance or disciplinary action number.PA59.2
PGI-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.PA59.2
PGI-EFFECT-DATE
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date for the grievance or disciplinary action follow up step.PA59.2
PGI-STATUS
STATUS		Numeric 1Contains the grievance, disciplinary action follow up status.
  • 1 Open
  • 2 In Process
  • 3 Completed
PA59.2
PGI-FOLLOW-CAT
FOLLOW_CAT		Alpha 10Contains the user-defined grievance, disciplinary action step category.PA59.2
PGI-FOLLOW-TYPE
FOLLOW_TYPE		Alpha 10Contains a user-defined grievance, disciplinary action step type.PA59.2
PGI-OUTCOME
OUTCOME		Alpha 10Contains a user-defined grievance, disciplinary action step outcome.PA59.2
PGI-PERFORMED-BY
PERFORMED_BY		Numeric 9Contains the employee who performed the grievance, disciplinary action follow up step.PA59.2
PGI-COMMENT
COMMENT		Alpha 40 (Lower Case)This field contains the comment narrative.PA59.2
PGI-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA59.2
PGI-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA59.2
PGI-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA59.2

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PGISET1COMPANY, EMPLOYEE, TYPE, GRIEV-DIS-NBR, SEQ-NBRPrimaryHR11.1, PA115, PA59.1, PA59.2
PGISET2COMPANY, EMPLOYEE, TYPE, GRIEV-DIS-NBR*, EFFECT-DATE*, SEQ-NBR*KeyChangeHR170, HR70.1, PA259, PA59.2

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
Act Step CatPCODESRequiredWhen PGI-FOLLOW-CAT != Spaces"GA" → PCO-TYPE, PGI-FOLLOW-CAT → PCO-CODE
Act Step OutcPCODESRequiredWhen PGI-OUTCOME != Spaces"GT" → PCO-TYPE, PGI-OUTCOME → PCO-CODE
Act Step TypePCODESRequiredWhen PGI-FOLLOW-TYPE != Spaces"GP" → PCO-TYPE, PGI-FOLLOW-TYPE → PCO-CODE
CompanyPRSYSTEMRequiredPGI-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredPGI-COMPANY → EMP-COMPANY, PGI-EMPLOYEE → EMP-EMPLOYEE
Griev Dis ActPAGRDIRequiredPGI-COMPANY → PAG-COMPANY, PGI-EMPLOYEE → PAG-EMPLOYEE, PGI-TYPE → PAG-TYPE, PGI-GRIEV-DIS-NBR → PAG-GRIEV-DIS-NBR
PaemployeePAEMPLOYEERequiredPGI-COMPANY → PEM-COMPANY, PGI-EMPLOYEE → PEM-EMPLOYEE
Performed ByEMPLOYEERequiredWhen PGI-PERFORMED-BY != ZeroesPGI-COMPANY → EMP-COMPANY, PGI-PERFORMED-BY → EMP-EMPLOYEE

Programs

Updated by (4)

Referenced by (3)