PV_APPMG_SC_VW(SQL View) |
Index Back |
---|---|
Approve Requisition Submit ConApprove Requisition Submit Confirmation Action View |
SELECT FIELDVALUE FROM PSXLATITEM WHERE FIELDNAME = 'PV_APP_ACT_STS' AND FIELDVALUE IN ('A','D','B','H') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PV_APP_ACT_STS | Character(4) | VARCHAR2(4) NOT NULL |
Action/Status
A=Approve A1=Approved B=Pushback B1=Pushed Back D=Deny D1=Denied H=Hold H1=On Hold P=Pending P1=See Lines X=Cancelled |