HGA_EA_CHABS_VW

(SQL View)
 Index Back

EA FL Appr Child Absence View

This is a shadow record of the GP_ABS_EVENT; This vw is used to populate the grid of events. Needs to review this view when there is change to GP_ABS_EVENT

SELECT AWE.EMPLID , AWE.EMPL_RCD , AE.TRANSACTION_NBR , AE.TRANSACTION_NBR_EA , AE.BGN_DT , AE.PIN_TAKE_NUM , AE.END_DT , PIN.DESCR , %Sql(HR_HT_EMAIL_DATE,AE.BGN_DT) , %Sql(HR_HT_EMAIL_DATE,AE.END_DT) , AE.ABS_ENTRY_SRC ,AE.ABSENCE_REASON ,' ' , G.XLATLONGNAME , AE.DURATION_ABS , SS.UNIT_TYPE , %Sql(FUNCLIB_HR_CHAR, AE.DURATION_ABS) %Concat ' ' %Concat G1.XLATLONGNAME , AE.WF_STATUS , G2.XLATLONGNAME ,' ' ,' ' ,' ' ,SS.COUNTRY , AE.COMMENTS ,' ' ,' ' , 'EOAW_INFO_ICN' FROM PS_GP_ABS_EA_AWE AWE , PS_GP_ABS_EVENT AE , PS_GP_PIN PIN , PS_GP_ABS_SS SS , PS_GP_ABS_SS_DAT DAT , PSXLATITEM G , PSXLATITEM G1 , PSXLATITEM G2 WHERE AE.EMPLID = AWE.EMPLID AND AE.EMPL_RCD = AWE.EMPL_RCD AND AE.TRANSACTION_NBR = AWE.TRANSACTION_NBR AND AE.TRANSACTION_NBR_EA = AWE.TRANSACTION_NBR_EA AND SS.PIN_TAKE_NUM = AE.PIN_TAKE_NUM AND DAT.TRANSACTION_NBR = AE.TRANSACTION_NBR AND DAT.EMPLID = AE.EMPLID AND DAT.EMPL_RCD = AE.EMPL_RCD AND DAT.COUNTRY = SS.COUNTRY AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, SS, AE.BGN_DT) AND SS.EFF_STATUS = 'A' AND G.FIELDNAME = 'ABS_ENTRY_SRC' AND G.FIELDVALUE = AE.ABS_ENTRY_SRC AND %EffdtCheck(PSXLATITEM, G, %CurrentDateIn) AND G.EFF_STATUS = 'A' AND G1.FIELDNAME = 'UNIT_TYPE' AND G1.FIELDVALUE = SS.UNIT_TYPE AND %EffdtCheck(PSXLATITEM, G1, %CurrentDateIn) AND G1.EFF_STATUS = 'A' AND G2.FIELDNAME = 'WF_STATUS' AND G2.FIELDVALUE = AE.WF_STATUS AND %EffdtCheck(PSXLATITEM, G2, %CurrentDateIn) AND G2.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 Record
3 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.
4 TRANSACTION_NBR_EA Number(15,0) DECIMAL(15) NOT NULL The Extendned Absence transaction number
5 BGN_DT Date(10) DATE NOT NULL Begin Date
6 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

Prompt Table: GP_PIN_ABSTK_VW

7 END_DT Date(10) DATE NOT NULL end date
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 DESCR25 Character(25) VARCHAR2(25) NOT NULL Short description
10 DESCR25_2 Character(25) VARCHAR2(25) NOT NULL Description part 2
11 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
1=Administrator Absence Event
2=Time & Labor
3=Third Party
4=Employee Absence Request
5=Manager Absence Request
6=Employee Timesheet
7=Manager Timesheet
A=Employee Extended Absence
B=Manager Extended Absence
C=Administrator Extended Absence
D=Employee Desktop Integration
12 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
13 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
14 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
15 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
16 ABS_UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Day(s)
H=Hour(s)
17 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
18 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
19 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
20 DESCR5 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
21 DESCR6 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
22 DESCR7 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
24 COMMENTS Long Character CLOB Comment
25 DESCR8 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
26 DESCR_2 Character(30) VARCHAR2(30) NOT NULL Derived Descr
27 EOPCIMAGE_ID Character(30) VARCHAR2(30) NOT NULL Image