EOQF_RECIPIENT_IDEOQF_SRCH_FLDNAMEN=No
Y=Yes
Prompt Table: PSRECDEFNPVW
Prompt Table: EOQF_FLDNM_VW
N=No
Y=Yes
EOQF_PRMPT_TBL(SQL Table) |
Index Back |
|---|---|
Recipient List Search Prompt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOQF_RECIPIENT_ID |
Character(30) | VARCHAR2(30) NOT NULL | Recipient List ID |
| 2 | EOQF_SRCH_FLDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 3 | FIELDLABEL | Character(60) | VARCHAR2(60) NOT NULL | Field Label |
| 4 | EOQF_ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
Enable
N=No Y=Yes |
| 5 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFNPVW |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EOQF_FLDNM_VW |
| 7 | EOQF_ORD_QST | Number(3,0) | SMALLINT NOT NULL | Question order |
| 8 | EOQF_USE_PROMPT | Character(1) | VARCHAR2(1) NOT NULL |
Use as prompt
N=No Y=Yes |