BUSINESS_UNIT_PCPROJECT_IDPrompt Table: PROJ_SCRTY_SRCH
Prompt Table: PC_INT_TMPL
GM_PROJECT1_VW(SQL View) |
Index Back |
|---|---|
Grants Projects ViewThe view provides an easy to use on-line prompt for the project table and is used in locations within the Projects application since it references the PC Business Unit and not setid. |
| SELECT A.BUSINESS_UNIT ,A.PROJECT_ID ,A.DESCR ,A.INTEGRATION_TMPL ,A.START_DT ,A.END_DT FROM PS_PROJECT A WHERE EXISTS ( SELECT 'X' FROM PS_CA_DETAIL_PROJ C WHERE C.BUSINESS_UNIT_PC = A.BUSINESS_UNIT AND C.PROJECT_ID = A.PROJECT_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJ_SCRTY_SRCH |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | INTEGRATION_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Integration
Prompt Table: PC_INT_TMPL |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |