EOCM_ACCESS_TP (SQL Table)	Index Back
Security table for TP Security table for TP

EOCM_ACCESS_TP

(SQL Table)

Security table for TP

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

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

5 EOCM_TP_CATLOG_MGR Character(1) VARCHAR2(1) NOT NULL Partner Catalog Manager
Y/N Table Edit
Default Value: N

6 EOCM_ACCESS_ALL Character(1) VARCHAR2(1) NOT NULL All Access Rights
Y/N Table Edit
Default Value: N

7 EOCM_ACCESS_DR_MAP Character(1) VARCHAR2(1) NOT NULL Catalog Management - field for defining and running catalog map access privileges
Y/N Table Edit
Default Value: N

8 EOCM_ACCESS_LOAD Character(1) VARCHAR2(1) NOT NULL catalog management - access privileges for loading catalog data
Y/N Table Edit
Default Value: N

9 EOCM_ACCESS_CAT Character(1) VARCHAR2(1) NOT NULL Access right field for categorization
Y/N Table Edit
Default Value: N

10 EOCM_ACCESS_STAGE Character(1) VARCHAR2(1) NOT NULL access rights for staging
Y/N Table Edit
Default Value: N

11 EOCM_ACCESS_MAN Character(1) VARCHAR2(1) NOT NULL access rights field for manual update
Y/N Table Edit
Default Value: N

12 EOCM_ACCESS_BS_CAT Character(1) VARCHAR2(1) NOT NULL Catalog Management - browse staged catalog access privilege field
Y/N Table Edit
Default Value: N

13 EOCM_ACCESS_PR_CAT Character(1) VARCHAR2(1) NOT NULL Catalog Management - browse production catalog access privilege field
Y/N Table Edit
Default Value: N

14 EOCM_NOTIFY_USER Character(1) VARCHAR2(1) NOT NULL Field used for Workflow Notification
B=Enterprise Manager/Partner
E=Enterprise Manager
P=Partner
Y/N Table Edit

15 EOCM_ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active / InActive flag
A=Active
I=Inactive
Default Value: A

#	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_ACCESS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Field for storing the Partner ID Prompt Table: %RECNAME_EDIT
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: EOCM_TPM_USR_VW
5	EOCM_TP_CATLOG_MGR	Character(1)	VARCHAR2(1) NOT NULL	Partner Catalog Manager Y/N Table Edit Default Value: N
6	EOCM_ACCESS_ALL	Character(1)	VARCHAR2(1) NOT NULL	All Access Rights Y/N Table Edit Default Value: N
7	EOCM_ACCESS_DR_MAP	Character(1)	VARCHAR2(1) NOT NULL	Catalog Management - field for defining and running catalog map access privileges Y/N Table Edit Default Value: N
8	EOCM_ACCESS_LOAD	Character(1)	VARCHAR2(1) NOT NULL	catalog management - access privileges for loading catalog data Y/N Table Edit Default Value: N
9	EOCM_ACCESS_CAT	Character(1)	VARCHAR2(1) NOT NULL	Access right field for categorization Y/N Table Edit Default Value: N
10	EOCM_ACCESS_STAGE	Character(1)	VARCHAR2(1) NOT NULL	access rights for staging Y/N Table Edit Default Value: N
11	EOCM_ACCESS_MAN	Character(1)	VARCHAR2(1) NOT NULL	access rights field for manual update Y/N Table Edit Default Value: N
12	EOCM_ACCESS_BS_CAT	Character(1)	VARCHAR2(1) NOT NULL	Catalog Management - browse staged catalog access privilege field Y/N Table Edit Default Value: N
13	EOCM_ACCESS_PR_CAT	Character(1)	VARCHAR2(1) NOT NULL	Catalog Management - browse production catalog access privilege field Y/N Table Edit Default Value: N
14	EOCM_NOTIFY_USER	Character(1)	VARCHAR2(1) NOT NULL	Field used for Workflow Notification B=Enterprise Manager/Partner E=Enterprise Manager P=Partner Y/N Table Edit
15	EOCM_ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active / InActive flag A=Active I=Inactive Default Value: A