SCHOOL_CRSE_VW

(SQL View)
 Index Back

School Courses Vw

AD02A View of School Course Table by Ext Org and School Course Number.

SELECT DISTINCT EXT_ORG_ID , SCHOOL_CRSE_NBR , DESCR FROM PS_SCHOOL_CRSE_TBL A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SCHOOL_CRSE_TBL WHERE A.EXT_ORG_ID = EXT_ORG_ID AND A.SCHOOL_SUBJECT = SCHOOL_SUBJECT AND A.SCHOOL_CRSE_NBR = SCHOOL_CRSE_NBR AND EFFDT <= %CurrentDateIn)

  • Related Language Record: SCHOOLCRSEVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    2 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr

    Prompt Table: SCHOOL_CRSE_HDR

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