PGM_SR_PJ_CNTVW(SQL View) |
Index Back |
|---|---|
Project Counter View of SRThis view works for showing project counter information of status report. |
| SELECT SR.EMPLID ,SR.BUSINESS_UNIT , SR.PROJECT_ID , PROJ.DESCR , COUNT(SR.PROJECT_ID) AS COUNT1 FROM %Table(PC_SR_SUM_DTL) SR , %Table(PROJECT) PROJ WHERE SR.PROJECT_ID = PROJ.PROJECT_ID AND SR.BUSINESS_UNIT = PROJ.BUSINESS_UNIT GROUP BY SR.EMPLID, SR.BUSINESS_UNIT, SR.PROJECT_ID, PROJ.DESCR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | COUNT1 | Number(10,0) | DECIMAL(10) NOT NULL | Counter |