QUERY Manager /EMPLMT_SRCH_QRY : No rows returned for some EMPLIDS
Hi,
In CS 9.0, when trying to run a simple QUERY in QUERY Manager with just PS_JOB, I notice some EMPLIDs are missing. If I put an EMPLID as a criteria, I get no rows returned and get the same result when running the SQL generated by the QUERY MANAGER.
It's basically due to the Security Record EMPLMT_SRCH_QRY but I am looking for help on what security settings I should be setting to get it working properly
Example of the SQL
SELECT A.EMPLID, A.EMPL_RCD, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFFSEQ, A.PER_ORG, A.DEPTID, A.JOBCODE, A.POSITION_NBR, A.SUPERVISOR_ID, A.HR_STATUS, A.APPT_TYPE, A.MAIN_APPT_NUM_JPN, A.POSITION_OVERRIDE, A.POSN_CHANGE_RECORD, A.EMPL_STATUS, A.ACTION, TO_CHAR(A.ACTION_DT,'YYYY-MM-DD'), A.ACTION_REASON, A.LOCATION, A.TAX_LOCATION_CD, TO_CHAR(A.JOB_ENTRY_DT,'YYYY-MM-DD'), TO_CHAR(A.DEPT_ENTRY_DT,'YYYY-MM-DD'), TO_CHAR(A.POSITION_ENTRY_DT,'YYYY-MM-DD'), A.SHIFT, A.REG_TEMP, A.FULL_PART_TIME, A.COMPANY, A.PAYGROUP, A.BAS_GROUP_ID, A.ELIG_CONFIG1, A.ELIG_CONFIG2, A.ELIG_CONFIG3, A.ELIG_CONFIG4, A.ELIG_CONFIG5, A.ELIG_CONFIG6, A.ELIG_CONFIG7, A.ELIG_CONFIG8, A.ELIG_CONFIG9, A.BEN_STATUS, A.BAS_ACTION, A.COBRA_ACTION, A.EMPL_TYPE, A.HOLIDAY_SCHEDULE, A.STD_HOURS, A.STD_HRS_FREQUENCY, A.OFFICER_CD, A.EMPL_CLASS, A.SAL_ADMIN_PLAN, A.GRADE, TO_CHAR(A.GRADE_ENTRY_DT,'YYYY-MM-DD'), A.STEP, TO_CHAR(A.STEP_ENTRY_DT,'YYYY-MM-DD'), A.GL_PAY_TYPE, A.ACCT_CD, A.EARNS_DIST_TYPE, A.COMP_FREQUENCY, A.COMPRATE, A.CHANGE_AMT, A.CHANGE_PCT, A.ANNUAL_RT, A.MONTHLY_RT, A.DAILY_RT, A.HOURLY_RT, A.ANNL_BENEF_BASE_RT, A.SHIFT_RT, A.SHIFT_FACTOR, A.CURRENCY_CD, A.BUSINESS_UNIT, A.SETID_DEPT, A.SETID_JOBCODE, A.SETID_LOCATION, A.SETID_SALARY, A.SETID_EMPL_CLASS, A.REG_REGION, A.DIRECTLY_TIPPED, A.FLSA_STATUS, A.EEO_CLASS, A.FUNCTION_CD, A.TARIFF_GER, A.TARIFF_AREA_GER, A.PERFORM_GROUP_GER, A.LABOR_TYPE_GER, A.SPK_COMM_ID_GER, A.HOURLY_RT_FRA, A.ACCDNT_CD_FRA, A.VALUE_1_FRA, A.VALUE_2_FRA, A.VALUE_3_FRA, A.VALUE_4_FRA, A.VALUE_5_FRA, A.CTG_RATE, A.PAID_HOURS, A.PAID_FTE, A.PAID_HRS_FREQUENCY, A.UNION_FULL_PART, A.UNION_POS, A.MATRICULA_NBR, A.SOC_SEC_RISK_CODE, A.UNION_FEE_AMOUNT,