PSA_ORGACT_VW

(SQL View)
 Index Back

Project Activity Org. View

ProjectActivity Organization view

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.WBS_ID , A.ACTIVITY_ID ,A.DESCR ,A.START_DT ,A.END_DT FROM PS_PROJ_ACTIVITY A ,PS_PSA_ORGPRJ_ACT B WHERE A.COSTING_ACT_SW = 'Y' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.ACTIVITY_ID = B.ACTIVITY_ID

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

Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

Prompt Table: SP_BU_PC_NONVW

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

Default Value: OPR_DEF_TBL_PC.PROJECT_ID

Prompt Table: PSA_PROJSRCH_VW

3 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID
4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACT_SRCH1

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 START_DT Date(10) DATE Start Date
7 END_DT Date(10) DATE End Date