EOCM_WRKPNR_VW2 (SQL View)	Index Back
User's Partner Catalog View It's used to display the working catalog for the partner dashboard

EOCM_WRKPNR_VW2

(SQL View)

User's Partner Catalog View

It's used to display the working catalog for the partner dashboard

SELECT A.OPRID ,A.SETID ,A.EOCM_CATALOG_ID ,A.EOCM_CAT_VER_ID ,B.EOCM_ACCESS_ID ,B.EOCM_TP_VER_ID ,A.EOCM_CAT_USER_TYPE ,A.EOCM_CATALOG_NM ,A.EOCM_CATALOG_TYPE ,A.EOCM_CATALOG_DT ,A.EOCM_ROW_NUM ,A.EOCM_OFFER_NUM ,B.EOCM_TP_VER_STATE ,B.CREATED_DTTM ,B.LASTUPDDTTM ,A.EOCM_EXPRESS_CAT ,A.EOCM_QUICK_ITMLOAD ,A.EOCM_MAP_OBJ ,A.EOCM_PSMSTMAP ,B.LASTUPDOPRID FROM %Table(EOCM_WRK_CAT_VW) A , %Table(EOCM_TP_VER) B , %Table(EOCM_CATALOG_TP) C WHERE A.SETID= B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND B.SETID= C.SETID AND B.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND B.EOCM_ACCESS_ID = C.EOCM_ACCESS_ID AND C.EOCM_ACTIVE_FLAG = 'A' AND B.EOCM_TP_VER_ID = ( SELECT MAX(D.EOCM_TP_VER_ID) FROM PS_EOCM_WRK_PNR_VW D WHERE A.OPRID = D.OPRID AND A.SETID = D.SETID AND A.EOCM_CATALOG_ID = D.EOCM_CATALOG_ID AND A.EOCM_CAT_VER_ID = D.EOCM_CAT_VER_ID AND B.EOCM_ACCESS_ID = D.EOCM_ACCESS_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: EOCM_TPM_USR_VW

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_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
Prompt Table: %RECNAME_EDIT

6 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id

7 EOCM_CAT_USER_TYPE Character(1) VARCHAR2(1) NOT NULL Catalog Management user type
E=Enterprise Catalog User
P=Partner Catalog User

8 EOCM_CATALOG_NM Character(32) VARCHAR2(32) NOT NULL Catalog Name

9 EOCM_CATALOG_TYPE Character(1) VARCHAR2(1) NOT NULL Catalog Type
1=Customer Catalog
2=Procurement Catalog
3=Training Catalog
Default Value: 1

10 EOCM_CATALOG_DT Date(10) DATE Catalog Creation Date

11 EOCM_ROW_NUM Number(11,0) DECIMAL(11) NOT NULL Row Number - This field is used to get the mins, secs as the unique tag for the offer id

12 EOCM_OFFER_NUM Number(11,0) DECIMAL(11) NOT NULL Offer Number

13 EOCM_TP_VER_STATE Character(1) VARCHAR2(1) NOT NULL TP version state (loaded, categorized, etc)
A=Pending Approval
B=In Progress
C=Categorized
D=Error
E=Error
F=Error
K=Error
L=Loaded
N=Created
P=Production
S=Staged
W=Waiting Review
X=Purchasing/Errors
Z=Purchasing

14 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

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

16 EOCM_EXPRESS_CAT Character(1) VARCHAR2(1) NOT NULL Express Catalog Flag Type

17 EOCM_QUICK_ITMLOAD Character(1) VARCHAR2(1) NOT NULL Quick Item Load Flag
N=Step by Step Load
Y=Quick Load

18 EOCM_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Catalog Management Map Object

19 EOCM_PSMSTMAP Character(1) VARCHAR2(1) NOT NULL Use Standard PS Master MAP

20 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: EOCM_TPM_USR_VW
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_ACCESS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Field for storing the Partner ID Prompt Table: %RECNAME_EDIT
6	EOCM_TP_VER_ID	Number(3,0)	SMALLINT NOT NULL	trading partner version id
7	EOCM_CAT_USER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Catalog Management user type E=Enterprise Catalog User P=Partner Catalog User
8	EOCM_CATALOG_NM	Character(32)	VARCHAR2(32) NOT NULL	Catalog Name
9	EOCM_CATALOG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Catalog Type 1=Customer Catalog 2=Procurement Catalog 3=Training Catalog Default Value: 1
10	EOCM_CATALOG_DT	Date(10)	DATE	Catalog Creation Date
11	EOCM_ROW_NUM	Number(11,0)	DECIMAL(11) NOT NULL	Row Number - This field is used to get the mins, secs as the unique tag for the offer id
12	EOCM_OFFER_NUM	Number(11,0)	DECIMAL(11) NOT NULL	Offer Number
13	EOCM_TP_VER_STATE	Character(1)	VARCHAR2(1) NOT NULL	TP version state (loaded, categorized, etc) A=Pending Approval B=In Progress C=Categorized D=Error E=Error F=Error K=Error L=Loaded N=Created P=Production S=Staged W=Waiting Review X=Purchasing/Errors Z=Purchasing
14	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time
15	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.
16	EOCM_EXPRESS_CAT	Character(1)	VARCHAR2(1) NOT NULL	Express Catalog Flag Type
17	EOCM_QUICK_ITMLOAD	Character(1)	VARCHAR2(1) NOT NULL	Quick Item Load Flag N=Step by Step Load Y=Quick Load
18	EOCM_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Catalog Management Map Object
19	EOCM_PSMSTMAP	Character(1)	VARCHAR2(1) NOT NULL	Use Standard PS Master MAP
20	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.