CA_RNW_SCH_VW

(SQL View)
 Index Back

CA-Renewal Package

PSIRS-KK This tables stores the high level information about a Renewal Package.

SELECT A.BUSINESS_UNIT , A.TARGET_CONTRACT , A.RNW_PKG_ID , A.DESCR , A.RNW_PKG_STATUS , B.SOLD_TO_CUST_ID , C.NAME1 , A.CURRENT_CYCLE_NBR FROM PS_CA_RNW_PKG A , PS_CA_CONTR_HDR B ,PS_CUSTOMER C , PS_SET_CNTRL_GROUP D WHERE A.TARGET_CONTRACT = B.CONTRACT_NUM AND B.SOLD_TO_CUST_ID = C.CUST_ID AND C.SETID = D.SETID AND D.REC_GROUP_ID = ( SELECT REC_GROUP_ID FROM PS_REC_GROUP_REC WHERE RECNAME = 'CUSTOMER') AND D.SETCNTRLVALUE=B.BUSINESS_UNIT

  • Related Language Record: CA_RNW_SCH_LANG

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

    Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT

    Prompt Table: SP_BU_CA_NONVW

    2 TARGET_CONTRACT Character(25) VARCHAR2(25) NOT NULL PSIRS-KK
    3 RNW_PKG_ID Character(10) VARCHAR2(10) NOT NULL PSIRS-KK

    Default Value: NEXT

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 RNW_PKG_STATUS Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
    CAN=Canceled
    PND=Pending
    PRG=In Progress

    Default Value: PND

    6 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

    Prompt Table: CUST_SLD_VW

    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    8 CURRENT_CYCLE_NBR Number(6,0) INTEGER NOT NULL PSIRS-KK