GRV_DETAIL_VW

(SQL View)
 Index Back

Grievance Detail View

View used by Crystal report OHS004-- Grievance Detail

SELECT A.GRIEVANCE_ID , A.GRIEVANCE_DT , B.DESCRSHORT , A.CONTRACT_REF , A.GRIEVANCE_STATUS , A.STATUS_DT , A.DESCRLONG , B.DESCRSHORT , C.ACTION_DT , C.NAME , C.RESOLUTION_DT , D.DESCR , C.COMMENTS FROM PS_GRIEVANCE A , PS_GRIEV_TYPE_TBL B , PS_GRIEVANCE_STEP C , PS_GRIEV_STEP_TBL D WHERE A.GRIEVANCE_TYPE = B.GRIEVANCE_TYPE AND A.GRIEVANCE_ID = C.GRIEVANCE_ID AND C.GRIEVANCE_STEP = D.GRIEVANCE_STEP AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_GRIEV_TYPE_TBL B1 WHERE B.GRIEVANCE_TYPE=B1.GRIEVANCE_TYPE AND B1.EFFDT <= A.GRIEVANCE_DT) AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_GRIEV_STEP_TBL D1 WHERE D.GRIEVANCE_STEP=D1.GRIEVANCE_STEP AND D1.EFFDT <= A.GRIEVANCE_DT)

  • Related Language Record: GRV_DTL_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GRIEVANCE_ID Character(10) VARCHAR2(10) NOT NULL Grievance ID
    2 GRIEVANCE_DT Date(10) DATE Grievance Date
    3 DESCR_GRV_TYPE Character(10) VARCHAR2(10) NOT NULL Grievance Type Description
    4 CONTRACT_REF Character(40) VARCHAR2(40) NOT NULL Contract Reference
    5 GRIEVANCE_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Appealed
    D=Dismissed
    P=Pending
    R=Rejected
    S=Settled
    U=Upheld
    W=Withdrawn
    6 STATUS_DT Date(10) DATE Status Date
    7 DESCRLONG Long Character CLOB Long Description
    8 DESCR_GRV_STEP Character(30) VARCHAR2(30) NOT NULL Grievance Step Description
    9 ACTION_DT Date(10) DATE Action Date
    10 NAME Character(50) VARCHAR2(50) NOT NULL Name
    11 RESOLUTION_DT Date(10) DATE Resolution Date
    12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    13 COMMENTS Long Character CLOB Comment