AV_MEMBR_ANNUAL (SQL Table)	Index Back
Annual Membership Goals This is the Annual Membership Goals record.

AV_MEMBR_ANNUAL

(SQL Table)

Annual Membership Goals

This is the Annual Membership Goals record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
Prompt Table: AV_INTV_MEMB_VW

3 MEMBER_YEAR Character(2) VARCHAR2(2) NOT NULL Denotes which year of the Membership Initiative you are in.

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: AV_INTV_MEMB_VW.START_DT

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: AV_INSTALL_INST.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL

6 GOAL_AMT_YR Number(16,2) DECIMAL(15,2) NOT NULL Dollar Goal

7 GOAL_MBRSHP_CNT Number(9,0) DECIMAL(9) NOT NULL The number of memberships (hard membership credits only) that are expected to be generated by the end of this Membership year.

8 MBRSHP_PCT_INCREAS Number(6,2) DECIMAL(5,2) NOT NULL The percent increase for memberships from this membership year to the previous membership year.

9 GOAL_MEMBER_CNT Number(9,0) DECIMAL(9) NOT NULL The expected number of members (including all joint memberships) that the membership initiative will generate by the end of the membership year.

10 MBR_PCT_INCREASE Number(6,2) DECIMAL(5,2) NOT NULL The expected percent increase in the number of members from this membership year to the previous membership year.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	INTV_CD	Character(10)	VARCHAR2(10) NOT NULL	Initiative Code Prompt Table: AV_INTV_MEMB_VW
3	MEMBER_YEAR	Character(2)	VARCHAR2(2) NOT NULL	Denotes which year of the Membership Initiative you are in.
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: AV_INTV_MEMB_VW.START_DT
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: AV_INSTALL_INST.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL
6	GOAL_AMT_YR	Number(16,2)	DECIMAL(15,2) NOT NULL	Dollar Goal
7	GOAL_MBRSHP_CNT	Number(9,0)	DECIMAL(9) NOT NULL	The number of memberships (hard membership credits only) that are expected to be generated by the end of this Membership year.
8	MBRSHP_PCT_INCREAS	Number(6,2)	DECIMAL(5,2) NOT NULL	The percent increase for memberships from this membership year to the previous membership year.
9	GOAL_MEMBER_CNT	Number(9,0)	DECIMAL(9) NOT NULL	The expected number of members (including all joint memberships) that the membership initiative will generate by the end of the membership year.
10	MBR_PCT_INCREASE	Number(6,2)	DECIMAL(5,2) NOT NULL	The expected percent increase in the number of members from this membership year to the previous membership year.