AV_RECOG_SEC_VW

(SQL View)
 Index Back

Recogntion by Des BU

Recognition by designation business unit for queries secured by Business Unit.

SELECT A.AV_DES_BU , A.EMPLID , A.EXT_ORG_ID , A.RECOGNITION_TYPE , A.BUSINESS_UNIT , A.SESSION_NO , A.GIFT_NO , A.CURRENCY_CD , C.GIFT_AMT , SUM(A.RCG_DES_AMT) , %Round(SUM(%DecMult(%DecDiv(A.RCG_DES_AMT , C.GIFT_AMT) , 100 )) , 4 ) FROM PS_AV_RCG_DES A , PS_AV_SESSION_TBL B , PS_AV_GIFT_DTL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SESSION_NO = B.SESSION_NO AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SESSION_NO = C.SESSION_NO AND A.GIFT_NO = C.GIFT_NO AND C.GIFT_AMT > 0 GROUP BY A.BUSINESS_UNIT,A.SESSION_NO,A.GIFT_NO,A.AV_DES_BU,A.EMPLID,A.EXT_ORG_ID,A.RECOGNITION_TYPE, A.CURRENCY_CD, C.GIFT_AMT

  • Parent record: AV_GIFT_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AV_DES_BU Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: AV_PEOPLE_SRCH

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

    Prompt Table: AV_EXT_ORG_SRCH

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

    Default Value: H

    Prompt Table: AV_RCG_TYPE_TBL

    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    6 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr

    Prompt Table: AV_SESSION_TBL

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

    Prompt Table: AV_GIFT_DTL

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

    Default Value: AV_SESSION_TBL.CURRENCY_CD

    9 GIFT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Gift Amount
    10 RCG_PCT_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount
    11 RECOGNITION_PCT Number(8,4) DECIMAL(7,4) NOT NULL Recognition Pct

    Default Value: 100