RB_TD_ACTCAT_VW

(SQL View)
 Index Back

Actions Category view

This view returns the Category details for for Actions.

SELECT B.ACTION_DFN_ID , A.ACTION_CAT_ID , A.ACTION_CAT_NAME , B.DESCR , A.STATUS , A.SETCNTRLOPT , A.SUBINT_OBJ_TYPE , A.ACTION_CAT_REC , A.SETCNTRLFLD , A.CAT_REC_ID_FLD , A.CAT_REC_DESCFLD , A.PNLGRPNAME , A.COMPONENT_MARKET , A.NODE_ACTION , A.ACTION1 , A.RB_TRANSACTION_ID , A.OPEN_NEW_PAGE , A.MARKET , A.PORTAL_NAME , A.PORTAL_OBJNAME , A.APPCLASSID , A.APPCLASS_PATH , A.FUNCTION_NAME , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.DETAIL_RECORD , B.SETCNTRLVALUE , B.ACTION_CAT_VALUE , B.DISP_TMPL_ID FROM PS_RB_TD_ACT_CAT A , PS_RB_TD_ACT_DFN B WHERE A.ACTION_CAT_ID =B.ACTION_CAT_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.
2 ACTION_CAT_ID Character(10) VARCHAR2(10) NOT NULL This is the key field for the Action Category Definition record.
3 ACTION_CAT_NAME Character(50) VARCHAR2(50) NOT NULL This field stores the Action Category Name as defined in the Action Category Definition Record.
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

6 SETCNTRLOPT Character(1) VARCHAR2(1) NOT NULL This field stores the option of Set Control - Business Unit, Set ID or None.
B=Business Unit
N=None
S=Set ID

Default Value: N

7 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
8 ACTION_CAT_REC Character(18) VARCHAR2(18) NOT NULL This field stores the category record value in the Action Category Definition.

Prompt Table: RB_TD_REC1_VW

9 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name

Prompt Table: RB_TD_CATFLD_VW

10 CAT_REC_ID_FLD Character(18) VARCHAR2(18) NOT NULL This is the key value for the Category Record specified on the Action Category Definition record.

Prompt Table: RB_TD_CATFLD_VW

11 CAT_REC_DESCFLD Character(18) VARCHAR2(18) NOT NULL This is the description field value in the Category Record specified in the Action Category Definition.

Prompt Table: RB_TD_CATFLD_VW

12 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: PSPNLGRPDFN_VW1

13 COMPONENT_MARKET Character(3) VARCHAR2(3) NOT NULL Market
14 NODE_ACTION Character(1) VARCHAR2(1) NOT NULL Node Action
A=Action
C=Portal Content Reference
G=Dynamic Grid
N=None
P=Application Class
T=Transfer

Default Value: T

15 ACTION1 Character(1) VARCHAR2(1) NOT NULL Action
A=Add
C=Correction
U=Update/Display
16 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID

Prompt Table: RB_TXN_DEFN

17 OPEN_NEW_PAGE Character(1) VARCHAR2(1) NOT NULL Y/N flag indicating whether to open a new page/window

Y/N Table Edit

Default Value: N

18 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Prompt Table: RB_TD_TXNMKT_VW

19 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

Prompt Table: RB_TD_PORTAL_VW

20 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name

Prompt Table: RB_TD_POBJ_VW

21 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: RBC_APPCLASS_VW

22 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

Prompt Table: RBC_APPRTPATH_V

23 FUNCTION_NAME Character(30) VARCHAR2(30) NOT NULL Function Name
24 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Prompt Table: RB_MSGSET_VW

25 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

Prompt Table: RB_MSGCAT_VW

26 DETAIL_RECORD Character(18) VARCHAR2(18) NOT NULL Field to store the record name for showing the confirmation message information for Action category in 360-Degree View setup.

Prompt Table: RB_TD_REC1_VW

27 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
28 ACTION_CAT_VALUE Character(50) VARCHAR2(50) NOT NULL This field contains the Category Value to be used on the Action Definition based on the Action Category selected.
29 DISP_TMPL_ID Character(30) VARCHAR2(30) NOT NULL Template identifier to define the display template.