GPAU_ADV_TYPE (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.

GPAU_ADV_TYPE

(SQL Table)

Absence Advance Payment Option

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

Related Language Record: GPAU_ADVTYP_LNG

Parent Record Of GPAU_ADVTYP_VW GPAU_ADV_RUNTYP GPAU_ADV_TAKE GPAU_NRP_ADV_AD GPAU_NRP_ADV_VW GPNZ_ADV_RUNTYP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPAU_ADV_DESCR Character(50) VARCHAR2(50) NOT NULL This is a description of the Advance Type.

3 GPAU_ADV_SHORTDESC Character(10) VARCHAR2(10) NOT NULL This is a description of the Advance Type.

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

5 GPAU_CAL_ORIDE_SW Character(1) VARCHAR2(1) NOT NULL This option determines whether the operator is able to select the Calendar Group in which advance payments are to be calculated for an Absence Event.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAU_ADVANCE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This code identifies options used in calculating advance payments for absence events.
2	GPAU_ADV_DESCR	Character(50)	VARCHAR2(50) NOT NULL	This is a description of the Advance Type.
3	GPAU_ADV_SHORTDESC	Character(10)	VARCHAR2(10) NOT NULL	This is a description of the Advance Type.
4	GPAU_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 Default Value: 30
5	GPAU_CAL_ORIDE_SW	Character(1)	VARCHAR2(1) NOT NULL	This option determines whether the operator is able to select the Calendar Group in which advance payments are to be calculated for an Absence Event. Y/N Table Edit Default Value: N