AV_RECOG_P_VW

(SQL View)
 Index Back

Posted Recognition View

All recognition fields for posted recogntion records only.

SELECT A.BUSINESS_UNIT , A.SESSION_NO , A.GIFT_NO , A.EMPLID , A.EXT_ORG_ID , A.RECOGNITION_TYPE , A.RECOGNITION_PCT , A.RCG_PCT_AMT , A.SA_ID_TYPE , A.RCG_APPLIED , A.PEOPLE_RELATION , A.ORG_RELATION , A.PE_RELATION , A.CNST_TYPE , A.ALUMNUS_TYPE , A.ANONYMOUS_FLG , A.CURRENCY_CD , A.CURRENCY_CD_ENTRY , A.RCG_PCT_AMT_ENTRY , A.INSTITUTION FROM PS_AV_RECOGNITION A , PS_AV_SESSION_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND B.SESS_STATUS = 'P'

  • Parent record: AV_GIFT_DTL

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

    Default Value: AV_SESSION_TBL.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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

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

    Prompt Table: AV_EXT_ORG_SRCH

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

    Default Value: H

    Prompt Table: AV_RCG_TYPE_TBL

    7 RECOGNITION_PCT Number(8,4) DECIMAL(7,4) NOT NULL Recognition Pct

    Default Value: 100

    8 RCG_PCT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    9 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
    O=Organization
    P=Person

    Default Value: P

    10 RCG_APPLIED Number(16,2) DECIMAL(15,2) NOT NULL Recognition Applied
    11 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    12 ORG_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    BR=Branch
    CF=Corporate Foundation
    PC=Parent Company
    SS=Subsidiary
    13 PE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
    14 CNST_TYPE Number(3,0) SMALLINT NOT NULL Constituent Type
    15 ALUMNUS_TYPE Character(1) VARCHAR2(1) NOT NULL Alumnus Type
    G=Graduate
    N=Non-Degree
    U=Undergraduate
    16 ANONYMOUS_FLG Character(1) VARCHAR2(1) NOT NULL Anonymous

    Y/N Table Edit

    Default Value: N

    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_SESSION_TBL.CURRENCY_CD

    18 CURRENCY_CD_ENTRY Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: AV_SESSION_TBL.CURRENCY_CD_ENTRY

    19 RCG_PCT_AMT_ENTRY Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    20 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: AV_SESSION_TBL.INSTITUTION