SEV_REV_REG

#	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 Default Value: 1
6	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
7	SEV_CURR_SESS_ST	Date(10)	DATE	Current Session Start Date
8	SESS_END_DT	Date(10)	DATE	Session End Date
9	SESS_BEGIN_DT	Date(10)	DATE	Session Beginning Date
10	SEV_AUTH_REASON	Character(2)	VARCHAR2(2) NOT NULL	SEVIS Authorization Reason ** KEEP in synch with SEV_AUTH_NEWREASON 01=Illness or Medical Condition 02=Initial Difficulty w/ English 03=Initial Difficulty-Reading Rqm 04=Unfamiliarity-US Teaching Mthd 05=Improper Crse Level Placement 06=To Complete Crse Study in Term 07=Part Time Commuter Student
11	START_DT	Date(10)	DATE	Start Date
12	END_DT	Date(10)	DATE	end date
13	SEV_AUTH_NEWREASON	Character(2)	VARCHAR2(2) NOT NULL	SEVIS New Authorization Reason ** KEEP in synch with SEV_AUTH_REASON 01=Illness or Medical Condition 02=Initial Difficulty w/ English 03=Initial Difficulty-Reading Rqm 04=Unfamiliarity-US Teaching Mthd 05=Improper Crse Level Placement 06=To Complete Crse Study in Term 07=Part Time Commuter Student
14	START_DATE_OVRD	Date(10)	DATE	Start Date Ovrd for Mass Retro
15	END_DATE_OVRD	Date(10)	DATE	End Date Ovrd for Mass Retro
16	UNT_TERM_TOT	Number(9,3)	DECIMAL(8,3) NOT NULL	Total Term Units
17	UNT_TAKEN_PRGRSS	Number(9,3)	DECIMAL(8,3) NOT NULL	Units Taken for Progress
18	SEV_EXCP_UNT_CHAR	Character(9)	VARCHAR2(9) NOT NULL	Full Course Override Units
19	SEV_LAST_SESSION	Character(1)	VARCHAR2(1) NOT NULL	Last Session Y/N Table Edit Default Value: N