SEV_HST_REG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee 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_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	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number Default Value: 1
7	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
8	SEV_CURR_SESS_ST	Date(10)	DATE	Current Session Start Date
9	SESS_END_DT	Date(10)	DATE	Session End Date
10	SESS_BEGIN_DT	Date(10)	DATE	Session Beginning Date
11	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
12	START_DT	Date(10)	DATE	Start Date
13	END_DT	Date(10)	DATE	end date
14	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
15	START_DATE_OVRD	Date(10)	DATE	Start Date Ovrd for Mass Retro
16	END_DATE_OVRD	Date(10)	DATE	End Date Ovrd for Mass Retro
17	SEV_LAST_SESSION	Character(1)	VARCHAR2(1) NOT NULL	Last Session Y/N Table Edit Default Value: N