ACADSUBPSFVW2LN

(SQL View)
 Index Back

Rel Lang -Academic Sub Plan Vw

ACADSUBPSFVW2LN is the language record related view to ACAD_SUBP_SFVW2. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT a.institution , a.acad_plan , a.acad_sub_plan , a.language_cd , a.descr FROM PS_ACAD_SUBPLN_LNG a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_ACAD_SUBPLN_LNG b WHERE b.institution = a.institution AND b.acad_plan = a.acad_plan AND b.acad_sub_plan = a.acad_sub_plan AND b.effdt <= %CurrentDateIn)

  • Related Language Record for ACAD_SUBP_SFVW2

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

    Prompt Table: INSTITUTION_TBL

    2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    3 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description