AV_VOL_ASGN_CAF

#	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	SCC_CAF_ATTR_SEQ	Number(4,0)	SMALLINT NOT NULL	Attribute Sequence
10	SCC_CAF_ATTRIB_NM	Character(20)	VARCHAR2(20) NOT NULL	Common Attribute Prompt Table: %EDITTABLE18
11	SCC_CAF_ATTR_VAL	Character(20)	VARCHAR2(20) NOT NULL	Attribute Value
12	SCC_CAF_ATTR_NVAL	Number(32,11)	DECIMAL(31,11) NOT NULL	Numeric Value
13	SCC_CAF_ATTR_DVAL	Date(10)	DATE	Date Value
14	SCC_CAF_ATTR_TVAL	Character(50)	VARCHAR2(50) NOT NULL	Text Value
15	SCC_CAF_ATTR_TIME	Time(15)	TIMESTAMP	Time Value
16	SCC_CAF_ATTR_YNO	Character(1)	VARCHAR2(1) NOT NULL	Yes/No Value Y/N Table Edit
17	SCC_CAF_ATTR_LVAL	Long Character	CLOB	Long Text Value