AV_INST_SCRTY

(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, EFF_STATUS, DESCR, DESCRSHORT, DESCRFORMAL, CAMPUS FROM PS_INSTITUTION_TBL

  • Related Language Record: AV_INSTSCRTYLNG

    • # 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    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

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

    Prompt Table: CAMPUS_TBL