AV_AL_MBR_CH_VW (SQL View)	Index Back
Alumni Member Alumni Member - Use this view to determine if a constituent is an alumni member. This view utilizes the institutionally define membership organization to determine if a person is an alumni member.

AV_AL_MBR_CH_VW

(SQL View)

Alumni Member

Alumni Member - Use this view to determine if a constituent is an alumni member. This view utilizes the institutionally define membership organization to determine if a person is an alumni member.

SELECT A.INSTITUTION , A.EMPLID , A.AV_MBR_ORG_COD , 'Y' FROM PS_AV_MEMBERSHIP A , PS_AV_INSTALL_INST B WHERE A.INSTITUTION = B.INSTITUTION AND A.AV_MBR_ORG_COD = B.AV_MBR_ORG_COD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

4 ALUMNI_MBR_FLG Character(1) VARCHAR2(1) NOT NULL Alumni Member
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	AV_MBR_ORG_COD	Character(10)	VARCHAR2(10) NOT NULL	Member Organization Code
4	ALUMNI_MBR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Alumni Member Y/N Table Edit Default Value: N