GPNZ_LVEADV_VW1 (SQL View)	Index Back
Absence Leave Advance Vw Absence Leave Advance - View

GPNZ_LVEADV_VW1

(SQL View)

Absence Leave Advance Vw

Absence Leave Advance - View

SELECT A.EMPLID , A.EMPL_RCD , A.GPNZ_ADVANCE_TYPE , A.GPNZ_ADV_CAL_RUNID , B. GP_PAYGROUP , B.CAL_ID , C.RUN_TYPE , C.GPNZ_ADVTYP_FIRST , C.GPNZ_ADVTYP_LAST , D.GPNZ_ADV_CAL_OPT FROM PS_GP_ABSEVT_SGPNZ A , PS_GPNZ_ABSADV_CAL B , PS_GPNZ_ADV_RUNTYP C , PS_GPNZ_ADV_TYPE D WHERE A.EMPLID =B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.PIN_TAKE_NUM = B.PIN_TAKE_NUM AND A. BGN_DT = B.BGN_DT AND A.GPNZ_ADVANCE_TYPE = C.GPNZ_ADVANCE_TYPE AND C.GPNZ_ADVANCE_TYPE = D.GPNZ_ADVANCE_TYPE AND C. RUN_TYPE ='KZPAYROLL' AND B.CALC_TYPE ='P'

# 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 GPNZ_ADVANCE_TYPE Character(10) VARCHAR2(10) NOT NULL This code identifies options used in calculating advance payments for absence events.

4 GPNZ_ADV_CAL_RUNID Character(18) VARCHAR2(18) NOT NULL This is the Calendar Group ID in which Advance Payments are to be included for an Absence Event.

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

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

7 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

8 GPNZ_ADVTYP_FIRST Character(2) VARCHAR2(2) NOT NULL This is used when calculating payments in advance for absence event. It defines which part of the period in which the absence begins should be calculated in advance.
10=Advance Whole Period
20=No Advance
30=Advance Absence, Reg in Normal
40=Advance Absence, Reg on Return

9 GPNZ_ADVTYP_LAST Character(2) VARCHAR2(2) NOT NULL This is used when calculating payments in advance for absence events. It defines which part of the period in which the absence ends (if any) should be calculated in advance.
10=Advance Whole Period
20=No Advance
30=Advance Absence, Reg in Normal

10 GPNZ_ADV_CAL_OPT Character(2) VARCHAR2(2) NOT NULL The option chosen here determines how the system will chhoose the Calendar Group in which an Advance should be paid.
10=Period Prior to Absence
20=Period Absence Begins
30=Payment Prior to Absence Begin
40=Payment After Absence Begin

#	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	GPNZ_ADVANCE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This code identifies options used in calculating advance payments for absence events.
4	GPNZ_ADV_CAL_RUNID	Character(18)	VARCHAR2(18) NOT NULL	This is the Calendar Group ID in which Advance Payments are to be included for an Absence Event.
5	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
6	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
7	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
8	GPNZ_ADVTYP_FIRST	Character(2)	VARCHAR2(2) NOT NULL	This is used when calculating payments in advance for absence event. It defines which part of the period in which the absence begins should be calculated in advance. 10=Advance Whole Period 20=No Advance 30=Advance Absence, Reg in Normal 40=Advance Absence, Reg on Return
9	GPNZ_ADVTYP_LAST	Character(2)	VARCHAR2(2) NOT NULL	This is used when calculating payments in advance for absence events. It defines which part of the period in which the absence ends (if any) should be calculated in advance. 10=Advance Whole Period 20=No Advance 30=Advance Absence, Reg in Normal
10	GPNZ_ADV_CAL_OPT	Character(2)	VARCHAR2(2) NOT NULL	The option chosen here determines how the system will chhoose the Calendar Group in which an Advance should be paid. 10=Period Prior to Absence 20=Period Absence Begins 30=Payment Prior to Absence Begin 40=Payment After Absence Begin