RB_AMPRUL_TM_VW (SQL View)	Index Back
AMP Rule Category Name View AMP Rule Template Category Name View, for RB_AMPRULE's search record.

RB_AMPRUL_TM_VW

(SQL View)

AMP Rule Category Name View

AMP Rule Template Category Name View, for RB_AMPRULE's search record.

SELECT TMPLT_CATEGRY_ID , TMPLT_CATEGRY_NAME FROM PS_RBC_TEMPLT_CAT WHERE TMPLT_CATEGRY_ID IN (20,22,23,24,28)

Related Language Record: RB_AMPRUL_TM_L

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

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