2 Replies Latest reply: Apr 17, 2013 11:44 AM by User706840-Oracle RSS

    HIGHEST DEGREE is populated with no source values in HR Analytics for PSFT

    User706840-Oracle
      Hi Gurus.
      I'm implementing BI Apps 7.9.6.3 with Peoplesoft 9.0 as source. Reviewing some reports in HR Analytics I found that the dimension called "Employee Education and Languages.Employee Highest Education Degree Description" is being populated with values that not belong to the source system.
      I found the following query in mplt_SIL_EmployeeDemographicAggregation_Load.LKP_CODES_HIGHEST_DEGREE:

      SELECT
      W_CODE_D.MASTER_CODE as MASTER_CODE,
      W_CODE_D.MASTER_VALUE as MASTER_VALUE,
      W_CODE_D.SOURCE_CODE as SOURCE_CODE,
      W_CODE_D.DATASOURCE_NUM_ID as DATASOURCE_NUM_ID
      FROM
      W_CODE_D
      WHERE
      W_CODE_D.CATEGORY = 'HIGHEST_DEGREE' AND
      W_CODE_D.LANGUAGE_CODE = 'E';

      When this query is execute it returned values like these in the W_CODE_D.MASTER_VALUE field:

      No Formal Education, Elementary Scholl Completed, Some High School, High School Graduate, Terminal Occupation Pgm DNC, Terminal Occupation Pgm Cmp,
      Some College - Less than 1 Yr, One Year College, Two Years College, Associate Degree, Three Years College, Four Years College, Bachelor Degree, Post Bachelors
      First Professional, Post-First Professional, Masters Degree, Post Masters, Sixth Year Degree, Post Sxth Year, Doctorate Degree, Post Doctorate, Not Indicated, Less Than HS Graduate
      HS Graduate or Equivalent, Some College, Technical School, 2-Year College Degree, Bachelor's Level Degree, Some Graduate School, Master's Level Degree, Doctorate (Academic)
      Doctorate (Professional), Post-Doctorate

      The customer said that those values are not form his Peoplesoft source system.
      I tried to follow the mapping of W_CODE_D but it is related with a lot of task.

      Somebody could tell me where those values came from? is there a harcode or csv file?
      Can I configure those values? -- I do not find anything about that for PSFT in the Configuration guide--

      Thanks in Advance