RY_DRE_CTL

(SQL Table)
 Index Back

Dialog response run control

Run control table to export dialog response raw data.

  • Related Language Record: RY_DRE_CTL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RY_DRE_REPORT_ID Character(30) VARCHAR2(30) NOT NULL Dialog response export report id. This field is used to identify the export report that is been created by the user.
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RA_NONVW

    5 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

    Prompt Table: RY_DRE_DLG_VW

    6 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    7 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID

    Prompt Table: RY_DRE_AUD_VW

    8 RY_DRE_STATUS Character(4) VARCHAR2(4) NOT NULL List the status of the dialog response export.
    010=In Design
    020=Processing
    030=Generated
    040=Failed

    Default Value: 010

    9 START_DT Date(10) DATE Start date field to store start date value.
    10 END_DT Date(10) DATE This field stores the end date values.
    11 PROCESS_INST Character(15) VARCHAR2(15) NOT NULL Process Instance
    12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    14 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
    15 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    16 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File