SEV_MST_ADD_IVW (SQL View)	Index Back
Inactive SEV_MST_ADDR

SEV_MST_ADD_IVW

(SQL View)

Inactive SEV_MST_ADDR

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

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