ADM_WEB_INT_VW

(SQL View)
Index Back

Academic Interests View

This view diplays all External Subject Areas which are Academic Interests. It is used by Web Prospect Create.

SELECT A.Ext_Subject_Area ,A.EFFDT ,A.Descr FROM PS_EXT_SUBJECT_TBL A WHERE A.Academic_Interest = 'Y' 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: ADM_WEB_INT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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