OPRIDDefault Value: PSOPRDEFN.OPRID
Prompt Table: PSOPRDEFN
RUN_CNTL_IDPrompt 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_RQST(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 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PSOPRDEFN.OPRID Prompt Table: PSOPRDEFN |
| 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 |