EOQF_EVENT_TBL

(SQL Table)
 Index Back

Event Configuration

Questionnaire Framework Event Configuration Table

  • Related Language Record: EOQF_EVENT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOQF_EVENT_ID Character(30) VARCHAR2(30) NOT NULL Questionnaire Event Framework
    2 EOQF_EVENT_TYPE Character(1) VARCHAR2(1) NOT NULL Questionnaire Event Framework
    C=Continuous
    S=Single
    3 EOQF_EVENT_STATUS Character(1) VARCHAR2(1) NOT NULL Questionnaire Event Framework
    A=Active
    C=Canceled
    D=Draft
    E=Expired
    I=Inactive

    Default Value: D

    4 EOQF_EVENT_NAME Character(50) VARCHAR2(50) NOT NULL Questionnaire Event Framework
    5 EOQF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Field

    Prompt Table: EOQF_CAT_VW

    6 EOQF_QSTNR_CODE Character(30) VARCHAR2(30) NOT NULL Questionnaire Code

    Prompt Table: EOQF_QSTNR_VW

    7 EOQF_EVENT_DESCR Long Character(5000) CLOB Questionnaire Event Framework
    8 EOQF_START_DATE Date(10) DATE Questionnaire Event Framework
    9 EOQF_END_DATE Date(10) DATE Questionnaire Event Framework
    10 EOQF_QUEST_EXPIRES Number(3,0) SMALLINT NOT NULL Questionnaire Event Framework
    11 EOQF_RECIPIENT_ID Character(30) VARCHAR2(30) NOT NULL Recipient List ID

    Prompt Table: %EDITTABLE

    12 EOQF_NC_FLAG Character(1) VARCHAR2(1) NOT NULL Notif Composer flag
    13 EOQF_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    14 EOQF_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    15 EOQF_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    16 EOQF_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id