PC_SUM_VW(SQL View) |
Index Back |
|---|---|
Project Resources |
| SELECT OPRID , PANELNAME , BUSINESS_UNIT , PROJECT_ID , ACTIVITY_ID , SUMMARY_ACT , RESOURCE_TYPE , RESOURCE_CATEGORY , RESOURCE_SUB_CAT , CURRENCY_CD , SUM(AMT1) , SUM(AMT2) , SUM(AMT3) , SUM(AMT4) , SUM(AMT5) , SUM(AMT6) , SUM(AMT7) , SUM(AMT8) , SUM(AMT9) , SUM(AMT10) , SUM(AMT11) , SUM(AMT12) , SUM(AMT13) , SUM(AMT14) , SUM(AMT15) , SUM(AMT16) , SUM(AMT17) , SUM(AMT18) , SUM(AMT19) , SUM(AMT20) , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_PC_SUM_DATA_TAO GROUP BY OPRID , PANELNAME , BUSINESS_UNIT , SUMMARY_ACT , PROJECT_ID , ACTIVITY_ID , RESOURCE_TYPE , RESOURCE_CATEGORY , RESOURCE_SUB_CAT , CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | PANELNAME | Character(18) | VARCHAR2(18) NOT NULL | Panelname |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 4 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 5 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACT_SRCH |
| 6 | SUMMARY_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity Y=Summary Activity |
| 7 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 8 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 9 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 12 | AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 13 | AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 14 | AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 15 | AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 16 | AMT6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 6 |
| 17 | AMT7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 7 |
| 18 | AMT8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 8 |
| 19 | AMT9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 9 |
| 20 | AMT10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 10 |
| 21 | AMT11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 11 |
| 22 | AMT12 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 12 |
| 23 | AMT13 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 13 |
| 24 | AMT14 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 14 |
| 25 | AMT15 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 15 |
| 26 | AMT16 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 16 |
| 27 | AMT17 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 17 |
| 28 | AMT18 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 18 |
| 29 | AMT19 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 19 |
| 30 | AMT20 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 20 |
| 31 | DRILL_DOWN | Character(1) | VARCHAR2(1) NOT NULL | Detail |
| 32 | PC_PROJ_ID_FLEX_PB | Character(1) | VARCHAR2(1) NOT NULL | Project ID Flex |
| 33 | PC_ACT_ID_FLEX_PB | Character(1) | VARCHAR2(1) NOT NULL | Activity ID Flex |
| 34 | PC_RES_TYP_FLEX_PB | Character(1) | VARCHAR2(1) NOT NULL | Source Type Flex |
| 35 | PC_CATEGY_FLEX_PB | Character(1) | VARCHAR2(1) NOT NULL | Category Flex |