AV_VOL_ASGN_VW

(SQL View)
Index Back

Vol. assigned - people & orgs

Returns all the volunteers assigned (whether they are assigned to people or organizations ).

SELECT DISTINCT A.INSTITUTION , A.STAFF_ID , B.NAME , B.LAST_NAME_SRCH FROM PS_AV_ASGN_VOL_PRP A , PS_HCR_PERSON_NM_I B WHERE A.STAFF_ID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID

Prompt Table: AV_STAFF_VOL_VW

3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name