SCHOOLCRSEVWLNG

(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 ,LANGUAGE_CD , DESCR FROM PS_SCHOOL_CRSE_LNG A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SCHOOL_CRSE_LNG 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 for SCHOOL_CRSE_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description