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

EOCM_WRK_PNR_VW

(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 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'

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

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