PAGRDISTEP

Contains follow up step information for grievance or disciplinary actions. This file is maintained primarily by PA69.2 (Grievance, Disciplinary Action Step).
UPDATED BY
PA59.1 PA59.2 HR11.1 PA115 HR170 HR70.1
PA259

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGI-COMPANY
Element: Company Hr		Numeric 4
PA59.2
PGI-EMPLOYEE
Element: Employee		Numeric 9
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.
PA59.2
PGI-TYPE
Element: Type		Alpha 2
Indicates whether the action concerns a grievance or disciplinary issue.
1 = Grievance
2 = Discplinary
PA59.2
PGI-GRIEV-DIS-NBR
Element: Griev Dis Nbr		Numeric 4
Contains the grievance or disciplinary action number.
PA59.2
PGI-SEQ-NBR
Element: Seq Nbr		Numeric 4
An automatically assigned sequence number.
PA59.2
PGI-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the date for the grievance or disciplinary action follow up step.
PA59.2
PGI-STATUS
Element: Status		Numeric 1
Contains the grievance, disciplinary action follow up status.
1 = Open
2 = In Process
3 = Completed
PA59.2
PGI-FOLLOW-CAT
Element: Follow Cat		Alpha 10
Contains the user-defined grievance, disciplinary action step category.
PA59.2
PGI-FOLLOW-TYPE
Element: Follow Type		Alpha 10
Contains a user-defined grievance, disciplinary action step type.
PA59.2
PGI-OUTCOME
Element: Outcome		Alpha 10
Contains a user-defined grievance, disciplinary action step outcome.
PA59.2
PGI-PERFORMED-BY
Element: Performed By		Numeric 9
Contains the employee who performed the grievance, disciplinary action follow up step.
PA59.2
PGI-COMMENT
Element: Comment		Alpha 40 (Lower Case)
This field contains the comment narrative.
PA59.2
PGI-DATE-STAMP
Element: 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
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA59.2
PGI-USER-ID
Element: User		Alpha 10 (Lower Case)
PA59.2


PAGRDISTEP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGISET1 COMPANY
EMPLOYEE
TYPE
GRIEV-DIS-NBR
SEQ-NBR
HR11.1 PA115
PA59.1 PA59.2
PGISET2 COMPANY
EMPLOYEE
TYPE
GRIEV-DIS-NBR*
EFFECT-DATE*
SEQ-NBR*
KeyChange
HR170 HR70.1
PA259 PA59.2


PAGRDISTEP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
"GP"->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
Paemployee PAEMPLOYEE Required
PGI-COMPANY->PEM-COMPANY
PGI-EMPLOYEE->PEM-EMPLOYEE
Performed By EMPLOYEE Required
When PGI-PERFORMED-BY !=Zeroes
PGI-COMPANY->EMP-COMPANY
PGI-PERFORMED-BY->EMP-EMPLOYEE

File created: Wed Jun 08 20:50:24 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.