EOCM_CATVER_HST (SQL Table)	Index Back
Store the Catalog Versions Store the Catalog Versions for history

EOCM_CATVER_HST

(SQL Table)

Store the Catalog Versions

Store the Catalog Versions for history

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

4 EOCM_CAT_VER_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id

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

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

7 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.

8 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	EOCM_CATALOG_ID	Character(32)	VARCHAR2(32) NOT NULL	Catalog ID
4	EOCM_CAT_VER_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Version Id
5	EOCM_CATVER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Catalog version Status C=Current P=Production R=Retired
6	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
7	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.
8	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.