Delivery Suite Feeder Mapping
Previous Topic  Next Topic 

Special Dept mapping is required for  DEL or <xxx>DL feeders, a row is required to be added for xxxDL:UNK to map to the Delivery suite Dept. A dummy is not created in the table, however this code


       LEFT(UTIL.Episode,20) AS HPRQCD,

          CASE WHEN UTIL.CAMPUS_TLA = UTIL.COMPANY_TLA THEN 'DEL' ELSE UTIL.CAMPUS_TLA +'DL' END AS HPAQCD,

          COALESCE(WDC.Dept_Code,'ZZYY99') + UTIL.Delivery_type_code + '.'  + UTIL.Delivery_Method_code + '.0' + convert(varchar,BabyNo_int) AS HPARCD,

          CONVERT(bigint,CONVERT(varchar,UTIL.Birth_Date,112)) AS HPAID1,

          0 AS HPGUD1,

          '' AS HPO8CD,

..

..

FROM    dbo.tblADMDeliveries UTIL LEFT OUTER JOIN dbo.tblDeptMappings WDC


shows that ZZYY99 is used if no mapping exists

A small number of sites may have a mapping to the Delivery Suite WARD CODE in use as well.