EP_NOM_LANG_VW

(SQL View)
 Index Back

Nominee search record

This record is used as a search view for participants in the nomination process. It is used to display to descriptions which may have language specific text.

SELECT JOB.EMPLID ,JOB.EMPL_RCD ,LNG.LANGUAGE_CD ,NM.FIRST_NAME_SRCH ,NM.LAST_NAME_SRCH ,LNG.DESCR FROM PS_PERSON_NAME NM ,PS_JOB JOB ,PS_DEPT_TBL_LANG LNG WHERE NM.EMPLID = JOB.EMPLID AND JOB.EFFDT = ( SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE JOB.EMPLID=J2.EMPLID AND JOB.EMPL_RCD=J2.EMPL_RCD AND J2.EFFDT <=%CurrentDateIn) AND JOB.EFFSEQ = ( SELECT MAX(J3.EFFSEQ) FROM PS_JOB J3 WHERE JOB.EMPLID = J3.EMPLID AND JOB.EMPL_RCD = J3.EMPL_RCD AND JOB.EFFDT=J3.EFFDT) AND LNG.SETID = JOB.SETID_DEPT AND LNG.DEPTID = JOB.DEPTID AND LNG.EFFDT = ( SELECT MAX(LNG2.EFFDT) FROM PS_DEPT_TBL_LANG LNG2 WHERE LNG2.SETID=LNG.SETID AND LNG2.DEPTID=LNG.DEPTID AND LNG2.EFFDT<=JOB.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EP_REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description