PROCESS_INSTANCEOPRIDDefault Value: PSOPRDEFN.OPRID
Prompt Table: PSOPRDEFN
Prompt Table: EOCM_CATALOG
Y/N Table Edit
Prompt Table: EOCM_CATEGORY_H
1=Flat File
2=CSV File
3=xCBL
Default Value: 1
1=Application Server
2=FTP
EOCM_ACCESS_IDEOCM_CTLG_S_AET(SQL Table) |
Index Back |
|---|---|
Catalog Syndication State RecCatalog Syndication State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PSOPRDEFN.OPRID Prompt Table: PSOPRDEFN |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | EOCM_CATALOG_ID | Character(32) | VARCHAR2(32) NOT NULL |
Catalog ID
Prompt Table: EOCM_CATALOG |
| 6 | EOCM_CAT_VER_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Version Id |
| 7 | EOCM_ACCESS_ALL | Character(1) | VARCHAR2(1) NOT NULL |
All Access Rights
Y/N Table Edit |
| 8 | EOCM_CAT_HIER_ID | Character(32) | VARCHAR2(32) NOT NULL |
Catalog Hierarchy ID
Prompt Table: EOCM_CATEGORY_H |
| 9 | EOCM_LAYOUT_FMT | Character(1) | VARCHAR2(1) NOT NULL |
File Layout Format
1=Flat File 2=CSV File 3=xCBL Default Value: 1 |
| 10 | EOCM_FILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique System Filename |
| 11 | EOCM_CATALOG_MOD | Character(1) | VARCHAR2(1) NOT NULL |
Catalog listing Method of Delivery
1=Application Server 2=FTP |
| 12 | EOCM_CAT_MOD_DTL | Character(254) | VARCHAR2(254) NOT NULL | Catalog Method of Delivery Details |
| 13 | EOCM_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |