EOBF_QRY_BAS_VW (SQL View)	Index Back
Prompts used in queries Prompts used in queries

EOBF_QRY_BAS_VW

(SQL View)

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 = '1'

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.

#	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.