EOCM_ETL_ACC_VW

(SQL View)
 Index Back

View to Fix Access ID

This view is used to fix the Field Maaping issues - EOCM_ACCESS_ID field appears when it is supposed to be hidden. Although this is an ETL issue this view helps fix the issue at Catalog Managment level.

SELECT DISTINCT EOEW_SRC_OBJ , FIELDNAME , EOEW_SRCCOLALIAS FROM PS_EOEW_ETLC_FLST WHERE EOEW_SRC_TYP = '2' AND EOEW_SRCCOLALIAS <> 'EOCM_ACCESS_ID'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEW_SRC_OBJ Character(30) VARCHAR2(30) NOT NULL Source Object
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias