RBC_TMPLTCAT_LG (SQL View)	Index Back
template category correspondence template category

RBC_TMPLTCAT_LG

(SQL View)

template category

correspondence template category

SELECT B.TMPLT_CATEGRY_ID , B. TMPLT_CATEGRY_NAME , B.LANGUAGE_CD FROM PS_RBC_TEMPLT_CAT A , PS_RBC_CAT_LNG B WHERE A.ACTIVE_FLAG = 'Y' AND B.TMPLT_CATEGRY_ID = A.TMPLT_CATEGRY_ID

Related Language Record for RBC_TMPLTCAT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TMPLT_CATEGRY_ID Number(6,0) INTEGER NOT NULL Template Category ID

2 TMPLT_CATEGRY_NAME Character(30) VARCHAR2(30) NOT NULL Holds the names of the categories. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TMPLT_CATEGRY_ID	Number(6,0)	INTEGER NOT NULL	Template Category ID
2	TMPLT_CATEGRY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Holds the names of the categories. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code