AVMBRACADVWLNG

(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

SELECT ACAD_GROUP ,LANGUAGE_CD , DESCR , DESCRSHORT FROM PS_ACAD_GROUP_LANG

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