PR_STATUS1=New
2=Denied
3=Submitted
4=Pending
5=Approved
6=Vouchered
7=Cancelled
PR_STATUS_VW(SQL View) |
Index Back |
|---|---|
Payment Request |
| SELECT pr_status , COUNT(*) FROM PS_PR_REQUEST GROUP BY PR_STATUS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PR_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
To detemine Payment Request Status
1=New 2=Denied 3=Submitted 4=Pending 5=Approved 6=Vouchered 7=Cancelled |
| 2 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |