EOCM_INSTALL

(SQL Table)
Index Back

Installation Record

Installation Record for Catalog Management

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOCM_LAST_TBLNUM Number(7,0) INTEGER NOT NULL Last Table Number Userd
2 EOCM_LAST_OBJ_NUM Number(12,0) DECIMAL(12) NOT NULL Last Data Object Number
3 EOCM_LAST_MAP_NUM Number(12,0) DECIMAL(12) NOT NULL Last Map Number
4 EOCM_DDLSPACE Character(30) VARCHAR2(30) NOT NULL Table Space for Catalog Management

Prompt Table: EOEW_TBLSPCATVW

5 EOCM_DFLT_URL Character(30) VARCHAR2(30) NOT NULL URL for Attachments

Prompt Table: PSURLDEFN

6 EOCM_CRM_FLAG Character(1) VARCHAR2(1) NOT NULL Customer Catalog (CRM Catalog) Flag

Y/N Table Edit

Default Value: Y

7 EOCM_ELM_FLAG Character(1) VARCHAR2(1) NOT NULL Course Catalog (ELM) flag

Y/N Table Edit

Default Value: Y

8 EOCM_EPRO_FLAG Character(1) VARCHAR2(1) NOT NULL Procurement (Purchasing + Epro) Catalog Flag

Y/N Table Edit

Default Value: Y

9 EOCM_CATPTNR_ROLE Character(30) VARCHAR2(30) NOT NULL Role for Catalog Partner User

Prompt Table: PSROLEDEFN

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

Y/N Table Edit

Default Value: N

11 EOCM_APRVE_ITMREQ Character(1) VARCHAR2(1) NOT NULL Approve Items Load Required Flag

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

13 EOCM_AUTOCRT_TBL Character(1) VARCHAR2(1) NOT NULL Auto Create Map error table

Y/N Table Edit

Default Value: N