PAGRDI – Grievance,Disciplinary Actions
- System
- Personnel (PA)
- Prefix
PAG- Primary key
COMPANY,EMPLOYEE,TYPE,GRIEV-DIS-NBR- Fields
- 37
- Updated by
- 3 programs
- Referenced by
- 4 programs
PAGRDI is the Grievance,Disciplinary Actions table in Lawson Personnel (prefix PAG). It is indexed by COMPANY, EMPLOYEE, TYPE, GRIEV-DIS-NBR (PAGSET1); alternate indexes: PAGSET2 and PAGSET3. It is related 1:1 to PCODES, CUCODES, PRSYSTEM, EMPLOYEE, DEPTCODE, JOBCODE and PAEMPLOYEE and 1:M to PAGRDISTEP. It is updated by HR11.1, PA115 and PA59.1 and referenced by HR170, HR70.1, PA259 and ZH500. The table has 37 fields, 3 indexes and 20 documented relations.
About PAGRDI
Contains grievance and disciplinary action information. Maintained primarily by PA59.1 (Grievance,Disciplinary Actions).
Fields (37)
Column = COBOL field name without the PAG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PAG-COMPANY PKCOMPANY | Numeric 4 | — | PA59.1 |
#PAG-EMPLOYEE PKEMPLOYEE | 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 PKTYPE | Alpha 2 | Indicates whether the action is tracking a grievance or disciplinary issue.
| PA59.1 |
#PAG-GRIEV-DIS-NBR PKGRIEV_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-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | PA59.1 |
#PAG-DATE SET3DATE | Numeric 8 (yyyymmdd) | Contains the date the grievance or disciplinary action was created. | PA59.1 |
#PAG-GRIEV-DIS-CATGRIEV_DIS_CAT | Alpha 10 | Contains the user-defined grievance or disciplinary action category. | PA59.1 |
#PAG-REPORT-DATEREPORT_DATE | Numeric 8 (yyyymmdd) | Contains the date the grievance or disciplinary action was reported. | PA59.1 |
#PAG-REPORTS-BYREPORTS_BY | Numeric 9 | Contains the name of the employee who reported the action. | PA59.1 |
#PAG-REPORT-BY-NAMEREPORT_BY_NAME | Alpha 30 (Lower Case) | Contains the name of the employee who reported the action. | PA59.1 |
#PAG-GRIEV-DIS-STATGRIEV_DIS_STAT | Alpha 10 | Contains the user-defined grievance, disciplinary action status. | PA59.1 |
#PAG-OUTCOMEOUTCOME | Alpha 10 | Contains the user-defined grievance,disciplinary action outcome. | PA59.1 |
#PAG-OUTCOME-DATEOUTCOME_DATE | Numeric 8 (yyyymmdd) | Contains the date of the grievance, disciplinary action outcome. | PA59.1 |
#PAG-DAYS-OUTDAYS_OUT | Numeric 3 | Contains the number of days the employee is away from work due to the grievance, disciplinary action. | PA59.1 |
#PAG-COSTCOST | Signed 11.2 | Contains the cost for the grievance,disciplinary action. | PA59.1 |
#PAG-PROCESS-LEVELPROCESS_LEVEL | Alpha 5 | Contains the process level where the grievance or disciplinary action occurred. | PA59.1 |
#PAG-DEPARTMENTDEPARTMENT | Alpha 5 | Contains the department where the grievance or disciplinary action occurred. | PA59.1 |
#PAG-LOCAT-CODELOCAT_CODE | Alpha 10 | Contains the location where the grievance or disciplinary action occurred. | PA59.1 |
#PAG-JOB-CODEJOB_CODE | Alpha 9 | Contains the employee's job code when the grievance or disciplinary action occurred. | PA59.1 |
#PAG-SHIFTSHIFT | Numeric 1 | Contains the shift where the grievance or disciplinary action occurred.
| PA59.1 |
#PAG-SUPERVISOR-EMPSUPERVISOR_EMP | Numeric 9 | Contains the supervisory where the grievance or disciplinary action occurred. | PA59.1 |
#PAG-UNION-CODEUNION_CODE | Alpha 10 | Contains the union with which the employee was associated when the grievance or disciplinary action occurred. | PA59.1 |
#PAG-BARGAIN-UNITBARGAIN_UNIT | Alpha 10 | Contains the bargaining unit with which the employee was associated when the grievance or disciplinary action occurred. | PA59.1 |
#PAG-CONTACT-NBRCONTACT_NBR | Numeric 9 | Contains the contact for the union or bargaining unit. | PA59.1 |
#PAG-CONTACT-NAMECONTACT_NAME | Alpha 30 (Lower Case) | Contains the employee contact of the union or bargaining unit. | PA59.1 |
#PAG-PHONE-COUNTRYPHONE_COUNTRY | Alpha 6 | Contains the telephone country code for the union or bargaining unit contact. | PA59.1 |
#PAG-PHONEPHONE | Alpha 15 | Contains the telephone number for the unit or bargaining unit contact. | PA59.1 |
#PAG-PHONE-EXTPHONE_EXT | Alpha 5 | Contains the telephone extension for the union or bargaining unit contact. | PA59.1 |
#PAG-COMMENTCOMMENT | Alpha 40 (Lower Case) | This field contains the comment narrative. | PA59.1 |
#PAG-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | PA59.1 |
#PAG-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | PA59.1 |
#PAG-CURRENCY-CODECURRENCY_CODE | Alpha 5 | Contains the currency in which the grievance or disciplinary action cost is recorded. | PA59.1 |
#PAG-CURR-NDCURR_ND | Numeric 1 | The number of decimals assigned to a particular account as determined by the account currency. | PA59.1 |
#PAG-BASE-CURRENCYBASE_CURRENCY | Alpha 5 | Contains the company's base currency. | PA59.1 |
#PAG-BASE-NDBASE_ND | Numeric 1 | The number of decimal positions defined for the company base currency. | PA59.1 |
#PAG-BASE-AMOUNTBASE_AMOUNT | Signed 15.2 | Contains the costs in the company's base currency. | PA59.1 |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PAGSET1 |
| Primary | HR11.1, HR170, HR70.1, ZH500, PA115, PA259, PA59.1, PA59.2 | |
PAGSET2 |
| PA59.1 | ||
PAGSET3 |
| KeyChange | HR170, HR70.1, ZH500, PA259 |
Relations
One to one (19) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bargain Unit | PCODES | Required | When PAG-BARGAIN-UNIT != Spaces |
| |||||||||
| Base Currency | CUCODES | Required | When (PAG-CURRENCY-CODE != Spaces) |
| |||||||||
| Category | PCODES | Required | When PAG-GRIEV-DIS-CAT != Spaces |
| |||||||||
| Company | PRSYSTEM | Required |
| ||||||||||
| Contact | EMPLOYEE | Required | When PAG-CONTACT-NBR != Zeroes |
| |||||||||
| Currency | CUCODES | Required | When (PAG-CURRENCY-CODE != Spaces) |
| |||||||||
| Department | DEPTCODE | Required | When PAG-DEPARTMENT != Spaces |
| |||||||||
| Employee | EMPLOYEE | Required |
| ||||||||||
| Griev Dis Cat | PCODES | Required | When PAG-GRIEV-DIS-CAT != Spaces |
| |||||||||
| Griev Dis Stat | PCODES | Required | When PAG-GRIEV-DIS-STAT != Spaces |
| |||||||||
| Job Code | JOBCODE | Required | When PAG-JOB-CODE != Spaces |
| |||||||||
| Location | PCODES | Required | When PAG-LOCAT-CODE != Spaces |
| |||||||||
| Outcome | PCODES | Required | When PAG-OUTCOME != Spaces |
| |||||||||
| Paemployee | PAEMPLOYEE | Not Required |
| ||||||||||
| Process Level | PRSYSTEM | Required | When PAG-PROCESS-LEVEL != Spaces |
| |||||||||
| Report By | EMPLOYEE | Required | When PAG-REPORTS-BY != Zeroes |
| |||||||||
| Status | PCODES | Required | When PAG-GRIEV-DIS-STAT != Spaces |
| |||||||||
| Super Emp | EMPLOYEE | Required | When (PAG-SUPERVISOR-EMP != Zeroes) |
| |||||||||
| Union | PCODES | Required | When PAG-UNION-CODE != Spaces |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Action Steps | PAGRDISTEP | Delete Cascades |
|