I'm implementing BI Apps 220.127.116.11 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:
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
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--