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 |