EOCM_CAT_VER_VW (SQL View)	Index Back
Store the Catalog Versions Store the Catalog Versions

EOCM_CAT_VER_VW

(SQL View)

Store the Catalog Versions

SELECT SETID , EOCM_CATALOG_ID , EOCM_CAT_VER_ID , EOCM_CATVER_STATUS , DESCR100 , LASTUPDDTTM ,LASTUPDOPRID FROM PS_EOCM_CAT_VER WHERE EOCM_CATVER_STATUS <> 'C'

# 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 EOCM_CAT_VER_ID2 Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id

4 EOCM_CATVER_STATUS Character(1) VARCHAR2(1) NOT NULL Catalog version Status
C=Current
P=Production
R=Retired

5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	EOCM_CAT_VER_ID2	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Version Id
4	EOCM_CATVER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Catalog version Status C=Current P=Production R=Retired
5	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.