PAGRDI

Contains grievance and disciplinary action information. Maintained primarily by PA59.1 (Grievance,Disciplinary Actions).
UPDATED BY
PA59.1 HR11.1 HR170 HR70.1 PA115 PA259

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAG-COMPANY
Element: Company Hr		Numeric 4
PA59.1
PAG-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.1
PAG-TYPE
Element: Type		Alpha 2
Indicates whether the action is tracking a grievance or disciplinary issue.
1 = Grievance
2 = Disciplinary
PA59.1
PAG-GRIEV-DIS-NBR
Element: Griev Dis Nbr		Numeric 4
Contains the action number. The numbers are assigned by the Personnel Administration system. The numbers start at one for each employee and type.
PA59.1
PAG-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
PA59.1
PAG-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains the date the grievance or disciplinary action was created.
PA59.1
PAG-GRIEV-DIS-CAT
Element: Griev Dis Cat		Alpha 10
Contains the user-defined grievance or disciplinary action category.
PA59.1
PAG-REPORT-DATE
Element: Report Date		Numeric 8 (yyyymmdd)
Contains the date the grievance or disciplinary action was reported.
PA59.1
PAG-REPORTS-BY
Element: Reports By		Numeric 9
Contains the name of the employee who reported the action.
PA59.1
PAG-REPORT-BY-NAME
Element: Report By Name		Alpha 30 (Lower Case)
Contains the name of the employee who reported the action.
PA59.1
PAG-GRIEV-DIS-STAT
Element: Griev Dis Stat		Alpha 10
Contains the user-defined grievance, disciplinary action status.
PA59.1
PAG-OUTCOME
Element: Outcome		Alpha 10
Contains the user-defined grievance,disciplinary action outcome.
PA59.1
PAG-OUTCOME-DATE
Element: Outcome Date		Numeric 8 (yyyymmdd)
Contains the date of the grievance, disciplinary action outcome.
PA59.1
PAG-DAYS-OUT
Element: Days Out		Numeric 3
Contains the number of days the employee is away from work due to the grievance, disciplinary action.
PA59.1
PAG-COST
Element: Cost		Signed 11.2
Contains the cost for the grievance,disciplinary action.
PA59.1
PAG-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
Contains the process level where the grievance or disciplinary action occurred.
PA59.1
PAG-DEPARTMENT
Element: Department		Alpha 5
Contains the department where the grievance or disciplinary action occurred.
PA59.1
PAG-LOCAT-CODE
Element: Locat Code		Alpha 10
Contains the location where the grievance or disciplinary action occurred.
PA59.1
PAG-JOB-CODE
Element: Job Code		Alpha 9
Contains the employee's job code when the grievance or disciplinary action occurred.
PA59.1
PAG-SHIFT
Element: Shift		Numeric 1
Contains the shift where the grievance or disciplinary action occurred.
1 = Shift 1
2 = Shift 2
3 = Shift 3
4 = Shift 4
5 = Shift 5
6 = Shift 6
7 = Shift 7
8 = Shift 8
9 = Shift 9
PA59.1
PAG-SUPERVISOR-EMP
Element: Supervisor Emp		Numeric 9
Contains the supervisory where the grievance or disciplinary action occurred.
PA59.1
PAG-UNION-CODE
Element: Union Code		Alpha 10
Contains the union with which the employee was associated when the grievance or disciplinary action occurred.
PA59.1
PAG-BARGAIN-UNIT
Element: Bargain Unit		Alpha 10
Contains the bargaining unit with which the employee was associated when the grievance or disciplinary action occurred.
PA59.1
PAG-CONTACT-NBR
Element: Contact Nbr		Numeric 9
Contains the contact for the union or bargaining unit.
PA59.1
PAG-CONTACT-NAME
Element: Contact Name		Alpha 30 (Lower Case)
Contains the employee contact of the union or bargaining unit.
PA59.1
PAG-PHONE-COUNTRY
Element: Phone Country		Alpha 6
Contains the telephone country code for the union or bargaining unit contact.
PA59.1
PAG-PHONE
Element: Phone		Alpha 15
Contains the telephone number for the unit or bargaining unit contact.
PA59.1
PAG-PHONE-EXT
Element: Phone Ext		Alpha 5
Contains the telephone extension for the union or bargaining unit contact.
PA59.1
PAG-COMMENT
Element: Comment		Alpha 40 (Lower Case)
This field contains the comment narrative.
PA59.1
PAG-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.1
PAG-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA59.1
PAG-USER-ID
Element: User		Alpha 10 (Lower Case)
PA59.1
PAG-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency in which the grievance or disciplinary action cost is recorded.
PA59.1
PAG-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA59.1
PAG-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the company's base currency.
PA59.1
PAG-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
PA59.1
PAG-BASE-AMOUNT
Element: Base Amt		Signed 15.2
Contains the costs in the company's base currency.
PA59.1


PAGRDI FILE INDEX

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


PAGRDI FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Bargain Unit PCODES Required
When PAG-BARGAIN-UNIT !=Spaces
"BU"->PCO-TYPE
PAG-BARGAIN-UNIT->PCO-CODE
Base Currency CUCODES Required
When (PAG-CURRENCY-CODE !=Spaces )
PAG-BASE-CURRENCY->CUC-CURRENCY-CODE
Category PCODES Required
When PAG-GRIEV-DIS-CAT !=Spaces
"GC"->PCO-TYPE
PAG-GRIEV-DIS-CAT->PCO-CODE
Company PRSYSTEM Required
PAG-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Contact EMPLOYEE Required
When PAG-CONTACT-NBR !=Zeroes
PAG-COMPANY->EMP-COMPANY
PAG-CONTACT-NBR->EMP-EMPLOYEE
Currency CUCODES Required
When (PAG-CURRENCY-CODE !=Spaces )
PAG-CURRENCY-CODE->CUC-CURRENCY-CODE
Department DEPTCODE Required
When PAG-DEPARTMENT !=Spaces
PAG-COMPANY->DPT-COMPANY
PAG-PROCESS-LEVEL->DPT-PROCESS-LEVEL
PAG-DEPARTMENT->DPT-DEPARTMENT
Employee EMPLOYEE Required
PAG-COMPANY->EMP-COMPANY
PAG-EMPLOYEE->EMP-EMPLOYEE
Griev Dis Cat PCODES Required
When PAG-GRIEV-DIS-CAT !=Spaces
"GC"->PCO-TYPE
PAG-GRIEV-DIS-CAT->PCO-CODE
Griev Dis Stat PCODES Required
When PAG-GRIEV-DIS-STAT !=Spaces
"GS"->PCO-TYPE
PAG-GRIEV-DIS-STAT->PCO-CODE
Job Code JOBCODE Required
When PAG-JOB-CODE !=Spaces
PAG-COMPANY->JBC-COMPANY
PAG-JOB-CODE->JBC-JOB-CODE
Location PCODES Required
When PAG-LOCAT-CODE !=Spaces
"LO"->PCO-TYPE
PAG-LOCAT-CODE->PCO-CODE
Outcome PCODES Required
When PAG-OUTCOME !=Spaces
"GO"->PCO-TYPE
PAG-OUTCOME->PCO-CODE
Paemployee PAEMPLOYEE Not Required
PAG-COMPANY->PEM-COMPANY
PAG-EMPLOYEE->PEM-EMPLOYEE
Process Level PRSYSTEM Required
When PAG-PROCESS-LEVEL !=Spaces
PAG-COMPANY->PRS-COMPANY
PAG-PROCESS-LEVEL->PRS-PROCESS-LEVEL
Report By EMPLOYEE Required
When PAG-REPORTS-BY !=Zeroes
PAG-COMPANY->EMP-COMPANY
PAG-REPORTS-BY->EMP-EMPLOYEE
Status PCODES Required
When PAG-GRIEV-DIS-STAT !=Spaces
"GS"->PCO-TYPE
PAG-GRIEV-DIS-STAT->PCO-CODE
Super Emp EMPLOYEE Required
When (PAG-SUPERVISOR-EMP !=Zeroes )
PAG-COMPANY->EMP-COMPANY
PAG-SUPERVISOR-EMP->EMP-EMPLOYEE
Union PCODES Required
When PAG-UNION-CODE !=Spaces
"UN"->PCO-TYPE
PAG-UNION-CODE->PCO-CODE


PAGRDI FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Action Steps PAGRDISTEP Delete Cascades
PAG-COMPANY->PGI-COMPANY
PAG-EMPLOYEE->PGI-EMPLOYEE
PAG-TYPE->PGI-TYPE
PAG-GRIEV-DIS-NBR->PGI-GRIEV-DIS-NBR
  PGI-SEQ-NBR

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

Home
Contact Us



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