SEV_HST_EVENT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: I20_EMPLID_VW
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_BATCH_ID	Character(14)	VARCHAR2(14) NOT NULL	SEVIS Compare Batch ID
5	SEV_EVENT_NBR	Number(5,0)	INTEGER NOT NULL	SEVIS Alert Detail Number
6	SEV_EVENT_DT	Date(10)	DATE	SEVIS Event Date
7	SEV_EVENT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	SEVIS Event Type Prompt Table: SEV_EVENT_TYPE
8	SEV_ALERT_ERROR	Character(1)	VARCHAR2(1) NOT NULL	SEVIS Alert Error Y/N Table Edit Default Value: N
9	SEV_ALERT_ADD_DATA	Character(1)	VARCHAR2(1) NOT NULL	SEVIS Additional Data N=No Additional Data R=Required Additional Data Y=Optional Additional Data Default Value: N
10	SEV_PRINT_FORM	Character(1)	VARCHAR2(1) NOT NULL	SEVIS Print Form Y/N Table Edit Default Value: Y
11	SEV_EXTRACT	Character(1)	VARCHAR2(1) NOT NULL	SEVIS Extract M=Master Synch N=None Y=Send to SEVIS Default Value: N
12	SEV_DSO_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	SEVIS School Official Emplid
13	SEV_RO_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Responsible Officer
14	SEV_EXT_BATCH_ID	Character(14)	VARCHAR2(14) NOT NULL	SEVIS Extract Batch ID
15	SEV_EXT_REQUEST_ID	Character(20)	VARCHAR2(20) NOT NULL	SEVIS Extract Request ID
16	SEV_ID	Character(11)	VARCHAR2(11) NOT NULL	SEVIS ID
17	SEV_PROCESS_DTTM	DateTime(26)	TIMESTAMP	SEVIS Process DateTime
18	SEV_FILE_ERROR	Character(5)	VARCHAR2(5) NOT NULL	SEVIS File Upload Error
19	SEV_FILE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SEVIS File Upload Status 0=Unsuccessful 1=Successful
20	SEV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	SEVIS Status A=Active C=Cancelled D=Deactivated F=Draft I=Initial L=Invalid N=No Show P=Completed T=Terminated V=Inactive
21	SEV_CHANGE_LVL_YN	Character(1)	VARCHAR2(1) NOT NULL	Change Level Occurred Y/N Table Edit
22	SEV_REMARKS	Long Character(500)	VARCHAR2(500)	Remarks