PAGRDISTEP FILE
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 This field 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
|
