RAE_DLGTRG_VW(SQL View) |
Index Back |
---|---|
View of Dialog TriggersDialog Triggers selected on Event Actions |
SELECT DIALOG_ID , RY_ACTION_ID , LABEL_TEXT , RY_ACT_TYPE_ID , DESCR254 FROM PS_RYEACT_TASK WHERE RY_ACT_TYPE_ID = 4 AND RY_TRIGER_ONDEMAND = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL |
Dialog ID field to identify both design time and run time dialog.
Prompt Table: RY_DIALOG |
2 | RY_ACTION_ID | Number(18,0) | DECIMAL(18) NOT NULL | Id for a dialog element for the dialog designer. |
3 | LABEL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | Activity Name |
4 | RY_ACT_TYPE_ID | Number(18,0) | DECIMAL(18) NOT NULL |
Used to determine the type of Element for the Dialog.
Prompt Table: RAE_DLGTRG_VW |
5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |