SEV_MST_BIO_IV2 (SQL View)	Index Back
Inactive SEV_MST_BIO

SEV_MST_BIO_IV2

(SQL View)

Inactive SEV_MST_BIO

SELECT a.EMPLID , a.SEV_SCHOOL_CD , a.LASTUPDOPRID , a.LASTUPDDTTM FROM PS_SEV_MST_BIO a WHERE a.EFF_STATUS = 'I' AND a.LASTUPDDTTM = ( SELECT MAX(a1.LASTUPDDTTM) FROM PS_SEV_MST_BIO 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 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.

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