EOBF_QRY_LNG_VW

(SQL View)
 Index Back

Prompts used in queries

Prompts used in queries

SELECT EOBF_REPORT_ID ,EOBF_PART_ID ,EOBF_LNG_IND_FLG ,EOBF_QBIND_SEQNO ,EOBF_QRY_PROMPT ,RECNAME ,FIELDNAME ,SYSTEM_DATA_FLG ,CREATEDTTM ,LASTUPDDTTM ,LASTUPDOPRID FROM PS_EOBF_QRY_PROMPT WHERE EOBF_LNG_IND_FLG = '2'

  • Parent record: EOBF_QRY_NAME

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOBF_REPORT_ID Character(30) VARCHAR2(30) NOT NULL BAM Interactive Report ID
    2 EOBF_PART_ID Character(20) VARCHAR2(20) NOT NULL BAM Part ID for Import Map
    3 EOBF_LNG_IND_FLG Character(1) VARCHAR2(1) NOT NULL Language indicator flag
    4 EOBF_QBIND_SEQNO Number(3,0) SMALLINT NOT NULL Base Language Query Bind Variable Sequence Number
    5 EOBF_QRY_PROMPT Character(18) VARCHAR2(18) NOT NULL Query prompt field
    6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

    7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: RECFIELD_VW

    8 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data
    9 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    10 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.