GPNZ_NRP_AB6_VW (SQL View)	Index Back
Absence Advance details This is a sibling of the GP Absence Event record used to hold details of advance payment for an absence.

GPNZ_NRP_AB6_VW

(SQL View)

Absence Advance details

This is a sibling of the GP Absence Event record used to hold details of advance payment for an absence.

SELECT EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM + 50000000 , END_DT , GPNZ_ADVANCE_TYPE , GPNZ_ADV_BGN_DT , GPNZ_ADV_END_DT , GPNZ_ADV_CAL_RUNID , GPNZ_ADV_PYMTDT , GPNZ_ADV_PRD , GPNZ_RET_CAL_RUNID , GPNZ_RET_PYMTDT , GPNZ_RET_PRD , GPNZ_START_SEG_SW , GPNZ_END_SEG_SW , PYE_RUN_NUM FROM PS_GP_ABSEVT_SGPNZ

Parent record: GP_ABS_EVENT

# 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 BGN_DT Date(10) DATE NOT NULL Begin Date

4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_PIN_ABSTK_VW

5 END_DT Date(10) DATE NOT NULL end date

6 GPNZ_ADVANCE_TYPE Character(10) VARCHAR2(10) NOT NULL This code identifies options used in calculating advance payments for absence events.
Prompt Table: GPNZ_ADVTYP_VW

7 GPNZ_ADV_BGN_DT Date(10) DATE The Begin Date used when calculating an Advance for an Absence. This is normally the same as the Begin Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.

8 GPNZ_ADV_END_DT Date(10) DATE The End Date used when calculating an Advance for an Absence. This is normally the same as the End Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.

9 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.
Prompt Table: GPNZ_ADV_RUNTYP

10 GPNZ_ADV_PYMTDT Date(10) DATE This is the date on which the Advance Payment is to be made. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid in advance.

11 GPNZ_ADV_PRD Character(10) VARCHAR2(10) NOT NULL This identifies the Calendar Period to which the Advance Payment is to be attributed.
Prompt Table: GP_CAL_PRD

12 GPNZ_RET_CAL_RUNID Character(18) VARCHAR2(18) NOT NULL This is the Calendar Group ID in which payments are to be made on return from an absence that is paid in advance.

13 GPNZ_RET_PYMTDT Date(10) DATE This is the date on which the 'On Return' Payments are to be made for an Absence that is paid in advance. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid on return.

14 GPNZ_RET_PRD Character(10) VARCHAR2(10) NOT NULL This identifies the Calendar Period to which 'On Return' Payments are to be attributed for an Absence paid in advance.
Prompt Table: GP_CAL_PRD

15 GPNZ_START_SEG_SW Character(1) VARCHAR2(1) NOT NULL Identifies whether a Segmentation Trigger is required at the end of an Absence Event or not. A trigger is required if only the absence part of the last period is to be calculated in advance.

16 GPNZ_END_SEG_SW Character(1) VARCHAR2(1) NOT NULL Identifies whether a Segmentation Trigger is required at the start of an Absence Event or not. A trigger is required if only the absence part of the first period is to be calculated in advance.

17 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	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
5	END_DT	Date(10)	DATE NOT NULL	end date
6	GPNZ_ADVANCE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This code identifies options used in calculating advance payments for absence events. Prompt Table: GPNZ_ADVTYP_VW
7	GPNZ_ADV_BGN_DT	Date(10)	DATE	The Begin Date used when calculating an Advance for an Absence. This is normally the same as the Begin Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.
8	GPNZ_ADV_END_DT	Date(10)	DATE	The End Date used when calculating an Advance for an Absence. This is normally the same as the End Date of the Absence that was paid in advance, but may be different if the Absence dates were changed after the advance was paid.
9	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. Prompt Table: GPNZ_ADV_RUNTYP
10	GPNZ_ADV_PYMTDT	Date(10)	DATE	This is the date on which the Advance Payment is to be made. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid in advance.
11	GPNZ_ADV_PRD	Character(10)	VARCHAR2(10) NOT NULL	This identifies the Calendar Period to which the Advance Payment is to be attributed. Prompt Table: GP_CAL_PRD
12	GPNZ_RET_CAL_RUNID	Character(18)	VARCHAR2(18) NOT NULL	This is the Calendar Group ID in which payments are to be made on return from an absence that is paid in advance.
13	GPNZ_RET_PYMTDT	Date(10)	DATE	This is the date on which the 'On Return' Payments are to be made for an Absence that is paid in advance. It is used to override the normal Payment Date for the Calendars/Periods that are to be paid on return.
14	GPNZ_RET_PRD	Character(10)	VARCHAR2(10) NOT NULL	This identifies the Calendar Period to which 'On Return' Payments are to be attributed for an Absence paid in advance. Prompt Table: GP_CAL_PRD
15	GPNZ_START_SEG_SW	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether a Segmentation Trigger is required at the end of an Absence Event or not. A trigger is required if only the absence part of the last period is to be calculated in advance.
16	GPNZ_END_SEG_SW	Character(1)	VARCHAR2(1) NOT NULL	Identifies whether a Segmentation Trigger is required at the start of an Absence Event or not. A trigger is required if only the absence part of the first period is to be calculated in advance.
17	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table