HCMD_CLASSIDHCMD_CLASSID2HCMD_ATTRIBID32=Ascending
68=Descending
OPRIDDefault Value: Y
HCMD_MDIS_TBL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCMD_CLASSID |
Character(12) | VARCHAR2(12) NOT NULL | EI_CLASSID |
| 2 | HCMD_CLASSID2 |
Character(12) | VARCHAR2(12) NOT NULL | Second EI_CLASSID field. |
| 3 | HCMD_ATTRIBID |
Character(30) | VARCHAR2(30) NOT NULL | Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor |
| 4 | EQRY_COL_POS | Number(3,0) | SMALLINT NOT NULL | Column position in output |
| 5 | EQRY_SORT_DIR | Character(3) | VARCHAR2(3) NOT NULL |
Sort Direction
32=Ascending 68=Descending |
| 6 | EQRY_ROW_LOCKED | Character(1) | VARCHAR2(1) NOT NULL | Is row locked? |
| 7 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | PRIVATE_QUERY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No Flag to indicate if its a private query
Default Value: Y |
| 9 | HCMD_USE_SUM | Character(1) | VARCHAR2(1) NOT NULL | Use Sum Aggregator |
| 10 | HCMD_USE_AVG | Character(1) | VARCHAR2(1) NOT NULL | Use Avg Aggregator |
| 11 | HCMD_USE_MIN | Character(1) | VARCHAR2(1) NOT NULL | Use Min Aggregator |
| 12 | HCMD_USE_MAX | Character(1) | VARCHAR2(1) NOT NULL | Use Max Aggregator |
| 13 | HCMD_USE_COUNT | Character(1) | VARCHAR2(1) NOT NULL | Use Count Aggregator |
| 14 | HCMD_USE_GROUPBY | Character(1) | VARCHAR2(1) NOT NULL | Use Groupe By |