PC_SUM_ACT_VW(SQL View) |
Index Back |
|---|---|
PM Desktop Activity View |
| SELECT OPRID, PANELNAME, BUSINESS_UNIT, PROJECT_ID, ACTIVITY_ID, 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 WHERE PANELNAME = 'ACTIVITY' GROUP BY OPRID, PANELNAME, BUSINESS_UNIT, 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 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 7 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 8 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | 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 |
| 11 | 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 |
| 12 | 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 |
| 13 | 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 |
| 14 | 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 |
| 15 | AMT6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 6 |
| 16 | AMT7 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 7 |
| 17 | AMT8 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 8 |
| 18 | AMT9 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 9 |
| 19 | AMT10 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 10 |
| 20 | AMT11 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 11 |
| 21 | AMT12 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 12 |
| 22 | AMT13 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 13 |
| 23 | AMT14 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 14 |
| 24 | AMT15 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 15 |
| 25 | AMT16 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 16 |
| 26 | AMT17 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 17 |
| 27 | AMT18 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 18 |
| 28 | AMT19 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 19 |
| 29 | AMT20 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount 20 |