EX_SES_NAME_VW(SQL View) |
Index Back |
|---|---|
SF Expense Approver Name ViewPTSF Expense Approver Name View |
| SELECT A.SHEET_ID , A.OPRID , D.NAME FROM %Table(EX_SES_APRVR_VW) A , PSOPRDEFN B , %Table(PERSONAL_DATA) D WHERE A.OPRID = B.OPRID AND B.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 |