AV_VOL_MIN_VW (SQL View)	Index Back
Volunteer Min St-dt asgn view This view grabs the min start-dt from the AV_VOL_ASGMT table.

AV_VOL_MIN_VW

(SQL View)

Volunteer Min St-dt asgn view

This view grabs the min start-dt from the AV_VOL_ASGMT table.

SELECT INSTITUTION, STAFF_ID, MIN(START_DT) FROM PS_AV_VOL_ASGMT GROUP BY INSTITUTION, STAFF_ID

# 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

3 START_DT Date(10) DATE Start Date

#	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
3	START_DT	Date(10)	DATE	Start Date