DISC_SUM_LNG_VW

(SQL View)
 Index Back

Disciplinary Action Summary

Language View used by Crystal Report OHS002-- Disciplinary Action Summary

SELECT A.EMPLID , C.LANGUAGE_CD , C.DESCR , D.DESCR FROM PS_DISCIPLIN_ACTN A , PS_DISCIP_TYP_LANG C , PS_DISCIP_STP_LANG D , PS_DISCIPLIN_STEP E WHERE A.EMPLID = E.EMPLID AND A.DISCIPLINE_DT = E.DISCIPLINE_DT AND A.DISCIPLINARY_TYPE = E.DISCIPLINARY_TYPE AND D.DISCIPLINARY_STEP = E.DISCIPLINARY_STEP AND C.LANGUAGE_CD = D.LANGUAGE_CD AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DISCIP_STP_LANG E1 WHERE E1.DISCIPLINARY_STEP = E.DISCIPLINARY_STEP AND E1.EFFDT <= A.DISCIPLINE_DT) AND A.DISCIPLINARY_TYPE = C.DISCIPLINARY_TYPE AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DISCIP_TYP_LANG C1 WHERE C1.DISCIPLINARY_TYPE = C.DISCIPLINARY_TYPE AND C1.EFFDT <= A.DISCIPLINE_DT)

  • Related Language Record for DISC_SUM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR_INC_TYPE Character(30) VARCHAR2(30) NOT NULL Incident Type Description
    4 DESCR_ACT_TYPE Character(30) VARCHAR2(30) NOT NULL Action type desciption