GPAU_NRP_ADV_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.

GPAU_NRP_ADV_VW

(SQL View)

Absence Advance Allowed Takes

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

SELECT GPAU_ADVANCE_TYPE , PIN_TAKE_NUM + 50000000 FROM PS_GPAU_ADV_TAKE

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

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