GPCH_OTA_VW(SQL View) |
Index Back |
|---|---|
Approve Srch for Overtime ReqThis is the search record used for the Approve EE Overtime Request transaction. |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.GPCH_ROW_NUM , O.OPRID , B.NAME , A.ACTION_DT_SS , A.GPCH_BEGIN_DATE , A.GPCH_END_DATE , A.GPCH_STATUS , C.EMPLID_TO FROM PS_GPCH_OT_DATA A , PS_PERSON_NAME B , PS_GPCH_OT_STATUS C , PSOPRDEFN O WHERE A.EMPLID=B.EMPLID AND A.EMPLID=C.EMPLID AND C.EMPLID_TO = O.EMPLID AND A.EMPL_RCD=C.EMPL_RCD AND A.GPCH_ROW_NUM=C.GPCH_ROW_NUM AND C.GPCH_WF_ACTION = ' ' AND C.CURRENT_STEP > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | GPCH_ROW_NUM |
Number(5,0) | INTEGER NOT NULL | Row Number |
| 4 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
| 7 | GPCH_BEGIN_DATE | Date(10) | DATE | Begin Date |
| 8 | GPCH_END_DATE | Date(10) | DATE | End Date |
| 9 | GPCH_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status
AAP=Approved automatically AFA=Awaiting final approval APC=Approved with Change APV=Approved AWC=Approved with change CAN=Cancelled CNL=Cancelled CPR=Cancelled DNY=Denied ERR=Error - Contact Administrator PRC=Processed PWC=Processed with change REW=Rework required SAV=Saved SUB=Submitted |
| 10 | EMPLID_TO | Character(11) | VARCHAR2(11) NOT NULL | Empl ID To |