SDB_E_PRIOTY_VW (SQL View)	Index Back
Inbound Email Priority View Inbound Email Priority View used in Contact Center Dashboard.

SDB_E_PRIOTY_VW

(SQL View)

Inbound Email Priority View

Inbound Email Priority View used in Contact Center Dashboard.

SELECT PRIORITY_NBR ,PRIORITY_NAME ,DESCR80 FROM PS_RB_PRIORTY_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

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

3 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
2	PRIORITY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Holds the names of the priorities. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.
3	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.