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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PGISET1
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. GRIEV-DIS-NBR
  5. SEQ-NBR
PrimaryHR11.1, PA115, PA59.1, PA59.2
PGISET2
  1. COMPANY
  2. EMPLOYEE
  3. TYPE
  4. GRIEV-DIS-NBR ↓
  5. EFFECT-DATE ↓
  6. SEQ-NBR ↓
KeyChangeHR170, HR70.1, PA259, PA59.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PCODESPRSYSTEMEMPLOYEEPAGRDIPAEMPLOYEEPAGRDISTEP

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
CompanyPRSYSTEMRequired
PGI-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PGI-COMPANY→EMP-COMPANY
PGI-EMPLOYEE→EMP-EMPLOYEE
Griev Dis ActPAGRDIRequired
PGI-COMPANY→PAG-COMPANY
PGI-EMPLOYEE→PAG-EMPLOYEE
PGI-TYPE→PAG-TYPE
PGI-GRIEV-DIS-NBR→PAG-GRIEV-DIS-NBR
PaemployeePAEMPLOYEERequired
PGI-COMPANY→PEM-COMPANY
PGI-EMPLOYEE→PEM-EMPLOYEE
Performed ByEMPLOYEERequiredWhen PGI-PERFORMED-BY != Zeroes
PGI-COMPANY→EMP-COMPANY
PGI-PERFORMED-BY→EMP-EMPLOYEE

Programs

Updated by (4)

Referenced by (3)