RD_DIALOG_VW (SQL View)	Index Back
Dialog View This view returns dialogs with the status of 'A', 'S', or 'P'

RD_DIALOG_VW

(SQL View)

Dialog View

This view returns dialogs with the status of 'A', 'S', or 'P'

SELECT A.SETID , B.DIALOG_ID , B.RY_DIALOG_NAME , B.RY_DIALOG_STATUS , B.START_DT , B.END_DT FROM PS_SET_CNTRL_GROUP A , PS_RY_DIALOG B WHERE A.REC_GROUP_ID = 'RD_01' AND A.SETCNTRLVALUE = B.BUSINESS_UNIT AND B.RY_DIALOG_STATUS IN ('A', 'P', 'S')

Related Language Record: RD_DIALOG_LNGVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 RY_DIALOG_STATUS Character(1) VARCHAR2(1) NOT NULL Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.

5 START_DT Date(10) DATE Start date field to store start date value.

6 END_DT Date(10) DATE This field stores the end date values.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	DIALOG_ID	Number(18,0)	DECIMAL(18) NOT NULL	Dialog ID field to identify both design time and run time dialog.
3	RY_DIALOG_NAME	Character(254)	VARCHAR2(254) NOT NULL	Field is used to capture a Dialog Name.
4	RY_DIALOG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Dialog Status field, will hold the value for the status, will need to look up the actual descr for the readable label.
5	START_DT	Date(10)	DATE	Start date field to store start date value.
6	END_DT	Date(10)	DATE	This field stores the end date values.