ST_GRNT_NOTE_VW

(SQL View)

SELECT DISTINCT EMPLID , STOCK_ID , GRANT_NBR , VEST_SUSPEND_DT , EXER_SUSPND_BGN_DT , EXER_SUSPND_END_DT , EXERCISE_HOLD_DT FROM PS_ST_GRANT WHERE GRANT_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Stock ID
Prompt Table: STOCK_TBL

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

4 VEST_SUSPEND_DT Date(10) DATE The date vesting is suspended when an employee is on leave.

5 EXER_SUSPND_BGN_DT Date(10) DATE No exercises will be allowed on or after this date.

6 EXER_SUSPND_END_DT Date(10) DATE Used in conjunction with Exer_Suspnd_Bgn_Dt.

7 EXERCISE_HOLD_DT Date(10) DATE Exercise Hold Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID Prompt Table: STOCK_TBL
3	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
4	VEST_SUSPEND_DT	Date(10)	DATE	The date vesting is suspended when an employee is on leave.
5	EXER_SUSPND_BGN_DT	Date(10)	DATE	No exercises will be allowed on or after this date.
6	EXER_SUSPND_END_DT	Date(10)	DATE	Used in conjunction with Exer_Suspnd_Bgn_Dt.
7	EXERCISE_HOLD_DT	Date(10)	DATE	Exercise Hold Date