EOCM_PRD_VER_VW

(SQL View)
Index Back

Distinct Production Versions

Only gives the distinct catalog ids/versions in EOCM_USR_OFF_VW.

SELECT DISTINCT EOCM_CATALOG_ID ,EOCM_CAT_VER_ID ,OPRID FROM %Table(EOCM_USR_OFF_VW)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
2 EOCM_CAT_VER_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).