RB_TD_CATACTLVW (SQL View)	Index Back
Related Actions View This view shows the related actions for the category.

RB_TD_CATACTLVW

(SQL View)

Related Actions View

This view shows the related actions for the category.

SELECT A.ACTION_CAT_ID , A.ACTION_DFN_ID , B.LANGUAGE_CD , B.DESCR FROM PS_RB_TD_ACT_DFN A , PS_RB_TD_ACT_DRLR B WHERE B.ACTION_DFN_ID = A.ACTION_DFN_ID

Related Language Record for RB_TD_CATACT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTION_CAT_ID Character(10) VARCHAR2(10) NOT NULL This is the key field for the Action Category Definition record.
Prompt Table: RB_TD_ACT_CAT

2 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.

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION_CAT_ID	Character(10)	VARCHAR2(10) NOT NULL	This is the key field for the Action Category Definition record. Prompt Table: RB_TD_ACT_CAT
2	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.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description