GPNZ_ADVTYP_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_ADVTYP_VW

(SQL View)

Absence Advance Allowed Takes

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

SELECT A.PIN_TAKE_NUM , A.GPNZ_ADVANCE_TYPE , B.GPNZ_ADV_DESCR FROM PS_GPNZ_ADV_TAKE A , PS_GPNZ_ADV_TYPE B WHERE A.GPNZ_ADVANCE_TYPE = B.GPNZ_ADVANCE_TYPE

Parent record: GPNZ_ADV_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
2	GPNZ_ADVANCE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This code identifies options used in calculating advance payments for absence events.
3	GPNZ_ADV_DESCR	Character(50)	VARCHAR2(50) NOT NULL	This is a description of the Advance Type.