BUSINESS_UNITPROJECT_IDPrompt Table: PROJECT_VW
ACTIVITY_IDEFFDTDefault Value: %date
EVENT_OCCURRENCECA_ACT_STAT_VW(SQL View) |
Index Back |
|---|---|
Project Activity ViewThis provides an easy to use on-line prompt for the Project Activities. |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.EFFDT , B.EVENT_OCCURRENCE , A.EFFSEQ , A.ACTIVITY_STATUS , B.CONTRACT_NUM , B.DAYS_LAG FROM PS_PROJ_ACT_STATUS A , PS_CA_BP_EVENTS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_PC AND A.PROJECT_ID = B.PROJECT_ID AND A.ACTIVITY_ID = B.ACTIVITY_ID AND B.MILESTONE_ORIGIN = 'A' AND A.ACTIVITY_STATUS <> B.ACTIVITY_STATUS AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_PROJ_ACT_STATUS D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.PROJECT_ID = A.PROJECT_ID AND D.ACTIVITY_ID = A.ACTIVITY_ID ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT_VW |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EVENT_OCCURRENCE |
Number(3,0) | SMALLINT NOT NULL | Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal. |
| 6 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 7 | ACTIVITY_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Activity Status |
| 8 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 9 | DAYS_LAG | Number(3,0) | SMALLINT NOT NULL | A number of days lag before an activity/event occurs. |