RB_ERMS_CATG_VW (SQL View)	Index Back
Category View CRM ERMS view for displaying Email category information

RB_ERMS_CATG_VW

(SQL View)

Category View

CRM ERMS view for displaying Email category information

SELECT TMPLT_CATEGRY_ID , TMPLT_CATEGRY_NAME FROM PS_RBC_TEMPLT_CAT WHERE ACTIVE_FLAG = 'Y' AND ERMS_RELATED = 'Y'

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