EQTXTBWRISECLNG (SQL View)	Index Back
Equation Table Write Security Equation Data Table Record name Write Authority Security Related Language View

EQTXTBWRISECLNG

(SQL View)

Equation Table Write Security

Equation Data Table Record name Write Authority Security Related Language View

SELECT A.EQTN_TB_AUTH_CLASS ,A.EQTN_DATA_RECNAME ,B.LANGUAGE_CD ,B.DESCR FROM PS_EQTN_TB_RECAUTH A , PS_EQTNDATAVWLNG B WHERE A.EQTN_AUTH_LEVEL = 'W' AND A.EQTN_DATA_RECNAME = B.EQTN_DATA_RECNAME

Related Language Record for EQTX_TB_WRI_SEC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EQTN_TB_AUTH_CLASS Character(30) VARCHAR2(30) NOT NULL Equation Table Authorization Class

2 EQTN_DATA_RECNAME Character(15) VARCHAR2(15) NOT NULL Equation Processor Data Record Name.

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EQTN_TB_AUTH_CLASS	Character(30)	VARCHAR2(30) NOT NULL	Equation Table Authorization Class
2	EQTN_DATA_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Equation Processor Data Record Name.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description