BUSINESS_UNITQS_APP_CONTEXTQSX_NAMEQS_SEQPrompt Table: %EDITTABLE18
<>=<>
===
ALL=ALL
BTWN=BETWEEN
LIKE=LIKE
Default Value: ALL
QS_QSX_TFLDS(SQL Table) |
Index Back |
|---|---|
Data extraction trace fldsDate Initials Issue # Description 101006 KBM 1572902004 Prompt table enabled for Trace fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | QS_APP_CONTEXT |
Character(18) | VARCHAR2(18) NOT NULL | QC application context identifier |
| 3 | QSX_NAME |
Character(24) | VARCHAR2(24) NOT NULL | Extraction Name |
| 4 | QS_SEQ |
Number(5,0) | INTEGER NOT NULL | Generic sequence number |
| 5 | QS_FIELD_COMP_NAME | Character(18) | VARCHAR2(18) NOT NULL | QC application structure field component |
| 6 | QS_FIELD_VALUE | Character(40) | VARCHAR2(40) NOT NULL |
Generic field for trace value input
Prompt Table: %EDITTABLE18 |
| 7 | QS_FIELD_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
Field selection operator
<>=<> === ALL=ALL BTWN=BETWEEN LIKE=LIKE Default Value: ALL |