AV_VOL_ASGN_TBL (SQL Table)	Index Back
Volunteer Asignment tbl This table holds all Volunteer Asignment information. 5/4/01 - Added EFFDT as a descending key.

AV_VOL_ASGN_TBL

(SQL Table)

Volunteer Asignment tbl

This table holds all Volunteer Asignment information. 5/4/01 - Added EFFDT as a descending key.

# 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 VOL_GRP_NBR Number(9,0) DECIMAL(9) NOT NULL Volunteer Group

5 EFFDT Date(10) DATE Effective Date

6 VOL_STRCT_NBR Number(9,0) DECIMAL(9) NOT NULL Volunteer Structure Nbr

7 VOL_NBR Number(6,0) INTEGER NOT NULL Volunteer Nbr

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

9 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID
Prompt Table: AV_STAFF_VOL_VW

10 START_DT Date(10) DATE NOT NULL Start Date

11 END_DT Date(10) DATE end date

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

#	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	VOL_GRP_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Volunteer Group
5	EFFDT	Date(10)	DATE	Effective Date
6	VOL_STRCT_NBR	Number(9,0)	DECIMAL(9) NOT NULL	Volunteer Structure Nbr
7	VOL_NBR	Number(6,0)	INTEGER NOT NULL	Volunteer Nbr
8	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
9	STAFF_ID	Character(11)	VARCHAR2(11) NOT NULL	Staff ID Prompt Table: AV_STAFF_VOL_VW
10	START_DT	Date(10)	DATE NOT NULL	Start Date
11	END_DT	Date(10)	DATE	end date
12	YRS_SERVICE	Number(5,2)	DECIMAL(4,2) NOT NULL	Yrs of Service