EOCM_MSTMAP_VW

(SQL View)
Index Back

Catalog Prompt View

Catalog Prompt View for Catalog Management. Used as the search view for Master Mapping.

SELECT SETID ,EOCM_CATALOG_ID ,EOCM_MAP_OBJ ,EOEW_MAP_OBJ FROM PS_EOCM_MAP_MST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID

Prompt Table: EOCM_CATALOG

3 EOCM_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Catalog Management Map Object
4 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object