PGM_PRJ_CR_STAT(SQL View) |
Index Back |
|---|---|
Change request statisticsTo display the change request statistics on the manager workbench page |
| SELECT ' ' ,' ' ,0 ,0 FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHANGE_REQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Change Request Type
B=Budget E=ETC P=Project |
| 2 | PGM_RESOURCE | Character(30) | VARCHAR2(30) NOT NULL | Change Request Type |
| 3 | PC_TOT_ITM_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Total Item Quantity |
| 4 | PC_TOT_PER_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Total Period Quantity |