AV_PLDG_E_SRCH

(SQL View)
 Index Back

Advancement People Search View

Common view used when searching for/selecting an organization for display/update. ----------------------------------------------------------------------------------------------------------------- Changed search field order to be consistent with the other search records - 22 Aug 2000. SELECT A.EXT_ORG_ID, C.SESSION_NO, C.GIFT_NO, C.SEQ_NO, B.INSTITUTION, B.OPRID, C.PLEDGE_DT, A.DESCR FROM PS_EXT_ORG_TBL A, PS_SCRTY_TBL_INST B, PS_AV_PLEDGE_DTL C WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N' ----------------------------------------------------------------------------------------------------------------- DD 2/4/00 Modify view for APRD => R-ACLARK-W26U6 OLD: SELECT A.EXT_ORG_ID, C.GIFT_NO, B.INSTITUTION, B.OPRID, C.PLEDGE_DT, A.DESCR FROM PS_EXT_ORG_TBL A, PS_SCRTY_TBL_INST B, PS_AV_PLEDGE_DTL C WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND B.ACCESS_CD = 'Y' AND C.ADJUSTMENT_FLG='N'

SELECT B.OPRID , B.INSTITUTION , A.EXT_ORG_ID , C.SESSION_NO , C.GIFT_NO , A.OTH_NAME_SORT_SRCH , A.DESCR , C.SEQ_NO , C.GIFT_AMT , C.PLEDGE_DT FROM PS_EXT_ORG_TBL A , PS_SCRTY_TBL_INST B , PS_AV_PLEDGE_DTL C , PS_AV_SESSION_TBL G WHERE B.INSTITUTION=C.INSTITUTION AND A.EXT_ORG_ID=C.EXT_ORG_ID AND %EffdtCheck(EXT_ORG_TBL E, A, %CurrentDateIn) 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: AVPLDGESRCHLNG

    • # 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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution

    Default Value: AV_OPR_DEF_TBL.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

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

    Prompt Table: AV_INST_E_SRCH

    4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number
    6 OTH_NAME_SORT_SRCH Character(50) VARCHAR2(50) NOT NULL Search Name
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    9 GIFT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Pledge Amount
    10 PLEDGE_DT Date(10) DATE First Payment Date