EOCM_PRD_VER_VW(SQL View) |
Index Back |
---|---|
Distinct Production VersionsOnly 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). |