GM_IN_ADDR_VW

(SQL View)
 Index Back

Institution Address


SELECT A.SETID ,A.INSTID , A.LOCATION , A.PROPOSAL_FLAG , A.EMAILID , B.PHONE , B.FAX FROM PS_LOCATION_TBL B , PS_GM_IN_ADDRESS A WHERE A.PROPOSAL_FLAG='Y' AND A.EFFDT=( SELECT MAX(M.EFFDT) FROM PS_GM_IN_ADDRESS M WHERE M.SETID=A.SETID AND M.INSTID=A.INSTID AND M.LOCATION = A.LOCATION AND M.EFFDT <= %CurrentDateIn ) AND B.SETID=A.SETID AND B.LOCATION=A.LOCATION AND B.EFFDT=( SELECT MAX(C.EFFDT) FROM PS_LOCATION_TBL C WHERE C.SETID=B.SETID AND C.LOCATION=B.LOCATION AND C.EFFDT<=A.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 INSTID Character(5) VARCHAR2(5) NOT NULL Institution ID

Prompt Table: GM_INSTITUTION

3 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

4 PROPOSAL_FLAG Character(1) VARCHAR2(1) NOT NULL Proposal Location

Y/N Table Edit

5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
6 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
7 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number