PC_PROJ_FIN_VW2 (SQL View)	Index Back
Project Financials Project Financials

PC_PROJ_FIN_VW2

(SQL View)

Project Financials

SELECT A.OPRID , ' ' , X.FIELDVALUE , X.XLATLONGNAME , CASE WHEN X.FIELDVALUE = 'ACT' THEN SUM(A.ACTUAL_AMOUNT) WHEN X.FIELDVALUE = 'BUD' THEN SUM(A.BUDGET_AMOUNT) ELSE 0 END , A.CURRENCY_CD FROM PS_PC_PROJ_FIN_VW3 A , PSXLATITEM X WHERE X.FIELDNAME = 'AMOUNT_TYPE2' AND X.FIELDVALUE IN ('ACT', 'BUD') AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn) GROUP BY A.OPRID, X.FIELDVALUE, X.XLATLONGNAME, A.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 BLANK Character(1) VARCHAR2(1) NOT NULL Blank

3 AMOUNT_TYPE2 Character(3) VARCHAR2(3) NOT NULL Field amount type
ACT=Actuals
BUD=Budget

4 AMOUNT_FIELDNAME Character(18) VARCHAR2(18) NOT NULL An internal work field utilized for calculating forecast amounts for a given category in cash wor

5 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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	BLANK	Character(1)	VARCHAR2(1) NOT NULL	Blank
3	AMOUNT_TYPE2	Character(3)	VARCHAR2(3) NOT NULL	Field amount type ACT=Actuals BUD=Budget
4	AMOUNT_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	An internal work field utilized for calculating forecast amounts for a given category in cash wor
5	RESOURCE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code