PC_SUM_REVNU_VW

(SQL View)
 Index Back

Summarized Revenue Recognized

This view summarized revenue recognized costs from the Projects Summary table. This revenue includes fixed-fee (FRV) and rate-based revenue.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , B.PROJECT_TYPE , A.ANALYSIS_TYPE , A.ACCOUNTING_DT , %Round(SUM(%DecMult(A.RESOURCE_AMOUNT, C.SIGNED_VALUE)), 3) FROM PS_PC_SUMMARY_TBL A , PS_PROJECT B , PS_PROJ_AN_GRP_MAP C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND C.ANALYSIS_GROUP = 'PSREV' AND C.SETID = D.SETID AND D.RECNAME = 'PROJ_AN_GRP_MAP' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT AND A.ANALYSIS_TYPE = C.ANALYSIS_TYPE AND A.GL_DISTRIB_STATUS = 'D' GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID, A.ACTIVITY_ID, B.PROJECT_TYPE, A.ANALYSIS_TYPE, A.ACCOUNTING_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
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 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount