EQRY_OUTPUT(SQL Table) |
Index Back |
|---|---|
Saved output column selectionsSaved output column selections |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EQRY_OUTPUT_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Output definition name |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | HCMD_CLASSID |
Character(12) | VARCHAR2(12) NOT NULL | EI_CLASSID |
| 4 | HCMD_ATTRIBID |
Character(30) | VARCHAR2(30) NOT NULL | Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor |
| 5 | EQRY_COL_POS | Number(3,0) | SMALLINT NOT NULL | Column position in output |
| 6 | EQRY_NAME | Character(20) | VARCHAR2(20) NOT NULL | Query Name |
| 7 | EQRY_SORT_DIR | Character(3) | VARCHAR2(3) NOT NULL |
Sort Direction
32=Ascending 68=Descending |
| 8 | EQRY_ROW_LOCKED | Character(1) | VARCHAR2(1) NOT NULL | Is row locked? |
| 9 | HCMD_USE_SUM | Character(1) | VARCHAR2(1) NOT NULL |
Use Sum Aggregator
Y/N Table Edit Default Value: N |
| 10 | HCMD_USE_AVG | Character(1) | VARCHAR2(1) NOT NULL |
Use Avg Aggregator
Y/N Table Edit Default Value: N |
| 11 | HCMD_USE_MIN | Character(1) | VARCHAR2(1) NOT NULL |
Use Min Aggregator
Y/N Table Edit Default Value: N |
| 12 | HCMD_USE_MAX | Character(1) | VARCHAR2(1) NOT NULL |
Use Max Aggregator
Y/N Table Edit Default Value: N |
| 13 | HCMD_USE_COUNT | Character(1) | VARCHAR2(1) NOT NULL |
Use Count Aggregator
Y/N Table Edit Default Value: N |
| 14 | HCMD_USE_GROUPBY | Character(1) | VARCHAR2(1) NOT NULL |
Use Groupe By
Y/N Table Edit Default Value: N |