INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.

Summary:

Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'.

In BIP report INFORMATION_TYPE is coded 'BMC Grade Details'

How the INFORMATION_TYPE get updated ? when we create job in HCM its show EIT and sometimes its 'BMC Grade Details'.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Current code

For few jobs INFORMATION_TYPE is 'EIT' and for rest its 'BMC Grade Details'.

select distinct j.name,j.effective_start_date jobstartdate,
jobex.INFORMATION_TYPE,jobex.JEI_INFORMATION2,jobex.JEI_INFORMATION1,PGFTL.NAME grade,jobex.CREATED_BY