OPRIDQRYNAMEEXPNUMPSQRYEXPR |
| PeopleSoft Field Name | Field Type | Description |
|---|---|---|
| OPRID | VARCHAR2(30) NOT NULL | A user's ID |
| QRYNAME | VARCHAR2(30) NOT NULL | Query Name |
| EXPNUM | SMALLINT NOT NULL | Expression Number |
| FIELDTYPE | SMALLINT NOT NULL | Field Type |
| LENGTH | INTEGER NOT NULL | Length |
| DECIMALPOS | SMALLINT NOT NULL | Decimal Positions |
| USECOUNT | SMALLINT NOT NULL | Use Count |
| EXPRESSIONTEXT | LONG VARCHAR | Expression Text |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 06 February 2013 |