SEV_PRG_SEL_VW

(SQL View)
 Index Back

SEVIS Selct School - ID Maint


SELECT A.EMPLID , B.SEV_PRG_NBR , C.OPRID , C.ACCESS_CD FROM PS_SCC_PERS_SA_VW A , PS_SEV_PRG_SP_TBL B , PS_SEV_PRG_SP_SCTY C WHERE C.ACCESS_CD = 'Y' AND (C.SEV_PRG_NBR = B.SEV_PRG_NBR OR C.SEV_PRG_NBR = 'ALL') AND ( EXISTS ( SELECT 'X' FROM PS_DS2019_FORM X WHERE X.EMPLID = A.EMPLID AND X.SEV_PRG_NBR = B.SEV_PRG_NBR) OR EXISTS ( SELECT 'X' FROM PS_DS2019_DEP Y WHERE Y.SEV_DEP_EMPLID = A.EMPLID AND Y.SEV_PRG_NBR = B.SEV_PRG_NBR))

# 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_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number
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