CA_WC_UNAMT_VW

(SQL View)
 Index Back

Grants Post Award

This is used in Contracts Workcenter to show the Posted Budget Amount <> Billing Limit exception.

SELECT HDR.CONTRACT_NUM , HDR.BUSINESS_UNIT , HDR.DESCR , HDR.CONTRACT_TYPE , AWD.REF_AWD_NUMBER , POS.RESOURCE_AMOUNT , FND.RESOURCE_AMOUNT , LMT.LIMIT_AMT_BIL , HDR.CURRENCY_CD , HDR.BILL_TO_CUST_ID , CUST.NAME1 , AWD.POST_ADMIN , HDR.CONTRACT_ADMIN , PER.NAME FROM PS_CA_CONTR_HDR HDR , PS_GM_AWARD AWD LEFT OUTER JOIN ( SELECT PER.EMPLID , PER.NAME FROM PS_PERS_DATA_EFFDT PER WHERE PER.EFFDT = ( SELECT MAX(PER1.EFFDT) FROM PS_PERS_DATA_EFFDT PER1 WHERE PER.EMPLID = PER1.EMPLID AND PER1.EFFDT <= %CurrentDateIn)) PER ON (PER.EMPLID = AWD.POST_ADMIN), PS_CA_WC_POSBUD_VW POS , PS_CA_WC_LMTAMT_VW LMT, PS_CA_WC_FNDBUD_VW FND, PS_CUSTOMER CUST , PS_SET_CNTRL_GROUP GRP WHERE HDR.CONTRACT_NUM = AWD.CONTRACT_NUM AND HDR.CONTRACT_NUM = POS.CONTRACT_NUM AND HDR.CONTRACT_NUM = LMT.CONTRACT_NUM AND HDR.CONTRACT_NUM = FND.CONTRACT_NUM AND POS.CONTRACT_NUM = AWD.CONTRACT_NUM AND POS.CONTRACT_NUM = LMT.CONTRACT_NUM AND POS.CONTRACT_NUM = FND.CONTRACT_NUM AND LMT.CONTRACT_NUM = AWD.CONTRACT_NUM AND LMT.CONTRACT_NUM = FND.CONTRACT_NUM AND AWD.CONTRACT_NUM = FND.CONTRACT_NUM AND POS.RESOURCE_AMOUNT <> LMT.LIMIT_AMT_BIL AND HDR.CA_PROC_STATUS ='A' AND HDR.BILL_TO_CUST_ID = CUST.CUST_ID AND HDR.BUSINESS_UNIT = GRP.SETCNTRLVALUE AND GRP.REC_GROUP_ID = 'FS_23' AND GRP.SETID = CUST.SETID

  • Related Language Record: CA_WC_UNAMT_LVW

  • Parent Record Of CA_WC_GMBUD_LVW CA_WC_GM_BUD_VW

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

    Prompt Table: SP_BU_CA_NONVW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type

    Prompt Table: CA_TYPE_TBL

    5 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number
    6 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
    7 RESOURCE_AMOUNT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
    8 LIMIT_AMT_BIL Signed Number(28,3) DECIMAL(26,3) NOT NULL Funded/Billing Limit Amount
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

    Prompt Table: CA_BILL_TO_VW

    11 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    12 POST_ADMIN Character(11) VARCHAR2(11) NOT NULL Post Award Administrator

    Prompt Table: GM_ELIG_ADM_VW

    13 CONTRACT_ADMIN Character(40) VARCHAR2(40) NOT NULL Contract Administrator defined on CABU.

    Prompt Table: MEMBER_VW

    14 NAME Character(50) VARCHAR2(50) NOT NULL Name