RQ_PROGSRCH_LNG

(SQL View)
Index Back

Rq Academic Prog Search

The Program Table View lists all academic programs that an institution has ever offered regardless of effective date.

SELECT DISTINCT INSTITUTION ,ACAD_PROG ,LANGUAGE_CD ,EFFDT ,DESCR FROM PS_ACAD_PROG_LANG

  • Related Language Record for RQ_PROG_SRCH
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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