| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EQUATION_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Equation Name
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 3 |
EQTN_PCODE_ROWID |
Number(8,0) |
INTEGER NOT NULL |
Pseudocode Row Id. Update key for Equation Processor compiler output file.
|
| 4 |
EQTN_PCODE_INSTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Equation Processor Pseudocode Instructions.
ADD=Add
AND=And
CALL=Call
DEL=Delete
DIV=Divide
EXST=Exists
FIND=Find
GET=Get
HALT=Halt
INS=Insert
ISEQ=Is Equal
ISGT=Is Greater
ISLT=Is Less
JUMP=Jump
MSG=Message
MULT=Multiply
NEGA=Negate
NOT=Not
OR=Or
POP=Pop
PUSH=Push
REST=Restore
RETN=Return
SAVE=Save
STOR=Store
SUBT=Subtract
UPD=Update
|
| 5 |
EQTN_OPERAND_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Equation Operand Type.
D=Date
E=Equation
F=Field
G=Global Variable
KGEQ=Keyed Global Equal
KGGE=Keyed Global Greater Equal
KGGT=Keyed Global Greater
KLEQ=Keyed Local Equal
KLGE=Keyed Local Greater Equal
KLGT=Keyed Local Greater
L=Local Variable
N=Number
PCOD=Pseudo Code
S=String
SQL=SQL
SRCE=Source Code
T=Table
V=Prompted Value
X=External Subroutine
|
| 6 |
EQTN_OPERAND_STR |
Character(128) |
VARCHAR2(128) NOT NULL |
Equation Operand String.
|
| 7 |
EQTN_OPERAND_NUM |
Signed Number(33,10) |
DECIMAL(31,10) NOT NULL |
Equation Operand Number.
|
| 8 |
EQTN_OPERAND_DT |
Date(10) |
DATE |
Equation Operand Date
|
| 9 |
EQTN_ROW_ID |
Number(8,0) |
INTEGER NOT NULL |
Equation Row Id to uniquely identify inserted rows. This is not the sequence in which the rows are to appear.
|