AV_INSTSCRTYLNG

(SQL View)
 Index Back

Institution Table Scrty

Displays all institutions, with the prompt button prompting against only those institutions for which security is enabled.

SELECT INSTITUTION , EFFDT ,LANGUAGE_CD , DESCR , DESCRSHORT , DESCRFORMAL FROM PS_INSTITUTION_LNG

  • Related Language Record for AV_INST_SCRTY

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

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: INSTITUTION_TBL.DESCR

    6 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field

    Default Value: INSTITUTION_TBL.DESCR