ARCH_AUDIT_RQST(SQL Table) |
Index Back |
|---|---|
PS Archiving Report Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
Prompt Table: ARCH_PROJ |
| 4 | ARCH_CLASS | Character(30) | VARCHAR2(30) NOT NULL | Archive Operator Class |
| 5 | ARCH_EVENT | Character(2) | VARCHAR2(2) NOT NULL |
Archiving Event
AE=Archive Edit SQL AI=Archive Import SQL AR=Archive Run SQL AV=Archive Events AX=Archive Export SQL BF=Batch Flat File Process BH=Batch History Process BI=Batch Import Process BP=Batch AE Process UC=Copy Archive ID UD=Delete Archive ID UG=Generate DM Script UR=Rename Archive ID UV=Utility Events |
| 6 | FROM_DT | Date(10) | DATE | From Date |
| 7 | TO_DT | Date(10) | DATE | To Date |
| 8 | PSARCH_PRINT_SQL | Character(1) | VARCHAR2(1) NOT NULL |
Print SQL?
Y/N Table Edit Default Value: N |
| 9 | PSARCH_FILE_PATH | Character(70) | VARCHAR2(70) NOT NULL | File Path |