RB_BU_PROMPT_VW (SQL View)	Index Back
ERMS Setid Prompt Table to use as Prompt for Setid for ERMS Mailbox Business Unit

RB_BU_PROMPT_VW

(SQL View)

ERMS Setid Prompt

Table to use as Prompt for Setid for ERMS Mailbox Business Unit

SELECT DISTINCT A.SETID , B.BUSINESS_UNIT FROM PS_SET_CNTRL_REC A , PS_BUS_UNIT_TBL_RB B WHERE A.REC_GROUP_ID = 'RB_01' AND %Substring(A.SETCNTRLVALUE,1,5) = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit