GRIEVANCE_STEP

(SQL Table)
 Index Back

Grievance Steps

Use GRIEVANCE_STEP to identify the steps taken to satisfy a grievance filed against your company by employees, unions, or other entities. This functionality is part of the Labor Relations modules. Before you use this record, you must set up the parent record, GRIEVANCE.

  • Related Language Record: GRIEV_STEP_LNG

  • Parent record: 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 GRIEVANCE_STEP Character(3) VARCHAR2(3) NOT NULL Grievance Step

    Prompt Table: GRIEV_STEP_TBL

    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 ACTION_DT Date(10) DATE NOT NULL Action Date

    Default Value: %date

    5 RESOLUTION_DT Date(10) DATE Resolution Date
    6 COMMENTS Long Character CLOB Comment
    7 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter code

    Prompt Table: LTR_GRIEV_VW

    8 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    9 STEP_RESLTN Character(3) VARCHAR2(3) NOT NULL Step Resolution

    Prompt Table: RESLTN_TYPE_VW