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;