GRV_DTL_LNG_VW

(SQL View)
 Index Back

Grievance Detail View

Language View used by Crystal report OHS004-- Grievance Detail

SELECT A.GRIEVANCE_ID , E.LANGUAGE_CD , B.DESCRSHORT , E.CONTRACT_REF , E.DESCRLONG , B.DESCRSHORT , D.DESCR , F.COMMENTS FROM PS_GRIEVANCE A , PS_GRIEV_TYPE_LANG B , PS_GRIEVANCE_STEP C , PS_GRIEV_STEP_LANG D , PS_GRIEV_LNG E , PS_GRIEV_STEP_LNG F WHERE A.GRIEVANCE_TYPE = B.GRIEVANCE_TYPE AND A.GRIEVANCE_ID = C.GRIEVANCE_ID AND A.GRIEVANCE_ID = E.GRIEVANCE_ID AND C.GRIEVANCE_STEP = D.GRIEVANCE_STEP AND C.GRIEVANCE_ID = F.GRIEVANCE_ID AND C.GRIEVANCE_STEP = F.GRIEVANCE_STEP AND B.LANGUAGE_CD = D.LANGUAGE_CD AND D.LANGUAGE_CD = E.LANGUAGE_CD AND E.LANGUAGE_CD=F.LANGUAGE_CD AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_GRIEV_TYPE_LANG 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_LANG D1 WHERE D.GRIEVANCE_STEP=D1.GRIEVANCE_STEP AND D1.EFFDT <= A.GRIEVANCE_DT)

  • Related Language Record for GRV_DETAIL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GRIEVANCE_ID Character(10) VARCHAR2(10) NOT NULL Grievance ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    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 DESCRLONG Long Character CLOB Long Description
    6 DESCR_GRV_STEP Character(30) VARCHAR2(30) NOT NULL Grievance Step Description
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 COMMENTS Long Character CLOB Comment