ADM_WEB_INT_VW(SQL View) |
Index Back |
---|---|
Academic Interests ViewThis 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) |
# | 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 |