RF_SCRIPTS_VW

(SQL View)
Index Back

All Trouble-shooting guide

Returns all branch scripts that have the type of Trouble-shooting guide.

SELECT A.SETID , A.SCRIPT_ID , A.SCRIPT_NAME , A.SCRIPT_TYPE , A.DESCRLONG FROM PS_RC_BSCRIPT A WHERE A.SCRIPT_TYPE='GUID' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RC_BSCRIPT B WHERE B.SETID = A.SETID AND B.SCRIPT_ID = A.SCRIPT_ID AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: RF_SCRIPTS_LVW
  • # 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.
    2 SCRIPT_ID Number(12,0) DECIMAL(12) NOT NULL Script ID
    3 SCRIPT_NAME Character(40) VARCHAR2(40) NOT NULL Branch Scripting Name Field
    4 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
    5 DESCRLONG Long Character CLOB Long Description