PGM_FR_CST_SUMH(SQL View) |
Index Back |
|---|---|
View Act Cost of Resource HrsTo fetch the sum of the Actual Cost of Resource Hours of all Activities. |
| SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,B.PROJECT_TYPE ,' ' ,%DateNull , ' ' , 0 ,%Round(SUM(%DecMult(%DecMult(A.RESOURCE_QUANTITY, E.QUANTITY_MULTIPLY), D.CONVERSION_RATE)) , 2) FROM PS_PC_SUMMARY_TBL A ,PS_PROJECT B ,PS_BUS_UNIT_TBL_PC C ,PS_UNITS_CVT_TBL D ,PS_PROJ_AN_GRP_MAP E ,PS_SET_CNTRL_REC F WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.PROJECT_ID=B.PROJECT_ID AND A.BUSINESS_UNIT=C.BUSINESS_UNIT AND A.UNIT_OF_MEASURE=D.UNIT_OF_MEASURE AND D.UNIT_OF_MEASURE_TO=C.UOM_HOURS AND E.ANALYSIS_GROUP=B.AN_GRP_TOT_COSTS AND E.SETID=F.SETID AND E.ANALYSIS_TYPE=A.ANALYSIS_TYPE AND F.RECNAME='PROJ_AN_GRP_MAP' AND F.SETCNTRLVALUE=A.BUSINESS_UNIT GROUP BY A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,B.PROJECT_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: SP_BU_PC_NONVW.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: SP_PROJ_NONVW.PROJECT_ID Prompt Table: SP_PROJ_NONVW |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | PROJECT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Project Type
A=Activity G=Grant H=Phase P=Project S=Segment |
| 5 | ANALYSIS_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 6 | ACCOUNTING_DT |
Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 7 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 8 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 9 | RESOURCE_QUANTITY | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity |