AV_WSET_PRS_VW2

(SQL View)
 Index Back

Workset People/Cnst/Yr Search

10/24/2003 8.9 Person Model Before: SELECT A.OPRID , A.WORKSET_CD , B.EMPLID , C.CNST_TYPE , C.INSTITUTION , D.AV_CLASS_YR , D.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_CNST_TYP_TBL C , PS_AV_CLASS_YR D WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPLID = D.EMPLID

SELECT A.OPRID , A.WORKSET_CD , B.EMPLID , D.CNST_TYPE , D.INSTITUTION , E.AV_CLASS_YR , E.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_CNST_TYP_TBL D , PS_AV_CLASS_YR E WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND %EffdtCheck( SCC_PRI_ADDR_VW C1, C, %CurrentDateIn) AND C.EMPLID = D.EMPLID AND D.EMPLID = E.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 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
5 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
6 AV_CLASS_YR Number(4,0) SMALLINT NOT NULL Class Year
7 INSTITUTION_SRCH Character(5) VARCHAR2(5) NOT NULL Institution
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
11 CITY Character(30) VARCHAR2(30) NOT NULL City
12 STATE Character(6) VARCHAR2(6) NOT NULL State
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
14 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
15 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name