BsWifit ad HOC SELECT '1' as orderby, 'BB' AS GROUP_NUMBER, PER.PERSON_NUMBER AS EMPLOYEE_ID, PER.PERSON_NUMBER AS USER_ID, 'E' AS RELATION, NAME.FIRST_NAME AS FIRST_NAME, UPPER(SUBSTR(NAME.MIDDLE_NAMES,1,1)) AS MIDDLE_INITIAL, NAME.LAST_NAME AS LAST_NAME, '' AS LAST_NAME_EFFECTIVE_DATE, '' AS NICKNAME, '' AS SOCIAL_SECURITY_NUMBER, '' AS DATE_OF_BIRTH, '' AS GENDER, '' AS Race_Ethnicity, --BEN.DISABILITY_STATUS AS DISABLED, --BEN.TOBACCO_TYPE_USAGE AS TOBACCO_USER, '' AS BENEFIT_CLASS_CODE, '' AS BENEFIT_CLASS_DATE, '' AS COMPENSATION_DATE, null AS SALARY, null AS HOURLY_RATE, null AS HOURS_PER_WEEK, null AS BENEFITS_BASE_SALARY, '' AS BONUS, '' AS COMMISSION, '' AS HIRE_DATE, '' AS REHIRE_DATE, '' AS Demographic_Field_1, '' AS DEPT_CODE, '' AS DEPARTMENT_EFF_DATE, '' AS LOCATION_CODE, '...