SEV_MST_REG_VW (SQL View)	Index Back
Last Updated SEV_MST_REG

SEV_MST_REG_VW

(SQL View)

Last Updated SEV_MST_REG

SELECT A.EMPLID , A.SEV_SCHOOL_CD , A.SEV_PRG_NBR , A.EFFDT , A.SEV_EXT_BATCH_ID , A.SEV_EXT_REQUEST_ID , A.EFF_STATUS , A.STRM , A.SESS_END_DT , A.SESS_BEGIN_DT , A.SEV_AUTH_REASON , A.START_DT , A.END_DT , A.LASTUPDOPRID , A.LASTUPDDTTM FROM PS_SEV_MST_REG A WHERE A.LASTUPDDTTM = ( SELECT MAX(A1.LASTUPDDTTM) FROM PS_SEV_MST_REG A1 WHERE A1.EMPLID = A.EMPLID AND A1.SEV_SCHOOL_CD = A.SEV_SCHOOL_CD AND A1.SEV_PRG_NBR = A.SEV_PRG_NBR)

# 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 AS_OF_DATE Date(10) DATE As of 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

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 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.

15 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	AS_OF_DATE	Date(10)	DATE	As of 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
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	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.
15	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.