HCSC_AWEPRCS_VW(SQL View) |
Index Back |
---|---|
AWE Audit ReportView of current approval processes |
SELECT A.EOAWPRCS_ID , A.EOAWDEFN_ID FROM PS_EOAW_PRCS A WHERE %EffdtCheck(EOAW_PRCS,A,%CURRENTDATEIN) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
2 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |