Deleted Primary Instructor Issue - PS_D_CLASS
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.
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
The issue has the following business impact:
Can not figure out where exactly we need to go to get this corrected.
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