QCKADMINSTVWLNG

(SQL View)
 Index Back

Institution-Admit Security Vw

Prompt view of the Institution Table and Quick Admit Temp table which enforces institutional security by operator.

SELECT DISTINCT a.institution ,b.oprid ,a.effdt ,a.language_cd ,a.descr FROM ps_institution_lng a ,PS_SCRTY_TBL_INST b ,ps_qck_adm_temp c WHERE b.access_cd = 'Y' AND b.institution = a.institution AND a.institution = c.institution

  • Related Language Record for QCK_ADM_INST_VW

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

    Prompt Table: INSTITUTION_TBL

    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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