AV_MBR_ACAD_VW

(SQL View)
Index Back

Academic Group Table View

Use Academic Group Table to record information about the high level organizational entities in your academic organization. An Academic Group typically equates to "college", but can encompass non-college entities such as "Continuing Education". Normally there is a one-to-one correspondence between the entries found in the Academic Group table and the entries contained in the "College" level of the Academic Organization Tree. This view is used to populate the Valid Values field on the Membership Criteria panel.

SELECT ACAD_GROUP, DESCR, DESCRSHORT FROM PS_ACAD_GROUP_TBL

  • Related Language Record: AVMBRACADVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AV_VALID_VALUE Character(15) VARCHAR2(15) NOT NULL Valid Value
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description