CLASS_FEE_VW

(SQL View)
Index Back

Class Fee View


SELECT A.SETID , B.CRSE_ID , B.DESCR FROM PS_SETID_TBL A , PS_CRSE_CATALOG B WHERE B.CRSE_ID NOT IN ( SELECT C.CRSE_ID FROM PS_CLASS_FEE_TBL C WHERE C.SETID = A.SETID) AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_CRSE_CATALOG BB WHERE BB.CRSE_ID = B.CRSE_ID AND BB.EFFDT <= %CurrentDateIn AND BB.EFF_STATUS = 'A')

  • Related Language Record: CLASSFEEVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID

    Prompt Table: CRSE_CAT_R1_VW

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