EOCM_MMPSRCH_VW

(SQL View)
 Index Back

Map Definition View

Map Definition View

SELECT B.SETID ,B.EOCM_CATALOG_ID ,A.EOEW_MAP_OBJ ,B.EOCM_MAP_OBJ ,A.EOEW_SRC_OBJ ,D.EOEW_SRCDONAME ,D.EOCM_DATA_SRC_ID ,E.EOCM_ACCESS_ID FROM PS_EOEW_MAP_DFN A , PS_EOCM_MAP_MST B , PS_EOCM_DATA_MST D , PS_EOCM_DSMST_PART E WHERE A.EOEW_MAP_OBJ = B.EOEW_MAP_OBJ AND A.EOEW_SRC_OBJ = D.EOEW_SRCDONAME AND D.EOEW_SRCDONAME = D.EOCM_DATA_SRC_ID AND D.SETID = E.SETID AND D.EOCM_DATA_SRC_ID = E.EOCM_DATA_SRC_ID UNION SELECT A.SETID ,A.EOCM_CATALOG_ID ,C.EOEW_MAP_OBJ ,'CMSTDMSTMAP' ,C.EOEW_SRC_OBJ ,D.EOEW_SRCDONAME ,D.EOCM_DATA_SRC_ID ,B.EOCM_ACCESS_ID FROM PS_EOCM_CATALOG A , PS_EOCM_CATALOG_TP B , PS_EOEW_MAP_DFN C , PS_EOCM_DATA_PSMST D WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.EOCM_MAP_OBJ = 'CMSTDMSTMAP' AND C.EOEW_MAP_OBJ = 'CCM_STD999999' AND C.EOEW_SRC_OBJ = D.EOCM_DATA_SRC_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
3 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object
4 EOCM_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Catalog Management Map Object
5 EOEW_SRC_OBJ Character(30) VARCHAR2(30) NOT NULL Source Object
6 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object
7 EOCM_DATA_SRC_ID Character(10) VARCHAR2(10) NOT NULL Catalog Source ID
8 EOTP_PARTNERID Number(15,0) DECIMAL(15) NOT NULL Partner ID