RB_TMPACKUSG_VW (SQL View)	Index Back
Template Package Usage Used for ERMS Rep[orts. List Template packages and any mailboxes they have been applied to within ERMS.

RB_TMPACKUSG_VW

(SQL View)

Template Package Usage

Used for ERMS Rep[orts. List Template packages and any mailboxes they have been applied to within ERMS.

SELECT A.RB_PACKAGE_NAME , B.MAILBOX_ID , A.ROW_ADDED_DTTM , B.SEND_DATE FROM PS_RBC_PACKAGE_DFN A , PS_RB_APPLD_TMP_VW B WHERE A.RB_PACKAGE_ID = B.RB_PACKAGE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RB_PACKAGE_NAME Character(30) VARCHAR2(30) NOT NULL Package Name

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

3 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

4 SEND_DATE Date(10) DATE Correspondence Send Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RB_PACKAGE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Package Name
2	MAILBOX_ID	Character(30)	VARCHAR2(30) NOT NULL	Mail Box Id is an Id associated with Mail Boxes
3	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
4	SEND_DATE	Date(10)	DATE	Correspondence Send Date