AV_MEMBR_ANNL_G (SQL Table)	Index Back
Annual Membership Sub Goals Membership Goals based on Type and Status.

AV_MEMBR_ANNL_G

(SQL Table)

Annual Membership Sub Goals

Membership Goals based on Type and Status.

# 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.
Prompt Table: AV_MEMBR_ANNUAL

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

5 AV_MBRSHP_TYP Character(15) VARCHAR2(15) NOT NULL Membership Type
Prompt Table: AV_MBR_TYP_TBL

6 AV_MBRSHP_STATUS Character(4) VARCHAR2(4) NOT NULL Membership status. Indicates whether the memberships are expected to be received from New, Lapsed, Rejoins, or other institution-defined categories.
LPSD=Lapsed
NEW=New
RJNS=Rejoins

7 MBRSHP_TYP_AMT Number(16,2) DECIMAL(15,2) NOT NULL Indicates the dues revenue that is expected to be received from the target group of the Membership Type.

8 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.

#	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. Prompt Table: AV_MEMBR_ANNUAL
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: AV_INTV_MEMB_VW.START_DT
5	AV_MBRSHP_TYP	Character(15)	VARCHAR2(15) NOT NULL	Membership Type Prompt Table: AV_MBR_TYP_TBL
6	AV_MBRSHP_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Membership status. Indicates whether the memberships are expected to be received from New, Lapsed, Rejoins, or other institution-defined categories. LPSD=Lapsed NEW=New RJNS=Rejoins
7	MBRSHP_TYP_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	Indicates the dues revenue that is expected to be received from the target group of the Membership Type.
8	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.