SETIDBUDGET_CATEGORYBUSINESS_UNITPROJECT_IDPC_BUD_TYPEC=Cost Budget
R=Revenue Budget
ACTIVITY_ID0=Low Priority
1=Medium Priority
2=High Priority
PC_BD_SM_ACT_VW(SQL View) |
Index Back |
|---|---|
Project Budget Activity SumView project budget activity summary information. |
| SELECT A.SETID , B.PC_BUDGET_ITEM AS BUDGET_CATEGORY , B.BUSINESS_UNIT , B.PROJECT_ID , B.PC_BUD_TYPE , B.ACTIVITY_ID , SUM(B.BUDGET_AMOUNT) AS BUDGET_AMOUNT , SUM(B.ACTUAL_AMOUNT) AS ACTUAL_AMOUNT , SUM(B.BUDGET_AMOUNT) - SUM(B.ACTUAL_AMOUNT) AS REMAIN_AMOUNT , ' ' , B.CURRENCY_CD FROM PS_SET_CNTRL_REC A , PS_PC_BUD_SUMMARY B WHERE A.RECNAME = 'GM_BUD_CATEGORY' AND A.SETCNTRLVALUE = B.BUSINESS_UNIT GROUP BY A.SETID, B.PC_BUDGET_ITEM, B.BUSINESS_UNIT, B.PROJECT_ID, B.PC_BUD_TYPE, B.ACTIVITY_ID, B.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUDGET_CATEGORY |
Character(15) | VARCHAR2(15) NOT NULL | BUDGET_CATEGORY |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | PC_BUD_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
This field defines a Projects Budget as either Cost or Revenue Based.
C=Cost Budget R=Revenue Budget |
| 6 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 7 | BUDGET_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Projects Budget Amount |
| 8 | ACTUAL_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Actual Invoice Amount |
| 9 | REMAIN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Remaining Amount |
| 10 | PC_IM_PRIO_ICON | Character(1) | VARCHAR2(1) NOT NULL |
Issue Priority Icon
0=Low Priority 1=Medium Priority 2=High Priority |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |