PAGRDI FILE
Contains grievance and disciplinary action information.
Maintained primarily by PA59.1 (Grievance,Disciplinary Actions).
REFERENCED BY
PA259
UPDATED BY
PA59.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAG-COMPANY Numeric 4 PA59.1
Company The company number represents an
established company and is entered on
all function codes.
PAG-EMPLOYEE Numeric 9 PA59.1
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.
PAG-TYPE Alpha 2 PA59.1
Type Indicates whether the action is
tracking a grievance or disciplinary
issue.
1 = Grievance
2 = Disciplinary
PAG-GRIEV-DIS-NBR Numeric 4 PA59.1
Griev Dis Nbr Contains the action number. The numbers
are assigned by the Personnel
Administration system. The numbers start
at one for each employee and type.
PAG-DESCRIPTION Alpha 30 (Lower Case) PA59.1
Description This field displays the description.
PAG-DATE Numeric 8 (yyyymmdd) PA59.1
Date Contains the date the grievance or
disciplinary action was created.
PAG-GRIEV-DIS-CAT Alpha 10 PA59.1
Griev Dis Cat Contains the user-defined grievance or
disciplinary action category.
PAG-REPORT-DATE Numeric 8 (yyyymmdd) PA59.1
Report Date Contains the date the grievance or
disciplinary action was reported.
PAG-REPORTS-BY Numeric 9 PA59.1
Reports By Contains the name of the employee who
reported the action.
PAG-REPORT-BY-NAME Alpha 30 (Lower Case) PA59.1
Report By Name Contains the name of the employee who
reported the action.
PAG-GRIEV-DIS-STAT Alpha 10 PA59.1
Griev Dis Stat Contains the user-defined grievance,
disciplinary action status.
PAG-OUTCOME Alpha 10 PA59.1
Outcome Contains the user-defined
grievance,disciplinary action outcome.
PAG-OUTCOME-DATE Numeric 8 (yyyymmdd) PA59.1
Outcome Date Contains the date of the grievance,
disciplinary action outcome.
PAG-DAYS-OUT Numeric 3 PA59.1
Days Out Contains the number of days the
employee is away from work due to the
grievance, disciplinary action.
PAG-COST Signed 11.2 PA59.1
Cost Contains the cost for the
grievance,disciplinary action.
PAG-PROCESS-LEVEL Alpha 5 PA59.1
Process Level Contains the process level where the
grievance or disciplinary action
occurred.
PAG-DEPARTMENT Alpha 5 PA59.1
Department Contains the department where the
grievance or disciplinary action
occurred.
PAG-LOCAT-CODE Alpha 10 PA59.1
Location Contains the location where the
grievance or disciplinary action
occurred.
PAG-JOB-CODE Alpha 9 PA59.1
Job Code Contains the employee's job code when
the grievance or disciplinary action
occurred.
PAG-SHIFT Numeric 1 PA59.1
Shift 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
PAG-SUPERVISOR-EMP Numeric 9 PA59.1
Supervisor Emp Contains the supervisory where the
grievance or disciplinary action
occurred.
PAG-UNION-CODE Alpha 10 PA59.1
Union Code Contains the union with which the
employee was associated when the
grievance or disciplinary action
occurred.
PAG-BARGAIN-UNIT Alpha 10 PA59.1
Bargaining Unit Contains the bargaining unit with which
the employee was associated when the
grievance or disciplinary action
occurred.
PAG-CONTACT-NBR Numeric 9 PA59.1
Contact Nbr Contains the contact for the union or
bargaining unit.
PAG-CONTACT-NAME Alpha 30 (Lower Case) PA59.1
Contact Name Contains the employee contact of the
union or bargaining unit.
PAG-PHONE-COUNTRY Alpha 6 PA59.1
Telephone Country Contains the telephone country code for
Code the union or bargaining unit contact.
PAG-PHONE Alpha 15 PA59.1
Telephone Number Contains the telephone number for the
unit or bargaining unit contact.
PAG-PHONE-EXT Alpha 5 PA59.1
Telephone Extension Contains the telephone extension for
the union or bargaining unit contact.
PAG-COMMENT Alpha 40 (Lower Case) PA59.1
Comment Line This field contains the comment
narrative.
PAG-DATE-STAMP Numeric 8 (yyyymmdd) PA59.1
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAG-TIME-STAMP Numeric 6 (hhmmss) PA59.1
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAG-USER-ID Alpha 10 (Lower Case) PA59.1
User ID Name Contains the user ID of the person who
last changed this record.
PAG-CURRENCY-CODE Alpha 5 PA59.1
Currency Code Contains the currency in which the
grievance or disciplinary action cost is
recorded.
PAG-CURR-ND Numeric 1 PA59.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PAG-BASE-CURRENCY Alpha 5 PA59.1
Base Currency Contains the company's base currency.
PAG-BASE-ND Numeric 1 PA59.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
PAG-BASE-AMOUNT Signed 15.2 PA59.1
Base Amount Contains the costs in the company's
base currency.
PAGRDI FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAGSET1 COMPANY PA259 PA59.1
EMPLOYEE PA59.2
TYPE
GRIEV-DIS-NBR
PAGSET2 COMPANY PA59.1
EMPLOYEE
TYPE
GRIEV-DIS-NBR*
PAGSET3 COMPANY KeyChange PA259
EMPLOYEE
TYPE
DATE*
GRIEV-DIS-NBR*
PAGRDI FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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
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-EMPLOYEE -> 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 RELATED
NAME 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
|
