AV_WSET_PRS_VW4

(SQL View)
 Index Back

Workset People/Class Yr Search

10/24/2003 8.9 Person Model Before: SELECT A.OPRID , A.WORKSET_CD , B.EMPLID , C.AV_CLASS_YR , C.INSTITUTION , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME , B.CITY , B.STATE , B.COUNTRY , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH FROM PS_AV_WORKSET_MBR A , PS_PERSONAL_DATA B , PS_AV_CLASS_YR C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID

SELECT A.OPRID , A.WORKSET_CD , B.EMPLID , D.AV_CLASS_YR , D.INSTITUTION , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME , C.CITY , C.STATE , C.COUNTRY , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH FROM PS_AV_WORKSET_MBR A , PS_HCR_PERSON_NM_I B , PS_SCC_PRI_ADDR_VW C , PS_AV_CLASS_YR D WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND %EffdtCheck( SCC_PRI_ADDR_VW C1, C, %CurrentDateIn) AND C.EMPLID = D.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 WORKSET_CD Character(10) VARCHAR2(10) NOT NULL Workset Code
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 AV_CLASS_YR Number(4,0) SMALLINT NOT NULL Class Year
5 INSTITUTION_SRCH Character(5) VARCHAR2(5) NOT NULL Institution
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
8 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 STATE Character(6) VARCHAR2(6) NOT NULL State
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
13 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name