GPFR_ABS_EVENT

(SQL View)
 Index Back

Absence Event list

GPFR absence event list

SELECT AEVT.EMPLID ,AEVT.EMPL_RCD ,AEVT.BGN_DT ,AEVT.PIN_TAKE_NUM ,AEVT.END_DT ,AEVT.ORIG_BEGIN_DT ,AEVT.ABS_ENTRY_SRC ,AEVT.VOIDED_IND ,AEVT.ABSENCE_REASON ,AEVT.EVT_CONFIG1 ,AEVT.EVT_CONFIG2 ,AEVT.EVT_CONFIG3 ,AEVT.EVT_CONFIG4 ,AEVT.CURRENCY_CD1 ,AEVT.CURRENCY_CD2 ,AEVT.CURRENCY_CD3 ,AEVT.CURRENCY_CD4 ,AEVT.MANAGER_APPR_IND ,GPIN.PIN_NM ,GPIN.PIN_CATEGORY ,GPIN.PIN_INDUSTRY ,GPIN.PIN_CUSTOM1 ,GPIN.PIN_CUSTOM2 ,GPIN.PIN_CUSTOM3 ,GPIN.PIN_CUSTOM4 ,GPIN.PIN_CUSTOM5 ,ATK.EFFDT ,ATK.EFF_STATUS ,ATK.ABS_TYPE_OPTN ,ATK.TAKE_CONFIG1 ,ATK.TAKE_CONFIG2 ,ATK.TAKE_CONFIG3 ,ATK.TAKE_CONFIG4 FROM PS_GP_ABS_EVENT AEVT ,PS_GP_PIN GPIN ,PS_GP_ABS_TAKE ATK WHERE AEVT.PIN_TAKE_NUM = GPIN.PIN_NUM AND GPIN.PIN_NUM = ATK.PIN_NUM AND ATK.EFFDT = ( SELECT MAX(ATK1.EFFDT) FROM PS_GP_ABS_TAKE ATK1 WHERE ATK1.PIN_NUM = ATK.PIN_NUM AND ATK1.EFFDT <= %CurrentDateIn AND ATK1.EFF_STATUS = 'A')

# 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 end date
6 ORIG_BEGIN_DT Date(10) DATE original begin date
7 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
1=Administrator
2=Time & Labor
3=Third Party
4=Employee Self Service
5=Manager Self Service
6=Employee Timesheet
7=Manager Timesheet
8 VOIDED_IND Character(1) VARCHAR2(1) NOT NULL Voided Indicator

Y/N Table Edit

9 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
10=Vacations

Prompt Table: %GP_EDIT_FLD1

10 EVT_CONFIG1 Character(10) VARCHAR2(10) NOT NULL config char
11 EVT_CONFIG2 Character(10) VARCHAR2(10) NOT NULL config char
12 EVT_CONFIG3 Character(10) VARCHAR2(10) NOT NULL config char
13 EVT_CONFIG4 Character(10) VARCHAR2(10) NOT NULL config char
14 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

15 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

16 CURRENCY_CD3 Character(3) VARCHAR2(3) NOT NULL currency code

Prompt Table: CURRENCY_CD_TBL

17 CURRENCY_CD4 Character(3) VARCHAR2(3) NOT NULL currency code

Prompt Table: CURRENCY_CD_TBL

18 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved

Y/N Table Edit

19 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
20 PIN_CATEGORY Character(4) VARCHAR2(4) NOT NULL Element Category

Prompt Table: GP_PIN_CATEGORY

21 PIN_INDUSTRY Character(4) VARCHAR2(4) NOT NULL Element Industry

Prompt Table: GP_PIN_INDUSTRY

22 PIN_CUSTOM1 Character(20) VARCHAR2(20) NOT NULL Customer FIelds
23 PIN_CUSTOM2 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM2
24 PIN_CUSTOM3 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM3 fields
25 PIN_CUSTOM4 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM4
26 PIN_CUSTOM5 Character(20) VARCHAR2(20) NOT NULL PIN_CUSTOM5
27 EFFDT Date(10) DATE NOT NULL Effective Date
28 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
29 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type

Prompt Table: GP_ABS_TYPE

30 TAKE_CONFIG1 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
31 TAKE_CONFIG2 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
32 TAKE_CONFIG3 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
33 TAKE_CONFIG4 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take