RS_EMPL_JOB_VW

(SQL View)
 Index Back

Search View for JOB App Msg

Search view for JOB App Message.

SELECT A.EMPLID ,A.EMPL_RCD , A.BUSINESS_UNIT FROM %Table(JOB) A WHERE A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM %Table(JOB) AA WHERE AA.EMPLID = A.EMPLID AND AA.EMPL_RCD = A.EMPL_RCD AND AA.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(BA.EFFSEQ) FROM %Table(JOB) BA WHERE BA.EMPLID = A.EMPLID AND BA.EMPL_RCD = A.EMPL_RCD AND BA.EFFDT = A.EFFDT) AND (EXISTS ( SELECT 'X' FROM %Table(RS_WRKR_EFFDT) CA WHERE CA.EMPLID = A.EMPLID AND CA.SYSTEM_SOURCE = 'RS' AND %EffdtCheck(RS_WRKR_EFFDT CAA, CA, %CurrentDateIn) AND CA.EMPL_RCD = A.EMPL_RCD) OR (NOT EXISTS ( SELECT 'X' FROM %Table(RS_WRKR_EFFDT) DA WHERE DA.EMPLID = A.EMPLID AND DA.SYSTEM_SOURCE = 'RS' AND %EffdtCheck(RS_WRKR_EFFDT DAA, DA, %CurrentDateIn) AND DA.EMPL_RCD = A.EMPL_RCD) AND A.EMPL_RCD = ( SELECT MIN(EA.EMPL_RCD) FROM %Table(JOB) EA WHERE EA.EMPLID = A.EMPLID AND EA.EFFDT = ( SELECT MAX(EAA.EFFDT) FROM %Table(JOB) EAA WHERE EAA.EMPLID = EA.EMPLID AND EAA.EMPL_RCD = EA.EMPL_RCD AND EAA.EFFDT <= %CurrentDateIn) AND EA.EFFSEQ = ( SELECT MAX(EBA.EFFSEQ) FROM %Table(JOB) EBA WHERE EBA.EMPLID = EA.EMPLID AND EBA.EMPL_RCD = EA.EMPL_RCD AND EBA.EFFDT = EA.EFFDT) AND EMPL_STATUS = 'A')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: NEW

Prompt Table: PERSONAL_DATA

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit