AV_CRIT_PERS_VW (SQL View)	Index Back
Person Criteria View This view captures Audience Selection Criteria for Persons

AV_CRIT_PERS_VW

(SQL View)

Person Criteria View

This view captures Audience Selection Criteria for Persons

SELECT INSTITUTION, AV_MBR_CRIT_TYP, AV_AUDIENCE, AV_APPROVED FROM PS_AV_AUDIENCE_TBL WHERE AV_MBR_CRIT_TYP='P' AND AV_APPROVED='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTION_TBL

2 AV_MBR_CRIT_TYP Character(1) VARCHAR2(1) NOT NULL This field is used to capture the type of Membership Criteria the user is setting up. It will identify whether to search for Person (people) or Organization (businesses).
B=Both
O=Organization
P=Person
Default Value: P

3 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code

4 AV_APPROVED Character(1) VARCHAR2(1) NOT NULL Approved

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTION_TBL
2	AV_MBR_CRIT_TYP	Character(1)	VARCHAR2(1) NOT NULL	This field is used to capture the type of Membership Criteria the user is setting up. It will identify whether to search for Person (people) or Organization (businesses). B=Both O=Organization P=Person Default Value: P
3	AV_AUDIENCE	Character(10)	VARCHAR2(10) NOT NULL	Audience Code
4	AV_APPROVED	Character(1)	VARCHAR2(1) NOT NULL	Approved