GP_ABSSS_PNDG_2(SQL View) |
Index Back |
|---|---|
Absence ManagementThis view is intended to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id |
| SELECT A.TRANSACTION_NBR , A.EMPLID , A.EMPL_RCD , A.BGN_DT , A.PIN_TAKE_NUM , A.END_DT , A.ORIG_EMPLID , A.ORIG_EMPL_RCD , A.ORIG_BEGIN_DT , A.ORIG_PIN_TAKE_NUM , A.ORIG_END_DT , A.COUNTRY , A.ELIG_GRP , B.PTAFPRCS_ID , B.PTAFDEFN_ID , C.ACTION_DT_SS , C.WF_STATUS , C.DURATION_ABS FROM PS_GP_ABS_SS_DAT A , PS_GP_ABS_SS B , PS_GP_ABS_EVENT C WHERE C.EMPLID = A.ORIG_EMPLID AND C.EMPL_RCD = A.ORIG_EMPL_RCD AND C.BGN_DT = A.ORIG_BEGIN_DT AND C.PIN_TAKE_NUM = A.ORIG_PIN_TAKE_NUM AND C.END_DT = A.ORIG_END_DT AND C.TRANSACTION_NBR = A.TRANSACTION_NBR AND C.ABS_ENTRY_SRC <> '1' AND B.COUNTRY = A.COUNTRY AND B.PIN_TAKE_NUM = A.PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, B, %CURRENTDATEIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRANSACTION_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | BGN_DT |
Date(10) | DATE | Begin Date |
| 5 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |
| 6 | END_DT |
Date(10) | DATE | end date |
| 7 | ORIG_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Originating Emplid |
| 8 | ORIG_EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 9 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |
| 10 | ORIG_PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 11 | ORIG_END_DT | Date(10) | DATE | Original END_DT before adjust |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 13 | ELIG_GRP | Character(10) | VARCHAR2(10) NOT NULL | eligibility group |
| 14 | PTAFPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 15 | PTAFDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Definition ID |
| 16 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
| 17 | 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 |
| 18 | DURATION_ABS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration field containing 2 decimals to handle absence requirements |