ST_GRANT_SRCH

(SQL View)
Index Back

Grant Search Record

Search record for ST_GRANT

SELECT SEC.OPRID ,SEC.EMPLID ,A.STOCK_ID ,A.GRANT_NBR ,SEC.ROWSECCLASS ,SEC.EMPL_RCD ,SEC.NAME ,A.GRANT_STATUS ,A.GRANT_DT ,A.STOCK_PLAN ,A.ST_OPTION_TYPE ,A.GRANT_PRICE ,A.SHARES_GRANTED FROM PS_ST_GRANT A ,PS_PERS_SRCH_GBL SEC WHERE A.EMPLID = SEC.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

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

Prompt Table: STOCK_TBL

4 GRANT_NBR Character(10) VARCHAR2(10) NOT NULL System assigned grant number used to uniquely identify the grant record.
5 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 GRANT_STATUS Character(1) VARCHAR2(1) NOT NULL Grant Status
A=Active
P=Pending
V=Void - Data Entry Error
9 GRANT_DT Date(10) DATE Grant Date
10 STOCK_PLAN Character(10) VARCHAR2(10) NOT NULL Stock Plan
11 ST_OPTION_TYPE Character(4) VARCHAR2(4) NOT NULL Option Type
ISAR=ISO-Stock Appreciation Right
ISO=Incentive Stock Option
NQ=Non-Qualified
NSAR=NQ-Stock Appreciation Right
RSA=Restricted Stock Award
12 GRANT_PRICE Number(19,6) DECIMAL(18,6) NOT NULL Price an employee pays to exercise the option.
13 SHARES_GRANTED Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of shares granted.