EX_APRV_KIB_VW(SQL View) |
Index Back |
|---|---|
Expense Approver Name ViewExpense Approver Name View for Insights |
| SELECT DISTINCT A.EX_DOC_ID , A.OPRID , C.NAME FROM PS_EX_APRVL_HIST A , PS_PERSONAL_DATA C WHERE A.EX_DOC_TYPE = 'S' AND A.ACTION_NAME NOT IN ('SUB', 'DEL', 'RES') AND A.APPROVER_PROFILE <> 'Employee' AND A.EMPLID = C.EMPLID UNION SELECT DISTINCT B.SHEET_ID , B.APPROVAL_OPRID , D.NAME FROM PS_EX_ER_APPR_VW B, PS_PERSONAL_DATA D, PSOPRDEFN E WHERE B.APPROVAL_OPRID = E.OPRID AND E.EMPLID = D.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | APPROVAL_OPRID | Character(30) | VARCHAR2(30) NOT NULL | A system generated value that reflects the operator that approved a given transaction. |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |