ABS_PAREE_VW_UK (SQL View)	Index Back
UK Parental Leave by Employee Used in the inquiry by employee of Parental Leave absences in the UK.

ABS_PAREE_VW_UK

(SQL View)

UK Parental Leave by Employee

Used in the inquiry by employee of Parental Leave absences in the UK.

SELECT EMPLID , EMPL_RCD , DEPENDENT_BENEF , ABSENCE_CODE , BEGIN_DT , RETURN_DT , DURATION_DAYS , ABS_DUR_WEEKS_UK , ABS_POSTPND_LVE_UK FROM PS_ABSENCE_HIST WHERE ABSENCE_TYPE = 'PAR'

# 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 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

4 ABSENCE_CODE Character(3) VARCHAR2(3) NOT NULL Absence Code

5 BEGIN_DT Date(10) DATE Begin Date

6 RETURN_DT Date(10) DATE Return Date

7 DURATION_DAYS Number(8,3) DECIMAL(7,3) NOT NULL Duration (Days)

8 ABS_DUR_WEEKS_UK Number(3,0) SMALLINT NOT NULL Keeps absence duration in weeks.

9 ABS_POSTPND_LVE_UK Character(1) VARCHAR2(1) NOT NULL Indicates if UK Parental Leave absence has been postponed.

#	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	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
4	ABSENCE_CODE	Character(3)	VARCHAR2(3) NOT NULL	Absence Code
5	BEGIN_DT	Date(10)	DATE	Begin Date
6	RETURN_DT	Date(10)	DATE	Return Date
7	DURATION_DAYS	Number(8,3)	DECIMAL(7,3) NOT NULL	Duration (Days)
8	ABS_DUR_WEEKS_UK	Number(3,0)	SMALLINT NOT NULL	Keeps absence duration in weeks.
9	ABS_POSTPND_LVE_UK	Character(1)	VARCHAR2(1) NOT NULL	Indicates if UK Parental Leave absence has been postponed.