GRIEV_LNG (SQL Table)	Index Back
Grievances Use GRIEVANCE to record information about grievances filed against your company by employees, unions, or other entities. This functionality is part of the Labor Relations modules. Use a subordinate record, GRIEVANCE_STEP, to identify the steps taken to satisfy the grievance.

GRIEV_LNG

(SQL Table)

Grievances

Use GRIEVANCE to record information about grievances filed against your company by employees, unions, or other entities. This functionality is part of the Labor Relations modules. Use a subordinate record, GRIEVANCE_STEP, to identify the steps taken to satisfy the grievance.

Related Language Record for GRIEVANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GRIEVANCE_ID Character(10) VARCHAR2(10) NOT NULL Grievance ID
Default Value: 0

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name

4 CONTRACT_REF Character(40) VARCHAR2(40) NOT NULL Contract Reference

5 DESCRLONG Long Character CLOB Long Description

6 RESLTN_COMM Character(254) VARCHAR2(254) NOT NULL Resolution Comments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GRIEVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Grievance ID Default Value: 0
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Contact Name
4	CONTRACT_REF	Character(40)	VARCHAR2(40) NOT NULL	Contract Reference
5	DESCRLONG	Long Character	CLOB	Long Description
6	RESLTN_COMM	Character(254)	VARCHAR2(254) NOT NULL	Resolution Comments