GPFR_TER_VW_LNG

(SQL View)
Index Back

Terminated Employees View-Rel

Related View to retrieve Terminated employees from the GPFR_TER_EE_SEL and to display the GPFR_TER_EE_SEL data in a grid that is visible to user

SELECT EE.EMPLID ,EE.EMPL_RCD ,EE.CONTRACT_NUM ,EELNG.LANGUAGE_CD ,EELNG.ACTION_DESCR ,EELNG.DESCR FROM PS_GPFR_TER_EE_SEL EE , PS_GPFR_TER_EE_LNG EELNG WHERE EE.EMPLID =EELNG.EMPLID AND EE.EMPL_RCD =EELNG.EMPL_RCD AND EE.CONTRACT_NUM =EELNG.CONTRACT_NUM

# 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 Rcd Nbr
3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description