HGA_EVENTAWE_VW

(SQL View)
Index Back

Absence Event 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 AE.TRANSACTION_NBR , AE.EMPLID , AE.EMPL_RCD , AE.BGN_DT , AE.PIN_TAKE_NUM , AE.END_DT , AE.ORIG_BEGIN_DT , AE.ABS_ENTRY_SRC , AE.PRC_EVT_ACTN_OPTN , AE.VOIDED_IND , AE.ABSENCE_REASON , AE.BEGIN_DAY_HRS , AE.BEGIN_DAY_HALF_IND , AE.END_DAY_HRS , AE.END_DAY_HALF_IND , AE.ALL_DAYS_IND , AE.START_TIME , AE.END_TIME , AE.START_TIME2 , AE.END_TIME2 , AE.EVT_CONFIG1 , AE.EVT_CONFIG2 , AE.EVT_CONFIG3 , AE.EVT_CONFIG4 , AE.EVT_CONFIG1_DT , AE.EVT_CONFIG2_DT , AE.EVT_CONFIG3_DT , AE.EVT_CONFIG4_DT , AE.EVT_CONFIG1_DEC , AE.EVT_CONFIG2_DEC , AE.EVT_CONFIG3_DEC , AE.EVT_CONFIG4_DEC , AE.EVT_CONFIG1_MON , AE.EVT_CONFIG2_MON , AE.EVT_CONFIG3_MON , AE.EVT_CONFIG4_MON , AE.CURRENCY_CD1 , AE.CURRENCY_CD2 , AE.CURRENCY_CD3 , AE.CURRENCY_CD4 , AE.MANAGER_APPR_IND , AE.OVRD_ENT_VAL , AE.OVRD_ADJ_VAL , AE.CAL_RUN_ID , AE.PYE_RUN_NUM , AE.LAST_UPDT_DT , AE.PROCESS_DT , AE.ABS_EVT_FCST_VAL , AE.FCST_DTTM , AE.DURATION_ABS , AE.DURATION_DYS , AE.DURATION_HOURS , AE.ACTION_DT_SS , AE.WF_STATUS , AE.TRANSACTION_NBR_EA , PIN.DESCR , SS.UNIT_TYPE , AE.FIRST_PROC_DT , AE.COMMENTS ,SS.EXCL_HOLIDAYS ,SS.EXCL_NON_WORK ,SS.START_END_HOL_RULE ,SS.START_END_OFF_RULE ,SS.REASON_REQUIRED ,SS.ALLOW_PARTIAL_DAYS ,SS.PARTIAL_DAYS_OPTN ,SS.FCST_IND ,SS.FCST_REQ_SUBMIT ,SS.FCST_REQ_APPROVAL , SS.FCST_MESSAGE ,SS.EOAWPRCS_ID ,SS.EOAWDEFN_ID , ST.OPRID , ST.EOAWSTEP_STATUS ,DAT.COUNTRY ,DAT.ELIG_GRP , PERS.LAST_NAME , PERS.NAME , SS.BAL_ACCUM_DISP_OPT , SS.CURR_BAL_ACCUM , EMPL.DEPTID , EMPL.HR_STATUS , EMPL.GP_PAYGROUP , EMPL.PAYGROUP , EMPL.OPRID FROM PS_GP_ABS_EVENT AE , PS_GP_PIN PIN ,PS_GP_ABS_SS SS , PS_GP_ABS_SS_DAT DAT , PS_PERSON_NAME PERS , PS_EMPLMT_SRCH_GBL EMPL , PS_GP_ABSSS_V_XREF X , PS_EOAW_STEP_VW ST WHERE SS.PIN_TAKE_NUM = AE.PIN_TAKE_NUM AND DAT.TRANSACTION_NBR = AE.TRANSACTION_NBR AND DAT.COUNTRY = SS.COUNTRY AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND AE.EMPLID = PERS.EMPLID AND AE.EMPLID = EMPL.EMPLID AND AE.EMPL_RCD = EMPL.EMPL_RCD AND %EffdtCheck(GP_ABS_SS, SS, AE.BGN_DT) AND X.EOAWTHREAD_ID = ST.EOAWTHREAD_ID AND X.EOAWPRCS_ID = ST.EOAWPRCS_ID AND AE.TRANSACTION_NBR = X.TRANSACTION_NBR AND X.EOAWPARENT_THREAD = ( SELECT MAX(Y.EOAWPARENT_THREAD) FROM PS_GP_ABSSS_V_XREF Y WHERE X.TRANSACTION_NBR = Y.TRANSACTION_NBR )

# 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 Record
4 BGN_DT Date(10) DATE NOT NULL 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 NOT NULL end date
7 ORIG_BEGIN_DT Date(10) DATE original begin date

Default Value: GP_ABS_EVENT.BGN_DT

8 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
9 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
N=Normal
V=Void
10 VOIDED_IND Character(1) VARCHAR2(1) NOT NULL Voided Indicator
11 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
12 BEGIN_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Partial Hours
13 BEGIN_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL indicates whether first day of an absence event began counts as half a day

Y/N Table Edit

Default Value: N

14 END_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL partial hours end
15 END_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL half day end indicator

Y/N Table Edit

Default Value: N

16 ALL_DAYS_IND Character(1) VARCHAR2(1) NOT NULL All Days Indicator
N=Apply To Begin Day Only
Y=Apply To All Days

Default Value: N

17 START_TIME Time(15) TIMESTAMP Interview Start Time
18 END_TIME Time(15) TIMESTAMP Interview End Time
19 START_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing Start Time of Absence Take
20 END_TIME2 Time(15) TIMESTAMP Contains End Time. Primarly created for storing End Time of Absence Take
21 EVT_CONFIG1 Character(10) VARCHAR2(10) NOT NULL config char
22 EVT_CONFIG2 Character(10) VARCHAR2(10) NOT NULL config char
23 EVT_CONFIG3 Character(10) VARCHAR2(10) NOT NULL config char
24 EVT_CONFIG4 Character(10) VARCHAR2(10) NOT NULL config char
25 EVT_CONFIG1_DT Date(10) DATE config date
26 EVT_CONFIG2_DT Date(10) DATE config date
27 EVT_CONFIG3_DT Date(10) DATE config date
28 EVT_CONFIG4_DT Date(10) DATE config date
29 EVT_CONFIG1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec
30 EVT_CONFIG2_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec
31 EVT_CONFIG3_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec
32 EVT_CONFIG4_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL config dec
33 EVT_CONFIG1_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL config monetary
34 EVT_CONFIG2_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL config monetary
35 EVT_CONFIG3_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL Config Monetary 3
36 EVT_CONFIG4_MON Signed Number(20,6) DECIMAL(18,6) NOT NULL config monetary
37 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: CURRENCY_CD_TBL

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

Prompt Table: CURRENCY_CD_TBL

41 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
42 OVRD_ENT_VAL Signed Number(12,6) DECIMAL(10,6) NOT NULL Override Entitlement Amoung
43 OVRD_ADJ_VAL Signed Number(8,2) DECIMAL(6,2) NOT NULL Override Adjustment Amoung
44 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
45 PYE_RUN_NUM Number(8,0) INTEGER NOT NULL Number to link to Payee Run Table
46 LAST_UPDT_DT Date(10) DATE Date of last Update
47 PROCESS_DT Date(10) DATE Process Date
48 ABS_EVT_FCST_VAL Character(30) VARCHAR2(30) NOT NULL This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.
49 FCST_DTTM DateTime(26) TIMESTAMP This field is used on the GP_ABS_EVENT to record the last time forecasting was run for this event.
50 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
51 DURATION_DYS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements
52 DURATION_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Duration (Hours)
53 ACTION_DT_SS Date(10) DATE Date Submitted
54 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
55 TRANSACTION_NBR_EA Number(15,0) DECIMAL(15) NOT NULL The Extendned Absence transaction number

Default Value: 0

56 DESCR Character(30) VARCHAR2(30) NOT NULL Description
57 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours
58 FIRST_PROC_DT Date(10) DATE GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation.
59 COMMENTS Long Character CLOB Comment
60 EXCL_HOLIDAYS Character(1) VARCHAR2(1) NOT NULL This fields indicates if the end date calculation needs to substract holidays
N=No
Y=Yes

Default Value: N

61 EXCL_NON_WORK Character(1) VARCHAR2(1) NOT NULL This fields indicates if the end date calculation needs to substract days off
N=No
Y=Yes

Default Value: N

62 START_END_HOL_RULE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether the start or end date of an absence request can be scheduled for a holiday.
63 START_END_OFF_RULE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether the start or end date can be scheduled for an off-day
64 REASON_REQUIRED Character(1) VARCHAR2(1) NOT NULL This field indicates whether the Reason field is required.

Y/N Table Edit

Default Value: N

65 ALLOW_PARTIAL_DAYS Character(1) VARCHAR2(1) NOT NULL This field indicates whether partial days are allowed for a particular absence take

Y/N Table Edit

Default Value: N

66 PARTIAL_DAYS_OPTN Character(1) VARCHAR2(1) NOT NULL This field will be used to indicate what types of partial days are allowed
B=Partial Hours and Half Days
D=Half Days
H=Partial Hours
N=None

Default Value: N

67 FCST_IND Character(1) VARCHAR2(1) NOT NULL This field is used on the GP_PIN record to indicate whether or not the element should be processed during Forecasting.

Y/N Table Edit

Default Value: N

68 FCST_REQ_SUBMIT Character(1) VARCHAR2(1) NOT NULL This field indicates whether Forecasting is required to submit an absence request.

Y/N Table Edit

Default Value: N

69 FCST_REQ_APPROVAL Character(1) VARCHAR2(1) NOT NULL This field indicates whether Forecasting is required to approve an absence request.

Y/N Table Edit

Default Value: N

70 FCST_MESSAGE Character(1) VARCHAR2(1) NOT NULL This field is used to indicate which type of Forecasting message to use as a result of Forecasting being complete, default message or a customized message.
C=Customized Message
D=Default Message
71 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
72 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
73 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
74 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
75 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
76 ELIG_GRP Character(10) VARCHAR2(10) NOT NULL eligibility group
77 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
78 NAME Character(50) VARCHAR2(50) NOT NULL Name
79 BAL_ACCUM_DISP_OPT Character(1) VARCHAR2(1) NOT NULL This field will dictate how the current balance will be calculated and displayed on the self-service pages.
N=Not Summarized
S=Summarized
80 CURR_BAL_ACCUM Number(8,0) INTEGER NOT NULL This field is used to contain the pin number of the accumulator that will represent the current balance of the entitlements.
81 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
82 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive
83 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
84 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
85 OPRID2 Character(30) VARCHAR2(30) NOT NULL User ID