SEV_SCH_SCTY_PR

(SQL View)
 Index Back

Security Prompt for School Cd

Prompt view which enforces operator security by School Code. It lists the School Codes that the operator is cleared to see.

SELECT a.sev_school_cd ,b.oprid ,a.sev_descr ,b.access_cd FROM PS_SEV_SCHL_CD_TBL a ,ps_sev_schlcd_scty b WHERE b.access_cd = 'Y' AND a.sev_school_cd = b.sev_school_cd OR (b.sev_school_cd = 'ALL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 SEV_DESCR Character(30) VARCHAR2(30) NOT NULL SEVIS Description
4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access