RB_MAILBOX_VW2 (SQL View)	Index Back
Mailbox view Used as lookup for t Maibox ID without getting affected by effective status field.

RB_MAILBOX_VW2

(SQL View)

Mailbox view

Used as lookup for t Maibox ID without getting affected by effective status field.

SELECT MAILBOX_ID , DESCR100 , EFF_STATUS FROM PS_RB_MAILBOX_DEFN

# 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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

3 RB_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective status field to bypass tools logic
A=Active
I=Inactive

#	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	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
3	RB_EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective status field to bypass tools logic A=Active I=Inactive