EOCM_INSTALL(SQL Table) |
Index Back |
|---|---|
Installation RecordInstallation 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 |