SEV_DOWNLD_SRCH

(SQL View)
 Index Back

SEVIS Download Results Search

Add operator SEVIS security to search record for viewing results of SEVIS batch processing.

SELECT A.SEV_EXT_BATCH_ID , B.OPRID , A.SEV_SCHOOL_CD , A.SEV_PRG_NBR , A.SEV_FILE_PROCESSED , A.SEV_UPLOAD_DTTM , A.SEV_DTTM FROM PS_SEV_DOWNLD_HDR A , PS_SEV_SCHLCD_SCTY B WHERE (EXISTS ( SELECT 'X' FROM PS_SEV_SCHLCD_SCTY B1 WHERE B1.ACCESS_CD = 'Y' AND (B1.SEV_SCHOOL_CD = A.SEV_SCHOOL_CD OR B1.SEV_SCHOOL_CD = 'ALL')) OR EXISTS ( SELECT 'X' FROM PS_SEV_PRG_SP_SCTY C WHERE C.ACCESS_CD = 'Y' AND (C.SEV_PRG_NBR = A.SEV_PRG_NBR OR C.SEV_PRG_NBR = 'ALL')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEV_EXT_BATCH_ID Character(14) VARCHAR2(14) NOT NULL SEVIS Extract Batch ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code

Prompt Table: SEV_SCH_SCTY_PR

4 SEV_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number

Prompt Table: SEV_PRG_SCTY_PR

5 SEV_FILE_PROCESSED Character(1) VARCHAR2(1) NOT NULL SEVIS File Processing Status
B=Processing Complete
B=Processed
E=Exported
P=Transaction Log Downloaded
U=Upload Acknowledged
6 SEV_UPLOAD_DTTM DateTime(26) TIMESTAMP SEVIS File Upload DateTime
7 SEV_DTTM DateTime(26) TIMESTAMP SEVIS Process DateTime