RA_CM_ST_BU_VW

(SQL View)
 Index Back

Campaign Status BU View


SELECT DISTINCT %TrimSubstr(B.SETCNTRLVALUE, 1, 5) , A.RA_CMPGN_STATUS_CD , A.DESCR FROM PS_RA_UD_CPGN_STAT A , PS_SET_CNTRL_REC B WHERE B.SETID = A.SETID AND B.RECNAME = 'RA_UD_CPGN_STAT'

  • Related Language Record: RA_CM_ST_BU_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 RA_CMPGN_STATUS_CD Character(4) VARCHAR2(4) NOT NULL Valid Campaign and Wave Status Codes
    APPR=Approved
    ARCH=Archived
    CMPL=Completed
    DCLN=Declined
    EXEC=Executing
    IREV=In Review
    NEW=New
    STOP=Stop
    TRIG=Trigger Approved
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description