BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: SP_PROJ_NONVW
ACTIVITY_IDPrompt Table: PC_ACT_TRAN_VW
OPRID2PC_WC_NO_CA_VW(SQL View) |
Index Back |
|---|---|
Projects not linked to ContactProject/activities not associated with a contract for Projects WorkCenter exception. |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , B.ACTIVITY_ID , MYP.OPRID , A.START_DT , A.END_DT , B.START_DT , B.END_DT FROM PS_PROJECT A , PS_PROJ_ACTIVITY B , PS_PC_OPRID_PRJACT MYP WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT = MYP.BUSINESS_UNIT AND A.PROJECT_ID = MYP.PROJECT_ID AND A.EFF_STATUS = 'A' AND B.EFF_STATUS = 'A' AND B.COSTING_ACT_SW = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_CA_DETAIL_PROJ C , PS_CA_DETAIL D WHERE B.BUSINESS_UNIT =C.BUSINESS_UNIT_PC AND B.PROJECT_ID = C.PROJECT_ID AND B.ACTIVITY_ID = C.ACTIVITY_ID AND C.CONTRACT_NUM = D.CONTRACT_NUM AND C.CONTRACT_LINE_NUM = D.CONTRACT_LINE_NUM AND D.PRICING_STRUCTURE = 'RATE') |
| # | 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: SP_PROJ_NONVW |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PC_ACT_TRAN_VW |
| 4 | OPRID2 |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 8 | ACT_END_DT | Date(10) | DATE | Activity End Date |