BUSINESS_UNITDefault Value: PROJ_ACTIVITY.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: PROJECT
ACTIVITY_IDPrompt Table: %EDITTABLE3
GM_PT_ACT_ST_VW(SQL View) |
Index Back |
|---|---|
Project Activity StatusProject Activity Status |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.ACTIVITY_STATUS FROM PS_PROJ_ACT_STATUS A WHERE A.Effdt = ( SELECT MAX(C.EffDt) FROM PS_PROJ_ACT_STATUS C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.PROJECT_ID = A.PROJECT_ID AND C.ACTIVITY_ID = A.ACTIVITY_ID AND C.EffDt <= %CurrentDateIn) 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 AND D.EffDt = A.EffDt) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJ_ACTIVITY.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | ACTIVITY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
Prompt Table: %EDITTABLE3 |