AV_INST_SCRTY2

(SQL View)
Index Back

Institution Table Security Vw

Prompt view of the Institution Table which enforces institutional security by operator and defaults the users institution.

select a.institution ,b.oprid ,a.effdt ,a.eff_status ,a.descr ,b.access_cd from PS_INSTITUTION_TBL a ,ps_scrty_tbl_inst b where b.access_cd = 'Y' and b.institution = a.institution

  • Related Language Record: AVINSTSCRTY2LNG
  • # 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN_SRCH

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    Y=Read/Write Access