GRIEVANCE

(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.

  • Related Language Record: GRIEV_LNG

  • Parent Record Of GRIEVANCE_STEP GRIEV_STEP_LNG

    • # 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 GRIEVANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Grievance Type

    Prompt Table: GRIEV_TYPE_TBL

    3 GRIEVANCE_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Appealed
    D=Dismissed
    P=Pending
    R=Rejected
    S=Settled
    U=Upheld
    W=Withdrawn

    Default Value: P

    4 STATUS_DT Date(10) DATE NOT NULL Status Date

    Default Value: %date

    5 FILED_BY Character(1) VARCHAR2(1) NOT NULL Filed By
    E=Employee/Applicant
    O=Other
    U=Union

    Default Value: E

    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    7 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    8 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    9 GRIEVANCE_DT Date(10) DATE NOT NULL Grievance Date

    Default Value: %date

    10 CONTRACT_REF Character(40) VARCHAR2(40) NOT NULL Contract Reference
    11 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    13 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Prompt Table: GVT_BARG_UNIT

    14 FINAL_RESOLUTION Character(3) VARCHAR2(3) NOT NULL Final Resolution

    Prompt Table: RESLTN_TYPE_VW

    15 RESLTN_COMM Character(254) VARCHAR2(254) NOT NULL Resolution Comments
    16 DESCRLONG Long Character CLOB Long Description