GRIEVANCE_SRCH

(SQL View)
 Index Back

Grievances Security Search

GRIEVANCE_SRCH is used to apply Row Level Access by DEPTID to the girevances filed. This version displays also UNION_CD. 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.

SELECT DISTINCT A.GRIEVANCE_ID , SEC.OPRID , A.GRIEVANCE_TYPE , A.GRIEVANCE_STATUS , A.FILED_BY , A.EMPLID , A.UNION_CD , A.CONTACT_NAME FROM PS_GRIEVANCE A , PS_DEPT_SEC_SRCH SEC WHERE A.DEPTID = ' ' OR A.DEPTID = SEC.DEPTID

  • Related Language Record: GRIEV_SRCH_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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 GRIEVANCE_TYPE Character(3) VARCHAR2(3) NOT NULL Grievance Type

    Prompt Table: GRIEV_TYPE_TBL

    4 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

    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

    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