PC_GNT_REFND_VW (SQL View)	Index Back
PC/AM Grant Refund View Used to determine if a grant refund is required prior to an asset interunit transfer or retirement.

PC_GNT_REFND_VW

(SQL View)

PC/AM Grant Refund View

Used to determine if a grant refund is required prior to an asset interunit transfer or retirement.

SELECT INCENTIVE_ID, MIN_IN_PERIOD FROM PS_PC_GNT WHERE INCENTIVE_TYPE = 'GNT' AND REFUND_TYPE <> 'N' AND ISSUED_FLG <>'Y' AND MIN_IN_PERIOD > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INCENTIVE_ID Character(10) VARCHAR2(10) NOT NULL Investment Incentive ID

2 MIN_IN_PERIOD Number(3,0) SMALLINT NOT NULL Minimum number of periods.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INCENTIVE_ID	Character(10)	VARCHAR2(10) NOT NULL	Investment Incentive ID
2	MIN_IN_PERIOD	Number(3,0)	SMALLINT NOT NULL	Minimum number of periods.