SAE_ACADORG_VW

(SQL View)
 Index Back

Academic Organization View

Academic Organization View

SELECT ORG.ACAD_ORG ,ORG.DESCR ,ORG.INSTITUTION ,ORG.CAMPUS FROM %Table(ACAD_ORG_TBL) ORG WHERE ORG.EFF_STATUS = 'A' AND %EffdtCheck(ACAD_ORG_TBL ORG_E, ORG, %CurrentDateIn)

  • Related Language Record: SAE_ACADORGVWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    4 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL