ACTION_DFN_IDPrompt Table: RB_TD_ACT_DFN
RB_TD_GRID_IDPrompt Table: RB_TD_DYNGRDHDR
LANGUAGE_CDRB_TD_ACTGRDLVW(SQL View) |
Index Back |
|---|---|
Related Language RecordRelated Language Record for Grid Actions. |
| SELECT A.ACTION_DFN_ID , A.RB_TD_GRID_ID ,B.LANGUAGE_CD ,C.DESCR254 , B.DESCR FROM PS_RB_TD_DYN_ACT A , PS_RB_TD_ACT_DRLR B , PS_RB_TD_DYNGHDLNG C WHERE B.ACTION_DFN_ID = A.ACTION_DFN_ID AND A.RB_TD_GRID_ID = C.RB_TD_GRID_ID AND C.LANGUAGE_CD = B.LANGUAGE_CD |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |