GPCH_MC_JOB_VW

(SQL View)
Index Back

Multi Contract Job View

Multi Contract Job View

SELECT DISTINCT SEC.OPRID , SEC.EMPLID , JOB.COMPANY , SEC.EMPL_RCD FROM PS_EMPLMT_SRCH_GBL SEC , PS_JOB JOB WHERE SEC.EMPLID = JOB.EMPLID AND SEC.EMPL_RCD = JOB.EMPL_RCD AND NOT EXISTS ( SELECT 1 FROM PS_GPCH_MC_COMPANY C WHERE C.COMPANY = JOB.COMPANY AND C.GPCH_MC_ENABLE = 'Y' AND SEC.EMPL_RCD = C.GPCH_MC_LEGAL_RCD AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GPCH_MC_COMPANY D WHERE D.COMPANY = C.COMPANY AND D.GPCH_MC_ENABLE = 'Y' AND D.EFFDT <= JOB.EFFDT))

# 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
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record