GPNZ_NRP_AB4_VW (SQL View)	Index Back
Absence Advance Allowed Takes This defines the Absence Take elements that the Advance Type is allowed to be used with.

GPNZ_NRP_AB4_VW

(SQL View)

Absence Advance Allowed Takes

This defines the Absence Take elements that the Advance Type is allowed to be used with.

SELECT GPNZ_ADVANCE_TYPE , PIN_TAKE_NUM + 50000000 FROM PS_GPNZ_ADV_TAKE

# 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 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GPNZ_ABS_TKE_VW

#	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	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GPNZ_ABS_TKE_VW