VC_AWARD_HDR

(SQL View)
Index Back

EE VC Award History View

VC Employee History View

SELECT DISTINCT EMPLID , EMPL_RCD , VC_PLAN_ID FROM PS_VC_AWARD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 VC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL VC Plan ID