RB_TT_PERCV_LNG (SQL View)	Index Back
Category View Text Tray category view, this does not include Personal category.

RB_TT_PERCV_LNG

(SQL View)

Category View

Text Tray category view, this does not include Personal category.

SELECT DISTINCT A.OPRID , C.CATEGORY , C.LANGUAGE_CD , C.CATEGORY_DESCR FROM PS_RB_TT_PERSONAL A , PS_RB_TT_QKEYS B , PS_RB_TT_CATEG_LNG C WHERE A.QK_ID = B.QK_ID AND B.CATEGORY = C.CATEGORY

Related Language Record for RB_TT_PERCAT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CATEGORY Character(4) VARCHAR2(4) NOT NULL Text Tray Category field.

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

4 CATEGORY_DESCR Character(30) VARCHAR2(30) NOT NULL Category Description field. Used in Text Tray

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CATEGORY	Character(4)	VARCHAR2(4) NOT NULL	Text Tray Category field.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	CATEGORY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Category Description field. Used in Text Tray