SPR_EXPVARDS_VW

(SQL View)
Index Back

Expense Variance Dept Summary

Expense Variance Dept Summary

SELECT A.OPRID ,A.BUSINESS_UNIT ,A.DEPTID ,B.DESCR ,SUM(A.POAMOUNT) ,SUM(A.SPR_TOTAL_TIME) ,SUM(A.SPR_TOTAL_EXPNS) ,SUM(A.SPR_TOTAL_AMT) ,SUM(A.POAMOUNT) - SUM(A.SPR_TOTAL_AMT) ,A.CURRENCY_CD FROM PS_SPR_EXPVAR_FACT A ,PS_SPR_DEPT_DIM B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.DEPTID = B.DEPTID GROUP BY A.OPRID , A.BUSINESS_UNIT , A.DEPTID ,B.DESCR ,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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
4 SP_DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
5 POAMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Purchase Order / Work Order Amount
6 SPR_TOTAL_TIME Number(27,3) DECIMAL(26,3) NOT NULL sPro Total Time Field for Analysis - Total Hours by Multiplies Time Reporting Code
7 SPR_TOTAL_EXPNS Number(27,3) DECIMAL(26,3) NOT NULL sPro Total Expense Amount
8 SPR_TOTAL_AMT Number(27,3) DECIMAL(26,3) NOT NULL sPro Total Amount Calculated from Hours Worked
9 SPR_AVAIL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Available Amount Field for Analysis
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code