| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
INQUIRY |
Character(10) |
VARCHAR2(10) NOT NULL |
Inquiry Name
|
| 3 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|
| 4 |
LOGICAL_OPERATOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Logical operators for selection criteria
AND=AND
OR=OR
|
| 5 |
KK_INQ_AMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in commitment control inquiries.
0=Budget
1=Expense or Recognized Revenue
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
6=Available
7=Available Budget
8=Allocated Amount
|
| 6 |
RELATIONL_OPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
Relational operators for selection criteria
<=less than
<==less than or equal to
<>=not equal to
==equal to
>=greater than
>==greater than or equal to
|
| 7 |
KK_INQ_AMT_TYPE2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in commitment control inquiries.
0=Budget
1=Expense or Recognized Revenue
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
6=Available
7=Available Budget
8=1
Default Value: 8
|
| 8 |
ARITHMETC_OPERATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Arithmetic Operator
+=Plus
-=Minus
Default Value: *
|
| 9 |
MULTIPLIER |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Multiplier
|