RA_BSCRIPT_VW

(SQL View)
 Index Back

Marketing View into Scripts

Campaign Management view into scripts

SELECT SETID , SCRIPT_ID , EFFDT , SCRIPT_NAME , SCRIPT_TYPE , SCRIPT_CATEGORY FROM PS_RC_BSCRIPT A WHERE A.SCRIPT_TYPE IN('LEAD', 'CSAT', 'TELM') AND EFF_STATUS = 'A' AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_RC_BSCRIPT B WHERE A.SETID = B.SETID AND A.SCRIPT_ID = B.SCRIPT_ID AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: RA_BSCRIPT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 SCRIPT_ID Number(12,0) DECIMAL(12) NOT NULL Script ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SCRIPT_NAME Character(40) VARCHAR2(40) NOT NULL Branch Scripting Name Field
    5 SCRIPT_TYPE Character(4) VARCHAR2(4) NOT NULL Branch Scripting Type field
    CHRN=Churn
    CORD=Configure Order
    CQST=Contact Questionnaire
    CSAT=Customer Satisfaction
    GUID=Troubleshooting Guide
    LEAD=Lead Qualification
    PADV=Product Advisor
    PAPP=Product Application
    TELM=TeleSales
    6 SCRIPT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Branch Scripting Category Field
    B=Branch Script
    L=Linear Script