AV_ORG_ALUM_CNT

(SQL View)
Index Back

Alumni Count

Alumni Count

SELECT INSTITUTION , EXT_ORG_ID , CNST_TYPE , COUNT (DISTINCT EMPLID) FROM PS_AV_ORG_ALUM_ALL GROUP BY INSTITUTION , EXT_ORG_ID , CNST_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
3 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
4 ALUMNI_FRIEND_CNT Number(6,0) INTEGER NOT NULL Alumni Count