GP_ABS_SS_APPR(SQL View) |
Index Back |
|---|---|
Self Service Approval StatusSelf Service Absences Approval Status |
| SELECT AE.EMPLID , AE.EMPL_RCD , AE.BGN_DT , AE.PIN_TAKE_NUM , AE.END_DT , AE.ACTION_DT_SS , AE.WF_STATUS , STA.OPRID FROM PS_GP_ABS_EVENT AE , PS_GP_ABS_SS_STA STA WHERE AE.TRANSACTION_NBR = STA.TRANSACTION_NBR AND AE.EMPLID=STA.EMPLID AND AE.EMPL_RCD = STA.EMPL_RCD AND AE.BGN_DT = STA.BGN_DT AND AE.PIN_TAKE_NUM = STA.PIN_TAKE_NUM AND AE.END_DT = STA.END_DT |
| # | 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 Rcd Nbr |
| 3 | BGN_DT |
Date(10) | DATE NOT NULL | Begin Date |
| 4 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
| 5 | END_DT |
Date(10) | DATE NOT NULL | end date |
| 6 | ACTION_DT_SS |
Date(10) | DATE NOT NULL | Termination Date |
| 7 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved |
| 8 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |