PC_SUM_DATA_TAO(SQL Table) |
Index Back |
|---|---|
Project Resources |
| # | 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 | SUMMARY_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity Y=Summary Activity |
| 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 |