SEV_MST_REG (SQL Table)	Index Back
SEVIS Master - Registration

SEV_MST_REG

(SQL Table)

SEVIS Master - Registration

# 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 EFFDT Date(10) DATE Effective Date

5 SEV_EXT_BATCH_ID Character(14) VARCHAR2(14) NOT NULL SEVIS Extract Batch ID

6 SEV_EXT_REQUEST_ID Character(20) VARCHAR2(20) NOT NULL SEVIS Extract Request ID

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

8 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: TERM_VAL_TBL

9 SEV_CURR_SESS_ST Date(10) DATE Current Session Start Date

10 SESS_END_DT Date(10) DATE Session End Date

11 SESS_BEGIN_DT Date(10) DATE Session Beginning Date

12 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

13 START_DT Date(10) DATE Start Date

14 END_DT Date(10) DATE end date

15 SEV_LAST_SESSION Character(1) VARCHAR2(1) NOT NULL Last Session
Y/N Table Edit
Default Value: N

16 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	EFFDT	Date(10)	DATE	Effective Date
5	SEV_EXT_BATCH_ID	Character(14)	VARCHAR2(14) NOT NULL	SEVIS Extract Batch ID
6	SEV_EXT_REQUEST_ID	Character(20)	VARCHAR2(20) NOT NULL	SEVIS Extract Request ID
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
8	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_VAL_TBL
9	SEV_CURR_SESS_ST	Date(10)	DATE	Current Session Start Date
10	SESS_END_DT	Date(10)	DATE	Session End Date
11	SESS_BEGIN_DT	Date(10)	DATE	Session Beginning Date
12	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
13	START_DT	Date(10)	DATE	Start Date
14	END_DT	Date(10)	DATE	end date
15	SEV_LAST_SESSION	Character(1)	VARCHAR2(1) NOT NULL	Last Session Y/N Table Edit Default Value: N
16	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.