RY_ACTION_IDRY_ACT_SRCH(SQL View) |
Index Back |
|---|---|
Search Record for elementsDesign Side Search Record for elements |
| SELECT A.RY_ACTION_ID , A.DIALOG_ID , A.RY_ACT_TYPE_ID , B.RY_IS_EXTERNAL FROM PS_RY_ACT_TASK A , PS_RY_ACT_TYPE B WHERE A.RY_ACT_TYPE_ID = B.RY_ACT_TYPE_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RY_ACTION_ID |
Number(18,0) | DECIMAL(18) NOT NULL | Id for a dialog element for the dialog designer. |
| 2 | DIALOG_ID | Number(18,0) | DECIMAL(18) NOT NULL | Dialog ID field to identify both design time and run time dialog. |
| 3 | RY_ACT_TYPE_ID | Number(18,0) | DECIMAL(18) NOT NULL | Used to determine the type of Element for the Dialog. |
| 4 | RY_IS_EXTERNAL | Character(1) | VARCHAR2(1) NOT NULL | Use to know if an object is meant for external usage. |