RB_MAILBOX_VW (SQL View)	Index Back
Prompt view of mailbox defn Prompt view to get all mailboxes defined in the database.

RB_MAILBOX_VW

(SQL View)

Prompt view of mailbox defn

Prompt view to get all mailboxes defined in the database.

SELECT MAILBOX_ID , MAILBOX_TYPE , REPLY_BY_MAIL_ADDR FROM PS_RB_MAILBOX_DEFN WHERE EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MAILBOX_ID Character(30) VARCHAR2(30) NOT NULL Mail Box Id is an Id associated with Mail Boxes

2 MAILBOX_TYPE Character(1) VARCHAR2(1) NOT NULL Identify the type of the Mailbox
C=Higher Education
E=External
H=Internal HR
I=Internal
P=Partner

3 REPLY_BY_MAIL_ADDR Character(254) VARCHAR2(254) NOT NULL Reply By Email Address is the default ddress used in message replies sent from the ERMS Framework

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MAILBOX_ID	Character(30)	VARCHAR2(30) NOT NULL	Mail Box Id is an Id associated with Mail Boxes
2	MAILBOX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identify the type of the Mailbox C=Higher Education E=External H=Internal HR I=Internal P=Partner
3	REPLY_BY_MAIL_ADDR	Character(254)	VARCHAR2(254) NOT NULL	Reply By Email Address is the default ddress used in message replies sent from the ERMS Framework