EX_APR_PROF_VW(SQL View) |
Index Back |
|---|---|
Approver Profile ViewApprover 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 | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BU_GL_NONVW |
|
| 2 | Character(15) | VARCHAR2(15) NOT NULL |
Approver profile name
Prompt Table:
EX_PROF_ASGN_VW
|