PGM_PRJ_CR_DET(SQL View) |
Index Back |
|---|---|
Change Request detailsTo display the change request details on the manager workbench page |
| SELECT ' ' ,' ' ,' ' ,%DateNull ,' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHANGE_REQ_ID | Character(15) | VARCHAR2(15) NOT NULL | Change Request ID |
| 2 | PRJ_CHNG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 3 | CHANGE_REQ_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Change Request Type
B=Budget E=ETC P=Project |
| 4 | APPROVER_ACTN_DT | Date(10) | DATE | The Date on which the approver takes necessary action |
| 5 | APPROVED_BY | Character(11) | VARCHAR2(11) NOT NULL | APPROVED_BY |