SAD_PRS_SPN_VWL

(SQL View)
 Index Back

Academic Sub Plan View Lang

Academic Sub Plan Language View

SELECT DISTINCT A.INSTITUTION ,A.ACAD_PLAN ,A.ACAD_SUB_PLAN , a1.language_cd , a1.descr FROM PS_ACAD_SUBPLN_TBL A , PS_ACAD_SUBPLN_LNG A1 WHERE A.INSTITUTION = A1.INSTITUTION AND A.ACAD_PLAN = A1.ACAD_PLAN AND A.ACAD_SUB_PLAN = A1.ACAD_SUB_PLAN AND A.EFFDT = A1.EFFDT AND (%CurrentDateIn <= a.SSR_LAST_PRS_DT OR a.SSR_LAST_PRS_DT IS NULL) AND a.effdt = ( SELECT MAX(effdt) FROM ps_ACAD_SUBPLN_TBL a2 WHERE a.institution = a2.institution AND a.acad_plan = a2.acad_plan AND a.acad_sub_plan = a2.acad_sub_plan AND a2.effdt <= %CurrentDateIn) AND a.eff_status <> 'I'

  • Related Language Record for SAD_PRS_SPLN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

    Prompt Table: INSTITUTION_TBL

    2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan field coming from campus solution system
    3 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic sub plan, a field together with program, plan, and sub plan to store student program information.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description