AVCTYPMINVWLNG

(SQL View)
 Index Back

Person Constituent Type

Person Constituent Type

SELECT A.INSTITUTION , A.EMPLID , B.LANGUAGE_CD , A.CNST_TYPE_PAST_FLG , B.DESCR FROM PS_AV_CNST_TYP_TBL A , PS_AV_CTYP_CD_LNG B WHERE A.CNST_TYPE = B.CNST_TYPE AND A.EMPLID <> ' ' AND A.CNST_TYPE IN ( SELECT MIN(C.CNST_TYPE) FROM PS_AV_CNST_TYP_TBL C WHERE A.INSTITUTION = C.INSTITUTION AND A.EMPLID = C.EMPLID AND C.CNST_TYPE_PAST_FLG <> 'Y') UNION ALL SELECT A.INSTITUTION , A.EMPLID , B.LANGUAGE_CD , A.CNST_TYPE_PAST_FLG , ( SELECT MESSAGE_TEXT FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR =14390 AND MESSAGE_NBR = 498 AND LANGUAGE_CD = B.LANGUAGE_CD) || ' ' || B.DESCR FROM PS_AV_CNST_TYP_TBL A , PS_AV_CTYP_CD_LNG B WHERE A.CNST_TYPE = B.CNST_TYPE AND A.EMPLID <> ' ' AND A.CNST_TYPE IN ( SELECT MIN(C.CNST_TYPE) FROM PS_AV_CNST_TYP_TBL C WHERE A.INSTITUTION = C.INSTITUTION AND A.EMPLID = C.EMPLID AND C.CNST_TYPE_PAST_FLG = 'Y')

  • Related Language Record for AV_CTYP_MIN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 CNST_TYPE_PAST_FLG Character(1) VARCHAR2(1) NOT NULL Past
    N=No
    Y=Yes
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description