EOBF_QRY_NAME (SQL Table)	Index Back
Queries used in report Queries used in report

EOBF_QRY_NAME

(SQL Table)

Queries used in report

# 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_QMAP_SEQNO Number(3,0) SMALLINT NOT NULL Map Sequence

4 EOBF_PARTID_DESCR Character(80) VARCHAR2(80) NOT NULL Description of BAM part ID

5 EOBF_QRY_NAME Character(30) VARCHAR2(30) NOT NULL Query name for base language
Prompt Table: EOBF_QRYDEFN_VW

6 EOBF_QRY_NAME_LNG Character(30) VARCHAR2(30) NOT NULL Query name for related language
Prompt Table: EOBF_QRYDEFN_VW

7 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data

8 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

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

10 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_QMAP_SEQNO	Number(3,0)	SMALLINT NOT NULL	Map Sequence
4	EOBF_PARTID_DESCR	Character(80)	VARCHAR2(80) NOT NULL	Description of BAM part ID
5	EOBF_QRY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Query name for base language Prompt Table: EOBF_QRYDEFN_VW
6	EOBF_QRY_NAME_LNG	Character(30)	VARCHAR2(30) NOT NULL	Query name for related language Prompt Table: EOBF_QRYDEFN_VW
7	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Data
8	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
9	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.
10	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.