SP_DLG_RY_OPR_L (SQL View)	Index Back
Related language table Used as related language table for the Dialog validation.

SP_DLG_RY_OPR_L

(SQL View)

Related language table

Used as related language table for the Dialog validation.

SELECT C.OPRID , B.SETID , A.DIALOG_ID , D.LANGUAGE_CD , D.RY_DIALOG_NAME FROM PS_RYEDIALOG A , PS_SET_CNTRL_REC B , PS_SEC_BU_OPR C , PS_RYEDIALOG_LNG D WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE AND B.RECNAME ='RYEDOC' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.DIALOG_ID = D.DIALOG_ID

Related Language Record for SP_DLG_RY_OPRVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

3 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.

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

5 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name.