PROJ_FLEX_BI_VW

(SQL View)
 Index Back

Project Flex Billing View


SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.DTTM_STAMP ,A.ANALYSIS_TYPE ,B.ANALYSIS_TYPE_MAP ,B.ANALYSIS_GROUP ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.RESOURCE_STATUS ,A.BUSINESS_UNIT_GL ,A.BI_DISTRIB_STATUS ,A.CURRENCY_CD ,A.UNIT_OF_MEASURE ,%Round(SUM(%DecMult(A.RESOURCE_QUANTITY, B.QUANTITY_MULTIPLY)), 2) ,%Round(SUM(%DecMult(A.RESOURCE_AMOUNT, B.SIGNED_VALUE)), 2) FROM PS_PROJ_RESOURCE A , PS_PROJ_AN_GRP_MAP B WHERE B.ANALYSIS_TYPE = A.ANALYSIS_TYPE GROUP BY A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ACTIVITY_ID ,A.DTTM_STAMP ,A.ANALYSIS_TYPE ,B.ANALYSIS_TYPE_MAP ,B.ANALYSIS_GROUP ,A.RESOURCE_TYPE ,A.RESOURCE_CATEGORY ,A.RESOURCE_SUB_CAT ,A.RESOURCE_STATUS ,A.BUSINESS_UNIT_GL ,A.BI_DISTRIB_STATUS ,A.CURRENCY_CD ,A.UNIT_OF_MEASURE HAVING SUM(%DecMult(A.RESOURCE_AMOUNT, B.SIGNED_VALUE)) <>0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJ_SCRTY_SRCH

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_SRCH

4 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
5 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: PROJ_ANTYPE_TBL

6 ANALYSIS_TYPE_MAP Character(3) VARCHAR2(3) NOT NULL Analysis Type Map

Prompt Table: PROJ_ANTYPE_TBL

7 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group

Prompt Table: SP_AN_GRP_NONVW

8 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RES_TYPE

9 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: PROJ_CATG_TBL

10 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: PROJ_SUBCAT_TBL

11 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource
12 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: SP_BUPCIT_NONVW

13 BI_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Distribution Status
D=Distributed
I=Ignore
N=Not Distributed
P=Priced
U=Unbillable/Non-billable
W=Billing Worksheet
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

15 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

16 RESOURCE_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Quantity
17 RESOURCE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount