PC_ACTT_TREE(SQL View) |
Index Back |
|---|---|
Project Activity SearchProject Activity Search |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.ROW_NUMBER_5 , A.WBS_ID , A.ACTIVITY_ID , A.DESCR1 , A.DESCR , A.ACTIVITY_TYPE , A.EFF_STATUS , B.PC_PROCESS_STATUS , A.PC_ACT_OWNER , A.PC_MILESTONE_FLG , A.SUMMARY_ACT , ' ' FROM PS_PC_PROJ_ACTJOIN A , PS_PC_ACT_COMP B WHERE A.PROJ_TMPL_FILTER = '1' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT_PC AND A.PROJECT_ID = B.PROJECT_ID_2 AND A.ACTIVITY_ID = B.ACTIVITY_ID_2 |
| # | 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 |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID |
| 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 |
| 6 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Project Description |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 |
| 9 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 10 | PC_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The processing state of a project.
A=Active I=Inactive P=Pending T=Template |
| 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 | SUMMARY_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity Y=Summary Activity |
| 14 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |