b1nary0mega
8/12/2015 - 3:04 PM

Generate Magnet_Profiles table from NPD view

Generate Magnet_Profiles table from NPD view

SELECT SUBSTR(JOB_DEPTID, 4) AS UNIT_ID,
  EMPLID AS EMPLOYEE_ID,
  FIRST_NAME,
  LAST_NAME,
  STD_HOURS AS MIN_WKLY_HRS,
  JOBCODE AS POS_CODE,
  DESCR AS TITLE,
  JOB_DEPTID AS DEPT,
  JOB_ENTRY_DATE AS POS_STRT_DATE,
  DEPT_ENTRY_DATE AS UNIT_STRT_DATE
FROM COMPLETENURSING_PS_20150701;