AV_GIFT_DTL_VW3

(SQL View)
 Index Back

Update Gift Entry


SELECT B.OPRID ,A.BUSINESS_UNIT ,A.INSTITUTION ,A.SESSION_NO ,A.GIFT_NO ,A.EMPLID ,A.EXT_ORG_ID FROM PS_AV_GIFT_DTL A ,PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.AV_SESS_TYPE = 'G' AND B.SESS_STATUS = 'O'

  • Parent record: AV_SESSION_TBL

    • # 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_BUS_UNIT_TBL

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

    Default Value: AV_BUS_UNIT_TBL.INSTITUTION

    4 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_SESS_OG_VW

    5 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID