EDM_JOB_VW_NLD

(SQL View)
 Index Back

First Hire Date Declaration.

First Hire Date Declaration.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EMPL_CLASS , A.COMPANY , A.HIRE_DT , A.LAST_HIRE_DT , A.ACTION , A.ACTION_REASON , %DateNull FROM PS_JOB A WHERE A.ACTION IN ('HIR','REH') AND A.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_JOB J WHERE J.EMPLID = A.EMPLID AND J.EMPL_RCD = A.EMPL_RCD AND J.ACTION IN ('HIR','REH')) AND A.REG_REGION IN ( SELECT REG_REGION FROM PS_REG_REGION_TBL WHERE COUNTRY = 'NLD')

# 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 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

Prompt Table: EMPL_CL_NLD_VW

5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

6 HIRE_DT Date(10) DATE First Start Date
7 REHIRE_DT Date(10) DATE Rehire Date
8 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

9 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
10 PROCESS_DT Date(10) DATE Process Date