AV_ASSIGNEDE_VW

(SQL View)
 Index Back

Assigned View

Use AV_ASSIGNED_VW to relate displayed to emplid or ext org id to determine if the constituent has any resource assignments.

SELECT B.INSTITUTION, A.EXT_ORG_ID, 'Y' FROM PS_EXT_ORG_TBL A, PS_INSTITUTION_TBL B WHERE (A.EXT_ORG_ID IN (SELECT C.EXT_ORG_ID FROM PS_AV_ASGN_STAFF C WHERE C.INSTITUTION=B.INSTITUTION) OR A.EXT_ORG_ID IN (SELECT D.EXT_ORG_ID FROM PS_AV_ASGN_VOL D WHERE D.INSTITUTION=B.INSTITUTION) OR A.EXT_ORG_ID IN (SELECT E.EXT_ORG_ID FROM PS_AV_ASGN_UNIT E WHERE E.INSTITUTION=B.INSTITUTION))

# 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 ASSIGNED_FLG Character(1) VARCHAR2(1) NOT NULL Assigned

Y/N Table Edit