PC_PROJ_ACTJOIN (SQL View)	Index Back
Project Activity Search

PC_PROJ_ACTJOIN

(SQL View)

Project Activity Search

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ROW_NUMBER_5 , A.WBS_ID , A.ACTIVITY_ID , A.DESCR , B.DESCR , A.ACTIVITY_TYPE , A.EFF_STATUS , A.SUMMARY_ACT , A.PC_ACT_OWNER , A.PC_MILESTONE_FLG , ' ' , B.PROJ_TMPL_FILTER FROM PS_PROJ_ACTIVITY A , PS_PROJECT B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID

Related Language Record: PROJ_ACT_LSRCH

# 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: PROJECT_VW

3 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number

4 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID

5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PROJ_ACT_VW

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

7 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

8 ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
Prompt Table: PROJ_ACT_TBL

9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

10 SUMMARY_ACT Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity

11 PC_ACT_OWNER Character(11) VARCHAR2(11) NOT NULL Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.

12 PC_MILESTONE_FLG Character(1) VARCHAR2(1) NOT NULL Milestone Activity
N=No
Y=Yes

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

14 PROJ_TMPL_FILTER Character(30) VARCHAR2(30) NOT NULL Template Filter - identifies who is able to view/update a project template. If this field is set to '1', the template is public. If the template is private, this field will contain the operator id of the person who created the template.

#	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: PROJECT_VW
3	ROW_NUMBER_5	Number(5,0)	INTEGER NOT NULL	Row Number
4	WBS_ID	Character(100)	VARCHAR2(100) NOT NULL	WBS ID
5	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_VW
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
8	ACTIVITY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Activity Type A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason Prompt Table: PROJ_ACT_TBL
9	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
10	SUMMARY_ACT	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether an activity is summary or detail. N=Detail Activity Y=Summary Activity
11	PC_ACT_OWNER	Character(11)	VARCHAR2(11) NOT NULL	Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.
12	PC_MILESTONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Milestone Activity N=No Y=Yes
13	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
14	PROJ_TMPL_FILTER	Character(30)	VARCHAR2(30) NOT NULL	Template Filter - identifies who is able to view/update a project template. If this field is set to '1', the template is public. If the template is private, this field will contain the operator id of the person who created the template.