BUSINESS_UNITPROJ_REQUEST_IDPGM_PR_FUND_MGR(SQL View) |
Index Back |
|---|---|
Project Request Funding MgrThis view returns the funding manager(s) for each project request. |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.BUSINESS_UNIT_GL , A.DEPTID , B.MANAGER_ID FROM PS_BC_COST_EST A , PS_DEPT_TBL B , PS_SET_CNTRL_REC CNTRL WHERE CNTRL.RECNAME = 'DEPT_TBL' AND CNTRL.SETCNTRLVALUE = A.BUSINESS_UNIT_GL AND B.SETID = CNTRL.SETID AND A.DEPTID = B.DEPTID AND B.EFF_STATUS = 'A' AND B.MANAGER_ID <> ' ' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_DEPT_TBL C WHERE B.SETID = C.SETID AND B.DEPTID = C.DEPTID AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJ_REQUEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | A unique identifier that represents a Project Request. |
| 3 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 5 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | Manager ID |