BUSINESS_UNITPROJECT_IDCHANGE_REQ_IDA=Approved
D=Declined
P=Pending
R=Returned
S=Submitted
PGM_CHC_BUD_STS(SQL View) |
Index Back |
|---|---|
Budget Change Request StatusThis view returns information on budget change requests, including status and new amounts. |
| SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.CHANGE_REQ_ID , A.CHANGE_REQ_STATUS , B.CST_BUD_ID_NEW , B.CST_BUD_AMT_NEW , B.REV_BUD_ID_NEW , B.REV_BUD_AMT_NEW FROM PS_PGM_CHC_REQ_HDR A , PS_PGM_CHC_REQ_BUD B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.CHANGE_REQ_ID = B.CHANGE_REQ_ID AND A.CHANGE_REQ_TYPE = 'B' |
| # | 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 | CHANGE_REQ_ID |
Character(15) | VARCHAR2(15) NOT NULL | Change Request ID |
| 4 | CHANGE_REQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Request Status
A=Approved D=Declined P=Pending R=Returned S=Submitted |
| 5 | CST_BUD_ID_NEW | Number(3,0) | SMALLINT NOT NULL | New Budget Plan |
| 6 | CST_BUD_AMT_NEW | Number(27,3) | DECIMAL(26,3) NOT NULL | New Cost Budget Amount |
| 7 | REV_BUD_ID_NEW | Number(3,0) | SMALLINT NOT NULL | New Budget Plan |
| 8 | REV_BUD_AMT_NEW | Number(27,3) | DECIMAL(26,3) NOT NULL | Revenue Budget Amount |