PROJ_FRT_22_VW

(SQL View)
 Index Back

Project Flex Resource 22 View


SELECT CHILD.SETID ,CHILD.TREE_NAME ,CHILD.EFFDT ,CHILD.TREE_NODE_NUM ,RES.BUSINESS_UNIT ,RES.PROJECT_ID ,RES.ACTIVITY_ID ,RES.ANALYSIS_TYPE ,FRT.SETID ,FRT.RESOURCE_GROUP ,FRT.RESOURCE_TYPE_MAP ,RES.RESOURCE_TYPE ,RES.RESOURCE_CATEGORY ,RES.RESOURCE_STATUS ,RES.BUSINESS_UNIT_GL ,RES.CURRENCY_CD ,RES.UNIT_OF_MEASURE ,%Round(SUM(%DecMult(RES.RESOURCE_QUANTITY, FRT.QUANTITY_MULTIPLY)), 2) ,%Round(SUM(%DecMult(RES.RESOURCE_AMOUNT, FRT.SIGNED_VALUE)), 2) FROM PS_PROJ_RESOURCE RES , PS_PROJ_RT_GRP_MAP FRT , PSTREENODE CHILD WHERE FRT.RESOURCE_TYPE = RES.RESOURCE_TYPE AND RES.BUSINESS_UNIT = CHILD.SETID AND RES.PROJECT_ID = CHILD.TREE_NODE GROUP BY CHILD.SETID ,CHILD.TREE_NAME ,CHILD.EFFDT ,CHILD.TREE_NODE_NUM ,RES.BUSINESS_UNIT ,RES.PROJECT_ID ,RES.ACTIVITY_ID ,RES.ANALYSIS_TYPE ,FRT.SETID ,FRT.RESOURCE_GROUP ,FRT.RESOURCE_TYPE_MAP ,RES.RESOURCE_TYPE ,RES.RESOURCE_CATEGORY ,RES.RESOURCE_STATUS ,RES.BUSINESS_UNIT_GL ,RES.CURRENCY_CD ,RES.UNIT_OF_MEASURE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

Prompt Table: SETID_TBL

2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: PROJ_TREE_VW

3 TREE_EFFDT Date(10) DATE Effective date of the Tree
4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: PROJECT

7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
8 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: PROJ_ANTYPE_TBL

9 FRT_SETID Character(5) VARCHAR2(5) NOT NULL Flexible Resource Type Setid

Prompt Table: SETID_TBL

10 RESOURCE_GROUP Character(5) VARCHAR2(5) NOT NULL Source Group

Prompt Table: PROJ_RT_GRP_TBL

11 RESOURCE_TYPE_MAP Character(5) VARCHAR2(5) NOT NULL Flexible Source Type

Prompt Table: PROJ_RT_GRP_MAP

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

Prompt Table: PROJ_RES_TYPE

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

Prompt Table: PROJ_CATG_TBL

14 RESOURCE_STATUS Character(1) VARCHAR2(1) NOT NULL Transaction Status
A=Resource Approved
U=Unapproved Resource
15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

17 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

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