SEV_ID_MAINT_VW (SQL View)	Index Back
SEVIS ID Maintenance Record View for SEVIS ID Maintenance.

SEV_ID_MAINT_VW

(SQL View)

SEVIS ID Maintenance Record

View for SEVIS ID Maintenance.

SELECT EMPLID , SEV_SCHOOL_CD , SEV_PRG_NBR , EFFDT , SEV_ID , LASTUPDOPRID , LASTUPDDTTM FROM PS_SEV_ID_MAINT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

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 NOT NULL Effective Date
Default Value: %Date

5 SEV_ID Character(11) VARCHAR2(11) NOT NULL SEVIS ID

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

7 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 Prompt Table: PEOPLE_SRCH
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 NOT NULL	Effective Date Default Value: %Date
5	SEV_ID	Character(11)	VARCHAR2(11) NOT NULL	SEVIS ID
6	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.
7	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.