PROCESS_INSTANCEPrompt Table: SETID_TBL
Prompt Table: EOCM_CATALOG
Prompt Table: EOCM_CAT_VER_VW
A=Archive the data
P=Purge from Archive
R=Restore from Archive
EOCM_ARCH_AET(SQL Table) |
Index Back |
|---|---|
Run Control Params for ArchiveRun Control Parameters for Catalog Management Archiving |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 4 | EOCM_CATALOG_ID | Character(32) | VARCHAR2(32) NOT NULL |
Catalog ID
Prompt Table: EOCM_CATALOG |
| 5 | EOCM_ARCH_ID | Character(7) | VARCHAR2(7) NOT NULL | Arch Id |
| 6 | EOCM_CAT_VER_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Catalog Version Id
Prompt Table: EOCM_CAT_VER_VW |
| 7 | EOCM_ARCH_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Archive Option
A=Archive the data P=Purge from Archive R=Restore from Archive |
| 8 | EOCM_CAT_ARCH_ID | Character(8) | VARCHAR2(8) NOT NULL | Unique archive id for catalog process |
| 9 | EOCM_GEN_ARCH_ID | Character(8) | VARCHAR2(8) NOT NULL | Unique Archive ID for generate table process |
| 10 | EOCM_ACCESS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |
| 11 | EOCM_TP_VER_ID | Number(3,0) | SMALLINT NOT NULL | trading partner version id |
| 12 | EOCM_CAT_LOOP | Number(3,0) | SMALLINT NOT NULL | Catalog Archive Loop |
| 13 | EOCM_GEN_LOOP | Number(3,0) | SMALLINT NOT NULL | Gen table loop |