|
|
PAGRDI FILE
Contains grievance and disciplinary action information.
Maintained primarily by PA59.1 (Grievance,Disciplinary Actions).
REFERENCED BY
HR170 HR70.1 PA259
UPDATED BY
PA59.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAG-COMPANY Numeric 4 PA59.1
Element: Company Hr
PAG-EMPLOYEE Numeric 9 PA59.1
Element: 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
Element: Type Indicates whether the action is
tracking a grievance or disciplinary
issue.
1 = Grievance
2 = Disciplinary
PAG-GRIEV-DIS-NBR Numeric 4 PA59.1
Element: 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
Element: Description This field displays the description.
PAG-DATE Numeric 8 (yyyymmdd) PA59.1
Element: Date Contains the date the grievance or
disciplinary action was created.
PAG-GRIEV-DIS-CAT Alpha 10 PA59.1
Element: Griev Dis Cat Contains the user-defined grievance or
disciplinary action category.
PAG-REPORT-DATE Numeric 8 (yyyymmdd) PA59.1
Element: Report Date Contains the date the grievance or
disciplinary action was reported.
PAG-REPORTS-BY Numeric 9 PA59.1
Element: Reports By Contains the name of the employee who
reported the action.
PAG-REPORT-BY-NAME Alpha 30 (Lower Case) PA59.1
Element: Report By NameContains the name of the employee who
reported the action.
PAG-GRIEV-DIS-STAT Alpha 10 PA59.1
Element: Griev Dis StatContains the user-defined grievance,
disciplinary action status.
PAG-OUTCOME Alpha 10 PA59.1
Element: Outcome Contains the user-defined
grievance,disciplinary action outcome.
PAG-OUTCOME-DATE Numeric 8 (yyyymmdd) PA59.1
Element: Outcome Date Contains the date of the grievance,
disciplinary action outcome.
PAG-DAYS-OUT Numeric 3 PA59.1
Element: 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
Element: Cost Contains the cost for the
grievance,disciplinary action.
PAG-PROCESS-LEVEL Alpha 5 PA59.1
Element: Process Lev HrContains the process level where the
grievance or disciplinary action
occurred.
PAG-DEPARTMENT Alpha 5 PA59.1
Element: Department Contains the department where the
grievance or disciplinary action
occurred.
PAG-LOCAT-CODE Alpha 10 PA59.1
Element: Locat Code Contains the location where the
grievance or disciplinary action
occurred.
PAG-JOB-CODE Alpha 9 PA59.1
Element: Job Code Contains the employee's job code when
the grievance or disciplinary action
occurred.
PAG-SHIFT Numeric 1 PA59.1
Element: 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
Element: Supervisor EmpContains the supervisory where the
grievance or disciplinary action
occurred.
PAG-UNION-CODE Alpha 10 PA59.1
Element: 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
Element: Bargain 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
Element: Contact Nbr Contains the contact for the union or
bargaining unit.
PAG-CONTACT-NAME Alpha 30 (Lower Case) PA59.1
Element: Contact Name Contains the employee contact of the
union or bargaining unit.
PAG-PHONE-COUNTRY Alpha 6 PA59.1
Element: Phone Country Contains the telephone country code for
the union or bargaining unit contact.
PAG-PHONE Alpha 15 PA59.1
Element: Phone Contains the telephone number for the
unit or bargaining unit contact.
PAG-PHONE-EXT Alpha 5 PA59.1
Element: Phone Ext Contains the telephone extension for
the union or bargaining unit contact.
PAG-COMMENT Alpha 40 (Lower Case) PA59.1
Element: Comment This field contains the comment
narrative.
PAG-DATE-STAMP Numeric 8 (yyyymmdd) PA59.1
Element: 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
Element: 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
Element: User
PAG-CURRENCY-CODE Alpha 5 PA59.1
Element: Currency Code Contains the currency in which the
grievance or disciplinary action cost is
recorded.
PAG-CURR-ND Numeric 1 PA59.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
PAG-BASE-CURRENCY Alpha 5 PA59.1
Element: Base Currency Contains the company's base currency.
PAG-BASE-ND Numeric 1 PA59.1
Element: Base Nd The number of decimal positions defined
for the company base currency.
PAG-BASE-AMOUNT Signed 15.2 PA59.1
Element: Base Amt Contains the costs in the company's
base currency.
PAGRDI FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAGSET1 COMPANY HR11.1 HR170
EMPLOYEE HR70.1 PA115
TYPE PA259 PA59.1
GRIEV-DIS-NBR PA59.2
PAGSET2 COMPANY PA59.1
EMPLOYEE
TYPE
GRIEV-DIS-NBR*
PAGSET3 COMPANY KeyChange HR170 HR70.1
EMPLOYEE PA259
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
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 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
|
