GM_INST_LVW

(SQL View)
Index Back

Grants Institution VIEW

Grants Institution VIEW without the SETID

SELECT INSTID , LANGUAGE_CD , DESCR , ORG_LEG_NAME , DESCRSHORT FROM PS_GM_INST_LNG

  • Related Language Record for GM_INST_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ORG_LEG_NAME Character(60) VARCHAR2(60) NOT NULL Organization Legal Name
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description