ADM_WEB_INT_LNG

(SQL View)
 Index Back

Related Language Acad Int View

This is the related language view for ADM_WEB_INT_VW. This view diplays all External Subject Areas which are Academic Interests. It is used by Web Prospect Create.

SELECT A.Ext_Subject_Area ,A.Language_Cd ,A.EFFDT ,A.Descr FROM PS_EXT_SUBJECT_LNG A ,PS_EXT_SUBJECT_TBL C WHERE C.Academic_Interest = 'Y' AND C.Ext_Subject_Area = A.Ext_Subject_Area AND C.Effdt = A.Effdt AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_EXT_SUBJECT_TBL B WHERE B.Ext_Subject_Area = A.Ext_Subject_Area AND B.EFF_STATUS = 'A' AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record for ADM_WEB_INT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description