GPNZ_ABSADV_SEG (SQL Table)	Index Back
Absence Advance Trigger record This table is used to create segmentation triggers when required for absences paid in advance. Rows will be inserted here with effective date of Absence Begin or Absence End date +1 when a partial period is to be advanced so that segmentation triggers can be created for those dates.

GPNZ_ABSADV_SEG

(SQL Table)

Absence Advance Trigger record

This table is used to create segmentation triggers when required for absences paid in advance. Rows will be inserted here with effective date of Absence Begin or Absence End date +1 when a partial period is to be advanced so that segmentation triggers can be created for those dates.

# 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 Rcd Nbr

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 PYE_RUN_NUM Number(8,0) INTEGER NOT NULL Number to link to Payee Run Table

#	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 Rcd Nbr
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table