ST_GRNT_RET_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_ST_GT
5	STOCK_ID	Character(10)	VARCHAR2(10) NOT NULL	Stock ID Prompt Table: STOCK_TBL
6	GRANT_NBR	Character(10)	VARCHAR2(10) NOT NULL	System assigned grant number used to uniquely identify the grant record.
7	GRANT_DT	Date(10)	DATE NOT NULL	Grant Date
8	STOCK_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Stock Plan Prompt Table: ST_OPT_PLAN_VW
9	ASOFDATE	Date(10)	DATE	As of Date
10	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
11	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
12	AGREEMENT_DT	Date(10)	DATE	Agreement Date
13	GRANT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Grant Status A=Active P=Pending V=Void - Data Entry Error Default Value: P
14	RET_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Retirement Eligible Y/N Table Edit Default Value: N
15	RET_ELIG_DT	Date(10)	DATE	Retire Eligible Dt
16	RET_ELIG_SRVC_MN	Number(2,0)	SMALLINT NOT NULL	Retire Eligible Service Month
17	RET_ELIG_SRVC_DY	Number(2,0)	SMALLINT NOT NULL	Retire Eligible Service Days
18	RET_AGE	Number(3,0)	SMALLINT NOT NULL	Normal Retire Age
19	RET_ELIG_DT_FLD	Character(1)	VARCHAR2(1) NOT NULL	Retire Eligible AsofDate A=Agreement Date G=Grant Date
20	FORECAST_ELIG_AGE	Number(3,0)	SMALLINT NOT NULL	Forecast Eligible Age
21	FORECAST_RET_ELIG	Character(1)	VARCHAR2(1) NOT NULL	Forecast Retirement Eligible
22	FORECAST_SRVC_DD	Number(2,0)	SMALLINT NOT NULL	Forecast Service days
23	FORECAST_SRVC_MM	Number(2,0)	SMALLINT NOT NULL	Forecast Service Months
24	FORECAST_SRVC_YY	Number(2,0)	SMALLINT NOT NULL	Forecast Req Service
25	BIRTHDATE	Date(10)	DATE	Date of Birth
26	SERVICE_DT	Date(10)	DATE	Service Date
27	RET_ELIGIBLE_AGE	Number(3,0)	SMALLINT NOT NULL	Retire Eligible Age
28	RET_ELIG_SRVC_YY	Number(3,0)	SMALLINT NOT NULL	Retire Eligible Req Service
29	DATE1	Date(10)	DATE	Date 1
30	DATE2	Date(10)	DATE	Date 2