ST_ACTN_PRC_VW3 (SQL View)	Index Back
Grant Number Prompt View This view is used to find a list of Grant Numbers for a particular individual.

ST_ACTN_PRC_VW3

(SQL View)

Grant Number Prompt View

This view is used to find a list of Grant Numbers for a particular individual.

SELECT DISTINCT A.EMPLID , A.STOCK_ID , A.GRANT_NBR FROM PS_ST_GRANT A WHERE A.ST_CANCEL_DT IS NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID

3 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.