| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CUSTOM_STMT_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Custom Statement Name
|
| 2 |
PA_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 3 |
STMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
SQL Statement Type
B=Boolean
F=Function
O=Operation
|
| 4 |
KEYWORD |
Character(8) |
VARCHAR2(8) NOT NULL |
Keyword
Prompt Table:
PA_CUSTOM3
|
| 5 |
OPERAND1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Operand1
Prompt Table:
%CUSTM_OPER1
|
| 6 |
OPERAND2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Operand2
Prompt Table:
%CUSTM_OPER2
|
| 7 |
OPERAND3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Operand3
Prompt Table:
%CUSTM_TEMP_TBL
|
| 8 |
OPERAND1_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand1 History Ind
Y/N Table Edit
Default Value: N
|
| 9 |
OPERAND2_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand2 History
Y/N Table Edit
Default Value: N
|
| 10 |
OPERAND3_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand3 History
Y/N Table Edit
Default Value: N
|
| 11 |
OPERAND1_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand date flag
Y/N Table Edit
Default Value: N
|
| 12 |
OPERAND2_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand2 date flag
Y/N Table Edit
Default Value: N
|
| 13 |
OPERAND3_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand3 date flag
Y/N Table Edit
Default Value: N
|
| 14 |
OPERATOR1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Operator1
*=multiply - operation
+=add - operation
-=minus - operation
/=divide - operation
<=less than - boolean
<==less than or equal - boolean
<>=not equal - boolean
===equal - boolean
>=greater than - boolean
>==greater than or equal - boolea
^=exponentiation - operation
|
| 15 |
OPERATOR2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Operator2
*=multiply - operation
+=add - operation
-=minus - operation
/=divide - operation
==assign to - operation
AN=and conjunction - boolean
OR=or conjunction - boolean
^=exponentiation - operation
|
| 16 |
OPERAND1_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand1 type
|
| 17 |
OPERAND2_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand2 type
|
| 18 |
OPERAND3_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Operand3 type
|
| 19 |
OPERAND1_CHAR |
Character(40) |
VARCHAR2(40) NOT NULL |
Operand1 character
|
| 20 |
OPERAND2_CHAR |
Character(40) |
VARCHAR2(40) NOT NULL |
Operand2 character
|
| 21 |
OPERAND3_CHAR |
Character(40) |
VARCHAR2(40) NOT NULL |
Operand3 character
|
| 22 |
OPERAND1_DEC |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Operand1 decimal
|
| 23 |
OPERAND2_DEC |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Operand2 decimal
|
| 24 |
OPERAND1_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Operand plan
|
| 25 |
OPERAND2_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Operand2 Plan
|
| 26 |
OPERAND3_DEC |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Operand3 decimal
|
| 27 |
OPERAND1_DATE |
Date(10) |
DATE |
Operand1 date
|
| 28 |
OPERAND2_DATE |
Date(10) |
DATE |
Operand2 date
|
| 29 |
OPERAND3_DATE |
Date(10) |
DATE |
Operand3 date
|
| 30 |
OPERAND1_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Operand1 sequence
|
| 31 |
OPERAND2_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Operand2 sequence
|
| 32 |
OPERAND3_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Operand3 sequence
|
| 33 |
OPERAND1_ALSTYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Operand1 alias type
|
| 34 |
OPERAND2_ALSTYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Operand2 Alias Type
|
| 35 |
OPERAND3_ALSTYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Operand3 Alias type
|
| 36 |
OPERAND1_PIC |
Character(10) |
VARCHAR2(10) NOT NULL |
Operand1 Picture
|
| 37 |
OPERAND2_PIC |
Character(10) |
VARCHAR2(10) NOT NULL |
Operand2 Picture
|
| 38 |
OPERAND3_PIC |
Character(10) |
VARCHAR2(10) NOT NULL |
Operand3 Picture
|