| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
|
| 3 |
EXPNUM |
Number(3,0) |
SMALLINT NOT NULL |
Expression Number
|
| 4 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
|
| 5 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 6 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 7 |
USECOUNT |
Number(3,0) |
SMALLINT NOT NULL |
Use Count
|
| 8 |
EXPRESSIONTEXT |
Long Character |
CLOB |
Expression Text
|