RC_QUES_SRCH_VW

(SQL View)
 Index Back

Branch Scripting

CRM Common Object Branch Scripting View

SELECT QUESTION_ID , QUESTION_TYPE , RC_QUESTION_NAME , %Substring(QUESTION_DESC , 1, 60) FROM PS_RC_QUESTION

  • Related Language Record: RC_QUES_SRH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 QUESTION_ID Number(12,0) DECIMAL(12) NOT NULL Used in CRM branch script

    Default Value: 999999999999

    2 QUESTION_TYPE Character(1) VARCHAR2(1) NOT NULL Question Type for CRM Branch Script I: Guide Information V: Value input S: Single Selection M: Multiple selection
    I=Guide Information
    M=Multiple Selection
    S=Single Selection
    V=Value Input

    Default Value: S

    3 RC_QUESTION_NAME Character(30) VARCHAR2(30) NOT NULL Question Name work field............
    4 QUESTION_DESC Character(254) VARCHAR2(254) NOT NULL Question