BC_PRJREQST_VW4(SQL View) |
Index Back |
|---|---|
Project Request |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.DESCR , B.PORTFOLIO_ID , A.BC_PROJ_REQ_STATUS , A.BC_PRIORITY_REQSTR , A.BC_PRIORITY_APPRVR , A.BC_INVESTMENT_TYPE , A.BC_REQUESTER , A.BC_APPROVER , A.BC_DEPTID_REQSTER , A.BC_PROJ_DEPTID , A.BC_PROJECT_OWNER , A.BC_RISK , A.BC_KBO_SUPPORT FROM PS_BC_PROJ_REQUEST A , PS_BC_PORT_OBJ_CMP B WHERE A.PROJECT_ID = B.OBJ_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PORTFOLIO_ID | Character(18) | VARCHAR2(18) NOT NULL | Portfolio ID |
| 5 | BC_PROJ_REQ_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Status of the Project Request.
01=Approved 02=Pending 03=Submitted 04=Canceled 05=Declined 06=Returned 07=Costing 08=Hold 09=Complete 10=Executed 11=Operationally Approved |
| 6 | BC_PRIORITY_REQSTR | Number(3,0) | SMALLINT NOT NULL |
Requester Priority
Default Value: 5 Prompt Table: BC_PRJ_PRTY_TBL |
| 7 | BC_PRIORITY_APPRVR | Number(3,0) | SMALLINT NOT NULL |
Approver Priority
Prompt Table: BC_PRJ_PRTY_TBL |
| 8 | BC_INVESTMENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Investment Type
01=Run Rate 02=Infrastructure 03=Transactional 04=Informational 05=Utilities |
| 9 | BC_REQUESTER | Character(50) | VARCHAR2(50) NOT NULL |
Requester of Project Request.
Prompt Table: PERSONAL_DATA |
| 10 | BC_APPROVER | Character(50) | VARCHAR2(50) NOT NULL |
Approver of Project Request.
Prompt Table: PERSONAL_DATA |
| 11 | BC_DEPTID_REQSTER | Character(10) | VARCHAR2(10) NOT NULL |
Department of the project requester.
Prompt Table: DEPT_TBL |
| 12 | BC_PROJ_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Project Owning Deptid |
| 13 | BC_PROJECT_OWNER | Character(40) | VARCHAR2(40) NOT NULL |
Project Owner
Prompt Table: PERSONAL_DATA |
| 14 | BC_RISK | Number(7,2) | DECIMAL(6,2) NOT NULL |
Risk
01=1- High 02=2 - Medium 03=3 - Low |
| 15 | BC_KBO_SUPPORT | Number(7,2) | DECIMAL(6,2) NOT NULL | KBO Support |