BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: PROJECT_VW
PC_BUDGET_IDACTIVITY_IDPC_EE_ACT(SQL View) |
Index Back |
|---|---|
Entry Event Activity ViewPrompt for Entry Events Run Control |
| SELECT DISTINCT B.BUSINESS_UNIT , B.PROJECT_ID , B.PC_BUDGET_ID , C.ACTIVITY_ID , D.DESCR , C.EE_PROC_STATUS FROM PS_PROJECT A , PS_PC_BUD_PLAN B , PS_PC_BUD_DETAIL C , PS_PROJ_ACTIVITY D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND B.PC_BUDGET_ID = C.PC_BUDGET_ID AND C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.PROJECT_ID = D.PROJECT_ID AND C.ACTIVITY_ID = D.ACTIVITY_ID AND A.GRANT_FLG <> 'Y' AND (C.ENTRY_EVENT <> ' ' OR C.KK_DEFAULT_EE = 'Y') AND C.JOURNAL_ID <> ' ' AND C.KK_DISTRIB_STATUS = 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT_VW |
| 3 | PC_BUDGET_ID |
Number(3,0) | SMALLINT NOT NULL | Budget Plan ID |
| 4 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EE_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Entry Event Line Status |