AV_ADJ_RCG_VW

(SQL View)
 Index Back

Adjusted Recognitions View

Contains all recognition records for adjusted gifts and pledges 7.26.00 SELECT INSTITUTION, SESSION_NO, GIFT_NO, SEQ_NO, EMPLID, EXT_ORG_ID, RECOGNITION_TYPE, RECOGNITION_PCT, RCG_PCT_AMT, SA_ID_TYPE, PEOPLE_RELATION, CNST_TYPE, ALUMNUS_TYPE, ANONYMOUS_FLG FROM PS_AV_ADJ_RECOG

SELECT BUSINESS_UNIT, SESSION_NO, GIFT_NO, SEQ_NO, EMPLID, EXT_ORG_ID, RECOGNITION_TYPE, RECOGNITION_PCT, RCG_PCT_AMT, SA_ID_TYPE, PEOPLE_RELATION, CNST_TYPE, ALUMNUS_TYPE, ANONYMOUS_FLG, INSTITUTION FROM PS_AV_ADJ_RECOG

  • Parent record: AV_ADJ_GIFT_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: AV_INST_BU_VW

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

    Prompt Table: AV_SESSION_TBL

    3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr

    Prompt Table: AV_GIFT_DTL

    4 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

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

    Prompt Table: AV_EXT_ORG_SRCH

    7 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type

    Prompt Table: AV_RCG_TYPE_TBL

    8 RECOGNITION_PCT Number(8,4) DECIMAL(7,4) NOT NULL Recognition Pct
    9 RCG_PCT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    10 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    11 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    12 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
    13 ALUMNUS_TYPE Character(1) VARCHAR2(1) NOT NULL Alumnus Type
    G=Graduate
    N=Non-Degree
    U=Undergraduate
    14 ANONYMOUS_FLG Character(1) VARCHAR2(1) NOT NULL Anonymous

    Y/N Table Edit

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

    Prompt Table: INSTITUTN_SCRTY