SEV_SCHL_SEL_VW

(SQL View)
 Index Back

SEVIS Selct School - ID Maint


SELECT A.EMPLID , B.SEV_SCHOOL_CD , C.OPRID , C.ACCESS_CD FROM PS_SCC_PERS_SA_VW A , PS_SEV_SCHL_CD_TBL B , PS_SEV_SCHLCD_SCTY C WHERE C.ACCESS_CD = 'Y' AND (C.SEV_SCHOOL_CD = B.SEV_SCHOOL_CD OR C.SEV_SCHOOL_CD = 'ALL') AND ( EXISTS ( SELECT 'X' FROM PS_I20_FORM X WHERE X.EMPLID = A.EMPLID AND X.SEV_SCHOOL_CD = B.SEV_SCHOOL_CD) OR EXISTS ( SELECT 'X' FROM PS_SEV_I20_DEP Y WHERE Y.SEV_DEP_EMPLID = A.EMPLID AND Y.SEV_SCHOOL_CD = B.SEV_SCHOOL_CD))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access