GP_ABS_CAL_VW (SQL View)	Index Back
Absence Calendars This view is used to show Absence calendars, i.e. calendars with a Calc-Type of 'A'.

GP_ABS_CAL_VW

(SQL View)

Absence Calendars

This view is used to show Absence calendars, i.e. calendars with a Calc-Type of 'A'.

SELECT A.GP_PAYGROUP , A.CAL_ID FROM PS_GP_CALENDAR A , PS_GP_RUN_TYPE B WHERE A.RUN_TYPE = B.RUN_TYPE AND B.CALC_TYPE='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

2 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
2	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id