EX_APR_PROF_VW

(SQL View)
Index Back

Approver Profile View

Approver profile prompt view

SELECT A.BUSINESS_UNIT_GL , A.APPROVER_PROFILE FROM PS_EX_APPRVR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BU_GL_NONVW

2 APPROVER_PROFILE Character(15) VARCHAR2(15) NOT NULL Approver profile name

Prompt Table: EX_PROF_ASGN_VW
Set Control Field: BUSINESS_UNIT_GL