AV_VOL_ASGMT (SQL Table)	Index Back
Volunteer Asignment table This table holds information for a volunteer assigned to a Membership Organization.

AV_VOL_ASGMT

(SQL Table)

Volunteer Asignment table

This table holds information for a volunteer assigned to a Membership Organization.

Parent record: AV_VOL_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

3 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code

4 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID

5 VOL_GRP_NBR Number(9,0) DECIMAL(9) NOT NULL Volunteer Group

6 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

7 START_DT Date(10) DATE Start Date

8 END_DT Date(10) DATE end date

9 YRS_SERVICE Number(5,2) DECIMAL(4,2) NOT NULL Yrs of Service

10 ASGMT_TYPE Character(6) VARCHAR2(6) NOT NULL Assignment Type
Prompt Table: AV_ASGN_TYP_TBL

11 AREA_RSPNS Character(6) VARCHAR2(6) NOT NULL Area of Responsibility
Prompt Table: AV_ASGN_AR_VW

12 VOL_MGR_ID Character(11) VARCHAR2(11) NOT NULL Volunteer Mgr
Prompt Table: AV_STAFF_VOL_VW

13 EFF_RATING Character(1) VARCHAR2(1) NOT NULL Effectiveness Rating
E=Excellent
F=Fair
G=Good
P=Poor

14 ASGN_AGAIN Character(1) VARCHAR2(1) NOT NULL Assign Again
Y/N Table Edit
Default Value: N

15 PTNL_LEADER Character(1) VARCHAR2(1) NOT NULL Potential Leader
Y/N Table Edit
Default Value: N

16 FUTURE_DESCR Long Character CLOB Future

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code
3	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code
4	STAFF_ID	Character(11)	VARCHAR2(11) NOT NULL	Staff ID
5	VOL_GRP_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Volunteer Group
6	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
7	START_DT	Date(10)	DATE	Start Date
8	END_DT	Date(10)	DATE	end date
9	YRS_SERVICE	Number(5,2)	DECIMAL(4,2) NOT NULL	Yrs of Service
10	ASGMT_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Assignment Type Prompt Table: AV_ASGN_TYP_TBL
11	AREA_RSPNS	Character(6)	VARCHAR2(6) NOT NULL	Area of Responsibility Prompt Table: AV_ASGN_AR_VW
12	VOL_MGR_ID	Character(11)	VARCHAR2(11) NOT NULL	Volunteer Mgr Prompt Table: AV_STAFF_VOL_VW
13	EFF_RATING	Character(1)	VARCHAR2(1) NOT NULL	Effectiveness Rating E=Excellent F=Fair G=Good P=Poor
14	ASGN_AGAIN	Character(1)	VARCHAR2(1) NOT NULL	Assign Again Y/N Table Edit Default Value: N
15	PTNL_LEADER	Character(1)	VARCHAR2(1) NOT NULL	Potential Leader Y/N Table Edit Default Value: N
16	FUTURE_DESCR	Long Character	CLOB	Future