PV_CO_LAST_UPDT

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PV_CO_UPDT_TYPE Character(1) VARCHAR2(1) NOT NULL Cohera Update Type
1=Supplier Products
2=Item Categories
3=Category Hierarchy

2 PV_CO_SCHEMA_NAME Character(128) VARCHAR2(128) NOT NULL Cohera Catalog Name

3 PV_MS_SUP_MPID Character(50) VARCHAR2(50) NOT NULL e

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

5 PV_CO_STATUS Character(1) VARCHAR2(1) NOT NULL Cohera Processing Status
1=Complete
2=Staged
3=In Process

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PV_CO_UPDT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Cohera Update Type 1=Supplier Products 2=Item Categories 3=Category Hierarchy
2	PV_CO_SCHEMA_NAME	Character(128)	VARCHAR2(128) NOT NULL	Cohera Catalog Name
3	PV_MS_SUP_MPID	Character(50)	VARCHAR2(50) NOT NULL	e
4	LAST_UPDATE_DTTM	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.
5	PV_CO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Cohera Processing Status 1=Complete 2=Staged 3=In Process