SEV_DOWNLD_HDR

#	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	SEV_SCHOOL_CD	Character(15)	VARCHAR2(15) NOT NULL	SEVIS School Code
3	SEV_PRG_NBR	Character(9)	VARCHAR2(9) NOT NULL	SEVIS Program Number
4	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
5	SEV_BATCH_SYSTEM	Character(30)	VARCHAR2(30) NOT NULL	SEVIS Batch system from which this transaction log was requested by the user and generated by the application. This is an optional attribute which may contain PROD, ALPHA, BETA, etc.
6	SEV_UPLOAD_DTTM	DateTime(26)	TIMESTAMP	SEVIS File Upload DateTime
7	SEV_UPLOAD_ERROR	Character(5)	VARCHAR2(5) NOT NULL	File Upload Result/Error Code
8	SEV_FILE_ACCEPTED	Character(1)	VARCHAR2(1) NOT NULL	File Accepted 0=File Not Accepted 1=File Accepted
9	SEV_DTTM	DateTime(26)	TIMESTAMP	SEVIS Process DateTime
10	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
11	SEV_FILE_ERROR	Character(5)	VARCHAR2(5) NOT NULL	SEVIS File Upload Error Prompt Table: SEV_FILE_ERROR
12	SEV_FILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SEVIS File Upload Status 0=Unsuccessful 1=Successful
13	SEV_VALID_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SEVIS File Validation Status 0=No Pass 1=Pass
14	SEV_DOWN_ERROR	Character(5)	VARCHAR2(5) NOT NULL	Result/Code error of download.
15	SEV_RECORD_NBR	Number(5,0)	INTEGER NOT NULL	SEVIS Records Requested for Process
16	SEV_SUCCESS_NBR	Number(5,0)	INTEGER NOT NULL	SEVIS Records Successfully Processed
17	SEV_FAILURE_NBR	Number(5,0)	INTEGER NOT NULL	SEVIS Records Failed to Process