BUSINESS_UNITPROJECT_IDACTIVITY_IDPOOL_IDSTART_DATEPGM_POOLCAC_PRJ(SQL View) |
Index Back |
|---|---|
Cache population viewPopulates the Cache Table with Project Pool values. Used in the App Engine |
| SELECT P.BUSINESS_UNIT , P.PROJECT_ID , ACT.ACTIVITY_ID , P.POOL_ID , G.EMPLID , G.START_DATE , G.END_DATE , PR.START_DT , PR.END_DT FROM %Table(PGM_PROJ_POOL) P , %Table(RS_MEMBER_GRID) G , %Table(PROJECT) PR , %Table(PROJ_ACTIVITY) ACT WHERE P.BUSINESS_UNIT = PR.BUSINESS_UNIT AND P.PROJECT_ID = PR.PROJECT_ID AND P.BUSINESS_UNIT = ACT.BUSINESS_UNIT AND P.PROJECT_ID = ACT.PROJECT_ID AND P.POOL_ID = G.POOL_ID AND PR.ENFORCE_TYPE = 'R' AND PR.SUMMARY_PRJ = 'N' AND PR.EFF_STATUS = 'A' AND ACT.EFF_STATUS = 'A' AND ACT.COSTING_ACT_SW = 'Y' AND (G.START_DATE BETWEEN PR.START_DT AND PR.END_DT OR G.END_DATE BETWEEN PR.START_DT AND PR.END_DT OR (G.START_DATE < PR.START_DT AND G.END_DATE IS NULL) OR (G.START_DATE < PR.START_DT AND G.END_DATE > PR.END_DT)) |
| # | 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 |
| 3 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | POOL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | START_DATE |
Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 7 | END_DATE | Date(10) | DATE | End Date |
| 8 | START_DT | Date(10) | DATE | Start Date |
| 9 | END_DT | Date(10) | DATE | End Date |