HGA_APPR_AW4_VW (SQL View)	Index Back
Absence Event View Get Absence Event and other related info. Used in Page Composer.

HGA_APPR_AW4_VW

(SQL View)

Absence Event View

Get Absence Event and other related info. Used in Page Composer.

SELECT DAT.TRANSACTION_NBR , DAT.EMPLID , DAT.EMPL_RCD , DAT.BGN_DT , DAT.PIN_TAKE_NUM , DAT.END_DT , AE.BGN_DT , AE.END_DT , ' ' , DAT.COUNTRY , rtrim(PIN.DESCR) , SS.UNIT_TYPE , AE.DURATION_HOURS , AE.DURATION_DYS , AE.ABS_EVT_FCST_VAL , AE.FCST_DTTM , SS.FCST_IND , CN.FCST_REQ_FLAG FROM PS_GP_ABS_SS SS , PS_GP_ABS_SS_DAT DAT , PS_GP_ABS_EVENT AE , PS_GP_PIN PIN , PSXLATITEM XLAT , PS_GP_ABS_SS_CNTRY CN 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 SS.UNIT_TYPE = XLAT.FIELDVALUE AND XLAT.FIELDNAME='UNIT_TYPE' AND %EffdtCheck(PSXLATITEM XLATA,XLAT,%CurrentDateIn) AND %EffdtCheck(GP_ABS_SS, SS, AE.BGN_DT) AND CN.COUNTRY = DAT.COUNTRY AND %EffdtCheck(GP_ABS_SS_CNTRY, CN, AE.BGN_DT)

# 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 ABS_BEGIN_DT Date(10) DATE Absence Begin Date

8 ABS_END_DT Date(10) DATE Absence End Date

9 ABSENCE_DURATION Character(15) VARCHAR2(15) NOT NULL Absence Duration

10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

11 HGA_ABS_DESCR Character(100) VARCHAR2(100) NOT NULL Absence Name

12 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours

13 DURATION_HRS Number(7,2) DECIMAL(6,2) NOT NULL Duration Hrs

14 DURATION_DYS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements

15 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.

16 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.

17 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.

18 FCST_REQ_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether Forecasting a request is enabled.

#	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	ABS_BEGIN_DT	Date(10)	DATE	Absence Begin Date
8	ABS_END_DT	Date(10)	DATE	Absence End Date
9	ABSENCE_DURATION	Character(15)	VARCHAR2(15) NOT NULL	Absence Duration
10	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
11	HGA_ABS_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Absence Name
12	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
13	DURATION_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration Hrs
14	DURATION_DYS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
15	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.
16	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.
17	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.
18	FCST_REQ_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether Forecasting a request is enabled.