AV_PL_SECE_SRCH

(SQL View)
 Index Back

AV Org Pldg Search VW Secured

Common view used when searching for/selecting an organization that has active pledges for display/update. Derived from AV_PLDG_E_SRCH, this view incorporates a join to the BU Security table for Business Unit Security. It is assigned to the component AV_PLDG_SCHD_ADJ_E by the Security App Engine Process.

SELECT B.OPRID ,C.BUSINESS_UNIT , A.EXT_ORG_ID , C.SESSION_NO , C.GIFT_NO , B.INSTITUTION , C.SEQ_NO , C.PLEDGE_DT , A.DESCR FROM PS_EXT_ORG_TBL A , PS_SCRTY_TBL_INST B , PS_AV_PLEDGE_DTL C , PS_AV_SCRTY_BU_TBL D , PS_AV_SESSION_TBL G WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND B.OPRID = D.OPRID AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N' AND C.BUSINESS_UNIT = G.BUSINESS_UNIT AND C.SESSION_NO = G.SESSION_NO AND G.SESS_STATUS = 'P'

  • Related Language Record: AVPLSECESRCHLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: AV_OPR_DEF_TBL.BUSINESS_UNIT

    Prompt Table: AV_BU_SCRTY_VW

    3 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Prompt Table: EXT_ORG_TBL

    4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Prompt Table: AV_PLDG3_SRCH

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

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    7 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    8 PLEDGE_DT Date(10) DATE First Payment Date
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description