EOBF_QRY_NAME(SQL Table) | 
Index Back | 
|---|---|
Queries used in reportQueries used in report | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | BAM Interactive Report ID | |
| 2 | 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 | This Y/ N field is used to identify which rows in a table are considered 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. |