RC_QUESTION

(SQL Table)
 Index Back

Branch Scripting

CRM Common Object Branch Scripting Question Table

  • Related Language Record: RC_QUESTION_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 RC_WEIGHT Number(8,0) INTEGER NOT NULL Branch Scripting Number field
    5 QUESTION_DESC Character(254) VARCHAR2(254) NOT NULL Question
    6 QUESTION_GUIDE Character(254) VARCHAR2(254) NOT NULL Question Hint
    7 RC_ANSWERSET_ID Number(12,0) DECIMAL(12) NOT NULL Answer Set ID for Branch Scripting

    Prompt Table: RC_ANSWERSET_VW

    8 SCR_VAR_ID Number(12,0) DECIMAL(12) NOT NULL Branch Scripting Value Field

    Prompt Table: RC_VARIABLE

    9 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    10 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    11 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    12 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    13 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    14 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time