ACTION_DFN_IDPrompt Table: RB_TD_ACT_DFN
RB_TD_GRID_IDPrompt Table: RB_TD_DYNGRDHDR
A=Active
I=Inactive
RB_TD_ACTGRD_VW(SQL View) |
Index Back |
|---|---|
Related GridsThis view shows the Related Dynamic Grids for a given Action in 360-Degree View Setup. |
| SELECT A.ACTION_DFN_ID , A.RB_TD_GRID_ID , C.DESCR254 , A.STATUS ,B.SETCNTRLVALUE , A.DISABLE_INACTIVEBO , A.SEQNUM , A.DEFAULT_FLG , B.DESCR ,A.ROW_ADDED_DTTM ,A.ROW_ADDED_OPRID FROM PS_RB_TD_DYN_ACT A , PS_RB_TD_ACT_DFN B , PS_RB_TD_DYNGRDHDR C WHERE B.ACTION_DFN_ID = A.ACTION_DFN_ID AND A.RB_TD_GRID_ID = C.RB_TD_GRID_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTION_DFN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
This field is used to store the Action ID, the key field for Actions in 360-Degree View.
Prompt Table: RB_TD_ACT_DFN |
| 2 | RB_TD_GRID_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Unique Identifier field for Dynamic Grid. This is a key field in RB_TD_DYNGRDHDR, RB_TD_DYNGHDLNG, RB_TD_DYNGRDLN
Prompt Table: RB_TD_DYNGRDHDR |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 5 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 6 | DISABLE_INACTIVEBO | Character(1) | VARCHAR2(1) NOT NULL | This flag is used to identify if the Action is to be disabled for Inactive Business Objects. |
| 7 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 8 | DEFAULT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Default Flag |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 11 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |