AV_ADJ_RCGDS_VW

(SQL View)
 Index Back

Adjust Recog/Desig View

Adjustment view for all records on the recognition/designation cross table. 7.24.00 SELECT INSTITUTION, SESSION_NO, GIFT_NO, SEQ_NO, EMPLID, EXT_ORG_ID, RECOGNITION_TYPE, DESIGNATION, INTV_CD, SA_ID_TYPE, RCG_DES_AMT, CURRENCY_CD, AV_SESS_TYPE, GIFT_DT, STATUS, FISCAL_YEAR, CAE_GIFT_TYPE, CNST_TYPE, ALUMNUS_TYPE, MOTIVATION_CD, CHARITABLE_AMT, AV_CASE_TYPE, AV_CASE_PRPS, GIFT_TYPE, PLEDGE_GIFT_NO, CAE_RE_FLG, ANONYMOUS_FLG FROM PS_AV_ADJ_RCG_DES

SELECT BUSINESS_UNIT, SESSION_NO, GIFT_NO, SEQ_NO, EMPLID, EXT_ORG_ID, RECOGNITION_TYPE, DESIGNATION, INTV_CD, SA_ID_TYPE, RCG_DES_AMT, CURRENCY_CD, AV_SESS_TYPE, GIFT_DT, STATUS, FISCAL_YEAR, CAE_GIFT_TYPE, CNST_TYPE, ALUMNUS_TYPE, MOTIVATION_CD, CHARITABLE_AMT, AV_CASE_TYPE, AV_CASE_PRPS, GIFT_TYPE, PLEDGE_GIFT_NO, CAE_RE_FLG, ANONYMOUS_FLG, INSTITUTION FROM PS_AV_ADJ_RCG_DES

  • Parent record: AV_ADJ_RECOG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    3 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
    4 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    7 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
    8 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
    9 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
    10 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person
    11 RCG_DES_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    13 AV_SESS_TYPE Character(2) VARCHAR2(2) NOT NULL Session Type
    AG=Gift Adjustment
    AM=Adjust Membership
    AP=Pledge Adjustment
    G=Gift
    M=Membership
    PL=Pledge
    14 GIFT_DT Date(10) DATE Gift Date
    15 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    16 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    17 CAE_GIFT_TYPE Character(1) VARCHAR2(1) NOT NULL CAE Type
    D=Deferred Gift
    E=Deferred Estate Gift
    G=Gift
    K=Gift In Kind
    N=Non-Gift
    18 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
    19 ALUMNUS_TYPE Character(1) VARCHAR2(1) NOT NULL Alumnus Type
    G=Graduate
    N=Non-Degree
    U=Undergraduate
    20 MOTIVATION_CD Character(9) VARCHAR2(9) NOT NULL Appeal Code
    21 CHARITABLE_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Charitable Amount
    22 AV_CASE_TYPE Character(4) VARCHAR2(4) NOT NULL CASE Type
    C=Current Unrestricted
    E=Endowment & Similar
    L=Loan Funds
    N=Non-Gift
    P=Plant Funds
    R=Current Restricted
    23 AV_CASE_PRPS Character(4) VARCHAR2(4) NOT NULL CASE Purpose
    A=Financial Aid
    B=Land & Buildings
    C=Chairs
    E=Equipment
    F=Faculty/Staff Compen
    J=Student Projects
    L=Library
    M=Academic Divisions
    N=Non-Gift
    O=Other Restricted Purposes
    P=Prizes
    R=Research
    S=Special Programs
    T=Athletics
    U=Unrestricted
    X=Public Service & Ext
    24 GIFT_TYPE Character(6) VARCHAR2(6) NOT NULL Gift Type
    25 PLEDGE_GIFT_NO Character(11) VARCHAR2(11) NOT NULL Pledge Number
    26 CAE_RE_FLG Character(1) VARCHAR2(1) NOT NULL CAE Real Estate
    27 ANONYMOUS_FLG Character(1) VARCHAR2(1) NOT NULL Anonymous

    Y/N Table Edit

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