SEV_REV_EMD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEV_SCHOOL_CD	Character(15)	VARCHAR2(15) NOT NULL	SEVIS School Code
2	SEV_PRG_NBR	Character(9)	VARCHAR2(9) NOT NULL	SEVIS Program Number
3	SEV_BATCH_ID	Character(14)	VARCHAR2(14) NOT NULL	SEVIS Compare Batch ID
4	SEV_EVENT_NBR	Number(5,0)	INTEGER NOT NULL	SEVIS Alert Detail Number
5	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
6	SEV_EMPL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	SEVIS Employment Type 01=Optional Practical Training 02=Curricular Practical Training 03=Off-Campus
7	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
8	SEQUENCE_NUMBER	Number(2,0)	SMALLINT NOT NULL	Sequence Number
9	SEV_EMPLOYER_NAME	Character(254)	VARCHAR2(254) NOT NULL	Supervisor First Name
10	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
11	END_DATE	Date(10)	DATE	End Date
12	SEV_EXT_EMPLOYER	Character(1)	VARCHAR2(1) NOT NULL	Supervisor First Name
13	SEV_PRV_START_DT	Date(10)	DATE	SEVIS 6.0 - Previous OPT Start Date
14	SEV_PRV_EMP_NAME	Character(254)	VARCHAR2(254) NOT NULL	Supervisor First Name
15	SEV_ADDRESS1	Character(60)	VARCHAR2(60) NOT NULL	SEVIS Address 1
16	SEV_ADDRESS2	Character(60)	VARCHAR2(60) NOT NULL	SEVIS Address 2
17	US_CITY	Character(60)	VARCHAR2(60) NOT NULL	City
18	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
19	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
20	SEV_USADR_EXPCD	Character(2)	VARCHAR2(2) NOT NULL	SEVIS Explanation Code OB=Campus business address OH=Campus housing address OM=Campus mailing address ON=New mailing address OO=Other override OP=New physical address
21	SEV_USADR_EXPTX	Character(200)	VARCHAR2(200) NOT NULL	SEVIS Explanation Code
22	SEV_EMPL_CODE	Character(2)	VARCHAR2(2) NOT NULL	SEVIS Employment Code 01=Full Time 02=Part Time
23	SEV_EMPL_EIN	Character(9)	VARCHAR2(9) NOT NULL	Employer Identification Number
24	SEV_JOB_TITLE	Character(64)	VARCHAR2(64) NOT NULL	Job Title
25	SEV_CRSE_REL	Long Character(1000)	VARCHAR2(1000)	Course Relevance
26	SEV_SELF_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Self Employed
27	SEV_SPVR_FNAME	Character(80)	VARCHAR2(80) NOT NULL	Supervisor First Name
28	SEV_SPVR_LNAME	Character(40)	VARCHAR2(40) NOT NULL	Supervisor Last Name
29	SEV_PHONE	Number(10,0)	DECIMAL(10) NOT NULL	Sevis Phone
30	SEV_SPVR_EXT	Number(8,0)	INTEGER NOT NULL	Supervisor Phone Ext
31	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address