SCHL_CRSE_TRVLN

(SQL View)
 Index Back

School Courses View

select a.EXT_ORG_ID , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.EFFDT , a.EFF_STATUS , a.EXT_SUBJECT_AREA , a.EXT_CAREER , a.EXT_CRSE_TYPE , a.COURSE_LEVEL , a.DESCR , a.DESCRSHORT , a.EXT_UNITS from PS_SCHOOL_CRSE_TBL a

SELECT a.EXT_ORG_ID , a.SCHOOL_SUBJECT , a.SCHOOL_CRSE_NBR , a.LANGUAGE_CD , a.EFFDT , a.DESCR , a.DESCRSHORT FROM PS_SCHOOL_CRSE_LNG a

  • Related Language Record for SCHL_CRSE_TRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CATALOG_ORG Character(11) VARCHAR2(11) NOT NULL Catalog Organization
    2 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: SCHOOL_SUBJ_HDR

    3 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: SCHOOL_CRSE_TBL.DESCR