Deleted Primary Instructor Issue - PS_D_CLASS (Doc ID 2125378.1)

Last updated on APRIL 08, 2016

Applies to:

PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On: PeopleSoft Enterprise EPM Campus Solutions Warehouse 9.1; DataStage 8.5 ETL Jobs

Deleted Primary Instructor Issue

Deleted Primary Instructor is being reported within OBIEE analysis, which is the incorrect instructor.

STEPS AS PER Deleted_Instructor_Issue_in_D_CLASS.docx
=========================================
Deleted Primary Instructor Issue in D_CLASS

Results of an OBIEE Analysis using Subject Area CSW - Student Records – Class Enrollment. The primary instructor is not the correct instructor for this class, the instructor shown was deleted in the source system, but it’s showing up in OBIEE.
<>
Primary Instructor Person Id = 1750781
Primary Instructor Person Name = xxxxxx

The criteria for the query is:
<>
Course Code is equal to / Is In 002713
AND Class session code is equal to / Is In 100
AND Term code is equal to / Is In 2143

The PS_CLASS_INSTR table shows the record for instructor 1750781 has a DATA_ORIGIN of ‘D’.
select crse_id, crse_offer_nbr, strm, session_code, class_section, class_mtg_nbr, instr_assign_seq, emplid, instr_role, sched_print_instr, instr_load_factor, data_origin, lastupd_ew_dttm from ps_class_instr where crse_id = '002713' and strm = '2143'
<>
CRSE_ID = 002713
EMPLID = 1750781
INSTR_ROLE = PI
DATA_ORIGIN = D

The PRI_INSTRCTR_SID for class 6965 from PS_D_CLASS is xxxxxx.
select crse_cd, crse_ld, crse_offer_num, term_cd, session_sd, class_section_cd, sbjct_cd, catalog_nbr, class_num, pri_instrctr_sid, data_origin, lastupd_ew_dttm from ps_d_class where crse_cd = '002713' and term_cd = '2143' and class_section_cd = '100'
<>
CRSE_CD = 002713
CLASS_NUM = 6965
PRI_INSTRCTR_SID = 930966

The result on dimension PS_D_PERSON shows the PRI_INSTRCTR_SID is 930966 which is xxxxxx.
select person_sid, person_id, person_nm, data_origin from ps_d_person where person_sid = '930966'
<>
PERSON_SID = 930966
PERSON_ID = 1750781
PERSON_NM = xxxxxx

BUSINESS IMPACT
===============
The issue has the following business impact:
Can not figure out where exactly we need to go to get this corrected.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms