PGM_MRS_ACT(SQL View) |
Index Back |
|---|
| SELECT B.BUSINESS_UNIT ,B.PROJECT_ID ,B.ACTIVITY_ID ,A.TEAM_MEMBER ,A.START_DT ,A.END_DT ,1 ,C.START_DT ,C.END_DT FROM PS_PROJ_TEAM_SCHED A , PS_PROJ_ACT_TEAM B , PS_PROJ_ACTIVITY C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.TEAM_MEMBER = B.TEAM_MEMBER AND A.TEAM_MEMBER_CLASS = 'L' AND A.TEAM_MEMBER_IND = 'E' AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND B.ACTIVITY_ID = C.ACTIVITY_ID |
| # | 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 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | AVAIL_UNITS | Number(6,0) | INTEGER NOT NULL | Availability Units |
| 8 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 9 | ACT_END_DT | Date(10) | DATE | Activity End Date |