GPNZ_ADV_RUNTYP (SQL Table)	Index Back
Absence Advance Payment Option This defines options used in determining the periods to be calculated in advance for an absence event.

GPNZ_ADV_RUNTYP

(SQL Table)

Absence Advance Payment Option

This defines options used in determining the periods to be calculated in advance for an absence event.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPNZ_ADVANCE_TYPE Character(10) VARCHAR2(10) NOT NULL This code identifies options used in calculating advance payments for absence events.

2 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
Prompt Table: GP_RUN_TYPE

3 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
Default Value: 10

4 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
Default Value: 10

5 GPNZ_ADVTYP_GAP Character(2) VARCHAR2(2) NOT NULL This is used when calculating payments in advance for absence events. It defines whether a "Gap" period preceding the absence should be calculated in advance or not. (A "Gap" is a period preceeding the absence where the payment date is after the beginning of the absence.)
10=Pay on Return
20=Pay in Advance
30=Pay in Normal Calendar Group
Default Value: 10

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPNZ_ADVANCE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This code identifies options used in calculating advance payments for absence events.
2	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name Prompt Table: GP_RUN_TYPE
3	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 Default Value: 10
4	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 Default Value: 10
5	GPNZ_ADVTYP_GAP	Character(2)	VARCHAR2(2) NOT NULL	This is used when calculating payments in advance for absence events. It defines whether a "Gap" period preceding the absence should be calculated in advance or not. (A "Gap" is a period preceeding the absence where the payment date is after the beginning of the absence.) 10=Pay on Return 20=Pay in Advance 30=Pay in Normal Calendar Group Default Value: 10