EQTN_GLOBAL_VAR (SQL Table)	Index Back
Equation Global Variables Equation Processor Global Variable Array

EQTN_GLOBAL_VAR

(SQL Table)

Equation Global Variables

Equation Processor Global Variable Array

# 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 NOT NULL Effective Date

3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 EQTN_OPERAND_GLB Character(100) VARCHAR2(100) NOT NULL Equation Processor Operand Global Variable Name.

5 EQTN_GLOBAL_TYPE Character(4) VARCHAR2(4) NOT NULL Equation Processor Global Variable Datatype
D=Date
N=Number
S=String

6 EQTN_OPERAND_NUM Signed Number(33,10) DECIMAL(31,10) NOT NULL Equation Operand Number.

7 EQTN_OPERAND_STR Character(128) VARCHAR2(128) NOT NULL Equation Operand String.

8 EQTN_OPERAND_DT Date(10) DATE Equation Operand Date

#	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 NOT NULL	Effective Date
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	EQTN_OPERAND_GLB	Character(100)	VARCHAR2(100) NOT NULL	Equation Processor Operand Global Variable Name.
5	EQTN_GLOBAL_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Equation Processor Global Variable Datatype D=Date N=Number S=String
6	EQTN_OPERAND_NUM	Signed Number(33,10)	DECIMAL(31,10) NOT NULL	Equation Operand Number.
7	EQTN_OPERAND_STR	Character(128)	VARCHAR2(128) NOT NULL	Equation Operand String.
8	EQTN_OPERAND_DT	Date(10)	DATE	Equation Operand Date