RYEAUD_DLG_VW

(SQL View)
Index Back

List All Audience for A Dialog

List All Audience for A Dialog, this view is a join among 4 table, Dialog, Audience, Task List, etc.

SELECT LST.SETID , LST.RA_LIST_ID , DLG.DIALOG_ID , DLG.RY_DIALOG_NAME , DLG.RY_DIALOG_STATUS , DLG.DESCR254 FROM PS_RA_LIST LST , PS_RY_AUDIENCE AUD , PS_RYEAUD_LIST AL , PS_RYEDIALOG DLG WHERE AUD.SETID = LST.SETID AND AUD.RA_LIST_ID = LST.RA_LIST_ID AND AL.RY_LIST_ID = AUD.RY_LIST_ID AND DLG.DIALOG_ID = AL.DIALOG_ID

# 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 RA_LIST_ID Character(15) VARCHAR2(15) NOT NULL Audience ID
3 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
4 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
5 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.
6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254