EQTN_SQL_TBL (SQL Table)	Index Back
Equation Proc Callable Sql Equation Processor Callable Sql object.

EQTN_SQL_TBL

(SQL Table)

Equation Proc Callable Sql

Equation Processor Callable Sql object.

Related Language Record: EQTN_SQL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EQTN_OPERAND_SQL Character(30) VARCHAR2(30) NOT NULL Equation Processor SQL that can be called. This sqlid will dovetail into potential merging with the sqlid field of tools 8.

2 EFFDT Date(10) DATE Effective Date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

5 SCC_DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type code indicates whether a row of data is system data, demo data, or customer data.
C=Customer Data
D=Demonstration Data
S=System Data
Default Value: C

6 EQTN_SQL_TEXT Long Character CLOB Equation Processor Callable SQL Text. This should be able to fold into tools 8's sql_text field.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EQTN_OPERAND_SQL	Character(30)	VARCHAR2(30) NOT NULL	Equation Processor SQL that can be called. This sqlid will dovetail into potential merging with the sqlid field of tools 8.
2	EFFDT	Date(10)	DATE	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	SCC_DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type code indicates whether a row of data is system data, demo data, or customer data. C=Customer Data D=Demonstration Data S=System Data Default Value: C
6	EQTN_SQL_TEXT	Long Character	CLOB	Equation Processor Callable SQL Text. This should be able to fold into tools 8's sql_text field.